Help with joins...

[Mickael Pervinski]

I have two tables.

Animals
-
AnimalID
AnimalNAME
AnimalSEX


Projects
-
ProjectID
MaleID
FemaleID


Let's say Projects holds MaleID:1 and FemaleID:2 I need to write a
query that joins these tables, and basically pulls back two sets of
animal information per one record in the projects table.

I have no problem doing a query that joins with just one id, but the
second match is throwing me off..


Any suggestions? I am not even sure if this is the best way to setup
the projects table.. so if it's not... let me know...

Crit


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284300
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Running a DTS package with CF

[Mickael Elmalem]

Thanks for the info that works great.  I just need to figure out, as Bryan said 
why it runs as per the schedule most times but does not at others.

Mike

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

Running a DTS package with CF

[Mickael Elmalem]

 Hello All,

I am hoping that someone help me with this one.  We have a server in our local 
network that synchronizes to a remote website.  This is done by a DTS package 
running on a machine in our network at scheduled intervals.  The issue is for 
what ever reason the DTS package that is supposed to run everyhour does not.  
If I log on to the machine and run the package it works then keeps on working.  
My question is.  Is there a way to have a user click on a CFM page to run a DTS 
package on the local machine?  The idea is that the staff know right away that 
the sync is not working and if they could invoke it, then escalate to IT that 
would help the service level.

Thanks.

Mike

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

File Uploads from Users

[Mickael Elmalem]

 Hello All,

I have an app where users can upload files to their respective folders, the 
folders are created dynaically when a user is created in my app.  I was using 
CFFILE to upload the files to the file system but the size of the files that 
you can upload is not very large.  There is a reqirment to have the users 
upload larger files.  Obviously FTP would be ideal for this, I could very 
easily create an FTP user with only write permissions and give the user a link 
like a href=ftp://username:[EMAIL PROTECTED] target=_blankUploadFile/a 
and have the users upload a file to a generic folder but my client wants each 
client to have their own desitnation folder.  This site is on a share host so I 
don't think that I can create FTP users programitically.

Is there a way to user CFFTP or another proces to get a large file from a user 
to a specific folder that was created dynamically?

Or another suggestion is to have one generic folder for uploads then have CF 
poll that folder and move it to the right directory, but I do not know how tell 
if a file is complete or how to connect it to a user's session.

Is what I am asking possible?

Mike

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

Problem with MySQL

[Mickael Elmalem]

 Hello All,

I have a problem with an app that I inherited that was not working properly.   
The database is MySQL but they want to convert it to a new database after 
extracting the old data.  I do not have much experience with MySQL and I am 
stumped with one field that they have in the database. 

When I view the database via PHPMyAdmin I see that the field in question has a 
type of Blob with an Attribute of Binary.  This field as per the site is 
supposed to house text longer than a few character so similar to the memo type 
in Access.  When I browse the database throught the MyAdmin it says the the 
contents of the field are [BLOB - 1 Bytes] or [BLOB - 20 Bytes]

How do I extract that information from the as the raw text from this type of 
field?  I bought a MySQL to MSAccess converter and does the trick no problem 
expect for this field.

Any Ideas?

Thanks

Mike

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

[Mickael Elmalem]

I just want to get in a format that my client can view on thier desktop to 
reveiw some of the database contents then place it in MS SQL

Nice, helpful response there knucklehead. The BLOB datatype (Binary 
Large Object) is usually used for storing images in MySQL and stuff like 
that. My first question is, why in the world would you want to convert 
TO MS Access???

--Ferg

Munson, Jacob wrote:

Any Ideas?



Yeah, go ask this question on a mailing list that has MySQL experts, not
a CF mailing list.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

[Mickael Elmalem]

Hi Andy,

I looked at your page.  But could not see how you actually write a select 
statement to view the data.

BLOB fields aren't text, they hold raw data such as an image, DOC file or
something else. They're roughly similar to a TEXT field in that they hold
the same amount of data.
http://dev.mysql.com/doc/refman/4.1/en/blob.html

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Mickael Elmalem [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 25, 2005 8:40 AM
To: CF-Talk
Subject: Problem with MySQL


 Hello All,

I have a problem with an app that I inherited that was not working properly.
The database is MySQL but they want to convert it to a new database after
extracting the old data.  I do not have much experience with MySQL and I am
stumped with one field that they have in the database.

When I view the database via PHPMyAdmin I see that the field in question has
a type of Blob with an Attribute of Binary.  This field as per the site is
supposed to house text longer than a few character so similar to the memo
type in Access.  When I browse the database throught the MyAdmin it says the
the contents of the field are [BLOB - 1 Bytes] or [BLOB - 20 Bytes]

How do I extract that information from the as the raw text from this type of
field?  I bought a MySQL to MSAccess converter and does the trick no problem
expect for this field.

Any Ideas?

Thanks

Mike

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

OT-Visual Web Server

[Mickael Elmalem]

Hello,

Sorry for being OT but I am sure that someone on this list can help me out 
here.  I have an app that my customer wants to host on their own webserver.  I 
gave them the basic config that I require.  They came back to me and said that 
they have decided to go with a Single IP, name based Visual Web Server.

What is this thing?  I could not find a straight answer?

Thanks

Mike

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221904
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: OT-Visual Web Server

[Mickael]

That's what I thought at first too, but they said no.  It is a Visual Web 
Server.  What could this be?


From: Taco Fleur [EMAIL PROTECTED]
Sent: Friday, October 21, 2005 6:36 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: OT-Visual Web Server 

I think they mean virtual hosts? One IP address many hosts, it's the
webserver that decides to what website to route the traffic.

Taco Fleur - CEO
Pacific Fox http://www.pacificfox.com.au 
an industry leader with commercial IT experience since 1994 .

** Web Design and Development 
** SMS Solutions, including developer API
** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for
AUSD$50 two years!
** Seamless Merchant integration
** We endorse PayPal, accept payments online now!

 -Original Message-
 From: Mickael Elmalem [mailto:[EMAIL PROTECTED] 
 Sent: Saturday, 22 October 2005 11:29 AM
 To: CF-Talk
 Subject: OT-Visual Web Server
 
 
 Hello,
 
 Sorry for being OT but I am sure that someone on this list 
 can help me out here. I have an app that my customer wants 
 to host on their own webserver. I gave them the basic config 
 that I require. They came back to me and said that they have 
 decided to go with a Single IP, name based Visual Web Server.
 
 What is this thing? I could not find a straight answer?
 
 Thanks
 
 Mike
 
 



~|
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:221906
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: Problems Making a CF DSN to SQL Server

[Mickael Elmalem]

Hi Joe,

Do you know where I can get those updates?  Are they cumulative, so that if I 
install the lastone it will be enough?

Hi Mickael,

Have you made sure that the most recent SQL server updates are
installed?  I've had this exact problem after installing recent CF
JDBC drivers.

-Joe

On 10/18/05, Mickael Elmalem [EMAIL PROTECTED] wrote:


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221455
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: Problems Making a CF DSN to SQL Server

[Mickael Elmalem]

Hi Mark,

I have tried, localhost, my machine name also 127.0.0.1 

Nothing helps.  It is really strange.

Mickael,

Add an entry in your host file for your machine - or use localhost or
127.0.0.1. When you say my machine name' you are really talking about an
NBT name - and the JDBC system would not be able to resolve that. It uses
(in order) HOSTS file, DNS and IP.

-Mark


-Original Message-
From: Mickael Elmalem [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 18, 2005 3:07 PM
To: CF-Talk
Subject: Problems Making a CF DSN to SQL Server


 Hello All,

I need to do some work on a clients site locally on my machine.  This is a
new laptop that has just been installed for me.

I have installed CF 6.1 on the machine because that what the customer is
using and Sql Server.

I am not able however to get an MS SQL dsn in CF to work.  I go to data
sources in the CF Admin

Add the Datasource Name and select Microsoft SQL Server as a Driver

On the next screen I enter the database name, the server (my machine name)
username and password.

But the message that I get is

Connection Verification failed for data source : mydsn

Error Establishing Socket: Connection refused : Connect

But if I make the DSN via the OBDC manager in windows, then point to that
DSN using the ODBC socket option it works?

What am I doing wrong?  Shouldn't I be able to just connect.

I am running XP pro with Service Pack 2 , and have made sure that fire wall
is turned off.

~|
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:221456
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: Problems Making a CF DSN to SQL Server

[Mickael Elmalem]

One thing that I forgot to add that may be important is the I restored this 
database from a backup.  I created a new user in SQL and gave them owner 
permission to the database.  And used the new username for my CF DSN 
Connection.  I tried the exact same steps on CF7 with the same restore and it 
worked fine

Mickael,

Also, using the server network utility (part of SQL server tools) unload
the mixed protocol and named pipes - leaving ONLY tcip/ip.

-Mark


-Original Message-
From: Mickael Elmalem [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 18, 2005 3:07 PM
To: CF-Talk
Subject: Problems Making a CF DSN to SQL Server


 Hello All,

I need to do some work on a clients site locally on my machine.  This is a
new laptop that has just been installed for me.

I have installed CF 6.1 on the machine because that what the customer is
using and Sql Server.

I am not able however to get an MS SQL dsn in CF to work.  I go to data
sources in the CF Admin

Add the Datasource Name and select Microsoft SQL Server as a Driver

On the next screen I enter the database name, the server (my machine name)
username and password.

But the message that I get is

Connection Verification failed for data source : mydsn

Error Establishing Socket: Connection refused : Connect

But if I make the DSN via the OBDC manager in windows, then point to that
DSN using the ODBC socket option it works?

What am I doing wrong?  Shouldn't I be able to just connect.

I am running XP pro with Service Pack 2 , and have made sure that fire wall
is turned off.

~|
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:221462
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: Problems Making a CF DSN to SQL Server

[Mickael Elmalem]

Thanks Mike

This did the trick

 From: Mickael Elmalem [mailto:[EMAIL PROTECTED] 
 Do you know where I can get those updates?  Are they 
 cumulative, so that if I install the lastone it will be enough?

http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446-
99A9-B7F0213F8BC5displaylang=en

Mike

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

Problems Making a CF DSN to SQL Server

[Mickael Elmalem]

 Hello All,

I need to do some work on a clients site locally on my machine.  This is a new 
laptop that has just been installed for me.

I have installed CF 6.1 on the machine because that what the customer is using 
and Sql Server. 

I am not able however to get an MS SQL dsn in CF to work.  I go to data sources 
in the CF Admin

Add the Datasource Name and select Microsoft SQL Server as a Driver

On the next screen I enter the database name, the server (my machine name) 
username and password.

But the message that I get is

Connection Verification failed for data source : mydsn

Error Establishing Socket: Connection refused : Connect

But if I make the DSN via the OBDC manager in windows, then point to that DSN 
using the ODBC socket option it works?

What am I doing wrong?  Shouldn't I be able to just connect.

I am running XP pro with Service Pack 2 , and have made sure that fire wall is 
turned off.  

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

CFX_File

[Mickael Elmalem]

Hello,

I am having a lot of trouble with CFFile on an NT machine.  I poked around on  
google and found a tag called CFX_FILE, how do I get that tag?  This is for CF5

Thanks

Mike

~|
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:221382
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: CFX_File

[Mickael Elmalem]

Hi Scott 

Thanks for the link.  I tried the tag and it does not work for me.  There is a 
variable called CFXFError that you can output.

I keep getting Unknown Action: Copy?

Yet the html file that comes with it says that it supports copy?

Has anyone used this tag?

Mike




http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn106vi
ewName=Exchange%20Search%20Detailsauthorid=35342215page=0scrollPos=0subc
atid=0snid=sn106itemnumber=0extid=1000414catid=0



Scott A. Stewart
Cold Fusion Developer
 
GNSI
11820 Parklawn Dr
Rockville, MD 20852
(301) 770-9610  
-Original Message-
From: Mickael Elmalem [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 18, 2005 5:09 PM
To: CF-Talk
Subject: CFX_File

Hello,

I am having a lot of trouble with CFFile on an NT machine.  I poked around
on  google and found a tag called CFX_FILE, how do I get that tag?  This is
for CF5

Thanks

Mike

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

[Mickael Elmalem]

The tag is returning the message Action Unknow : Copy

Here is my code

CFX_FILE USERNAME=username
   PASSWORD=password
   ACTION=Copy
   source=\\machinename\sharename\file.txt
   destination=c:\inetpub\wwwroot\testfiles\


 From: Mickael Elmalem [mailto:[EMAIL PROTECTED] 
 I am having a lot of trouble with CFFile on an NT machine.  I 
 poked around on  google and found a tag called CFX_FILE, how 
 do I get that tag?  This is for CF5

What is the problem you are having, specifically?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

[Mickael Elmalem]

Tried that too.  I tried COPY, copy, Copy

Still no luck

Copy? [...] copy?

May be the check for the action is case sensitive. If it is a CFX, it 
must be in C or Java which bothe compare
strings case sensive by default.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.

~|
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:221397
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: CFX_File

[Mickael Elmalem]

The problem that I was trying to copy a file from an NT Share
and I was getting the following error

Error: Access is denied. (error 5).

This share is open to Everyone.

Mike


 From: Mickael Elmalem [mailto:[EMAIL PROTECTED] 
 The tag is returning the message Action Unknow : Copy

No, what is the problem you were having with the cffile tag on CF5 not the
CFX tag?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

[Mickael Elmalem]

Actually CF is running as a user account that has access to that share.

I have it working on a different machine with that setup.

But it still doesn't explain why CFX_FILE doesn't work.  Shouldn't the fact 
that the tag passes a username and password overcome the permission problem?

 The problem that I was trying to copy a file from an NT Share 
 and I was getting the following error
 
 Error: Access is denied. (error 5).
 
 This share is open to Everyone.
 

Is the CF service running under a local system account or a user account?
You won't be able to access shares if CF is running with local system
account permissions.

Paul

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

CFTRY and CFCATCH

[Mickael]

Hi All,

I have never really had a good handle on CFTRY and CFCATCH.  If I have 
an error on my website as follows


  The request has exceeded the allowable time limit Tag: CFQUERY


What type of cfcatch is that?  Or can that not be caught by CFCatch?

Mike




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

CF Query Timeout

[Mickael]

Hello,

I have a unique situation that I only have limited control over.  I was 
hoping someone on the list could provide some assistance.

Here is my issue.  A have a CF Site on a shared hosting account at 
Crystaltech.  The database is Access.  This was fine for a certain 
amount of time but now either there is too much activity on the shared 
box or the query are returning too much data that the CFQUERY timeout is 
becoming and issue.

The data in access is being supplied from the client via FTP and the CF 
app accesses it.  It is over written over night.  I can change the way 
the client gives me the data it is an automated process.

So I was thinking that I would mirror the exact tables in MS SQL then 
once a night select all the content from Access and insert it into SQL.  
Then have all my users access the SQL tables.

Sounds logical, the only issue is that I can get the all the records to 
insert into the MSSQL database in a timely fasion.  I keep getting the 
CFQERY timeout.

Maybe its the way that I am doing it that is inefficient.  I am using 
both DSN like so,

cfquery name=GetPayments datasource=#request.AccessDsn#
Select * from Client_Pmt
/cfquery

cfoutput query=GetPayments

cfquery datasource=#request.MSSQLDsn# 
name=qry_insertPayments
insert into Client_Pmt
(Acct_id, PMT_Date,Pmt_Code,PMTAMT)
Values (#Getpayments.DEBT_ID#, 
'#Getpayments.PMT_DATE#',  '#Getpayments.PMT_CODE#', #Getpayments.PMTAMT#)
   
/cfquery

/cfoutput

Is there a better way to do this?


Thanks

Mike




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220500
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: block forms from being filled out automatically

[Mickael]

I have just tried changing the address of the form to see if throws the 
spammer off

Mike Kear wrote:

I had one of these too. As far as I could tell, it was an automated process 
to harvest the email addresses where forms send back a confirmation or 
thanks by email.
 In my case, the spammer was filling out the same information in every 
field, so all I did was change the action page so that if field1 = field2 = 
field3 = field4, it just gave a 'thanks' page on the site, sent no email out 
and dumped the results. The problem went away then. I dont know if the 
spammer still has his computer pointed at my client's site or not. 
 Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET http://ASP.NET hosting from AUD$15/month 


 On 9/14/05, Mickael [EMAIL PROTECTED] wrote: 
  

Hi,

One of my clients is getting bombarded by some jerk, connection to a
form on his webpage and filling out the fields with junk and submitting
the forms. What can I do to prevent a computer from filling out my
forms. I don't really want to use that crazy jumbled image where to you
type in the letters you see.

Any advise?

Thanks

Mike








~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

block forms from being filled out automatically

[Mickael]

Hi,

One of my clients is getting bombarded by some jerk, connection to a 
form on his webpage and filling out the fields with junk and submitting 
the forms.  What can I do to prevent a computer from filling out my 
forms.  I don't really want to use that crazy jumbled image where to you 
type in the letters you see.

Any advise?

Thanks

Mike



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

Gateway Pages and IIS

[Mickael]

Hi All,

I am hoping that someone on this list has worked through this before I 
reinvent the wheel.  We have a small content management system that we 
have written that allows users to make changes to their site.  We would 
like to add a new feature where users can create gateway for marketing.  
When our users create a new page on our system the URL ends up being 
www.ourdomain.com/index.cfm?pageid=111 (or what ever number).  Our issue 
now is that we would like to make pages that easier to read and print on 
advertising.  So for example if they create a page that is connect to 
Marketing they would like to be able to access that page via 
www.domain.com/marketing

The only way that I can see this working is to create an interface in my 
CMS that would create a new folder in the webroot of thier choosing and 
insert an index.cfm file in at folder with a cflocation tag point ing 
to index.cfm?pageid=111 or whatever the url.

This solution would work, but would create a ton of folders in our 
webroot, and we also have our own folders for the app there as well.  My 
question is there a more elegant way of handling this problem?  We have 
played with the idea of adding an Intelligent 404 page but part of the 
goal is to have their stats package also track the accesses to these pages.

I was just wondering what other people are doing?  We are Using IIS as a 
web server.

Thanks

Mike



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214777
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: Gateway Pages and IIS

[Mickael]

Hi Russ

I agree with you, but my client think that pages with Extensions are not 
nice looking they want folders.

Mike

Russ Michaels wrote:

You would really want static pages as gateway pages anyway, to make them
search engine friendly, which I presume is the reason your doing it.
So generating a www.doamin.com/marketing.htm page would be better than
www.ourdomain.com/index.cfm?pageid=111

Russ

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: 12 August 2005 16:59
To: CF-Talk
Subject: Gateway Pages and IIS

Hi All,

I am hoping that someone on this list has worked through this before I
reinvent the wheel.  We have a small content management system that we have
written that allows users to make changes to their site.  We would like to
add a new feature where users can create gateway for marketing.  
When our users create a new page on our system the URL ends up being
www.ourdomain.com/index.cfm?pageid=111 (or what ever number).  Our issue now
is that we would like to make pages that easier to read and print on
advertising.  So for example if they create a page that is connect to
Marketing they would like to be able to access that page via
www.domain.com/marketing

The only way that I can see this working is to create an interface in my CMS
that would create a new folder in the webroot of thier choosing and insert
an index.cfm file in at folder with a cflocation tag point ing to
index.cfm?pageid=111 or whatever the url.

This solution would work, but would create a ton of folders in our webroot,
and we also have our own folders for the app there as well.  My question is
there a more elegant way of handling this problem?  We have played with the
idea of adding an Intelligent 404 page but part of the goal is to have their
stats package also track the accesses to these pages.

I was just wondering what other people are doing?  We are Using IIS as a web
server.

Thanks

Mike







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

Displaying a TimeStamp in CF

[Mickael]

Hello,

I have been trying to Steve Ray's Bugtracker to work on my laptop.  I 
know the code works but I am not sure what database this was originally 
designed for.  I am using MSSQL and CFMX 7.  The code is trying to 
return a field called change_date the datatype in MSSQL is TimeStamp, 
the coldfustion code wants to output it as 
#dateformat(change_date,'mm/dd/')# which looks fine to me if this 
was a regular datefield, but when I go to look at the value of the data 
in the field via enterprise manager it says binary.

The coldfusion error that I am getting is the following

 The value class [B could not be converted to a date.

My question is since this is a timestamp (binary) field is there anther 
way to return the value in CF then what I have display above?  Also how 
can a date be Binary?

Thanks

Mike



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213377
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: OT - MySQL to MSSQL

[Mickael]

Thanks I will try that.
- Original Message -
From: George Abraham [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, July 01, 2005 2:36 PM
Subject: Re: OT - MySQL to MSSQL


 Mickael,
 DTS comes with MS SQL's Enterprise Manager. And yes, DTS will create
 the tables, etc. for you. It does a bad job of some things during the
 export. For example, I would check the properties of fields that were
 designated as primary keys or are ID fields and make sure that they
 are so after the export.

 If you really want to be careful, export the structure of the mySQL
 database (tables, etc) to a text file (DDL) and then run the DDL
 script using Enterprise Manager's Query Analyzer. Make sure that the
 tables are designated as owned by the dbo, if that is important to
 you. Then use DTS to import the data. Note that this way will take a
 far longer time and effort from you, since you will have to make sure
 that all the incoming fields (from mySQL) line up with those in SQL
 Server. DTS will try to line up whatever it things are right, but
 sometimes it gets things wrong.

 George

 On 7/1/05, Mickael [EMAIL PROTECTED] wrote:
  Hi George,
 
  I have never used DTS.  Will it with DTS create the Tables and structure
for
  me automatically?  Or do I need create all the tables first?
  - Original Message -
  From: George Abraham [EMAIL PROTECTED]
  To: CF-Talk cf-talk@houseoffusion.com
  Sent: Friday, July 01, 2005 10:56 AM
  Subject: Re: OT - MySQL to MSSQL
 
 
   I did this a long time ago, but if I remember correctly, all you need
   are the mySQL ODBC driver and MS SQL Server's Enterprise Manager.
   Install the ODBC driver, then use DTS in Enterprise Manager to
   transfer the tables and the data.
  
   HTH,
   George
  
   On 7/1/05, Mickael [EMAIL PROTECTED] wrote:
Hi All,
   
I was wondering if someone can point me to the best way to import a
=
MySQL Database to a new MS SQL Database.  There is an export utility
in
  =
MySQL that exports that tables to a text file with the create table
=
statements and all the content.  But I think this only works from
One =
MySQL database to another.  Is there an easy way to do this in CF?
I =
have the MySQL DSN setup and the MSSQL DSN setup on the same box?
   
I have have seen a lot of utilities out there for MySQL to Access.
My =
issue is that the database needs to have more than 255 fields Access
=
does not support more than 255 fields.
   
Thanks
   
   
   
Mike Elmalem
   
   
   
   
   
   
  
  
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

OT - MySQL to MSSQL

[Mickael]

Hi All,

I was wondering if someone can point me to the best way to import a =
MySQL Database to a new MS SQL Database.  There is an export utility in =
MySQL that exports that tables to a text file with the create table =
statements and all the content.  But I think this only works from One =
MySQL database to another.  Is there an easy way to do this in CF?  I =
have the MySQL DSN setup and the MSSQL DSN setup on the same box?

I have have seen a lot of utilities out there for MySQL to Access.  My =
issue is that the database needs to have more than 255 fields Access =
does not support more than 255 fields.

Thanks



Mike Elmalem





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211013
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: Fusebox + Sajax?

[Mickael]

I thought Fusebox works in PHP as well?
- Original Message -
From: Damien McKenna [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, July 01, 2005 9:59 AM
Subject: Fusebox + Sajax?


 Has anyone tried using Sajax in a Fusebox application?  I was concerned
 over how the two might clash as Sajax passes the data to/from
 pagename.cfm?rs=functionname which in theory would cause problems with a
 Fusebox application's fuseactions.  Any thoughts?

 BTW, the reason I was looking to use Sajax was because its
 multi-language, so I can use the same framework in both my PHP and CFML
 work.

 --
 Damien McKenna - Web Developer - [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
 The Limu Company - http://www.thelimucompany.com/
 http://www.thelimucompany.com/  - 407-804-1014
 #include stdjoke.h



 

~|
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:211022
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: OT - MySQL to MSSQL

[Mickael]

Hi George,

I have never used DTS.  Will it with DTS create the Tables and structure for
me automatically?  Or do I need create all the tables first?
- Original Message -
From: George Abraham [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, July 01, 2005 10:56 AM
Subject: Re: OT - MySQL to MSSQL


 I did this a long time ago, but if I remember correctly, all you need
 are the mySQL ODBC driver and MS SQL Server's Enterprise Manager.
 Install the ODBC driver, then use DTS in Enterprise Manager to
 transfer the tables and the data.

 HTH,
 George

 On 7/1/05, Mickael [EMAIL PROTECTED] wrote:
  Hi All,
 
  I was wondering if someone can point me to the best way to import a =
  MySQL Database to a new MS SQL Database.  There is an export utility in
=
  MySQL that exports that tables to a text file with the create table =
  statements and all the content.  But I think this only works from One =
  MySQL database to another.  Is there an easy way to do this in CF?  I =
  have the MySQL DSN setup and the MSSQL DSN setup on the same box?
 
  I have have seen a lot of utilities out there for MySQL to Access.  My =
  issue is that the database needs to have more than 255 fields Access =
  does not support more than 255 fields.
 
  Thanks
 
 
 
  Mike Elmalem
 
 
 
 
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

Zipping or Rar Large Files with Coldfusion

[Mickael]

Hello,

I have a really large Txt file that I would like to Zip then Send to my server 
then upzip it there using CFX_ZIP.  The problem that I am running in to is that 
the file is too large for a valid zip archive the file is over 5gb.  Each time 
I try to unzip it on the server I get a corrupt file.  

I know that RAR supports large file sizes but I do not know of a tag in CF that 
un rars files on the server.

Has anyone run it to this problem?  Any suggestions?

Thanks,


Mike Elmalem
eFactory Inc.
416-836-9460



~|
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:208626
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: Zipping or Rar Large Files with Coldfusion

[Mickael]

That is a good suggestion.  Thanks Brad I will give it a try.

 Mike


From: Brad Roberts [EMAIL PROTECTED]
Sent: Sunday, June 05, 2005 3:37 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: Zipping or Rar Large Files with Coldfusion 

I use the command line tools for WinRAR
(http://www.rarlab.com/download.htm), using cfexecute. Works well for me,
but the largest file I've unzipped is around 100 meg.

HTH,

Brad Roberts

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: Sunday, June 05, 2005 5:18 PM
To: CF-Talk
Subject: Zipping or Rar Large Files with Coldfusion

Hello,

I have a really large Txt file that I would like to Zip then Send to my
server then upzip it there using CFX_ZIP. The problem that I am running in
to is that the file is too large for a valid zip archive the file is over
5gb. Each time I try to unzip it on the server I get a corrupt file. 

I know that RAR supports large file sizes but I do not know of a tag in CF
that un rars files on the server.

Has anyone run it to this problem? Any suggestions?

Thanks,

Mike Elmalem
eFactory Inc.
416-836-9460



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

[Mickael]

Hi Dustin

I was referring to an editor that you can use via a webpage
- Original Message -
From: Dustin M Snell [Network Automation]
[EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, March 23, 2005 6:24 PM
Subject: RE: HTML Editor


 Why not Dreamweaver MX 2004? That's my favorite one.

 -Dustin

 -Original Message-
 From: Mickael [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, March 23, 2005 3:02 PM
 To: CF-Talk
 Subject: HTML Editor

 Hello All,

 I am sorry for being OT but I was wondering if anyone could point me in
the
 right direction in regards to an HTML Editor that can be used for my users
 to edit their own pages.

 I have been using FCK editor and SoEditor but find that their support for
 stylesheets is terrible.  Can an anyone recommend a good reliable editor
 that I can use or buy.


 Thanks

 Mike





 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

HTML Editor

[Mickael]

Hello All,

I am sorry for being OT but I was wondering if anyone could point me in the 
right direction in regards to an HTML Editor that can be used for my users to 
edit their own pages.

I have been using FCK editor and SoEditor but find that their support for 
stylesheets is terrible.  Can an anyone recommend a good reliable editor that I 
can use or buy.


Thanks

Mike



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

Hosting for SEMI dedicated

[Mickael]

Hi All,

I know that hosting has been discussed many times on this list.  But I would 
still like to know who the stars are.  I am presently hosting with 
Hostmysite.com and crystaltech.com but as of late their machines are getting 
overloaded.  I am looking for semi dedicated hosting for CF 6.1 and SQL server. 
 Can anyone recommend a company that they have had a good experience with?  The 
two companies that I am with answer the phone 7/24 which is a big plus as well.

Thanks

Mike



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199226
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: Hosting for SEMI dedicated

[Mickael]

Will they be able to stay on 6.1 for a while.  There seems to be an issue
with FB4 Code running CFMX7 that I would rather not get in to right now
until the proper fixes get resolved.

Mike
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, March 17, 2005 4:24 PM
Subject: RE: Hosting for SEMI dedicated


 AHP has some VPS server deals for CF-Talk readers:
 http://www.fusionauthority.com/Article.cfm/ArticleID:4381
 They actually provide the bandwidth for House of Fusion/Fusion Authority
and
 some of my new stuff is going up on one of their VPS servers.

  Hi All,
 
  I know that hosting has been discussed many times on this list.  But I
  would still like to know who the stars are.  I am presently hosting with
  Hostmysite.com and crystaltech.com but as of late their machines are
  getting overloaded.  I am looking for semi dedicated hosting for CF 6.1
  and SQL server.  Can anyone recommend a company that they have had a
good
  experience with?  The two companies that I am with answer the phone 7/24
  which is a big plus as well.
 
  Thanks
 
  Mike
 
 
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

UI Problems

[Mickael]

Hello All,

My developer and I are working on a CMS for various clients.  Our clients keep 
coming up with new requirements as the project grow or change.  We are not 
having any issues meeting these requirement for new functionality on the 
website.  But in my opinion we are not achieving an elegant and easy to use 
interface.  As I review the interfaces I am finding that they are very 
configurable, very scalable yet I feel that they are written for programmers or 
people of a technical background which kind of defeats the purpose of creating 
a CMS in the first place.  I am sure that many people on this have faced the 
same issue.  Can any one suggest a good resource for making easy to understand 
user interfaces, books, sites anything.  

BTW if anyone feels that they are an expert in this field I am also open to 
paying for Consulting in this matter.

Thanks

Mike




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

[Mickael]

Can someone send me Jim's note I did not get it, strange?
- Original Message -
From: Calvin Ward [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, March 14, 2005 10:30 AM
Subject: RE: OT - UI problems


 I have to disagree. This is very much on topic in my opinion. Since when
is
 discussing UI design for a CF application not appropriate for cf-talk?

 I liked the rest of your post, very useful and well written.

 - Calvin

 -Original Message-
 From: Jim Davis [mailto:[EMAIL PROTECTED]
 Sent: Sunday, March 13, 2005 3:59 PM
 To: CF-Talk
 Subject: RE: OT - UI problems

  -Original Message-
  From: Mickael [mailto:[EMAIL PROTECTED]
  Sent: Sunday, March 13, 2005 9:51 AM
  To: CF-Talk
  Subject: OT - UI problems
 
  Hello All,

 First off you might consider posting this to cf-community - the discussion
 there could go much farther than here.


 

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

OT - UI problems

[Mickael]

Hello All,

My developer and I are working on a CMS for various clients.  Our clients keep 
coming up with new requirements as the project grow or change.  We are not 
having any issues meeting these requirement for new functionality on the 
website.  But in my opinion we are not achieving an elegant and easy to use 
interface.  As I review the interfaces I am finding that they are very 
configurable, very scalable yet I feel that they are written for programmers or 
people of a technical background which kind of defeats the purpose of creating 
a CMS in the first place.  I am sure that many people on this have faced the 
same issue.  Can any one suggest a good resource for making easy to understand 
user interfaces, books, sites anything.  

BTW if anyone feels that they are an expert in this field I am also open to 
paying for Consulting in this matter.

Thanks

Mike



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

Redirects on Region

[Mickael]

Hello All,

I was wondering if someone could tell me how the following is done. 

When you go to google.com for instance it knows that I am from Canada and 
redirects me to google.ca.  I would like to implement the same sort of thing on 
a site that I working on.  For me is it is a little simpler, the site is for 
people in Israel and the rest of the world.  So when they type in my domain if 
they are in Israel I would like to redirect to a site, and all other people I 
would like to redirect them to the international site.

I tried using the OS language setting but this is not very reliable, as people 
can have their pcs set to many different languages yet they are all in the same 
country.

Is there some kind of IP listing that I can query?

Mike



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

[Mickael]

Hi Jochem,

Thanks for the info.  I haven't looked at it in its entirety yet.  But is
says something about loading a jar file on the server.  I am on shared
hosting, is that something that I can do in my webspace or requires the
hosting company to install?
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, February 20, 2005 12:01 PM
Subject: Re: Redirects on Region


 Mickael wrote:
 
  When you go to google.com for instance it knows that I am from Canada
and redirects me to google.ca.  I would like to implement the same sort of
thing on a site that I working on.  For me is it is a little simpler, the
site is for people in Israel and the rest of the world.  So when they type
in my domain if they are in Israel I would like to redirect to a site, and
all other people I would like to redirect them to the international site.
 
  I tried using the OS language setting but this is not very reliable, as
people can have their pcs set to many different languages yet they are all
in the same country.

 Check out Paul Hastings geoLocator: http://www.cfczone.org/

 Jochem

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

[Mickael]

Cool thanks
- Original Message -
From: Paul Hastings [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, February 20, 2005 9:57 PM
Subject: Re: Redirects on Region


 Mickael wrote:
  Thanks for the info.  I haven't looked at it in its entirety yet.  But
is
  says something about loading a jar file on the server.  I am on shared
  hosting, is that something that I can do in my webspace or requires the
  hosting company to install?

 first off, you should get the latest version:

 http://www.sustainablegis.com/projects/geoLocator/

 the zip there also contains a file using spike's remote classpath method
 to get around shared host problems. at a minimum though you'll need
 createobject.

 

~|
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:195713
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 - Sql Help

[Mickael]

Hi All,

I am a little stumped with the following task in SQL which seems simple enough 
to me.  I have a form that my users can select a range of Dates for a 
particular report.  The range is not day month year, but month and year and 
ending month and year.

In my database I have a date field, it is only one date.  The date is 
(dd/mm/) format.  Let's say that I have
5 records for Jan 5, 5 records for Feb 1 and 5 records for feb 15.

I would like to capture those 15 records by saying

select * from table where date between Jan2005 and feb2005 ( so in essence
not having to say Jan 1, 2005 and Feb 28, 2005)

Can this be done?

Thanks

Mike





~|
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:195184
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: OT - Sql Help

[Mickael]

Hi Rick,

That is simple.  Thanks just what I was looking for
- Original Message -
From: Rick Root [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, February 17, 2005 11:26 AM
Subject: Re: OT - Sql Help


 Mickael wrote:
 
  select * from table where date between Jan2005 and feb2005 ( so in
essence
  not having to say Jan 1, 2005 and Feb 28, 2005)

 How about:

 WHERE
 MONTH(date) = 1 and
 YEAR(date) = 2005) and
 MONTH(date) = 2 and
 YEAR(date) = 2005




 

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

Looking for an FB4 Developer

[Mickael]

Hello All,

Sorry for being OT.  I am looking for a developer in the Toronto Area 
preferably or someone that is really good at working remotely.  To make some 
ongoing changes and work on a CFMX Fusebox 4 site.  Should have a good 
understanding of FB4 and MSSQL (stored procs)

Please reply off list.

Thank you,

Mike



~|
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:194203
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: Replacing variable text in a string

[Mickael]

Hi Ryan,

This is not working for me either.  Here is what I have

cfoutput#DisplaySql#/cfoutput

hr

cfoutput#REReplaceNoCase(DisplaySql,set primary_assign_id
=[[:digit:]]{3},,ALL)#/cfoutput

When I out put the DisplaySQL variable each instance looks the same.  I am
wonder if the digit part is an issue?  Could it be that the numbers are
coming across as text and not being recognized?

Just seems so simple that it should work.  One thing about my variable is
that I am using PreservesingleQuotes() to create it.  Could that have
anything to do with it?

Mike
- Original Message -
From: Ryan Duckworth [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 01, 2005 4:25 PM
Subject: RE: Replacing variable text in a string


 This works and is tested:

 cfscript
 yourString = set primary_assign_id = 123;
 /cfscript

 cfoutput
 #REReplaceNoCase(yourString,set primary_assign_id =
 [[:digit:]]{3},,ALL)#
 /cfoutput

 Good luck.

 Ryan Duckworth
 Macromedia ColdFusion Certified Professional
 Uhlig Communications
 10983 Granada Lane
 Overland Park, KS 66211
 (913) 754-4272

 -Original Message-
 From: Mickael [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, February 01, 2005 2:43 PM
 To: CF-Talk
 Subject: Re: Replacing variable text in a string

 Hey Scott,

 This is not working for me.  I corrected the typo from Palace to place
 but
 it is not working.  Any Ideas?

 Thanks

 Mike
 - Original Message -
 From: Scott Stroz [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Tuesday, February 01, 2005 2:04 PM
 Subject: Re: Replacing variable text in a string


  RERepalce(yourString,set primary_assign_id = [:digit:]{3},,all)
 
  Should work, but has not been tested.
 
 
  On Tue, 1 Feb 2005 12:57:51 -0500, Mickael [EMAIL PROTECTED] wrote:
   Hello,
  
   I would like replace a portion of a string that is a SQL statement
 generated by my users via an interface that I have created.  I have
 never
 used Regular Expressions but from what I have heard about this task
 sounds
 like a candidate.
  
   I would like to update a SQL statement that is generated by my users
 there is a portion of the string that says set primary_assign_id = 123
 that I would like to remove the problem is that I am not sure what the
 number is but I know that it always three numbers.
  
   How can I do this?
  
   Regards,
  
   Mike
  
  
 
 



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192730
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: Replacing variable text in a string

[Mickael]

Please disregard Ryan,

This is working fine, it seems that I left out a space before the Digit
statement.

Thanks




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

Replacing variable text in a string

[Mickael]

Hello,

I would like replace a portion of a string that is a SQL statement generated by 
my users via an interface that I have created.  I have never used Regular 
Expressions but from what I have heard about this task sounds like a candidate.

I would like to update a SQL statement that is generated by my users there is a 
portion of the string that says set primary_assign_id = 123 that I would like 
to remove the problem is that I am not sure what the number is but I know that 
it always three numbers.

How can I do this?  

Regards,

Mike



~|
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:192608
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: Replacing variable text in a string

[Mickael]

Hey Scott,

This is not working for me.  I corrected the typo from Palace to place but
it is not working.  Any Ideas?

Thanks

Mike
- Original Message -
From: Scott Stroz [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 01, 2005 2:04 PM
Subject: Re: Replacing variable text in a string


 RERepalce(yourString,set primary_assign_id = [:digit:]{3},,all)

 Should work, but has not been tested.


 On Tue, 1 Feb 2005 12:57:51 -0500, Mickael [EMAIL PROTECTED] wrote:
  Hello,
 
  I would like replace a portion of a string that is a SQL statement
generated by my users via an interface that I have created.  I have never
used Regular Expressions but from what I have heard about this task sounds
like a candidate.
 
  I would like to update a SQL statement that is generated by my users
there is a portion of the string that says set primary_assign_id = 123
that I would like to remove the problem is that I am not sure what the
number is but I know that it always three numbers.
 
  How can I do this?
 
  Regards,
 
  Mike
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

OT-SES Consultants

[Mickael]

Hi All

Sorry for being OT.  I have a client that needs search engine optimization done 
on their website.  I would like hire a consultant to do this for me.  The site 
already has SES friend URLs.  Can anyone recommend a good and reliable SEO 
consultant offlist, someone that you have had good experience with.

Thank you

Mike



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

OT Content Protection

[Mickael]

Hi All,

Sorry for being OT.  But I was wondering how the following was accomplished.  I 
went to the following page 

http://www.nymity.com/pipeda/pipeda.asp#4_9principle9individualaccess

And I was not able to highlight the text, to copy in IE or able to Right click 
copy in Firefox.

How is this done?

Mike


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

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

OpenSource Calendar

[Mickael]

Hello All,

I am donating some time to a charitable organization.  They need a web calendar 
like the monthly view in Outlook.  Were  the day is broken down in 1 hour 
increments and those one hour slots can be booked.

Is there something like that in CF available in opensource or something that is 
close that I can modify slightly to get working.  Trying not to make this a big 
project so that it will not cost them anything.

Thanks

Mike


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

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

[Mickael]

Hi David,

Actually all three views would be great.  Is there a demo of this working?
- Original Message -
From: COLLIE David [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, December 03, 2004 8:04 AM
Subject: RE: OpenSource Calendar


  I am donating some time to a charitable organization.  They
  need a web calendar like the monthly view in Outlook.  Were
  the day is broken down in 1 hour increments and those one
  hour slots can be booked.

 Sorry to be pedantic but that is the week/day view... The month view is
 like a normal calendar.

 You may want to look at this thread...

 http://www.houseoffusion.com/cf_lists/messages.cfm/threadid:36802/forumi
 d:4

 --
 dc

 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

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

[Mickael]

Its nice but it is a date picker not really an events calendar.
- Original Message -
From: Dawson, Michael [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, December 03, 2004 9:10 AM
Subject: RE: OpenSource Calendar


 Yes. I love this calendar.

 -Original Message-
 From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED]
 Sent: Friday, December 03, 2004 7:02 AM
 To: CF-Talk
 Subject: Re: OpenSource Calendar

 Hi Mickael
 maybe this is the best web calendar on the web:

 http://dynarch.com/mishoo/calendar.epl

 Open source...

 Cheers

 Marco


 On Fri, 3 Dec 2004 07:50:37 -0500, Mickael [EMAIL PROTECTED] wrote:
  Hello All,
 
  I am donating some time to a charitable organization.  They need a web
 calendar like the monthly view in Outlook.  Were  the day is broken down
 in 1 hour increments and those one hour slots can be booked.
 
  Is there something like that in CF available in opensource or
 something that is close that I can modify slightly to get working.
 Trying not to make this a big project so that it will not cost them
 anything.
 
  Thanks
 
  Mike
 
 



 

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

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

[Mickael]

This is cool.  Thanks Steve.
- Original Message -
From: Steve Bryant [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, December 03, 2004 11:10 AM
Subject: Re: OpenSource Calendar


 You might take a look at this one:

 http://cfopen.org/projects/coldcalendar/

 (one of several nifty things on cfopen)

  I am donating some time to a charitable organization.  They need a web
  calendar like the monthly view in Outlook.  Were  the day is broken
  down in 1 hour increments and those one hour slots can be booked.
 
  Is there something like that in CF available in opensource or
  something that is close that I can modify slightly to get working.
  Trying not to make this a big project so that it will not cost them
  anything.
 
  Thanks
 
  Mike

 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

OT Customize DW's HTML tags

[Mickael]

Hi All,

I sure this is possible, but I just wanted to know where to do it.  I would 
like to customize DWMX so that when I select a tag it comes out how I chose.

For example when I select img it comes out as 

img src=image.gif

But I would like the default to be

img src=image.gif border=0

And other tags that I would like to customize as well.  Where is this done?

Mike


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

[Mickael]

Hi Barney,

I installed it. And it works great!

Thanks


- Original Message -
From: Barney Boisvert [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, November 09, 2004 4:12 PM
Subject: Re: DW Title Bar


 Nope, MM wouldn't want DW to be easy to use like that.  I know there's
 a plugin at communitymx.com that will add a new bar to your display
 that contains the full path of the current document, as well as add a
 button for jumping to it in the files panel.  That's about it though.

 cheers,
 barneyb

 On Tue, 9 Nov 2004 14:53:34 -0500, Mickael [EMAIL PROTECTED] wrote:
  Hi All,
 
  I was wondering if someone knows if it is possible to customize DW
slightly.  On my PC I have a copy of a Development site and the Production
Site.  Since both sites are essentially the same, I am having a hard time
looking at templates from both sites and determining where they are from.
 
  When I open a file in DW the title bar says FOLDER/FILENAME This site
goes a few folders deep, my question is.  Is there a way to expose more of
the file path in the Title Bar for DW?
 
  Sorry for being OT
 
  Mike
 
 

 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

DW Title Bar

[Mickael]

Hi All,

I was wondering if someone knows if it is possible to customize DW slightly.  
On my PC I have a copy of a Development site and the Production Site.  Since 
both sites are essentially the same, I am having a hard time looking at 
templates from both sites and determining where they are from.

When I open a file in DW the title bar says FOLDER/FILENAME This site goes a 
few folders deep, my question is.  Is there a way to expose more of the file 
path in the Title Bar for DW?

Sorry for being OT

Mike



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

Adding Values in Browser

[Mickael]

Hello All,

I need to create a form that is modelled after an excel spreadsheet with formulas.  
What the spread sheet does is calculate expenses using the values being entered in its 
fields.

i.e.

Rent = $500
Food = $250
Water = $150
etc..

Total = (the total of the above.)

How do you do this with out reloading the page?  Do you need to be a javascript expert 
or is this relatively easy to do?

Thanks

Mike



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

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

SQL Mask not using CF

[Mickael]

Hi All

I was wondering if someone could help me out with the following SQL function.

I would like to select Today(*) from my database but have it display as Thursday, 
October 28, 2004

This is easily done with a mask in CF but is there  a way to do it right in my select 
statement?

Something like (ddd, , dd, , today(*)) 

I working with a sybase database.

Thanks

Mike



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

Buying Studio MX

[Mickael]

Hi All,

Is there anyone on this list can point me to a place where I can buy a Boxed version 
of Studio MX with Flash Pro cheaper than I can from the Macromedia site?  I am in 
Toronto Canada

Sorry for being OT

Mike


~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

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

OT .NET

[Mickael]

Hi All

Sorry for being OT.  But could anyone point me to a good resource to learn .NET, from 
the begining (hopefully skipping console apps).  I am interested in Web and Windows 
apps.

Also if anyone could share their thoughts about VB.NET and C# which to learn?

Please note that I am not a formal trained programmer.

Thanks 

Mike


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

[Mickael]

Dave,
Thanks for the resources

I don't want to start the whole .net vs cf discussion here.  But is it
possible to build things as quick as you can in C# as you can in CF?  Are
somethings faster better in C#?

Mike
- Original Message - 
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 12:49 PM
Subject: RE: OT .NET


  Sorry for being OT.  But could anyone point me to a good
  resource to learn .NET, from the begining (hopefully skipping
  console apps).  I am interested in Web and Windows apps.

 You don't want to skip console apps! They're very helpful for learning
 fundamental programming without the complexities of GUI building. In that
 vein, you might want to take a look at Programming in the Key of C#,
which
 is an introduction to C# for non-programmers:


http://www.amazon.com/exec/obidos/tg/detail/-/0735618003/qid=1098376723/sr=1
 -1/ref=sr_1_1/104-8014579-3212717?v=glances=books

 Personally, I liked the O'Reilly Programming C# book by Jesse Liberty,
 which focuses on C# syntax but covers ASP.NET and Windows Forms along the
 way.

  Also if anyone could share their thoughts about VB.NET and C#
  which to learn?

 I would recommend that you learn C# instead of VB.NET. C# is the reference
 language for the .NET platform, and it's a C-style language.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 phone: 202-797-5496
 fax: 202-797-5444


 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

[Mickael]

will do
- Original Message - 
From: Donna French [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 12:40 PM
Subject: Re: OT .NET


 I've taken a college course and learned the basics of VB.NET and
 Visual Studio, but we only worked with windows forms - no ASP.NET. So
 I've been going through the tutorial at W3Schools (www.w3schools.com).
 They also have tutorials on the .NET framework which you'll need at
 least a basic understanding of before diving into the others.

 If you find something else that works great for you let me know. I'm
 always looking for good tutorials b/c I learn best by example instead
 of reading page after page of explanation.

 HTH,
 Donna


 On Thu, 21 Oct 2004 12:26:55 -0400, Mickael [EMAIL PROTECTED] wrote:
  Hi All
 
  Sorry for being OT.  But could anyone point me to a good resource to
learn .NET, from the begining (hopefully skipping console apps).  I am
interested in Web and Windows apps.
 
  Also if anyone could share their thoughts about VB.NET and C# which to
learn?
 
  Please note that I am not a formal trained programmer.
 
  Thanks
 
  Mike
 
 

 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182221
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: Problems with Excelsheet in French from Coldfusion

[Mickael]

Well I have made some progress with this I am using cfset locale = SETLOCALE(French (Canadian)) and lscurrencyformat

Now the strange thing is when I view the html results everything looks fine for numbers under 1000
For example if I have a value 498,13$ when I export it to excel if display as a numeric value but if the number was higher let say add 1k to it.It would display as 1 498,13$ with a space for every thousand separator now when I export this to excel all the values that or greater than 999,99$ or (999,99$) download a character instead of the space and get formatted as text in excel as opposed to numbers.

Any Ideas on how I can fix this?

Thanks 

Mike
- Original Message - 
From: Mickael 
To: CF-Talk 
Sent: Friday, September 17, 2004 10:02 AM
Subject: Problems with Excelsheet in French from Coldfusion

Hello,

I am having an issue with an excel spreadsheet that I make with Coldfusion.The issue is with the dollar values in the sheet.When viewed with an English machine the values show up as currency in Excel which is good.But when viewed with a French Canadian machine the dollar values come out as text.This is preventing the users from adding any forumulas to the spread sheet or treating the values as a currency.

Any Ideas on how I can correct this?

Thanks in advance

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Problems with Excelsheet in French from Coldfusion

[Mickael]

Hello,

I am having an issue with an excel spreadsheet that I make with Coldfusion.The issue is with the dollar values in the sheet.When viewed with an English machine the values show up as currency in Excel which is good.But when viewed with a French Canadian machine the dollar values come out as text.This is preventing the users from adding any forumulas to the spread sheet or treating the values as a currency.

Any Ideas on how I can correct this?

Thanks in advance

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: HTTPS post

[Mickael]

Thanks Lee,

That worked great!
- Original Message - 
From: Lee Howard 
To: CF-Talk 
Sent: Monday, September 13, 2004 8:57 PM
Subject: Re: HTTPS post

How about using a com object.Something like this in VB. 

Dim objXMLHTTP, xml, response
 Set xml = CreateObject(MSXML2.XMLHTTP)

 ' Notice the two changes in the next two lines:
 xml.Open POST, http://www.webserver.com/Find, false
 xml.setRequestHeader Content-Type, application/x-www-form-urlencoded
 xml.Send action="">
 response = xml.responseText
 Set xml = Nothing

found something similar here:
http://www.developerfusion.com/show/3272/2/

On Mon, 13 Sep 2004 12:18:39 -0400, Mickael [EMAIL PROTECTED] wrote:
 Hello All,
 
 This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie.
 
 They client want this however to run off of a pc not runnnga webserver or CF.They have the ability to create HTML pages using VB6, would anyone on this list know how an html page could be formated and have the form submitted to a remote page via HTTPs?
 
 Does this make sense?
 
 Thanks
 
 Mike

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

HTTPS post

[Mickael]

Hello All,

This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie.

They client want this however to run off of a pc not runnnga webserver or CF.They have the ability to create HTML pages using VB6, would anyone on this list know how an html page could be formated and have the form submitted to a remote page via HTTPs?

Does this make sense?

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: HTTPS post

[Mickael]

Don't you need the submit button to be clicked?I would like this to run automated.
- Original Message - 
From: Tony Weeg 
To: CF-Talk 
Sent: Monday, September 13, 2004 12:57 PM
Subject: Re: HTTPS post

form method=post action="">

that wont work?

tw

On Mon, 13 Sep 2004 12:18:39 -0400, Mickael [EMAIL PROTECTED] wrote:
 Hello All,
 
 This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie.
 
 They client want this however to run off of a pc not runnnga webserver or CF.They have the ability to create HTML pages using VB6, would anyone on this list know how an html page could be formated and have the form submitted to a remote page via HTTPs?
 
 Does this make sense?
 
 Thanks
 
 Mike
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: HTTPS post

[Mickael]

Hi,

What I would like the VB app to create a one time html page locally and post a hidden value in the form to the HTTPs page.It would be like me creating an HTML page on my desktop with aform and the action page being the Https URL and clicking submit.Just I would like to run a page like that.If they were able to accept a GET it would be easy I would just call a URL , but need a post.

Mike
- Original Message - 
From: Greg Morphis 
To: CF-Talk 
Sent: Monday, September 13, 2004 2:35 PM
Subject: Re: HTTPS post

Are you wanting them to be able to create a html form (using their VB
program) and then upload the html form?
Are you wanting the VB6 app to upload it or allow the users to upload them?

On Mon, 13 Sep 2004 14:17:06 -0400, Mickael [EMAIL PROTECTED] wrote:
 Don't you need the submit button to be clicked?I would like this to run automated.
- Original Message -
From: Tony Weeg
To: CF-Talk
Sent: Monday, September 13, 2004 12:57 PM
Subject: Re: HTTPS post
 
form method=post action="">
 
that wont work?
 
tw
 
On Mon, 13 Sep 2004 12:18:39 -0400, Mickael [EMAIL PROTECTED] wrote:
 Hello All,

 This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie.

 They client want this however to run off of a pc not runnnga webserver or CF.They have the ability to create HTML pages using VB6, would anyone on this list know how an html page could be formated and have the form submitted to a remote page via HTTPs?

 Does this make sense?

 Thanks

 Mike


 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Range in SQL

[Mickael]

Hello All,

I was wondering if someone could help me with an SQL statement for Sybase.I need to do an update using on SQL not CF.What I would like to do is the opposite of TOP sort of.I have a query that returns lets x records and I would like to not update 125 records and have my statement update the rest what ever that is.

Sort of like leave the TOP 125 alone and do the update.

How do you do this in SQL?

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

CF Ticketing System

[Mickael]

Hello All,

Does anyone know of a free Coldfusion ticketing system?The kind where people can log an issue get a ticket number and view them in a queue?I had one in PHP that was free and pretty robust.Just wondering if there is one out there for free or cheap if someone has one to sell.

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

CFHTTP

[Mickael]

Hello All,

I have never used CFHTTP before,and I am running in to an issue.I would like to retrieve information from a form on a remote server.If I simple do this in IE .

https://username:[EMAIL PROTECTED]/search.cgi?name=searchnamenumber=123search=all

This returns the proper information in my browser.

So I tried this in CF

cfhttp 
name=username 
password=password 
method=get 
url="" 
resolveurl=yes/cfhttp

cfoutput
#cfhttp.FileContent# /cfoutput

But I get the following error
The column name !DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN is invalid.
Column names must be valid variable names. They must start with a letter and can only include letters, numbers, and underscores.

I don't really understand how columns work. I would just like to display that page or save it to a variable.

How do I deal with columns with CFHTTP?

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: CFHTTP

[Mickael]

Hi Dave,

Sorry this was a cut and paste issue, my tag does use https://
- Original Message - 
From: Dave Watts 
To: CF-Talk 
Sent: Wednesday, July 28, 2004 4:31 PM
Subject: RE: CFHTTP

 I have never used CFHTTP before,and I am running in to an 
 issue.I would like to retrieve information from a form on a 
 remote server.If I simple do this in IE .
 
 https://username:[EMAIL PROTECTED]/search.cgi?name=searc
 hnamenumber=123search=all
 
 This returns the proper information in my browser.
 
 So I tried this in CF
 
 cfhttp
 name=username 
 password=password 
 method=get 
 url="" 
 resolveurl=yes/cfhttp
 
 
 cfoutput
 #cfhttp.FileContent# /cfoutput
 
 But I get the following error
 The column name !DOCTYPE HTML PUBLIC -//IETF//DTD 
 HTML 2.0//EN is invalid.
 Column names must be valid variable names. They must 
 start with a letter and can only include letters, numbers, 
 and underscores.
 
 
 I don't really understand how columns work. I would just like 
 to display that page or save it to a variable.
 
 How do I deal with columns with CFHTTP?

I'm not sure what exactly you're getting back, but your first URL uses
HTTPS, while your CFHTTP tag isn't. You must specify the entire URL within
the CFHTTP tag (https://...)

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: CFHTTP

[Mickael]

Thank you very much.The name instead of username was the problem.Works great
- Original Message - 
From: Adam Haskell 
To: CF-Talk 
Sent: Wednesday, July 28, 2004 5:03 PM
Subject: Re: CFHTTP

I would re-look at your actual Cfhttp call Invalid column would
indicate to me that you are trying to put the cfhttp content into a
query.

Notice: 
cfhttp
name=username

Should be: 
cfhttp
username=username

Adam H

On Wed, 28 Jul 2004 16:49:27 -0400, Dave Watts [EMAIL PROTECTED] wrote:
  h...not sure what that column stuff is aboutbut have
  a look at CFHTTPPARAM...it's used for passing in the URL
  params ?name=searchnamenumber=123search=all properly
 
 You can send URL parameters embedded directly within the URL attribute,
 rather than using CFHTTPPARAM.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 phone: 202-797-5496
 fax: 202-797-5444
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Problem with SQL Server and CF5

[Mickael]

Hello All,

I am relatively new to MSSQL so forgive me if the question is rather junior.I have a few pages that make up an image gallery.I designed the pages using CFMX and MSSQL and they worked fine on my machine.I have uploaded them to the server and I am getting the following error

PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

The code line is not exact but it is point around a line of code where I am doing a Query of a Query on CF5.

I have never seen this error before could someone point me in the right direction with this one.

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Problem with SQL Server and CF5

[Mickael]

Here is what the lines around the error say.

cfdirectory action="" directory=#thisDirectory##qry_GetDirectoryNames.GalleryDirectory# name=imagelist filter=*.jpg

cfquery name=qry_MakeThumbnailList dbtype=query
Select name from imagelist
/cfquery
- Original Message - 
From: Bert Dawson 
To: CF-Talk 
Sent: Monday, July 19, 2004 1:01 PM
Subject: RE: Problem with SQL Server and CF5

What does your Query of a Query say?
There are a number of subtle differences in the way it works in CFMX vs. CF5

Bert

____

From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: 19 July 2004 17:15
To: CF-Talk
Subject: Problem with SQL Server and CF5

Hello All,

I am relatively new to MSSQL so forgive me if the question is rather junior.I have a few pages that make up an image gallery.I designed the pages using CFMX and MSSQL and they worked fine on my machine.I have uploaded them to the server and I am getting the following error

PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

The code line is not exact but it is point around a line of code where I am doing a Query of a Query on CF5.

I have never seen this error before could someone point me in the right direction with this one.

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Problem with SQL Server and CF5

[Mickael]

Gave me the same error.Strange it works on my machine.
- Original Message - 
From: Bert Dawson 
To: CF-Talk 
Sent: Monday, July 19, 2004 2:10 PM
Subject: Re: Problem with SQL Server and CF5

just a guess as i haven't got access to a CF5 box this second, but try changing it to:

cfquery name=qry_MakeThumbnailList dbtype=query
SELECT[name] AS filename
FROM imagelist
/cfquery

It might not like the name column
(i would expect MX to complain about it but it doesn't seem to mind either way...)

Cheers
Bert



From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: 19 July 2004 19:02
To: CF-Talk
Subject: Re: Problem with SQL Server and CF5

Here is what the lines around the error say.

cfdirectory action="" directory=#thisDirectory##qry_GetDirectoryNames.GalleryDirectory# name=imagelist filter=*.jpg

cfquery name=qry_MakeThumbnailList dbtype=query
Select name from imagelist
/cfquery
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Problem with SQL Server and CF5

[Mickael]

Hi Ian

I tried that and I my imagelist query is returning a proper recordset but it is choking on this query 

cfquery name=qry_MakeThumbnailList dbtype=query
Select name from imagelist
/cfquery
- Original Message - 
From: Ian Skinner 
To: CF-Talk 
Sent: Monday, July 19, 2004 4:36 PM
Subject: RE: Problem with SQL Server and CF5

Have you tried a cfdump var=#imagelist# between your cfdirectory... and cfquery ... tags to make sure you are getting a valid query object?

--
Ian Skinner
Web Programmer
BloodSource
file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento 
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.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

CF Image Gallery

[Mickael]

Hi All,

I was wondering if anyone knows where I can get a some code for an Image Gallery.I have seen tons of these for Free in PHP.But none in CF yet.The gallery I am looking for is type that you upload images to a folder, then on the display page some code makes that thumbnails and displays them in a column on the left hand side (frameset) and if you click on the image it appears on the right hand side of the frameset.

If someone code point me to some open source code that would be great, or if it is not difficult give me a couple of pointers on how to build it.

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

cfx_image

[Mickael]

Hi 

Can anyone point me to where I can find the a tutorial on how to use CFX_Image?Or the docs?

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Manipulation Excel files

[Mickael]

Thanks Geoff,

This is great for Creating the excel files, but how do you manipulate existing one?
- Original Message - 
From: Geoff Bowers 
To: CF-Talk 
Sent: Monday, July 05, 2004 8:50 PM
Subject: Re: Manipulation Excel files

This is a great little post on leveraging java libraries for Excel. 
Dave Ross' blog has a bunch of others that might also shed some light.

Generating Excel spreadsheets from CFMX
http://www.medlogs.com/dave/001848.html

Where would you be without these little gems appearing daily on
Fullasagoog (http://www.fullasagoog.com/)?

-- geoff
http://www.daemon.com.au/

- Original Message -
From: Mickael [EMAIL PROTECTED]
Date: Mon, 5 Jul 2004 10:53:35 -0400
Subject: Manipulation Excel files
To: CF-Talk [EMAIL PROTECTED]

Hello All,

I was wondering if someone could point me in the right direction.I
need to be able to extract certain information from cells an excel
file, update some cell, delete some rows in the file then import the
file to my database.Can anybody point me to a resource that explains
how to do this or if someone has some experience with this it would be
greatly appreciated.

Thank you
Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Manipulation Excel files

[Mickael]

Hi Matt,

Will this plugin work with files that is not formatted nicely in rows and columns, can the tag read the file and determine cell positions?
- Original Message - 
From: Matt Liotta 
To: CF-Talk 
Sent: Monday, July 05, 2004 10:16 PM
Subject: RE: Manipulation Excel files

I have an open source CFX available at
http://sourceforge.net/projects/openxcf named CFX_ExcelQuery that allows you
to read and write XLS files as CF queries.

-Matt

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 On Behalf Of Mickael
 Sent: Monday, July 05, 2004 10:54 AM
 To: CF-Talk
 Subject: Manipulation Excel files
 
 Hello All,
 
 I was wondering if someone could point me in the right direction.I need
 to be able to extract certain information from cells an excel file, update
 some cell, delete some rows in the file then import the file to my
 database.Can anybody point me to a resource that explains how to do this
 or if someone has some experience with this it would be greatly
 appreciated.
 
 Thank you,
 
 Mike
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Manipulation Excel files

[Mickael]

Hello All,

I was wondering if someone could point me in the right direction.I need to be able to extract certain information from cells an excel file, update some cell, delete some rows in the file then import the file to my database.Can anybody point me to a resource that explains how to do this or if someone has some experience with this it would be greatly appreciated.

Thank you,

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

TreeMenu for Fusebox/CF site

[Mickael]

Hello All

I had a question regarding JS menus and CF.I am looking for a collapsible menu that stays open during use.The type that I am looking for is where the menu would have a + sign to the left of it to display that there is sub-content then clicking on the word would expose the sub-menu slightly indented and content of the next sub level.This tree really only needs to be text/css based and not image based.

I am looking for something that will work well with different browsers, is simple enough that I could write some coldfusion around it so that I can have my client add menu items dynamically and does not require frames. 

Does anyone know of a menu that I can use?I have found many but none that I was particularly fond of, not even at Milonic.

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: TreeMenu for Fusebox/CF site

[Mickael Elmalem]

Massimo,

That menu is great!Just what I was loooking for.

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: TreeMenu for Fusebox/CF site

[Mickael Elmalem]

Massimo,

Just one question how do you prevent the titles from Wrapping?Similar to nowrap.

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: TreeMenu for Fusebox/CF site

[Mickael Elmalem]

Please disreard my last post, I figured it out.Great menu!

Massimo,

Just one question how do you prevent the titles from Wrapping?Similar to nowrap.

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Ordering File Names

[Mickael]

Hi All,

I need to display file names from my directory on a page.The file names are in the following format 1014133248-1.pdf, 1014133248-2.pdf, 1014133248-3.pdf etc

I need to display them in order, this works fine for files up to -9 but after that I end up with

1014133248-1.pdf
1014133248-11.pdf
1014133248-12.pdf

I am using CFDIRECTORY Then a Query of the output.Is there a way to order them properly?

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Ordering File Names

[Mickael]

I see, that is the only way to do it?
- Original Message - 
From: Burns, John D 
To: CF-Talk 
Sent: Monday, June 28, 2004 1:55 PM
Subject: RE: Ordering File Names

You need to make the numbers -01, -02 etc.File systems order
alphabetically, not numerically. If you can't get the files in a
different format, you may want to run some kind of script to rename
everything to take the number between - and . And convert it to a 3
digit number. 

John 

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 28, 2004 1:53 PM
To: CF-Talk
Subject: Ordering File Names

Hi All,

I need to display file names from my directory on a page.The file
names are in the following format 1014133248-1.pdf, 1014133248-2.pdf,
1014133248-3.pdf etc

I need to display them in order, this works fine for files up to -9 but
after that I end up with

1014133248-1.pdf
1014133248-11.pdf
1014133248-12.pdf

I am using CFDIRECTORY Then a Query of the output.Is there a way to
order them properly?

Thanks

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SMTP Relay service

[Mickael]

hostmysite.com has this service, it is not very expensive either
- Original Message - 
From: Trevor Holm-Laursen 
To: CF-Talk 
Sent: Monday, June 28, 2004 2:34 PM
Subject: SMTP Relay service

Hey all,

We have several clients that we have built email notification services for
where their users can sign up for updates to the site or unsubscribe if they
do not wish to receive them any more.The problem came when the hosting
provider could not handle the email volumes (3000 - 5000 emails per mailing)
so we started hosing it off a server in house but we would like to get away
from it.We are looking for a service we can pay for to use as a relay
service.Any suggestions?Most sites are running on 6.1 but there is one
site running on 4.5.

Thanks,

Trevor
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Problems saving Files in DXMX 2004

[Mickael]

Hi All,

I have an issue with my Dreamweaver.I cannot save files properly.I keep getting this error

While executing onLoad in _afterSave.htm, the following _javascript_ error(s) occurred:

In file _aftersave:

ReferenceError: aftersave is not defined

Has anyone experienced this problem?

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Problems saving Files in DXMX 2004

[Mickael]

Hi,

I don't have any extensions installed.Is there somewhere else I can look?

Mike
- Original Message - 
From: dave 
To: CF-Talk 
Sent: Saturday, June 26, 2004 12:41 PM
Subject: Re: Problems saving Files in DXMX 2004

sounds like a conflict with an extention
you may wanna check through them and see

-- Original Message --
From: Mickael [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Sat, 26 Jun 2004 12:33:58 -0400

Hi All,

I have an issue with my Dreamweaver.I cannot save files properly.I keep getting this error

While executing onLoad in _afterSave.htm, the following _javascript_ error(s) occurred:

 

In file _aftersave:

ReferenceError: aftersave is not defined



Has anyone experienced this problem?



Mike




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Problems saving Files in DXMX 2004

[Mickael]

I'll try that.Thanks
- Original Message - 
From: John Beynon 
To: CF-Talk 
Sent: Saturday, June 26, 2004 2:19 PM
Subject: Re: Problems saving Files in DXMX 2004

i had it, no extensions installed. Had patched fireworks reinstalled
dwmx and it wenr away!

jb/

On Sat, 26 Jun 2004 12:50:20 -0400, Mickael [EMAIL PROTECTED] wrote:
 
 Hi,
 
 I don't have any extensions installed.Is there somewhere else I can look?
 
 Mike
- Original Message -
From: dave
To: CF-Talk
Sent: Saturday, June 26, 2004 12:41 PM
Subject: Re: Problems saving Files in DXMX 2004
 
sounds like a conflict with an extention
you may wanna check through them and see
 
-- Original Message --
From: Mickael [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Sat, 26 Jun 2004 12:33:58 -0400
 
Hi All,

I have an issue with my Dreamweaver.I cannot save files properly.I keep getting this error

While executing onLoad in _afterSave.htm, the following _javascript_ error(s) occurred:



In file _aftersave:

ReferenceError: aftersave is not defined



Has anyone experienced this problem?



Mike




 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Conntecting to Foxpro Database with CFMX

[Mickael]

Hi All,

I need to connect to a foxpro database with CFMX but the driver does not appear in my CFAdmin list.How do you connect foxpro?

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Conntecting to Foxpro Database with CFMX

[Mickael Elmalem]

That worked Great.

Thanks Ben

Create an ODBC connection using the Windows Control Panel applet, and then
connect to that in CF Admin.
 
--- Ben
 

_

From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 24, 2004 10:09 AM
To: CF-Talk
Subject: Conntecting to Foxpro Database with CFMX


Hi All,

I need to connect to a foxpro database with CFMX but the driver does not
appear in my CFAdmin list.How do you connect foxpro?

Mike 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

List of States and Provinces

[Mickael]

Hi All,

Can someone point me to a link where I can download a list of all the US States and Canadian Provinces

Ideally a delimited file of some kind where the actual Abbreviation is used like NY, New York

Thanks in advance.

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Sorting for Reports

[Mickael Elmalem]

Thanks Doug,

That helped a lot.Now I have another question.The layout looks great but it is in a vertical listing I would like to make some tables.Is there a way to determine the recordcount in each category?Like query.recordcount just for the group=category part of my CFQuery?

Mike

 get the category for every row as you are doing, order by this 
 category, then use the group attribute in cfoutput

 
 
 cfoutput query=foo group=category

 #foo.category# /br
 
 cfoutput

 #foo.filename#/br
 
 /cfoutput
 /cfoutput

 
 
 something like that

 
 

 
 
 Doug
 
 -Original Message-
 From: Mickael Elmalem [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, June 09, 2004 5:23 PM
 To: CF-Talk
 Subject: Sorting for Reports
 
 
 Hello All,
 
 I need to create a page that displays files(viewlets) uploaded by 
 users, by category.The users can create categories on their own then 
 the files get bound to that category.I have that part working fine.
 
 My issue is the displayI have one table that has two columns, 
 categoryID and Category and another table that has 
 The filename, categoryid, and a friendly filename
 
 Here is my SQL statement
 
 SELECT ViewletCategory.Category, Viewlets.FileName, Viewlets.
 ViewletName
 FROM ViewletCategory INNER JOIN Viewlets ON ViewletCategory.CategoryID 
 = Viewlets.Category;
 
 The display issue that I am having is I would like to show the 
 category only as a heading once then list the files associated to that 
 category below.
 
 Then the next category as a heading then all the files associated 
 below.
 
 But what I am getting from my query is the category for everyrow, this 
 is not what I want.Could someone point me in the right direction.
 
 Thanks
 
 Mike
 
 Then show the 

 _

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

CFQUERY Timeout

[Mickael]

Hello All,

My host has issues from time to time I get a CFQUERY timeout.But when I rerun the query it works (most times).What type of CFCATCH type would this be?

Here is my error

Error Occurred While Processing Request
The request has exceeded the allowable time limit Tag: CFQUERY


Thanks in Advance,

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