Re: Creating replicated sites with coldfusion

2007-10-16 Thread Gabriel Robichaud
Hello everyone

I have a bit of code and I am a little confused as to why, when i change the
format attribute to =flash, the whole thing goes crazy. All the values in
my text field are identical to the first row returned by the query.
However, HTML format works quite well with expected output.

Any input would be great. Code is bellow. I am working off Windows XP. CF8
Dev edition.



cfoutput
cfloop query=getLabels

cfform format=html  id=mod#theID#
action=index.cfm?view=labels#session.URLToken#
method=post skin=haloSilver width=310
   cfformgroup type=horizontal
 cfinput type=hidden name=ID value=#theID#
 cfformitem width=25 type=html#theLabelID#/cfformitem
 cfinput width=170 type=text value=#theContent# name=label
 cfinput width=75 type=submit value=Update name=submit
   /cfformgroup
 /cfform


/cfloop
/CFOUTPUT


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


CFFORM Flash VS Html

2007-10-16 Thread Gabriel Robichaud
On 10/16/07, Gabriel Robichaud [EMAIL PROTECTED] wrote:

 Hello everyone

 I have a bit of code and I am a little confused as to why, when i change
 the format attribute to =flash, the whole thing goes crazy. All the values
 in my text field are identical to the first row returned by the query.
 However, HTML format works quite well with expected output.

 Any input would be great. Code is bellow. I am working off Windows XP. CF8
 Dev edition.



 cfoutput
 cfloop query=getLabels

 cfform format=html  id=mod#theID# 
 action=index.cfm?view=labels#session.URLToken#
 method=post skin=haloSilver width=310
cfformgroup type=horizontal
  cfinput type=hidden name=ID value=#theID#
  cfformitem width=25 type=html#theLabelID#/cfformitem
  cfinput width=170 type=text value=#theContent# name=label
  cfinput width=75 type=submit value=Update name=submit
/cfformgroup
  /cfform


 /cfloop
 /CFOUTPUT



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

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


another accent problem

2005-03-21 Thread Gabriel Robichaud
0k... cfmx 7 running somewhere in cyberspace. I really hope someone
has the answer to this issue. I am querying a mysql db.

I cannot, for the life of me, get accents to display properly.

see http://www.vertelligence.com/index.cfm?view=labels for proof.

weird looking y carachters are directly in the cfm template. the
word that should say Français but says something like it, comes from
a mysql db.

here is my encoding stuff from my Application.cfm

cfapplication name=#appName# sessionmanagement=Yes
sessiontimeout=#CreateTimeSpan(0,0,45,0)#
cfprocessingdirective pageencoding=iso-8859-1
cfcontent type=text/html; charset=iso-8859-1

cfif not isDefined(cookie.langPref)
cfcookie name=langPref value=1
/cfif

cfscript
setEncoding(form, iso-8859-1);
snip other stuff
/cfscript

if anyone has any idea how to solve this i would really appreciate the help.

TIA!!

~|
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:199640
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: french character problem

2005-03-21 Thread Gabriel Robichaud
is this a joke? Is this really how I solve this problem?

I just saw this message. How on earth do i convert ALL my files? One
by one? is there an easy way to do this? Can I do this in Dreamweaver?
 And why the hell did MM do something so F(*)ING STUPID. HELLO THE
WORLD DOES NOT ONLY SPEAK ENGLISH.

TIA

Gabriel


On Sun, 27 Feb 2005 18:09:51 -0500, Claude Schneegans
[EMAIL PROTECTED] wrote:
  I have a bunch of french characters, not even being read from a
 
 database, straight text, that will not display properly when thay are
 inside a .cfm template.
 
 Ah ah, j'ai eu ce problème-là moi aussi mon vieux !
 I suppose you are under CFMX, or that you recently moved to CFMX?
 The problem is that CFMX is now forcing all text to be UTF-8.
 I know it is a real plus, but for us using only European languages for
 which ISO-8859-whatever was perfectly doing the job, it is a PITA.
 The solutions:
 1º use an editor able to create files in UTF-8, and convert all your existing 
 files in UTF-8
(This was suggested here by someone else, so please don't shoot me ;-)
 2º add this in your Application.cfm:
 CFSET CFversion = listGetAt(server.coldfusion.productVersion, 1)
 CFIF CFversion GT 5
 cfcontent type=text/html; charset=ISO-8859-1
 cfset setEncoding(url,ISO-8859-1)
 cfset setEncoding(form,ISO-8859-1)
 /CFIF
 (the test for the version is not mandatory, especially if you have the same 
 version on your development and production server.)
 
 I take the opportunity here first to thank the person who gave me the trick, 
 secondly to express my anger at MM who didn't put this UTF-8 behavior as an 
 option in the CF administrator, and designed it so the new version is not 
 compatible with the previous 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.
 
 
 

~|
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:199642
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: french character problem

2005-03-21 Thread Gabriel Robichaud
ok.. thank you!!!

I will give this a try. Will have to get the folks on the hosting side
to cooperate on this one.

Gabriel


On Tue, 22 Mar 2005 12:42:41 +0700, Paul Hastings
[EMAIL PROTECTED] wrote:
 Gabriel Robichaud wrote:
  is this a joke? Is this really how I solve this problem?
 
 it's one way.
 
  I just saw this message. How on earth do i convert ALL my files? One
 
 unifier, http://www.melody-soft.com/html/unifier.html, works a treat 
 if you do a lot of i18n work is certainly worth $15 US.
 
  by one? is there an easy way to do this? Can I do this in Dreamweaver?
 
 you probably don't have to do it at all. if you're happy with iso-8859-1
 (which you know doesn't contain the euro symbol):
 
 in application.cfm
   cfcontent type=text/html; charset=ISO-8859-1
   cfset setEncoding(url,ISO-8859-1)
   cfset setEncoding(form,ISO-8859-1)
 
 on each cf page:
   cfprocessingdirective pageencoding=iso-8859-1
 
 for that mysql dsn (advanced option, connection string):
 useUnicode=truecharacterEncoding=iso-8859-1 (not sure it could also be
 iso88591, check the mysql docs).
 
 or if you want the whole server to just deliver latin-1
 changed the defaultCharset value in cf_root/lib/neo-runtime.xml file:
 
 var name='defaultCharset'stringUTF-8/string/var
 
 replace utf-8 with the charset you want.
 
 

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


french character problem

2005-02-27 Thread Gabriel Robichaud
Hey everyone,

I have a bunch of french characters, not even being read from a
database, straight text, that will not display properly when thay are
inside a .cfm template. The same characters inside a .html will
display appropriately.

I have tried using cfcontent, does not change anything, characters are
displayed as garbage text. some weird upside down y.

environment : linux, apache, cfmx 6.1

Any ideas? here is the cfml example.

cfcontent type=text/html; charset = iso-8859-1 
html
head
titleTest Page/title
/head

body

testing old style html accents nbsp;Aacute;eacute;euml;br
testing chars as they are typed Àéè

/body
/html

you can see this in action at http://blog.gabrielrobichaud.com/testaccent.cfm


TIA!!
Gabriel

~|
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:196727
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: french character problem

2005-02-27 Thread Gabriel Robichaud
I have solved this issue with the cfprocessingdirective

woo hoo

Hey everyone,

I have a bunch of french characters, not even being read from a
database, straight text, that will not display properly when thay are
inside a .cfm template. The same characters inside a .html will
display appropriately.

I have tried using cfcontent, does not change anything, characters are
displayed as garbage text. some weird upside down y.

environment : linux, apache, cfmx 6.1

Any ideas? here is the cfml example.

cfcontent type=text/html; charset = iso-8859-1 
html
head
titleTest Page/title
/head

body

testing old style html accents nbsp;Aacute;eacute;euml;br
testing chars as they are typed Àéè

/body
/html

you can see this in action at http://blog.gabrielrobichaud.com/testaccent.cfm


TIA!!
Gabriel

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


Yellow fields

2004-11-15 Thread Gabriel Robichaud
Hello yall!

Can anyone explain why certain input text fields appear with a yellow
background in Internet Explorer even if i have an alternate color
defined in my stylesheet?

Is there anyway to overide this yellow?

TIA!
Gabriel

~|
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:184350
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: Yellow fields

2004-11-15 Thread Gabriel Robichaud
well, actually, i just foudn this link, they blame google tool bar!
http://www.htmldog.com/ptg/archives/17.php


On Tue, 16 Nov 2004 15:31:39 +1100, Mike Kear [EMAIL PROTECTED] wrote:
 Send a note to our pal Bill Gates.  It's his work.
 
 It was part of the  upgrade to IE and I have no idea what it's for,
 and how come some form fields are yellow and others aren't.  But
 apparently our life  is better because of it.
 
 I too wish it'd go away.
 
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 AFP Webworks
 http://afpwebworks.com
 .com,.net,.org domains from AUD$20/Year
 
 On Mon, 15 Nov 2004 23:17:47 -0500, Gabriel Robichaud
 
 
 [EMAIL PROTECTED] wrote:
  Hello yall!
 
  Can anyone explain why certain input text fields appear with a yellow
  background in Internet Explorer even if i have an alternate color
  defined in my stylesheet?
 
  Is there anyway to overide this yellow?
 
  TIA!
  Gabriel
 
 
 
 

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


Cf puzzle

2004-03-31 Thread Gabriel Robichaud
Ok folks!

I have a directory... c:/cfusionmx/wwwroot/somedir/
That has Application.cfm and index.cfm files.

Now... that being said.Lets assume that in order to hit the index.cfm
I need to type in the browser
http://www.gabrielrobichaud.com/

Now what I would like to do, is catch these types of hits
http://www.gabrielrobichaud.com/xyz

Xyz is not a directory, it never will be nor is it a file.I would like
to catch that xyz, put it invariable and then do some funky treatment.
BUT, what I am getting currently is: The page cannot be found error
message.

How can I get this xyz value and put it in a variable?
Any leads would be really appreciated!!!
Gabriel
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cf puzzle

2004-03-31 Thread Gabriel Robichaud
Ok.. thanks.

I will do searching for mod_rewrite.I had no idea what I'm trying to do was called that.I really want to avoid using the 404 handler if possible.

If anyone else has done this before i would love to hear how it got done.

Gabriel

Hi,

Try doing some searches on the houseoffusion archives and/or the
almighty google:

If you are using apache, just search for mod_rewrite
for you are using IIS, search for IIS and mod_rewrite

Another option is this:
http://www.spike.org.uk/go/friendly-urls

An additional one (dirty hack) would be to use the 404 error handler.

/Hugo


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




Re: Cf puzzle

2004-03-31 Thread Gabriel Robichaud
The only thing is that this is not an error.And I want to make this part of the functionality of the site.So I am concerned that using the error page like this might put a strain on performance.Or am I worrying about nothing?

Custom error page through your web server to point to a CFM that
evaluates the URL string and strips out what you want into variables.
#cgi# scope will help a lot.

John Burns 

-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 31, 2004 10:13 AM
To: CF-Talk
Subject: Cf puzzle

Ok folks!

I have a directory... c:/cfusionmx/wwwroot/somedir/ That has
Application.cfm and index.cfm files.

Now... that being said.Lets assume that in order to hit the index.cfm
I need to type in the browser http://www.gabrielrobichaud.com/

Now what I would like to do, is catch these types of hits
http://www.gabrielrobichaud.com/xyz

Xyz is not a directory, it never will be nor is it a file.I would like
to catch that xyz, put it invariable and then do some funky treatment.
BUT, what I am getting currently is: The page cannot be found error
message.

How can I get this xyz value and put it in a variable?
Any leads would be really appreciated!!!
Gabriel
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cf puzzle

2004-03-31 Thread Gabriel Robichaud
If you are using apache, just search for mod_rewrite
for you are using IIS, search for IIS and mod_rewrite

Ok.. it seems that this would be perfect for what I want to do. But where the heck am i going to find hosting that is going to let me write my own mod_rewrite rules?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cf puzzle

2004-03-31 Thread Gabriel Robichaud
 I don'it think it is possible. The CF server will not even be aware of 
 such a request which will never be forwarded by the HTTP server to the 
 CF server.
 Since the HTTP request IS a 404 error, I don't see how this could be 
 done not using the 404 handler.
 

Well, using a mod_rewrite like isapirewrite.com will let me change that url around before it gets sent to cf.But that opens up a whole other problem... Like who is going to host this thing?

I would consider hosting it myself.. but I dont think thats a very good idea.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cf puzzle

2004-03-31 Thread Gabriel Robichaud
Can you back up and embellish on what it is that you are trying to do 
exactly?Maybe there is a better way that the listees can help with.

Ray

At 09:37 AM 3/31/2004, Gabriel Robichaud wrote:


Its pretty simple.I want to capture anything that comes after mydomain.com/so if mydomain.com/xyz is typed in the browser, all i want to do is be able to assign the xyz into a cf variable and then use that information to retreive stuff from my database.

The problem lies with capturing the xyz.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cf puzzle

2004-03-31 Thread Gabriel Robichaud
hmm.. dont know how i missed that. 

Will keep an eye out on this one.

Thanks
Gabriel

 If you are using IIS check out a thread from earlier today

 
 
 http://www.houseoffusion.com/cf_lists/index.
 cfm/method=messagesthreadid=31591forumid=4

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




Re: Cf puzzle

2004-03-31 Thread Gabriel Robichaud
Hmmm... I have no idea what those are.Must investigate.

Gabriel

Wouldn't SES urls work?I have never used them and don't really know
what they are, but other people on the list talk about passing params
that way.Am I way off here?

John
 

-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 31, 2004 9:48 AM
To: CF-Talk
Subject: Re: Cf puzzle


Its pretty simple.I want to capture anything that comes after
mydomain.com/so if mydomain.com/xyz is typed in the browser, all i
want to do is be able to assign the xyz into a cf variable and then use
that information to retreive stuff from my database.

The problem lies with capturing the xyz.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cf puzzle

2004-03-31 Thread Gabriel Robichaud
Yes its typed in by the user.or a click somewhere on the internet. 

The problem lies with capturing the xyz

Ok, fine, but where does this xyz come from ? Typed in by the user? For what purpose?

--
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cf puzzle

2004-03-31 Thread Gabriel Robichaud
Hey Mark,

Thanks.Looks like this is the easiest solution and I dont think I need to worry too much about the overhead at this point... maybe later but I could just deal with that if it happens.

Thanks everyone for your help!

Gabriel
 Gabriel,
 
 The web server already has to parse the header, determine if the file 
 exists and point to the file (or 404 handler) -
 yes I would imagine that there is a bit more overhead than if the 
 file/folder existed in the first place - but I have
 several sites doing this and similar things, some of them trafficked 
 quite heavily, and I've never noticed an
 appreciable difference.Obviously a lot depends on the expected load.
 I would also say that a dedicated IP address
 (rather than a virtual host) would make a slight difference because 
 the web server wouldn't have the additional task of
 finding the right site for that Host header before it even looks for 
 a file. But again, I don't know that you would
 notice the difference except under a near capacity load.
 
 -Mark

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




RE: webcam et coldfusion

2004-03-09 Thread Gabriel Robichaud
do you want to do video or just still images?

 
If all you want to do is play around with still images, just use your web cam software to capture images in a directory accessible by coldfusion, then use coldfusion to display these images on your website for video.. its a bit more complex...



From: Steff [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 09, 2004 10:18 AM
To: CF-Talk
Subject: RE: webcam et coldfusion

Sorry

Here the message

I want to use on my site a webcam. How should I do? Can coldfusion help me?

Thanks

[Steff]
-Message d'origine-
De : Bruce Sorge [mailto:[EMAIL PROTECTED]
Envoy : Tuesday, March 09, 2004 4:11 PM
 : CF-Talk
Objet : Re: webcam et coldfusion

D'abord, pardonnez mon franais. Il suce. Je ne suis pas sr comment vous
feriez ceci avec ColdFusion, mais vous pouvez faire ceci avec le flash.
Avez-vous examin cette option ?
 - Original Message -
 From: Steff
 To: CF-Talk
 Sent: Tuesday, March 09, 2004 9:03 AM
 Subject: webcam et coldfusion

 Bonjour

si je relie une webcam  mon serveur, puis-je utiliser coldfusion
pour
 visualiser le contenu de ma webcam?

 Merci
 Stphane 

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




RE: Reg Expressions?

2004-02-19 Thread Gabriel Robichaud
There is a sectioncalled Regular Expressions that I find has a nice
reference, could probably fit on a page if you cut and paste it

 
http://www.webdevelopersjournal.com/articles/jscript_forms2.html

 
Gabriel



From: Adkins, Randy [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 19, 2004 9:10 AM
To: CF-Talk
Subject: Reg Expressions?

Does anyone know a tutorial or perferrably a listing
of regular _expression_ usage like a cheat sheet that
I can print out and use as a reference.

Randy Adkins
Senior Systems Engineer
SRA International, Inc 

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




RE: MySQL and CF

2004-02-06 Thread Gabriel Robichaud
I use mySQL all the time.You cant beat the cost for the amount of
performance/robstness you get.



From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 9:56 AM
To: CF-Talk
Subject: SOT: MySQL and CF

Let me preface this by saying that I don't fault anyone for their 
opinions. They are their opinions and as such deserve respect as such. 
When speaking of the below scenario I can see (especially considering 
the slow pace of mySQL dev in the past [which is no longer the case]) 
why someone may have thought along these lines.

Recently I was looking at evaluating a CF RAD tool under development (no

details yet, but I'll let you know if and when I'm able). The tool 
looked like it would do all the things I wanted, yet I came to find out 
it didn't support mySQL.

When I asked about this I was told that support had not been included 
because a) mySQL didn't support foreign keys, and b) because of this 
lack of functionality (and others) it wasn't a serious database
player.

I will post part of my response to this at the end of this message, but 
my question for the community is this, how many of us here use mySQL? Or

have used it in a site they've developed for a client? How many passed 
up using mySQL because of similar perceptions as those state above?

I'm not trying to start a debate or a flame war here, I'm just trying to

gage the perceptions out there in my fellow development community. I 
know that there are quite a few people here that develop third party 
apps for CF developers and I think it would be beneficial (for us all) 
to see what the percentages might me on this.

Here is a snippit of my response:

MySQL supports foreign keys when the table is of the InnoDB type (MySQL

supports several different engines). Support for this has been around 
since at least 4.0, though I think it may even go back as far as 3.23.

The Alpha build of 5.0 was released this last month. E-week reported in 
testing that it was incredibly stable and that the new addition of 
stored procedure support was a major plus. As I understand it views are 
to be supported possibly as early as 5.1.

Cutter

P.S. Anyone who may be looking for some good beginner information on 
MySQL should check out the excellent book MySQL Tutorial by Luke 
Welling and Laura Thomson. Though it only covers 4.x, it is very easy to

read and understand and provides short targeted tutorials for getting 
yourself up and going. I've been working with MySQL for about 3 years 
now and I've come to find I've only been scratching the surface of what 
it's capable of. 

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




RE: What happened to Ben Forta's book?

2004-01-26 Thread Gabriel Robichaud
Well thats good news!

 
Looks like I'll be adding another Forta book to my book shelf.If all
programming books were as well written and as interesting to read as
Forta's books are, our jobs would be a lot easier!!

 
Gabriel



From: Irvin Gomez [mailto:[EMAIL PROTECTED] 
Sent: Sunday, January 25, 2004 8:38 AM
To: CF-Talk
Subject: Re:What happened to Ben Forta's book?

Thanks, Michael and Ben.

Actually, I had ordered the book from Amazone.com back in November. I'll
be definitely going to buy it. So far I haven't gone wrong with A Ben
Forta book!

irvin

 I've heard from the technical editor that it's great. I can't speak on

 it's publishing date, but I'd suggest you reserve your copy now. :)
 
  title something like Teach Yourself Regular Expressions.
  
  It was listed at Amazon.com for November release. If it's anything 
  like the SQL in 10 Minutes one, it's a little jewel.
  
  Hope they release it soon... 

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




RE: Java Information...

2004-01-20 Thread Gabriel Robichaud
Cool, thanks for the link!

 
I was wondering if there are any GOOD, J2EE resources outthere?
Suggested frameworks, etc.

 
I found some stuff on sun's site but... i dont know.I am wondering how
I could start, and plan out a learning path.

 
Starting from not knowing java, to eventually being able to design
architecture in J2EE, programming, etc.

 
Gabriel



From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 20, 2004 2:53 PM
To: CF-Talk
Subject: OT: Java Information...

In case anyone is interested in diving into JAVA, the following link
provides so very easy reading and introduction into the language...
Along
with code samples, etc...

Enjoy.

http://www.devjavasoft.org/FirstEdition/Copy/

Mike 

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




RE: MACR Stock price?

2003-12-30 Thread Gabriel Robichaud
Maybe its just the January effect.Historically, the market goes up a bit in january every year while Financial Planners and people do last minute investing before tax returns.

 
or, maybe I dont know what im talkign about, just repeating what I heard on CNN 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 11:11 AM
To: CF-Talk
Subject: OT: MACR Stock price?

At latest sale the MACR stock was at $18.40 -- up 2.24% today.

I bought some MACR shares 5 days ago for $17.94 -- and am quite happy.

I expected the price to increase gradually to the $22 range.

Any ideas why the stock is going up so rapidly? (Other than the 
excellent company and superior products)

TIA

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




RE: BabelFish down ?

2003-12-18 Thread Gabriel Robichaud
I have worked with various Language Services companies over the past 10 years, and I must say that Machine Translation is just a bad idea.I really hope you are not translating text other than for your personal use.I would laugh so hard if a client or supplier would hand me a proposal or something that was ran through babel fish!Yes, it is obvious when a machine did the work, and it's usually badly written.?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office /

essage-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 12:20 AM
To: CF-Talk
Subject: Re: BabelFish down ?

my first reaction to machine translators (MT) is usually bah humbug.

 Question. Does anyone know of a similar service that
 is free or fee based ? I really need this functionality at my company.

not wishing to encourage this, but i blogged about MT back in june. there's
a list of MT offerings in that entry (machine translations? bah humbug)
that might be of help:
http://cfg11n.blogspot.com/2003_06_01_cfg11n_archive.html 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Best Practices

2003-12-17 Thread Gabriel Robichaud
if you thought of putting all your texts in variables in seperate .cfm and jsut doing a cfinclude and then calling these variables.That way you could call your variables depending on the languagecfif session.language eq french
 call the french file
cfelse
call the english file
 /cfif

 
and then you can just do your code normally using variables in your cfml to call your txt.

 
of course then there is the issue of maintaining 2 variable lists but i think its easier to have it all in one file rather than spread accross your code.

 
Gabriel

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 9:38 AM
To: CF-Talk
Subject: Best Practices

Hello All,

I have an app that seem to run very slow at time, I am looking for ways that I may not be using CF efficiently.

The app is in french and english, and is able user is able to switch back and forth from french to english.I use a session variable for this.

My code states is cfif session.language eq 1english textcfelsefrench text/cfif

Here apiece of table

table border=1 cellspacing=0 cellpadding=1 bordercolor=66 align=center
tr
 tdcfif session.language eq 1Issue #cfelseDemande #/cfif/td
 tdcfif session.language eq 1User IDcfelseIdentification de l'usager/cfif/td
 tdcfif session.language eq 1Date LoggedcfelseDate d'entre/cfif/td

My question is, is is better to Have the whole english table under the first if statement then then entire french table in else faster than what I am doing above.I like the method above because I have essentially only one table to view the other way I would have two.

I am looking for suggestion on how to optimize this.

Thanks

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




RE: Best Practices

2003-12-17 Thread Gabriel Robichaud
From a code maintenance stand point, creating two files or two tables is too much work IMHO.I think the best is just to put variables in seperate files where each file contains vars which are assigned french or english text.Then, all you do at the top of a cfm, is do 1 cfif and call the appropriate template with the vars for the desired language.. not too mention that this solves the issue of adding more languages down the road.

 
Gabriel

-Original Message-
From: Mike Brunt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 10:13 AM
To: CF-Talk
Subject: RE: Best Practices

My opinion would be to reduce the number of cfif's by creating one table or
file in English and the other in French.Although you seem like you want to
avoid two tables or two files, that is the most efficient way to do this
from a run-time standpoint.

Kind Regards - Mike Brunt
Webapper Services LLC
Web Site http://www.webapper.com
Blog http://www.webapper.net

Webapper Web Application Specialists

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 6:53 AM
To: CF-Talk
Subject: Re: Best Practices

Hi Mike,

I agree with your point on the clarity and I have no problem making
includes.I was really wonder if there is a performance issue when I ask CF
to evaluate each CFIF or is that not really an issue?
- Original Message -
From: Tangorre, Michael
To: CF-Talk
Sent: Wednesday, December 17, 2003 9:41 AM
Subject: RE: Best Practices

First off, since the conditions are the same for each TD, put one
condition
around the TR and avoid that redundancy OR... I would create two separate
files, and cfinclude the one you need although you would still need
the
one condition to determine which to include. For sake of clarity I would
recommend two files and one logic block to determine which to include.

Mike

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 9:38 AM
To: CF-Talk
Subject: Best Practices

Hello All,

I have an app that seem to run very slow at time, I am looking for ways
that
I may not be using CF efficiently.

The app is in french and english, and is able user is able to switch back
and forth from french to english.I use a session variable for this.

My code states is cfif session.language eq 1english textcfelsefrench
text/cfif

Here apiece of table

table border=1 cellspacing=0 cellpadding=1 bordercolor=66
align=center
 tr
tdcfif session.language eq 1Issue #cfelseDemande #/cfif/td
tdcfif session.language eq 1User IDcfelseIdentification de
l'usager/cfif/td
tdcfif session.language eq 1Date LoggedcfelseDate
d'entre/cfif/td

My question is, is is better to Have the whole english table under the
first
if statement then then entire french table in else faster than what I am
doing above.I like the method above because I have essentially only one
table to view the other way I would have two.

I am looking for suggestion on how to optimize this.

Thanks

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




RE: fusebox

2003-12-11 Thread Gabriel Robichaud
Thanks to everyone who responded!Looks like I will have lots of reading to do this weekend.(The weather sucks anyway) *sigh*

 
I really want to looking into FB before I start coding my next Project..I have a sneaking suspition my next client is going to demand a kown methodology.Not a bad thing... just have to rework how i work!

 
Again thanks guys!I knew i could count on you!

 
Gabriel

-Original Message-
From: Sandy Clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 8:29 AM
To: CF-Talk
Subject: RE: fusebox

Woops, one correction, the Fusebox 4 list is on Yahoo, not topica, the
topica list is the regular fusebox list.

[EMAIL PROTECTED]
[EMAIL PROTECTED]

_

From: Sandy Clark [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 11, 2003 8:07 AM
To: CF-Talk
Subject: RE: fusebox

If you go to the Techspedition site, there are a couple of the chapters on
the xml grammar available from the FB4 book. http://www.techspedition.com

If you go to my site, I have written toolbars with help documentation on the
xml grammar for both homesite and dreamweaver as well as FB4 examples
(mostly for layout) from a simple hello world, to a blog.
http://www.shayna.com

The fusebox 4 forums on Topica are still fairly active, even though there
has been an effort to move to the fusebox forums.

The core files and sample downloads for FB4 can be found at
http://beta.fusebox.org. The xml cfx java files for the CF5 version can be
found at http://xml.fusebox.org.

I know the site is out of date, it hasn't been updated and needs doing,
however I'm not one of the site's owners and can't do much. These are all
free resources. I think Brian Kotek has stuff on his site as well.

As to the books, Discovering FB3 and Discovering FB4 are musts.I like the
New Riders book, but it tends to stray from FB3 and go into Flip (for that
it is a great resource).

Hope all this helps.

Sandy Clark

_

From: Kola Oyedeji [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 11, 2003 7:20 AM
To: CF-Talk
Subject: RE: fusebox

I'd also agree there seems to be a lack of documentation of FB3 and 4. I
would also agree that it seems that you are expected to buy the books to
get any real info - the fusebox site (other than forums) is next to
useless. 

There is actually more useful information on
http://bombusbee.com/downloads.main.htm (check out the newbie guide)
than there is on the fusebox site.

That said, If you are set on learning FB3 and not FB4 (which I would
recommend instead) then grab a copy of discovering fusebox 3 with
coldfusion.

Finally as there has been plenty discussion of FB recently and its pros
and cons I would strongly advise anyone evaluating a framework to
actually evaluate it by using it and *not* by soliciting opinions. For
every argument against using fusebox there is one for using it!

HTH

Kola

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] 
Sent: 11 December 2003 07:52
To: CF-Talk
Subject: Re: fusebox

 Hello all,

 I am looking into the FB framework and, well, I am just
 getting confused.There seems to be very little
 documentation on the fb website and I can really find any
 resources.Where should I be looking?

 Gabriel

I've had the same issue -- i.e. when you download the core files for
FB3, there's no explanation of how to build your fbx_circuits.cfm
template. There is a forum on the FB site, although that hardly counts
as documentation. It seems like they largely want you to buy the books
or take their classes. Just my impression of it anyway. Granted I'm
somewhat biased -- see the onTap framework in my sig below.

s. isaac dealey 214-823-9345

team macromedia volunteer http://www.macromedia.com/go/team

chief architect, tapestry cmshttp://products.turnkey.to

onTap is open sourcehttp://www.turnkey.to/ontap
_ 
_ 
_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




fusebox

2003-12-10 Thread Gabriel Robichaud
Hello all,

 
I am looking into the FB framework and, well, I am just getting confused.There seems to be very little documentation on the fb website and I can really find any resources.Where should I be looking?

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




RE: sql Row Error Msg?

2003-12-09 Thread Gabriel Robichaud
I am pretty sure that SQL Server has a maximum size for each row.The only work aroudn would be changing the field do clob, because then that limit does not apply.

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:57 AM
To: CF-Talk
Subject: OT:sql Row Error Msg?

Ok this is a new one for me!I have a table that users add plans to.
Because each section of the plan can be extensive each field is 4000
characters long.
I have one user who is having a problem.He said when he went to edit the
last field e received the following error: 
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size
8063 which is greater than the allowable maximum of 8060.

So this has to actually do with a SQL row character maximum?(Its' SQL2000)
I retried entering the plan in the test environment and had the same issue.
I then tried to do an edit from sql query analyzer and got the same message.
Anyone know about this- how to work around it?
Thanks,
J 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Fusebox - whats the big deal anyway?

2003-12-06 Thread Gabriel Robichaud
I for one would love to see the arguments FOR using fusebox.I have been to the FB web site and I am not sure its worth the effort of learning a completely new mehtodology and reengineering my processes to fit someone elses model.I think that Dan's points are valid especially when it comes to creativity, but I am sure there are opinions, very good ones, pro FB.I just don`t see them.What I do see, is a lot of people posting questions about it on the forums that seem overly complicated, and honestly, the last thing i need is more complication in my Dev process.

-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 1:37 PM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?

If you don't like it, don't use it.Everything you've said is opinion.

-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED] 
Sent: December 6, 2003 11:34 AM
To: CF-Talk
Subject: Fusebox - whats the big deal anyway?

First off I admit that I don't know much about Fusebox, other than it's a 
methodology for writing web application software. I've done a bit of 
research into it. And quite frankly I don't see what the big deal is.

I think the thing I don't like about it, is that Fusebox is someone else's 
idea of how to create a web application. So right off the bat Fusebox 
developers short-cicrut their own creative ways to use Coldfusion and 
place themselves into a box that someone else has defined?

Again, I'm no expert on programming or coldfusion ( I do know some ), but I 
think what I do know is creativity. Would it not be more fun, more exciting 
to develop your own methods of doings things? Methods that are customized to

your own unique personality and skill?

I do welcome Fusebox developers to enlighten me as to the benefit of using 
it and why. Maybe even comment on how they can use their own creative 
processes within it. Right now, Fusebox just seems like a good idea for the 
person who created.

We could all create a new methodology ourselves...right now call it 
Ultimate Coral Dragon, then write books and articles...I don't know, it 
all seems silly.

_ __
Daniel Farmer
Web Developer Consultant
P: 613.284.1684 
_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Fusebox - whats the big deal anyway?

2003-12-06 Thread Gabriel Robichaud
Ok... so you make a valid point of saying anyone can use it.I still dont see why I should use it.I can use Pascal if I want, but i dont think i should.Thats what I keep hearing, fusebox is usefull, fusebox will do this, fusebox will do that, but nobody really says why.When i decided to explore CFML programming, a colleague said : It will make your programming easier. and i said why is that to which he replied Because you will need less code to do the same task, and its tag based, both of which will enable you to have quicker turn arounds.That to me is why. Just saying because its easier is not a reason.

 
So why is it easy to use?How is it useful?

 
Gabriel

-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 2:06 PM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?

Are you sure the questions are overly complicated, or are you not sure
about the context of the questions?

Anyhow, Fusebox is easy to use and very useful.Heck, if I can teach a very
junior programmer to use it mindlessly, I'm sure anyone else can.

As for the creativity aspect, like I said before, if you like creating your
own frameworks, then go right ahead (I know a few people on this list have).
No one's holding a gun to your head.

-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] 
Sent: December 6, 2003 11:54 AM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?

I for one would love to see the arguments FOR using fusebox.I have been to
the FB web site and I am not sure its worth the effort of learning a
completely new mehtodology and reengineering my processes to fit someone
elses model.I think that Dan's points are valid especially when it comes
to creativity, but I am sure there are opinions, very good ones, pro FB.I
just don`t see them.What I do see, is a lot of people posting questions
about it on the forums that seem overly complicated, and honestly, the last
thing i need is more complication in my Dev process.

-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 1:37 PM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?

If you don't like it, don't use it.Everything you've said is opinion.

-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED] 
Sent: December 6, 2003 11:34 AM
To: CF-Talk
Subject: Fusebox - whats the big deal anyway?

First off I admit that I don't know much about Fusebox, other than it's a 
methodology for writing web application software. I've done a bit of 
research into it. And quite frankly I don't see what the big deal is.

I think the thing I don't like about it, is that Fusebox is someone else's 
idea of how to create a web application. So right off the bat Fusebox 
developers short-cicrut their own creative ways to use Coldfusion and 
place themselves into a box that someone else has defined?

Again, I'm no expert on programming or coldfusion ( I do know some ), but I 
think what I do know is creativity. Would it not be more fun, more exciting 
to develop your own methods of doings things? Methods that are customized to

your own unique personality and skill?

I do welcome Fusebox developers to enlighten me as to the benefit of using 
it and why. Maybe even comment on how they can use their own creative 
processes within it. Right now, Fusebox just seems like a good idea for the 
person who created.

We could all create a new methodology ourselves...right now call it 
Ultimate Coral Dragon, then write books and articles...I don't know, it 
all seems silly.

_ __
Daniel Farmer
Web Developer Consultant
P: 613.284.1684 
_ 
_ 
_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Fusebox - whats the big deal anyway?

2003-12-06 Thread Gabriel Robichaud
Woah woah Nobody is bitching as you put it.Simple exchange of ideas is all.I think Dan was just looking for a general idea of people's opinions.If you can`t give that, then just dont say anything.This is a discussion forum, after all.

 
Gabriel

-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 2:48 PM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?

I suggest you read the documentation that the fusebox site has.

Rather than bitching about Fusebox (a most particular waste of time), I
suggest you download the examples and try them out.

-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED] 
Sent: December 6, 2003 12:41 PM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?

Those terms you use preprocess layouts and postprocess [ insert jargon 
here ] mean nothing to those who don't use FB. Could you explain it, in 
simpler terms?

X-OriginalArrivalTime: 06 Dec 2003 19:36:47.0111 (UTC) 
FILETIME=[4952A170:01C3BC30]

Like I keep saying, no one is asking you to use it.Yeesh.

As for benefits, one very obvious benefit are layouts (FB3), preprocess and
postprocess directives (FB4).

-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
Sent: December 6, 2003 12:24 PM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?


Ok... so you make a valid point of saying anyone can use it.I still dont
see why I should use it.I can use Pascal if I want, but i dont think i
should.Thats what I keep hearing, fusebox is usefull, fusebox will do
this, fusebox will do that, but nobody really says why.When i decided to
explore CFML programming, a colleague said : It will make your programming
easier. and i said why is that to which he replied Because you will 
need
less code to do the same task, and its tag based, both of which will enable
you to have quicker turn arounds.That to me is why. Just saying because
its easier is not a reason.


So why is it easy to use?How is it useful?


Gabriel

-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 2:06 PM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?

Are you sure the questions are overly complicated, or are you not sure
about the context of the questions?

Anyhow, Fusebox is easy to use and very useful.Heck, if I can teach a 
very
junior programmer to use it mindlessly, I'm sure anyone else can.

As for the creativity aspect, like I said before, if you like creating your
own frameworks, then go right ahead (I know a few people on this list 
have).
No one's holding a gun to your head.

-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
Sent: December 6, 2003 11:54 AM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?

I for one would love to see the arguments FOR using fusebox.I have been 
to
the FB web site and I am not sure its worth the effort of learning a
completely new mehtodology and reengineering my processes to fit someone
elses model.I think that Dan's points are valid especially when it comes
to creativity, but I am sure there are opinions, very good ones, pro FB.I
just don`t see them.What I do see, is a lot of people posting questions
about it on the forums that seem overly complicated, and honestly, the last
thing i need is more complication in my Dev process.

-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 1:37 PM
To: CF-Talk
Subject: RE: Fusebox - whats the big deal anyway?

If you don't like it, don't use it.Everything you've said is opinion.

-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED]
Sent: December 6, 2003 11:34 AM
To: CF-Talk
Subject: Fusebox - whats the big deal anyway?

First off I admit that I don't know much about Fusebox, other than it's a
methodology for writing web application software. I've done a bit of
research into it. And quite frankly I don't see what the big deal is.

I think the thing I don't like about it, is that Fusebox is someone else's
idea of how to create a web application. So right off the bat Fusebox
developers short-cicrut their own creative ways to use Coldfusion and
place themselves into a box that someone else has defined?

Again, I'm no expert on programming or coldfusion ( I do know some ), but I
think what I do know is creativity. Would it not be more fun, more exciting
to develop your own methods of doings things? Methods that are customized 
to

your own unique personality and skill?

I do welcome Fusebox developers to enlighten me as to the benefit of using
it and why. Maybe even comment on how they can use their own creative
processes within it. Right now, Fusebox just seems like a good idea for the
person who created.

We could all create a new methodology ourselves...right now call it
Ultimate Coral Dragon, then write books and articles...I don't know, it
all seems silly.

_ __
Daniel Farmer
Web Developer

RE: Generating Primary Key in Oracle (part 2)

2003-12-05 Thread Gabriel Robichaud
If your on Oracle, you should go with sequences!

 
http://www.macromedia.com/devnet/server_archive/articles/cf_best_practices_oracle.html#6

 
Gabriel

-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 8:55 AM
To: CF-Talk
Subject: Re: Generating Primary Key in Oracle (part 2)

Hi Stacy,

 I was thinking of using a single db table with single db column to store
 the current 'highest value' for the primary key.

 If anyone's used this method before...do you this incremental value
 across multiple tables? i.e. I have a table for 'orders' and another for
 'users'. Would both feed off this single primary key table?

I use a sequence, but I use the same sequence across an application. It cuts
down on the number of objects I need to maintain, and makes it so that any
one table probably doesn't have too many consecutive primary keys. The same
would apply if you're building your own table to generate a sequential
primary key. Though, I really see no reason for building your own table when
sequences are so easy to use. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFML app server...

2003-12-04 Thread Gabriel Robichaud
wow... the site must be down, i was able to view it all this am.

 
Gabriel

-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:03 AM
To: CF-Talk
Subject: Re: Another CFML app server...

I would like to try it, but none of the links work on the site ;)

Tim Blair wrote:

 Morning,

 Has anyone seen this before: http://www.pcaonline.com/coral/

 It's a new one on me...

 Tim.

 ---
 RAWNET LTD - Internet, New Media and ebusiness Gurus.
 Visit our new website at http://www.rawnet.com for
 more information about our company, or call us free
 anytime on 0800 294 24 24.
 ---
 Tim Blair
 Web Application Engineer, Rawnet Limited
 Direct Phone : +44 (0) 1344 393 441
 Switchboard : +44 (0) 1344 393 040
 ---
 This message may contain information which is legally
 privileged and/or confidential.If you are not the
 intended recipient, you are hereby notified that any
 unauthorised disclosure, copying, distribution or use
 of this information is strictly prohibited. Such
 notification notwithstanding, any comments, opinions,
 information or conclusions expressed in this message
 are those of the originator, not of rawnet limited,
 unless otherwise explicitly and independently indicated
 by an authorised representative of rawnet limited.
 ---
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFML app server...

2003-12-04 Thread Gabriel Robichaud
Chickens.

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:09 AM
To: CF-Talk
Subject: Re: Another CFML app server...

I think its been removed :)

On 4/12/03 3:04 pm, Gabriel Robichaud [EMAIL PROTECTED] wrote:

 wow... the site must be down, i was able to view it all this am.
 
 
 Gabriel
 
 -Original Message-
 From: Clint Tredway [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 04, 2003 10:03 AM
 To: CF-Talk
 Subject: Re: Another CFML app server...
 
 I would like to try it, but none of the links work on the site ;)
 
 Tim Blair wrote:
 
  Morning,
 
  Has anyone seen this before: http://www.pcaonline.com/coral/
 
  It's a new one on me...
 
  Tim.
 
  ---
  RAWNET LTD - Internet, New Media and ebusiness Gurus.
  Visit our new website at http://www.rawnet.com for
  more information about our company, or call us free
  anytime on 0800 294 24 24.
  ---
  Tim Blair
  Web Application Engineer, Rawnet Limited
  Direct Phone : +44 (0) 1344 393 441
  Switchboard : +44 (0) 1344 393 040
  ---
  This message may contain information which is legally
  privileged and/or confidential.If you are not the
  intended recipient, you are hereby notified that any
  unauthorised disclosure, copying, distribution or use
  of this information is strictly prohibited. Such
  notification notwithstanding, any comments, opinions,
  information or conclusions expressed in this message
  are those of the originator, not of rawnet limited,
  unless otherwise explicitly and independently indicated
  by an authorised representative of rawnet limited.
  ---
  
_
 
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFML app server...

2003-12-04 Thread Gabriel Robichaud
They are back:

 
CORAL News

Thu, Dec, 4, 2003 - Wow! Over the past few days we've had hundreds of visitors to the Coral Web Site! Looks like many of you are looking for ways to deploy your CFML applications without paying for server licenses. Keep the comments coming, we want to hear from you! 

-Original Message-
From: Tim Blair [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:16 AM
To: CF-Talk
Subject: RE: Another CFML app server...

 I think its been removed :)

Hmm, I just get a directory listing denied message now...We got
informed of it's existence by someone sending us a message through the
contact form on our company site:

---8
My name is Roger Samuel representing Coral Web Application Builder. It's
a new product that allows you to run Cold Fusion, (CFML) and portions of
(ASP), in a stand-alone application without Cold Fusion or ASP or a
pre-installed Web Server, and without paying ANY run-time or server
license fees.

It's an exciting new product that's finally going to allow web
developers to have what Windows developers have always had. The ability
to deliver stand-alone applications royalty free to consumers or small
business workgroups!
---8

Very strange that it just be removed after they've started telling
people about it...

Tim.

---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com for
more information about our company, or call us free
anytime on 0800 294 24 24.
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
--- 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFML app server...

2003-12-04 Thread Gabriel Robichaud
I agree!

 
The kind of work that I do fits in well with their idea.Its enough work selling your product without having to up the price by a few thousand dollars just for server liscences.

 
Gabriel

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 3:43 PM
To: CF-Talk
Subject: RE: Another CFML app server...

At 03:24 PM 12/4/03 -0500, Adam Wayne Lehman wrote:
Seriously though. they only support like 25 tags! You'd be better off
just learning the ASP equivalents and calling it a day!

24 by my count (I'm ignoring cflock since it isn't needed.)

cfabort
cfapplication
cfbreak
cfcookie
cfdirectory
cfexecute
cffile
cfhttp
cfif
cfelse
cfelseif
cfinclude
cflocation
cflock not required in Coral
cfloop
cfmail
cfoutput
cfparam
cfpop
cfprocessingdirective
cfquery
cfscript
cfset
cftransaction
cftry/cfcatch

While it could be better, it is a start - we should be encouraging this 
sort of thing, I think.

T


Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division

-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 12:34 PM
To: CF-Talk
Subject: RE: Another CFML app server...

A the links seemed to work for me as well. I kinda like the idea of
this...



 From: Greg Luce [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: RE: Another CFML app server...
 Date: Thu, 4 Dec 2003 11:36:44 -0500
 MIME-Version: 1.0
 Received: from houseoffusion.com ([64.118.64.245]) by
mc5-f39.hotmail.com
 with Microsoft SMTPSVC(5.0.2195.6713); Thu, 4 Dec 2003 08:41:33 -0800
 Received: from LOCALHOST by LOCALHOSTwith ESMTP id
 9EF0D689E3AD1E40A2C3F72EDF6FB058Thu, 4 Dec 2003 11:39:33 -0500
 X-Message-Info: JGTYoYF78jGZZGSE3Ub5y1wF09VcJMdd
 Message-ID: [EMAIL PROTECTED]
 Precedence: bulk
 References:
[EMAIL PROTECTED]
 Return-Path: [EMAIL PROTECTED]
 X-OriginalArrivalTime: 04 Dec 2003 16:41:41.0752 (UTC)
 FILETIME=[7ED08F80:01C3BA85]
 
 What doesn't work? I just bounced through it all and downloaded it.
 
 -Original Message-
 From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 04, 2003 10:11 AM
 To: CF-Talk
 Subject: RE: Another CFML app server...
 
 
 Chickens.
 
 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 04, 2003 10:09 AM
 To: CF-Talk
 Subject: Re: Another CFML app server...
 
 I think its been removed :)
 
 On 4/12/03 3:04 pm, Gabriel Robichaud [EMAIL PROTECTED]
 wrote:
 
   wow... the site must be down, i was able to view it all this am.
  
  
   Gabriel
  
   -Original Message-
   From: Clint Tredway [mailto:[EMAIL PROTECTED]
   Sent: Thursday, December 04, 2003 10:03 AM
   To: CF-Talk
   Subject: Re: Another CFML app server...
  
   I would like to try it, but none of the links work on the site ;)
  
   Tim Blair wrote:
  
Morning,
   
Has anyone seen this before: http://www.pcaonline.com/coral/
   
It's a new one on me...
   
Tim.
   
---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com for
more information about our company, or call us free
anytime on 0800 294 24 24.
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---
   
  _
  
  
 _
 _
 
 
 
_


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




RE: Another CFML app server...

2003-12-04 Thread Gabriel Robichaud
Perl?And thats supposed tomake my life easier?might as well step into a time machine back into 1992.The reason i Like CFML as opposed to the others, is ease of use and coding simplicity.

 
I would rather do a cfquery than try to open, manage, query and close my dbconnections.. etc etc etc etc etc.

 
I wont even begin complaining about ASP and and micro$oft empire...

 
php... well thats just as cryptic as perl IMHO.

 
its all about KISS. (keep it simple stupid)

 
Gabriel

-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 3:50 PM
To: CF-Talk
Subject: Re: Another CFML app server...

It seems to me that there are a lot of better alternativesphp, 
asp.net, python, perl, etc.I guess I'm just trying to apply the old 
rule the right tool for the right job

/slips on flameproof underwear

marlon

Thane Sherrington wrote:

 At 03:24 PM 12/4/03 -0500, Adam Wayne Lehman wrote:
 Seriously though. they only support like 25 tags! You'd be better off
 just learning the ASP equivalents and calling it a day!

 24 by my count (I'm ignoring cflock since it isn't needed.)

 cfabort
 cfapplication
 cfbreak
 cfcookie
 cfdirectory
 cfexecute
 cffile
 cfhttp
 cfif
 cfelse
 cfelseif
 cfinclude
 cflocation
 cflock not required in Coral
 cfloop
 cfmail
 cfoutput
 cfparam
 cfpop
 cfprocessingdirective
 cfquery
 cfscript
 cfset
 cftransaction
 cftry/cfcatch

 While it could be better, it is a start - we should be encouraging this
 sort of thing, I think.

 T


 
 Adam Wayne Lehman
 Web Systems Developer
 Johns Hopkins Bloomberg School of Public Health
 Distance Education Division
 
 -Original Message-
 From: Dan Farmer [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 04, 2003 12:34 PM
 To: CF-Talk
 Subject: RE: Another CFML app server...
 
 A the links seemed to work for me as well. I kinda like the idea of
 this...
 
 
 
  From: Greg Luce [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Subject: RE: Another CFML app server...
  Date: Thu, 4 Dec 2003 11:36:44 -0500
  MIME-Version: 1.0
  Received: from houseoffusion.com ([64.118.64.245]) by
 mc5-f39.hotmail.com
  with Microsoft SMTPSVC(5.0.2195.6713); Thu, 4 Dec 2003 08:41:33 -0800
  Received: from LOCALHOST by LOCALHOSTwith ESMTP id
  9EF0D689E3AD1E40A2C3F72EDF6FB058Thu, 4 Dec 2003 11:39:33 -0500
  X-Message-Info: JGTYoYF78jGZZGSE3Ub5y1wF09VcJMdd
  Message-ID: [EMAIL PROTECTED]
  Precedence: bulk
  References:
 [EMAIL PROTECTED]
  Return-Path: [EMAIL PROTECTED]
  X-OriginalArrivalTime: 04 Dec 2003 16:41:41.0752 (UTC)
  FILETIME=[7ED08F80:01C3BA85]
  
  What doesn't work? I just bounced through it all and downloaded it.
  
  -Original Message-
  From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
  Sent: Thursday, December 04, 2003 10:11 AM
  To: CF-Talk
  Subject: RE: Another CFML app server...
  
  
  Chickens.
  
  -Original Message-
  From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
  Sent: Thursday, December 04, 2003 10:09 AM
  To: CF-Talk
  Subject: Re: Another CFML app server...
  
  I think its been removed :)
  
  On 4/12/03 3:04 pm, Gabriel Robichaud [EMAIL PROTECTED]
  wrote:
  
wow... the site must be down, i was able to view it all this am.
   
   
Gabriel
   
-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:03 AM
To: CF-Talk
Subject: Re: Another CFML app server...
   
I would like to try it, but none of the links work on the site ;)
   
Tim Blair wrote:
   
 Morning,

 Has anyone seen this before: http://www.pcaonline.com/coral/

 It's a new one on me...

 Tim.

 ---
 RAWNET LTD - Internet, New Media and ebusiness Gurus.
 Visit our new website at http://www.rawnet.com for
 more information about our company, or call us free
 anytime on 0800 294 24 24.
 ---
 Tim Blair
 Web Application Engineer, Rawnet Limited
 Direct Phone : +44 (0) 1344 393 441
 Switchboard : +44 (0) 1344 393 040
 ---
 This message may contain information which is legally
 privileged and/or confidential.If you are not the
 intended recipient, you are hereby notified that any
 unauthorised disclosure, copying, distribution or use
 of this information is strictly prohibited. Such
 notification notwithstanding, any comments, opinions,
 information or conclusions expressed in this message
 are those of the originator, not of rawnet limited,
 unless otherwise explicitly and independently indicated
 by an authorised representative of rawnet limited.
 ---

   _
   
   
  _
  _
  
  
  
 _
 
 
 
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription

RE: Another CFML app server...

2003-12-04 Thread Gabriel Robichaud
Oh yee of little faith.

 
 1977: Apple Computer moves from Jobs' garage to an office in Cupertino

 
talk about backwoods :)

[Gabriel Robichaud] 
 -Original Message-
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 4:02 PM
To: CF-Talk
Subject: RE: Another CFML app server...

Sorry. This whole thing seems a little backwoods to me. I'll admit I'm
superficial about this sort of thing, but I'm not about to use a
webserver from a company who has such a crappy site. The information
about the server so far is misleading at best. Not a single person on
their staff is here to comment to the community? Or bother to make an
official announcement?

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 3:43 PM
To: CF-Talk
Subject: RE: Another CFML app server...

At 03:24 PM 12/4/03 -0500, Adam Wayne Lehman wrote:
Seriously though. they only support like 25 tags! You'd be better off
just learning the ASP equivalents and calling it a day!

24 by my count (I'm ignoring cflock since it isn't needed.)

cfabort
cfapplication
cfbreak
cfcookie
cfdirectory
cfexecute
cffile
cfhttp
cfif
cfelse
cfelseif
cfinclude
cflocation
cflock not required in Coral
cfloop
cfmail
cfoutput
cfparam
cfpop
cfprocessingdirective
cfquery
cfscript
cfset
cftransaction
cftry/cfcatch

While it could be better, it is a start - we should be encouraging this 
sort of thing, I think.

T


Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division

-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 12:34 PM
To: CF-Talk
Subject: RE: Another CFML app server...

A the links seemed to work for me as well. I kinda like the idea of
this...



 From: Greg Luce [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: RE: Another CFML app server...
 Date: Thu, 4 Dec 2003 11:36:44 -0500
 MIME-Version: 1.0
 Received: from houseoffusion.com ([64.118.64.245]) by
mc5-f39.hotmail.com
 with Microsoft SMTPSVC(5.0.2195.6713); Thu, 4 Dec 2003 08:41:33 -0800
 Received: from LOCALHOST by LOCALHOSTwith ESMTP id
 9EF0D689E3AD1E40A2C3F72EDF6FB058Thu, 4 Dec 2003 11:39:33 -0500
 X-Message-Info: JGTYoYF78jGZZGSE3Ub5y1wF09VcJMdd
 Message-ID: [EMAIL PROTECTED]
 Precedence: bulk
 References:
[EMAIL PROTECTED]
 Return-Path: [EMAIL PROTECTED]
 X-OriginalArrivalTime: 04 Dec 2003 16:41:41.0752 (UTC)
 FILETIME=[7ED08F80:01C3BA85]
 
 What doesn't work? I just bounced through it all and downloaded it.
 
 -Original Message-
 From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 04, 2003 10:11 AM
 To: CF-Talk
 Subject: RE: Another CFML app server...
 
 
 Chickens.
 
 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 04, 2003 10:09 AM
 To: CF-Talk
 Subject: Re: Another CFML app server...
 
 I think its been removed :)
 
 On 4/12/03 3:04 pm, Gabriel Robichaud [EMAIL PROTECTED]
 wrote:
 
   wow... the site must be down, i was able to view it all this am.
  
  
   Gabriel
  
   -Original Message-
   From: Clint Tredway [mailto:[EMAIL PROTECTED]
   Sent: Thursday, December 04, 2003 10:03 AM
   To: CF-Talk
   Subject: Re: Another CFML app server...
  
   I would like to try it, but none of the links work on the site ;)
  
   Tim Blair wrote:
  
Morning,
   
Has anyone seen this before: http://www.pcaonline.com/coral/
   
It's a new one on me...
   
Tim.
   
---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com for
more information about our company, or call us free
anytime on 0800 294 24 24.
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---
   
  _
  
  
 _
 _
 
 
 
_



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




Re:Date Range Query Issues

2003-12-03 Thread Gabriel Robichaud
Here is the code I use to find stuff in a date range!

Judging from the quality of your postings in the past, I am sure you can modify it to your own needs!As for the discussion regarding separating your dates into separate fields… hey… if I have learned anything in my experience in computer science, its that there is more than one way to do a job, and sometimes the less obvious one is the best one, even when everyone thinks Its crazy.They killed Galileo for saying the earth revolved around the sun! ;)

Here is the code.I stored all my date fields as numeric to increase speed, and I don’t forget about to change the arguments into cfqueryparams, etc.But I am sure you know what to do. If you have any questions about the code let me know!This code works great for checking overlap withi a single date... ie does 13th of September 2003 over lap a ascheduled event... you could easily integrate overlapping with date ranges if you change the operators = or = to the BETWEEN sql operator, like I did in the !---ALTERNATIVE QUERY FOR DATE RANGES ---. I didn’t test this query, but I am pretty sure the logic is correct.Let me know how it worked out for you.

Gabriel

!---

---function description : GetEventsThisDay

This function returns a query of events for a given day.

Argument list
CurrentMonth : The month for which we need the event
CurrentYear: The Year for which we need the event
CurrentDay: The day for which we need the event

		
Author : Gabriel Robichaud
Date : August 7th 2003

---
cffunction name=getEventsThisDay returntype=query
cfargument name=CurrentMonth required=true type=numeric
cfargument name=CurrentYear required=true type=numeric
cfargument name=CurrentDay required=true type=numeric

cfquery datasource=#CAB# username=#username# password=#password# name=GET_EVENTS SELECT * FROM EVENTS 
where EVENT_START_YEAR = #Arguments.currentYear#
	and event_start_month = #Arguments.currentMonth# 
	and event_start_day = #Arguments.currentDay# 
	and event_end_year = #Arguments.currentYear#
	and event_end_month = #Arguments.currentMonth#	
	and event_end_day = #arguments.currentday#
/cfquery

!---ALTERNATIVE QUERY FOR DATE RANGES 
cfquery datasource=#CAB# username=#username# password=#password# name=GET_EVENTS SELECT * FROM EVENTS 
where (EVENT_START_YEAR between #startyear# and #end_year#
	and event_start_month between #startmonth# and #end_month#
	and event_start_day between #startday# and #end_day#)
OR	(event_end_year between #startyear# and #end_year#
	and event_end_month between #startmonth# and #end_month#
	and event_end_day between #startday# and #end_day#
	)
/cfquery
---

cfreturn get_events

/cffunction

Cheers, 
Gabriel

Hello list ;)
 
I have a db table in which I store Start and End Dates called
ONCALL_SHIFTS. These are ranges. 
 
For example 
 
Start_Month 12
Start_Day 1
Start_Year 2003
Start_Time 8
 
End_Month 12
End_Day 15
End_Year 2003
End_Time 8
 
There are also two shift types: Backup and Primary
 
So I have a form where the schedulers can add new shifts. It basically
asks them for the start and end info, the doctor's name, and what the
shift type is.
 
Now, what I want to check for is that there are no overlaps in the
shifts, but only if the shift_types are the same; meaning, it's ok to
have 2 doctors scheduled for 12/1/2003-12/15/2003 as long as the
shift_types are different (backup and primary). It's also ok if one
doctor is scheduled for both shift types (ex. Dr. X is both backup and
primary on this date range).
 
I know I need to pull a query that brings back the records that would
be overlapped. And if that recordset is empty, proceed with the insert.
Otherwise, give the user a message that there is an overlap and take
them back to the form.
 
The problems are:
 
1) I can't figure out what should be in the WHERE clause.
2) Have I screwed myself by chopping up the dates?
 
Here's the idea:
 
cfset formDate = form.Start_Month/form.Start_Day/form.Start_Year
cfset formTime = form.Start_Hour
 
cfquery name=qrycheckForDupes datasource=#request.DSN#
SELECT
 Shift_ID
 Start_Day,
 Start_Month,
 Start_Hour,
 Start_Year
FROM
 ONCALL_SHIFTS
WHERE
 ?
 

/cfquery
 
cfif qrycheckForDupes.recorset NEQ 0
 

cfquery name=InsertSHIFT datasource=#request.DSN#
INSERT INTO
 ONCALL_SHIFTS
 (Start_Day,
 Start_Month,
 Start_Hour,
 Start_Year,
 Start_AMPM,
 Schedule_Type_ID,
 End_Day,
 End_Month,
 End_Hour,
 End_Year,
 End_AMPM,
 Doctor_ID,
 Division_ID
 )
VALUES
 (
 #Form.Start_Day#,
 #Form.Start_Month#,
 #Form.Start_Hour#,
 #Form.Start_Year#,
 '#Form.Start_AMPM#',
 #Form.Schedule_Type_ID#,
 #Form.End_Day#,
 #Form.End_Month#,
 #Form.End_Hour#,
 #Form.End_Year#,
 '#Form.End_AMPM#',
 #Form.Doctor_ID#,
 #URL.DIVISIONID#
 )
/cfquery

RE: CF+MySQL+Apache french characters not properly displayed.

2003-11-10 Thread Gabriel Robichaud
Hey Yves!

 
I was having the same problem on win2k mx 6.1 mysql version 3.xxx whatever
it was, if I recall the webserver was IIS but it was the same problems you
described... accents converted to ? . I had to resort to setting all the
encodings to iso-8859-1.I noticed though that accented characters that
were embedded in my .cfm templates who were not from the database worked
fine. It was only the ones in the DB..., which I thought was weird.But
setting cfprocessing, cfcontent and encoding forms to use iso-8859-1 did the
trick for me as well. 

 
So far, getting accents to work has been my number one issue with cfmx 6 and
6.1

-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]
Sent: November 10, 2003 3:59 PM
To: CF-Talk
Subject: RE: CF+MySQL+Apache french characters not properly displayed.

 
Finally,
It had to do with MySQL's encoding, 3.23.58 not being compatible with
UTF-8 from what I found.

So I'm forcing CFMX to use iso-8859-1.

Now my pages come out as expected.

I have one question if anyone would there be any draw backs to doing
this?

Thanks,

Yves
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]
Sent: 10 novembre 2003 15:02
To: CF-Talk
Subject: CF+MySQL+Apache french characters not properly displayed.

Hello,

I've been racking my brain over this for a little bit...

I'm running CFMX 6.1, Apache 2.0.48 and MySQL 3.23.58.

I'm a bit confused at this behavior... I converted an access db to mysql
using a conversion tool. I log in to webmin, look at the data in my
tables,
everything looks fine. Characters such as ,,.. all display as they
should.

When I view a page with this same data through my webserver (apache), all
the french characters are messed up.

Any ideas??

Thanks,

Yves

_


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




RE: VoIP

2003-11-07 Thread Gabriel Robichaud
Have you tried Nortel? ;)

 
-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED]
Sent: November 7, 2003 9:31 AM
To: CF-Talk
Subject: OT: VoIP

 
Sorry for the OT. Is there anyone on this list in the Southern Ontario
region that knows on companies that provide Voice Over IP or Broadband
phone service?

Thanks! 

Dan Phillips
www.CFXHosting.com 
1-866-239-4678 x105
[EMAIL PROTECTED]

.

_


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




RE: OT- Dynamic Page Layouts

2003-11-05 Thread Gabriel Robichaud
IF its not good practice? What else do you suggest?Personally, I think css
is quirky and causes more cross browser headaches than its really worth.
Maybe my knowledge of css isn't wide enough to adequately implement them,
but everything I have done/seen/read with cssbasically ends up sounding
like this : You can do this, but not with that browser you need to do this
instead but that won't work with version x.x and it just goes on and on...
I actually cfinclude my headers and footers in Application.cfm and
OnRequestEnd.cfmAnd I fail to see why this is such a bad idea? So I have
decided to limit use of CSS in my sites to things that work on most
browsers. 

-Original Message-
From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]
Sent: November 5, 2003 6:30 AM
To: CF-Talk
Subject: RE: OT- Dynamic Page Layouts

 
Note that it is not good practice to use OnRequestEnd.cfm for any display
outputs. (The same goes for Application.cfm)

I understood that the Mickael's problem was not how to get something
appended to every called template, rather how to get a display piece to be
presented at the bottom of the browser window (no matter what template is
called).

/Hugo

-
Hugo AhleniusE-Mail: [EMAIL PROTECTED]
Project Officer Phone:+46 8 230460
UNEP GRID-ArendalFax:+46 8 230441
Stockholm OfficeMobile:+46 733 467111
 WWW: http://www.grida.no
http://www.grida.no 
- 

| -Original Message-
| From: Peter Tilbrook [mailto:[EMAIL PROTECTED]
| Sent: Wednesday, November 05, 2003 11:47
| To: CF-Talk
| Subject: RE: OT- Dynamic Page Layouts
|
|
| Mike, as Hugo stated definately avoid frames for this tip.
|
| Use the OnRequestEnd.cfm template.
|
| Unlike the Application.cfm template, OnRequestEnd.cfm is
| executed AFTER
| all other cfm templates. Very handy and I haven't worked out
| a better way to
| use it from what you require.
|
| In fact that is what I use for the footer at
| www.actcfug.com. There IS a
| way to use it with frames but it usually requires using
| CFABORT at the end
| of the template which probably isn't good practice - but it
| works at any
| rate. You could use the CFABORT method at the end of a
| template in say a
| small popup where your usual footer either does not fit or is not
| appropriate.
|
| HTH
|
| Peter Tilbrook
| ColdFusion Applications Developer
| ColdGen Internet Solutions
| Manager, ACT and Region ColdFusion Users Group -
| http://www.actcfug.com http://www.actcfug.com 
| 4/73 Tharwa Road
| Queanbeyan, NSW, 2620
| AUSTRALIA
|
| Telephone: +61-2-6284-2727
| Mobile: +61-0439-401-823
| E-mail: [EMAIL PROTECTED]
|
| World Wide Web: http:/www.coldgen.com/
| -Original Message-
| From: Mickael [mailto:[EMAIL PROTECTED]
| Sent: Wednesday, 5 November 2003 9:36 PM
| To: CF-Talk
| Subject: Re: OT- Dynamic Page Layouts
|
|
| Hugo
|
| Thanks that is just what I needed.
|- Original Message -
|From: Hugo Ahlenius
|To: CF-Talk
|Sent: Wednesday, November 05, 2003 2:52 AM
|Subject: Re: OT- Dynamic Page Layouts
|
|Two ways:
|
|* Frames, I think you should avoid it for this case.
|* CSS. I found a good way on the web somewhere (now link).
| You can look at
|the source and the css of this page, which uses a CSS
| method to do this:
| http://globalis.no/admin/ http://globalis.no/admin/ 
|
|-
|Hugo AhleniusE-Mail: [EMAIL PROTECTED]
|Project Officer Phone:+46 8 230460
|UNEP GRID-ArendalFax:+46 8 230441
|Stockholm OfficeMobile:+46 733 467111
| WWW: http://www.grida.no
http://www.grida.no 
|-
|
|
|| On Wednesday, November 05, 2003 05:50 [GMT+1=CET],
|| Mickael [EMAIL PROTECTED] wrote:
|
|| Hello All,
||
|| This is not exactly a coldfusion question but does
| pertain to dynamic
|| site.I have a site in CF that the client would like to include a
|| standard footer at the bottom of the page.This works
| fine when the
|| content that is returned is more than once screen in my explorer
|| window at my resolution.
||
|| The problem that I am having is that some of the pages
| have content
|| that is returned and it is a little bit less one screen
| so I see my
|| footer then the remainder of the screen below the footer
| which is not
|| what the client wants.
||
|| Is there a way to handle this?
||
|| Thanks
||
|| Mike
||
||
||
|
|
|
| 
_


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




createdate() how screwy is this

2003-11-04 Thread Gabriel Robichaud
For the longest time I have been struggling to figure out why on certain
pages, all my French characters are turned into question marks (?).I have
my encoding done correctly, and the only characters that seem affected are
those that are stored into a database.They are stored correctly; they are
just not retrieved correctly.Well, last night I figured out that the if I
use the createdate() function anywhere in those cfm pages... ALL accents
magically turn into question marks.But this could be a problem since I
can't use the createdate() function in my calendering app!

 Has anyone run into this before and if so, how did you handle it?

 
Windows 2k
Mysql DB
CFMX

 
Thanks y'all!
Gabriel

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




RE: Not Subscribed: OT: SQL Server to Oracle migration

2003-11-04 Thread Gabriel Robichaud
Yeah... good luck.

 
I recently did analysis on a ms sql 2000 to oracle 8i and 9i migration...
the oracle migration tool on the oracle website is where you need to start,
it will identify all the stuff in your DB that cannot be converted
automatically and provided a good starting point.It also identifies all
incompatibilities in table names and column names, etc, etc, etc...

 
Your cfqueries might not work depending on how you have written them.Other
than testing them one by one, I did not find any solution to this.Another
big issue is stored procedures, as PL/SQL is very different than T-SQL.
Some stored procedures are converted automatically with the Oracle Migration
Workbench, but most need some level of human intervention.So your efforts
are going to be greater depending on the complexity of your stored procs,
and how your sql db was designed.

 
Gabriel

 
-Original Message-
From: Michael Hodgdon [mailto:[EMAIL PROTECTED]
Sent: November 4, 2003 10:16 AM
To: CF-Talk
Subject: FW: Not Subscribed: OT: SQL Server to Oracle migration

 
I have an Off Topic question for the list.

I have a few databases that I was thinking of migrating from SQL 2000 to
Oracle 8.1.7.1.5 .I am wondering two things:

1) Will the SQL in my CF Templates still work after the migration?

2) Are there any major pitfalls or recommendations you could give me in
terms of the actual migration?

Any help is appreciated.

Michael

_


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




RE: SQL for duplicate entries

2003-11-04 Thread Gabriel Robichaud
Just off the top of my head, I would try

 
Select all columns list from (
Select all columns list, count(*) as counting
>From mytable
Group by all columns list) a
Where a.counting  1

 
I know this would work on oracle... don't know about MSSQL or otherwise, but
you get the idea

 
GAbriel

 
-Original Message-
From: brob [mailto:[EMAIL PROTECTED]
Sent: November 4, 2003 3:09 PM
To: CF-Talk
Subject: SQL for duplicate entries

 
Hey guys, i have a table with abot 4,000 records.Is there a special SQL
that will return all records that are duplicates, or do I have to do it the
old fashioned way?

THanks
_


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




RE: createdate() how screwy is this

2003-11-04 Thread Gabriel Robichaud
I am using cfsetting, cfcontent and setencoding I have tried using
iso-8859-1 and utf-8 I get the same result. 

 
As far as I can tell the datasource is ODBC but I am not certain since this
is out of my control on the production environment, on my dev, I used the
Mysqlthat was already in the cf admin

 
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: November 4, 2003 3:38 PM
To: CF-Talk
Subject: Re: createdate() how screwy is this

 
Gabriel Robichaud wrote:
 For the longest time I have been struggling to figure out why on certain
 pages, all my French characters are turned into question marks (?).I
have
 my encoding done correctly, and the only characters that seem affected are
 those that are stored into a database.They are stored correctly; they
are
 just not retrieved correctly.

How is your datasource set up? Are you using cfsetting, cfcontent 
and setencoding?

Jochem

-- 
You have the right
to remain silent
but should you?
- Loesje

_


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




page encoding french characters stupid hosting

2003-10-31 Thread Gabriel Robichaud
Ok

 
For the last week I have been battling in out with my hosting provider.I
develop all my apps in French, French content, French in the db tables,
French... BUT my development environment is 100% English, because I prefer
the to work in English... so I develop my apps, they work 100% fine in my
English dev environment... so... move to production, ie, my hosting
provider... ALL ACCENTED CHARACTERS that are passed to the server via web
forms are converted to `y.My hosting provider is convinced it's a coding
problem, but yet, if this was true, I would have the same problem on my dev
machines right?I tried it on two separate dev machines, and I just can't
reproduce this bug.I have cfcontent set to iso-8859-1,also
setEncoding(form, UTF-8) did not work and the cfprocessing directive did
not work either 

 
Here is how ti works.

 
- User enters accents in form
- User presses submit
- cfoutput#form.content#/cfoutputall accents are converted to
'y 
- this happens before its inserted into the database so its clearly
a problem on the server or some obscure thing I don't know about

 
PLEASE, anyone with ideas, I am all ears!!

Gabriel

 

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




RE: page encoding french characters stupid hosting

2003-10-31 Thread Gabriel Robichaud
H... yeah, I could try setLocale(French (Canadian));I will try
that... but my hope levels are getting lower and lower every day!Any other
takers?

 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: October 31, 2003 10:03 AM
To: CF-Talk
Subject: Re: page encoding french characters stupid hosting

 
I think you can use set locale to change the settings.

Rex

- Original Message -
From: Gabriel Robichaud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, October 31, 2003 2:33 PM
Subject: page encoding french characters stupid hosting

Ok

For the last week I have been battling in out with my hosting provider.I
develop all my apps in French, French content, French in the db tables,
French... BUT my development environment is 100% English, because I prefer
the to work in English... so I develop my apps, they work 100% fine in my
English dev environment... so... move to production, ie, my hosting
provider... ALL ACCENTED CHARACTERS that are passed to the server via web
forms are converted to `y.My hosting provider is convinced it's a coding
problem, but yet, if this was true, I would have the same problem on my dev
machines right?I tried it on two separate dev machines, and I just can't
reproduce this bug.I have cfcontent set to iso-8859-1,also
setEncoding(form, UTF-8) did not work and the cfprocessing directive did
not work either

Here is how ti works.

- User enters accents in form
- User presses submit
- cfoutput#form.content#/cfoutputall accents are converted to
'y
- this happens before its inserted into the database so its clearly
a problem on the server or some obscure thing I don't know about

PLEASE, anyone with ideas, I am all ears!!

Gabriel

_


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




RE: page encoding french characters stupid hosting

2003-10-31 Thread Gabriel Robichaud
You mean the lang environment variable on the server settings right?

 
-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED]
Sent: October 31, 2003 10:11 AM
To: CF-Talk
Subject: Re: page encoding french characters stupid hosting

 
 ALL ACCENTED CHARACTERS that are passed to the server via web
 forms are converted to `y.

We had a similar problem in a JRun/Linux environment which was fixed by
setting the LANG environment variable appropriately.

Nick

_


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




RE: page encoding french characters stupid hosting

2003-10-31 Thread Gabriel Robichaud
Ok.. I will try that as soon as I can... believe it or not I cant ftp from
the site I am working today. *grumble*

 
Gabriel

 
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: October 31, 2003 10:20 AM
To: CF-Talk
Subject: Re: page encoding french characters stupid hosting

 
Gabriel Robichaud wrote:

 For the last week I have been battling in out with my hosting provider.I
 develop all my apps in French, French content, French in the db tables,
 French... BUT my development environment is 100% English, because I prefer
 the to work in English... so I develop my apps, they work 100% fine in my
 English dev environment... so... move to production, ie, my hosting
 provider... ALL ACCENTED CHARACTERS that are passed to the server via web
 forms are converted to `y.My hosting provider is convinced it's a coding
 problem, but yet, if this was true, I would have the same problem on my
dev
 machines right?I tried it on two separate dev machines, and I just can't
 reproduce this bug.I have cfcontent set to iso-8859-1,also
 setEncoding(form, UTF-8) did not work and the cfprocessing directive
did
 not work either 

 Here is how ti works.

 - User enters accents in form
 - User presses submit
 - cfoutput#form.content#/cfoutputall accents are converted
to
 'y 
 - this happens before its inserted into the database so its
clearly
 a problem on the server or some obscure thing I don't know about

 PLEASE, anyone with ideas, I am all ears!!

Set cfcontent, setEncoding and cfprocessingdirective all to 
UTF-8. If that doesn't work, show the code and the URL.

Jochem

-- 
You have the right
to remain silent
but should you?
- Loesje

_


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




accents

2003-10-30 Thread Gabriel Robichaud
Do you guys know of a function for converting accented characters into their
ascii equivalents or from  to eacute;

 
Gabriel

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




webserve.ca hosting woes

2003-10-28 Thread Gabriel Robichaud
Hey Guys

 
I recently signed up with webserve.ca for some CF hosting...Has anyone
here experience problems with them setting up DSN's for CF.I spent 3 days
(I wish I was joking) with their tech support explaining that a ODBC DSN is
not the same as creating one in cf!They claim that I can just create and
ODBC DSN in my control panel (what they call the interface to administrate
my site) and call that from Coldfusion cfm pages... well that doesn't work.
They did some tinkering, and they got 1 of my ODBC DSNs to work, but if I
create new ones, (of course) they don't work.Can anyone shed any light on
this?I only signed a 3 month hosting thing because well, I am not stupid
and CF hosting is expensive and my requirement is to host this in Canada, so
anyone know of any GOOD CF hosts in Canada?

 
TIA!
Gabriel

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




RE: Form and hidden variable question

2003-10-20 Thread Gabriel Robichaud
Have you tried just doing a cfoutput#frm.outputselection#/cfoutput on
your target cfm page just to see if it is in fact empty? 

 
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: October 20, 2003 10:10 AM
To: CF-Talk
Subject: Re:Form and hidden variable question

 
Makes no difference, the value in the hidden variable is still empty. I
tried this is in subme function:

document.frm.txtarea1.value = document.frm.outputselection.value;

On form submission, I see the textarea briefly populated with the value in
the hidden variable but it dissapears when the form is fully submitted.
Should I be adding something between the textarea tag?
textareaSomething/textarea
_


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




RE: OT: max length of a fieldname

2003-10-16 Thread Gabriel Robichaud
Oracle doesn't really have a INFORMATION_SCHEMA, but it has numerous tables
in the data dictionary that do the exact same thing if not more.

 
Gabriel

 
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: October 16, 2003 8:41 AM
To: CF-Talk
Subject: Re: OT: max length of a fieldname

 
Jill Robin Pascua said:
 What'st he maximum length for fieldnames in MS SQL
 Server and in Oracle?

This should be in the INFORMATION_SCHEMA of the database:

SELECT sizing_name, supported_value
FROMinformation_schema.sql_sizing
WHEREsizing_id = 30

Not sure if Oracle supports an INFORMATION_SCHEMA, but MS SQL Server
has one. You should check it out, it has a lot of information.

Jochem

_


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




getting the day of week in a date

2003-10-16 Thread Gabriel Robichaud
Hey all!

 
Anyone know why this code doesn't return the right day of week?
cfset firstDayOfcurrMonth =
DayOfWeek(FirstDayOfMonth(createdate(url.currYear, url.currMonth,
url.currday)))

 
I get the wrong day!Even if I replace the variables url.currYear,
url.currmonth, url.currday with now() I still get the wrong day returned!

 
cfset firstDayOfcurrMonth = DayOfWeek(FirstDayOfMonth(now()))

 
Any help would be great

 
Gabriel
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: October 16, 2003 1:13 PM
To: CF-Talk
Subject: RE: Quotes in a Text Box Problem

 
HTMLeditFormat() escapes all special characters for you, including
quotes, ampersand, greater than and less than

Don't try to do it with Replace as you're just going to have several of
them to cover every eventuality

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2003 12:30 PM
To: CF-Talk
Subject: Quotes in a Text Box Problem

If #import_detail.PA_SIZE# equals the value of: 15x34

This will display correctly inside a CFOUTPUT statement:

cfoutputProduct Size: #import_detail.PA_SIZE#cfoutput

will display correctly as

Product Size: 15x34

BUT..

This:

input type=text
name=PA_SIZE
value=cfoutput#import_detail.PA_SIZE#/cfoutput
size=32

will show the text box and cut off after the first quote, so I get a 
text box with just 15 in it.

I know there's a fix, I just ain't found it yet.

Ideas?

TIA

_

_


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




RE: getting the day of week in a date

2003-10-16 Thread Gabriel Robichaud
 

 
-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]
Sent: October 16, 2003 1:53 PM
To: CF-Talk
Subject: re: getting the day of week in a date

 
YAY! Thank you all very much!!

 
Gabriel

Original Message:
 From: Gabriel Robichaud [EMAIL PROTECTED]

 Anyone know why this code doesn't return the right day of week?
 cfset firstDayOfcurrMonth =
 DayOfWeek(FirstDayOfMonth(createdate(url.currYear, url.currMonth,
 url.currday)))

firstDayOfMonth() returns the actual number of the day in the year that the
first day of a month starts on.For example, February 1st would return 32
(the 32nd day of the year).

I think what you want is:
cfset firstDayOfcurrMonth = DayOfWeek(createdate(url.currYear,
url.currMonth, 1))

(since no matter what month it is, the first day is ALWAYS a date of 1[
X/1/2003 ])

Scott

---
Scott Brady
http://www.scottbrady.net/ http://www.scottbrady.net/ 

_


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




cfscript

2003-10-10 Thread Gabriel Robichaud
Hey out there?

 
Anyone know of a good resource for CFScript... some documentation would be
really cool!

TIA!!

 
Gabriel

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




RE: Mac and SQL Server

2003-10-09 Thread Gabriel Robichaud
You know... I have been entertaining the idea of getting a Mac as well... I
wonder if the Linux underneath it would permit to install a Linux oracle
db??

 
Anyone have any info on that?

 
Gabriel

 
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: October 9, 2003 2:38 PM
To: CF-Talk
Subject: OT: Mac and SQL Server

 
Other than running Virtual PC and installing a SQL server instance on it, is

there a version of SQL server that can run on a MAC? I am evaluating a 
PowerBook G4 as a replacement for my Dell, and have JRUN and CFMX installed 
and running just fine. Also have Studio MX installed and running fine as 
well. I really do not want to use MySQL as you cannot do Stored Procs with 
it, and of course MS Access is totally out of the question.

Thanks,

Bruce Sorge

_


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




RE: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread Gabriel Robichaud
Well, here in CANADA ;) they always file them in Programming, and sometimes
in Web-Programming hehehehe
 
_
Gabriel Robichaud
Analyste-programmeur
 
Technomedia Formation inc.
1001, boul. De Maisonneuve Ouest 5e tage
Montral (Qubec) H3A 3C8
Tlphone :(514) 287-1561 poste 308
Tlcopieur : (514) 287-1733 
http://www.technomedia.ca
_
 
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: September 30, 2003 6:45 PM
To: CF-Talk
Subject: RE: CFV: comp.lang.coldfusion Usenet Newsgroup
 
Speaking of more legitimacy -- what's up with chain bookstores always filing
the CF titles under graphic/web design?

I asked an employee of my local Barnes and Nobel the other day and he said
this was a corporate decision.

Personally, it always irks me that CF books aren't in with the programming
books.Maybe we should all start complaining to the chains about this, and
MM -- MM should file its own protests. I think.

H.



~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~

 -Original Message-
 From: Dave Hodder [SMTP:[EMAIL PROTECTED]
 Sent: Saturday, September 27, 2003 12:38 PM
 To: CF-Talk
 Subject: Re: CFV: comp.lang.coldfusion Usenet Newsgroup
 
 Jim McAtee wrote:
 
  There's already a CF newsgroup.Why the need for another?
 
 It's covered in the comp.lang.coldfusion rationale.Some of us on the 
 existing alt.comp.lang.coldfusion group feel a proper comp.* group 
 would give ColdFusion more legitimacy, as well as the group having 
 better propagation, longer message retention periods, etc.
 
 Regards,
 
 Dave
 
_
 
 [ Todays Threads 
_

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




Solved: OT : sql server port to oracle

2003-09-19 Thread Gabriel Robichaud
In case anyone cares

You can download the Oracle Migration Workbench. That takes care of
converting MANY different types of Databases to Oracle.  (Even Access!)

Cheers y'all!



_
Gabriel Robichaud
Analyste-programmeur

Technomedia Formation inc.
_

-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
Sent: September 18, 2003 11:54 AM
To: CF-Talk
Subject: OT : sql server port to oracle

Has anyone ever heard of a tool to conver sql server stored procedures, etc,
to Oracle?

If anyone has done this before... feel free to contact me off list.

Gabriel


~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137653
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


MVC

2003-09-19 Thread Gabriel Robichaud
Does anyone have any info or links or books to recommend for integrating MVC
(Model View Contoller) paradigm into CF development?

Gabriel

_
Gabriel Robichaud
Analyste-programmeur

Technomedia Formation inc.
1001, boul. De Maisonneuve Ouest 5e étage
Montréal (Québec) H3A 3C8
Téléphone :   (514) 287-1561 poste 308
Télécopieur : (514) 287-1733 
http://www.technomedia.ca
_

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: September 19, 2003 10:55 AM
To: CF-Talk
Subject: Re: [ OT] Special security Alert!

On Friday 19 Sep 2003 15:39 pm, you said:
 Hardly a theat, as most people will be saavy enough to realise its a
 spoof.

You and me might.
Bob down in the mail room might not.

--
Tom Chiverton (sorry 'bout sig.)
Advanced ColdFusion Programmer

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


~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137668
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


OT : sql server port to oracle

2003-09-18 Thread Gabriel Robichaud
Has anyone ever heard of a tool to conver sql server stored procedures, etc,
to Oracle?

If anyone has done this before... feel free to contact me off list.

Gabriel

~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137511
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


javascript and page processing

2003-09-16 Thread Gabriel Robichaud
Hey folks

i am having popup issues

cfif createodbcdatetime(form.fldLoadDateN) gt dtLastUpdate
cfset updateRecord=Y
cfelse
cfset updateRecord = N
script language=JavaScript
window.open('SomeFile.cfm',
'noChange',
'resizable=no,toolbar=no,location=no,directories=no,status=no,menubar=no,scr
ollbars=no,width=300,height=199,top=50,left=50');/script
/cfif

ok... i have a cflocation at the bottom of the page that generates this... 

so my js popup doesnt popup.  How can i make sure it pops up?

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: javascript and page processing - clarify

2003-09-16 Thread Gabriel Robichaud
so my js popup doesnt popup.  How can i make sure it pops up?

actually, what i should have said, is there is a cflocation that calls a
template and i think because of that my popup doesnt happen, because when i
cfabort the page before the cflocation, the popup happens.

-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
Sent: September 16, 2003 11:03 AM
To: CF-Talk
Subject: javascript and page processing


Hey folks

i am having popup issues

cfif createodbcdatetime(form.fldLoadDateN) gt dtLastUpdate
cfset updateRecord=Y
cfelse
cfset updateRecord = N
script language=JavaScript
window.open('SomeFile.cfm',
'noChange',
'resizable=no,toolbar=no,location=no,directories=no,status=no,menubar=no,scr
ollbars=no,width=300,height=199,top=50,left=50');/script
/cfif

ok... i have a cflocation at the bottom of the page that generates this... 




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: javascript and page processing - clarify

2003-09-16 Thread Gabriel Robichaud
so what you are saying is that my target cfm (in the cflocaton) should look
for a param that indicates if the record was updated, if not then popup from
there and not from the preocessing page...  thanks. ;)
Gabriel

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: September 16, 2003 11:09 AM
To: CF-Talk
Subject: Re: javascript and page processing - clarify


On Tuesday 16 Sep 2003 16:05 pm, Gabriel Robichaud wrote:
 so my js popup doesnt popup.  How can i make sure it pops up?

 actually, what i should have said, is there is a cflocation that calls a
 template and i think because of that my popup doesnt happen, because when
i
 cfabort the page before the cflocation, the popup happens.

Most browsers ignore any HTML in the body of a response sent with a 302 
location header and just do the redirect stright away.

-- 
Tom Chiverton (sorry 'bout sig.)
Advanced ColdFusion Programmer

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


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: javascript and page processing - clarify

2003-09-16 Thread Gabriel Robichaud
actually, this is for online learning software that is actually sold...
people want this popup.. trust me, its all good :)



-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: September 16, 2003 11:15 AM
To: CF-Talk
Subject: RE: javascript and page processing - clarify


CFlocation returns a redirect header instead of the content of the page.

If you need to redirect the page after creating a popup (you'd better be
using this power for good, not evil, btw) you should consider using a
JavaScript redirect instead.


--  Ben Doom
Programmer  General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
: Sent: Tuesday, September 16, 2003 11:06 AM
: To: CF-Talk
: Subject: RE: javascript and page processing - clarify
:
:
: so my js popup doesnt popup.  How can i make sure it pops up?
:
: actually, what i should have said, is there is a cflocation that calls a
: template and i think because of that my popup doesnt happen,
: because when i
: cfabort the page before the cflocation, the popup happens.
:
: -Original Message-
: From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
: Sent: September 16, 2003 11:03 AM
: To: CF-Talk
: Subject: javascript and page processing
:
:
: Hey folks
:
: i am having popup issues
:
: cfif createodbcdatetime(form.fldLoadDateN) gt dtLastUpdate
:   cfset updateRecord=Y
:   cfelse
:   cfset updateRecord = N
:   script language=JavaScript
:   window.open('SomeFile.cfm',
: 'noChange',
: 'resizable=no,toolbar=no,location=no,directories=no,status=no,menu
: bar=no,scr
: ollbars=no,width=300,height=199,top=50,left=50');/script
:   /cfif
:
: ok... i have a cflocation at the bottom of the page that
: generates this...
:
:
:
:
: 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: works fine in access, but not cf

2003-09-15 Thread Gabriel Robichaud
heheh, I think he means debatable.


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: September 15, 2003 11:13 AM
To: CF-Talk
Subject: RE: works fine in access, but not cf


What does discutable mean?  is that a cross between inscrutable and
discountable?

-Mark

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 10:02 AM
To: CF-Talk
Subject: Re: works fine in access, but not cf


this is an ODBC error,

Not even: this a programer's error. The standars in SQL is to use single
quotes, not double quotes.

By the way, this choice is discutable since single quotes are not even
quotes, they are apostrophes,
and usually, double quotes is the standard to delimit strings. ;^)



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: works fine in access, but not cf

2003-09-15 Thread Gabriel Robichaud
vive la linguistique!

Gabriel

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: September 15, 2003 11:18 AM
To: CF-Talk
Subject: Re: works fine in access, but not cf


I think he means debatable.

This is not questionable ;-)


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Family tree program

2003-09-09 Thread Gabriel Robichaud
Ah Montréal!  C'est toi ma ville ;)

Gabriel

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: September 8, 2003 6:30 PM
To: CF-Talk
Subject: Re: Family tree program


PS... I see from your header that you are with Videotron? We may be
neigbours, I'm in Montreal ;-)


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Simple html question

2003-08-14 Thread Gabriel Robichaud
CHARLIE... I COULD NOT HAVE SAID IT BETTER MYSELF!!

cheers!

Charlie Griefer wrote:
 Well, the 'big question' may not be that big to everybody :)
 
 Yes, it works in NS.  Will it work in NS 4.x?  I don't know.
 
 Personally, I don't worry about NS 4.x anymore.  In my opinion, the number
 of users with NS 4.x is an acceptable level of loss.  I can't spend
 resources on making sure a page will render properly for a browser that
 represents such a small % of my audience.  To me, that time spent would be a
 greater loss.
 
 This might not be the most popular stance...but given the limited resources
 that I do have to work with, my feeling is that if my code is
 standards-compliant (by current standards), then I've done my job.  Also
 (and I'm sure this is a very naive belief), I feel that the more we, as Web
 Developers, cater to each and every browser (if i do *this* then it will
 work correctly in that browser...and add a condition here to make sure it
 works in *that* browser), then we give the browser companies no motivation
 to ensure that their products will render code 'properly'.
 
 I know that digresses a bit from the original comment (dealing with older
 browsers)...but I'm curious to know if others feel this way...and if so, do
 you act on it?  Or are you in a position where you don't have the option (or
 desire) to discount any certain browser(s)?
 
 As this isn't directly related to CF, hope it's not considered off-topic.
 Seems that since we all develop for the Web, it would be relevant.
 
 Charlie
 
 - Original Message - 
 From: Bryan Stevenson [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, August 12, 2003 10:02 AM
 Subject: Re: Simple html question
 
 
 
and the big question...does it work in Nutscrape and if so...how far back?
version 4.x? ;-)

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message -
From: Andre Mohamed [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 9:47 AM
Subject: RE: Simple html question



You can't get smaller than 1 pixel thickness (unless you consider
dotted/dashed borders)

table style=border:1px solid black
tr
tdhello world/td
/tr
/table

That's as thin as you can get (it definitely doesn't look the same the
default border - though that depends on your browser)

Andri

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: 12 August 2003 17:36
To: CF-Talk
Subject: Simple html question

Hi,
Just a very simple question,
is it possible to apply a style to a table to manipulate its border,
border=1 is just a tab to thick for the fine layout our designer has
done.

I tried table style=border:1px;border-color:#00, but this just
gives
the default border of one.

Can't seem to find anything in the style editor shipped with CF studio
4.5,

Respectfully,

j.



 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



Re: supressing white spaces

2003-08-14 Thread Gabriel Robichaud
perfect.. thats the kind of info i was lookign for!

Thanks!!
Gabriel

DURETTE, STEVEN J (AIT) wrote:
 Gabriel,
 
 One thing that you can do is to surround any cf only code that doesn't do
 output (cfset, etc) with the cfsilent/cfsilent tags.
 
 You can also check the Enable Whitespace Management option in the
 administrator.
 
 Lastly, I believe that there is another tag that you can use at the
 beginning of your .cfm file that will suppress whitespace, but I can't
 remember it at the moment.
 
 The cfsilent has worked best for me.
 
 Steve
 
 
 -Original Message-
 From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 07, 2003 10:17 AM
 To: CF-Talk
 Subject: supressing white spaces
 
 
 Ok...
 
 So I was wondering if there is a way to make the source of my pages look 
 neater in the view source window.  there are way too many spaces and 
 such.  This is not really a problem, but i am concerned with potential 
 clients looking at the source and not understanding why the code looks 
 so crappy.  So, is there a way to eleminate these spaces?  What am I 
 doing wrong?  ver MX 6.0  win2k  IIS
 
 Gabriel


-- 
Gabriel Robichaud
Programmer
Development  Alumni Relations Services
McGill University
(514)398-5653
[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



supressing white spaces

2003-08-14 Thread Gabriel Robichaud
Ok...

So I was wondering if there is a way to make the source of my pages look 
neater in the view source window.  there are way too many spaces and 
such.  This is not really a problem, but i am concerned with potential 
clients looking at the source and not understanding why the code looks 
so crappy.  So, is there a way to eleminate these spaces?  What am I 
doing wrong?  ver MX 6.0  win2k  IIS

Gabriel
-- 
Gabriel Robichaud
Programmer
Development  Alumni Relations Services
McGill University
(514)398-5653
[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

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



Re: Debugger for Oracle storeprocedures

2003-08-07 Thread Gabriel Robichaud
the best one is availabe by Quest Software as part of the TOAD utility.

other than than that, there isnt much out there to debug pl/sql.


good luck!

Gabriel


Ramesh Deva wrote:
 Hi,
 
 Anybody knows good debugger for Oracle Stored Procedures?
 
 Thanks
 ramesh
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



query output stops after 114 records

2003-07-31 Thread Gabriel Robichaud
Ok Folks, here is a good one.

I have a query  :
cfquery datasource=cab name=getlabels
select *
from labels order by label_code
/cfquery

this shows that my getlabels.recordcount  is 118

BUT when i do
cfoutput query=getLabels
cfset counter = counter + 1
trtd#counter#/td
   td#label_code#/td
   TD#lang_id#/TD
   td#label#/td
/tr
/cfoutput

it only displays 114 records.  And the content of #label# on the last 
record is
truncated!

i checked in the db, there is 118 records, and the there is nothing 
wrong with label 114.  it looks like the processing stops for some 
reason. becaue there is no more html code after this record in the page 
source and the fotter is not displayed, even though my footer is called 
by an include tag in the OnRequestEnd.cfm template.

Any ideas as to why this happens?

TIA!
Gabriel

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



query output stops after 114 records

2003-07-31 Thread Gabriel Robichaud
I tried all that, doesnt change anything

when i reverse the other, it stops at the 114 th record, even thouth its a different 
record.  I then implemented page navigatino.. ie display 25 records, then the next 25 
then the next 25... well

it trucates at the 24th record. 

SO, i decided, on hunch, to change the cffom to form  and my problem was 
solved!! argh

but now that leaves me with a new problem, i cant used CFFORM

Does anyone have any idea why this could happen?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



query output stops after 114 records

2003-07-31 Thread Gabriel Robichaud
hahah, i knew someone was going to say that!! LOL

 but now that leaves me with a new problem, i cant used CFFORM

Pesonally I wouldn't see that as a problem, more a blessing in
disguise...  ;)

Tim.


---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com for
more information about our company, or call us free
anytime on 0800 294 24 24.
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

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



Re: saved form fields

2003-07-24 Thread Gabriel Robichaud
you could just have them in hidden fields in a form, or in a form using 
value='#form.fieldname#' in each input tag,

less effective would be putting them in a cookie or put them in a database.



Robert Orlini wrote:
 How do I save a form field over multiple pages? 
 
 After submitting the form from one page a review order page displays the fields and 
 then the customer submits the order. Unfortunately the fields are gone. How can I 
 retain the fields for future page submissions? Do I use CFPARAM or CFSET?
 
 Any help for this newbie is appreciated in advance...thanks!
 
 Robert O.
 HWW
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



Re: saved form fields

2003-07-24 Thread Gabriel Robichaud
did you put them between the cfoutput/cfoutput tags?  what do you 
see int he source page of the browser when you test it?

Robert Orlini wrote:
 I've used the input tags different ways w/no success:
 
 input type=hidden name=Institution value='#form.institution#'
 input type=hidden name=Institution value=#form.institution#
 input type=hidden name=Institution value='#institution#'
 
 Am I doing something wrong?
 
 RO
 
 -Original Message-
 From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 24, 2003 10:02 AM
 To: CF-Talk
 Subject: Re: saved form fields
 
 
 you could just have them in hidden fields in a form, or in a form using 
 value='#form.fieldname#' in each input tag,
 
 less effective would be putting them in a cookie or put them in a database.
 
 
 
 Robert Orlini wrote:
 
How do I save a form field over multiple pages? 

After submitting the form from one page a review order page displays the fields and 
then the customer submits the order. Unfortunately the fields are gone. How can I 
retain the fields for future page submissions? Do I use CFPARAM or CFSET?

Any help for this newbie is appreciated in advance...thanks!

Robert O.
HWW


 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



cookie detection

2003-07-23 Thread Gabriel Robichaud
Is there a way to detect that a user has his cookies turned off??

Gabriel

-- 
Gabriel Robichaud
Programmer
Development  Alumni Relations Services
McGill University
(514)398-5653
[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



Re: cookie detection

2003-07-23 Thread Gabriel Robichaud
I guess i should have been more clear in my question... doing it in 2 
pages is what i wanted to avoid.  It would be nice if i could just test 
to see if the user has cookies enabled and then do treatment 
accordingly.  That would let me do something in Application.cfm... but I 
guess i'll handle it in my header file.

thank you philip for your answer.

Gabriel

Philip Arnold wrote:
I would think, just set it, then try to read it (if it doesnt
exist) it's disabled ;) hehe
 
 
 But you HAVE to do it over 2 pages
 
 If you try to set one and then check it on the same page, it hasn't had
 a chance to get to the browser, so it's always set...
 
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

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



Re: cookie detection

2003-07-23 Thread Gabriel Robichaud
yes, i aknowledged all of that in my previous post.

I thought maybe there was a shortcut.


thanks anyway


Tony Weeg wrote:
 that's the inherent problem with what you are trying to doyou are
 trying
 to validate something that is client side, using a server side
 technology :)
 
 what you could do, is put the cookie check on the previous page, a
 simple non-sense cookie
 that just tests...then, on the page you want to set your real
 cookie..you could say hey you don't have cookies turned on, get em on
 now!!!
 
 but that's still a two page setup
 
 tony weeg
 uncertified advanced cold fusion developer
 tony at navtrak dot net
 www.navtrak.net
 office 410.548.2337
 fax 410.860.2337
 
 
 -Original Message-
 From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, July 23, 2003 3:17 PM
 To: CF-Talk
 Subject: Re: cookie detection
 
 
 I guess i should have been more clear in my question... doing it in 2 
 pages is what i wanted to avoid.  It would be nice if i could just test 
 to see if the user has cookies enabled and then do treatment 
 accordingly.  That would let me do something in Application.cfm... but I
 
 guess i'll handle it in my header file.
 
 thank you philip for your answer.
 
 Gabriel
 
 Philip Arnold wrote:
 
I would think, just set it, then try to read it (if it doesnt
exist) it's disabled ;) hehe


But you HAVE to do it over 2 pages

If you try to set one and then check it on the same page, it hasn't 
had a chance to get to the browser, so it's always set...





 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



Re: cookie detection

2003-07-23 Thread Gabriel Robichaud
hey jon,

Thanks for the suggestion, i will more than likely use this idea!

Gabriel

jon hall wrote:
 Using CF alone as mentioned requires two pages, but you can do it with
 javascript in one. Depending on how your entrance page is set up, you
 could write out the hrefs with js or something similar so the cookie
 detection looks transparent to the user, and more importantly, to
 search engines.
 
 pseudocode...
 
 setCookie(someVal, cookiename);
 if(getCookie(cookiename))
//user has cookies
 else
//no cookies
 
 Good JS cookie library here which includes supportsCookies()...
 http://www.dithered.com/javascript/cookies/usage.html
 


-- 
Gabriel Robichaud
Programmer
Development  Alumni Relations Services
McGill University
(514)398-5653
[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



Re: cookie detection

2003-07-23 Thread Gabriel Robichaud
wow.. thanks!!

!
  * *
|___|

Gabriel

Bryan Stevenson wrote:
 OK..here goes...not makin any claims...but this works fine for the site it's
 on.
 
 The site has an index.cfm file which uses a varaiable (pg) to include the
 appropriate content (pretty simple template framework).
 
 CODE AT TOP OF INDEX.CFM FILE (not in Application.cfm):
 
 !--- test for existence of the test cookie to ensure cookies are
 enabled---
 cfif NOT IsDefined(Cookie.CookieTest) AND NOT
 IsDefined(URL.StopCookieTest)
   cfinclude template=cookie_test.cfm
   !--- the abort is only needed if the user is sent to the disabled cookie
 notification page ---
   cfif NOT Len(CGI.HTTP_Cookie) OR IsDefined(URL.StopCookieTest)
 cfabort
   /cfif
 /cfif
 
 CODE FOR COOKIE_TEST.CFM (pass yer own URL vars):
 
 !--- test for existence of the test cookie ---
 cfif NOT IsDefined(Cookie.CookieTest)
   !--- set test cookie ---
   cfcookie name=CookieTest value=1
   !--- redirect to second cookie test page to verify cookie was set ---
   cfoutput
 cfheader name=location
 value=cookie_test2.cfm?pg=#pg#lang=#lang#tid=#tid#
 cfheader statuscode=302 statustext=Moved temporarily
   /cfoutput
 /cfif
 
 CODE FOR COOKIE_TEST2.cfm (again use yer own URL vars):
 
 !--- Cookies are not enabled ---
 cfif NOT Len(CGI.HTTP_Cookie)
   cflocation
 url=index.cfm?pg=cookie_test_disabledlang=#lang#tid=#tid#StopCookieTest=
 1
 cfelse
   cflocation
 url=index.cfm?pg=#pg#lang=#lang#tid=#tid#StopCookieTest=1
 /cfif
 
 
 A few things to note:
 1) This must run BEFORE any other cookies are set or the
 Len(CGI.HTTP_Cookie) above will get fouled
 2) For us this runs so fast that you don't even see it happen
 3) You need to make your own cookie_test_disabled file outside of this test
 to tell the user what to do if cookies are disabled ;-)
 
 HTH
 
 Cheers
 
 Bryan Stevenson B.Comm.
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 t. 250.920.8830
 e. [EMAIL PROTECTED]
 
 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com
 - Original Message -
 From: Bryan Stevenson [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, July 23, 2003 1:28 PM
 Subject: Re: cookie detection
 
 
 
just remember it won't work if the user has disabled JS ;-)

I have code to do a 2 page method that the user will never see and it
 
 works
 
regardless of JS being onI'll try and dig it up.  It may only work
 
 with
 
the arhitecture of the site it's used on...not sure...but you can have it.

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message -
From: Gabriel Robichaud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 1:05 PM
Subject: Re: cookie detection



hey jon,

Thanks for the suggestion, i will more than likely use this idea!

Gabriel

jon hall wrote:

Using CF alone as mentioned requires two pages, but you can do it with
javascript in one. Depending on how your entrance page is set up, you
could write out the hrefs with js or something similar so the cookie
detection looks transparent to the user, and more importantly, to
search engines.

pseudocode...

setCookie(someVal, cookiename);
if(getCookie(cookiename))
   //user has cookies
else
   //no cookies

Good JS cookie library here which includes supportsCookies()...
http://www.dithered.com/javascript/cookies/usage.html



--
Gabriel Robichaud
Programmer
Development  Alumni Relations Services
McGill University
(514)398-5653
[EMAIL PROTECTED]



 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



Re: Internationalization Issue

2003-07-03 Thread Gabriel Robichaud
I had a similar issue on win2k and added the following to my 
Application.cfm file : cfcontent type = text/html; charset = 
ISO-8859-1 and it solved all my foreign euro-accents problems.

dont know if this will help you.
good luck
Gabriel



Richard Crawford wrote:
 To be honest, I have no idea where to even begin with this one -- whether 
 it's a Solaris issue, an Apache issue, a Cold Fusion issue, or a JRun issue.
 
 The problem is this: we have as part of our website a Spanish class, which 
 requires students to input their replies in a form by entering special 
 characters (e.g., y or a or ?) using the alt keys and their numeric 
 keypad.  [ALT}=[1][6][8] produces ? foe xample.  But when the form is sent 
 to the instructor, the special characters are presented as an = sign plus a 
 hexadecimal code.
 
 I suspect that this is going to turn out to be an Apache issue, but I'm not 
 sure; it was working fine when we were using WindowsNT with IIS and Cold 
 Fusion.
 
 Any suggestions or help or solutions(!) would be greatly appreciated.
 
 Thanks!
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



CFSCRIPT

2003-06-26 Thread Gabriel Robichaud
Hey folks.

questions regarding scripting.

I want to see YY as 0 not 0.25

and i want to use the modulus operator (or modulo, dont know what to 
call it in english) so i can get the remainder.  I dont know what the 
operator is for cfscript.  obvious answer is % but that doesnt work.

So how do i get my #resutl# to equal 0 (an integer and not a decimal)
and how do i get the remainder of a devision in #remainder#? (see code 
below for clarification)


**CODE HERE
cfscript

YY = DateFormat(NOW(), YY);

result = YY/12;

remainder = YY%12;

/cfscript

cfoutput
BrBR
The result is : font size=+4#result#/fontBR
The remainder is : font size=+4#remainder#/fontBR

/cfoutput
**NO MORE CODE**

Any thoughts?

Thanks
Gabriel

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

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



Re: CFSCRIPT

2003-06-26 Thread Gabriel Robichaud
perfect thanks!!

Nagy, Daniel J wrote:
 % = MOD 
 
 Int() will return a float as a whole number.
 
 -Original Message-
 From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
 Sent: Thursday, June 26, 2003 1:56 PM
 To: CF-Talk
 Subject: CFSCRIPT
 
 
 Hey folks.
 
 questions regarding scripting.
 
 I want to see YY as 0 not 0.25
 
 and i want to use the modulus operator (or modulo, dont know what to 
 call it in english) so i can get the remainder.  I dont know what the 
 operator is for cfscript.  obvious answer is % but that doesnt work.
 
 So how do i get my #resutl# to equal 0 (an integer and not a decimal)
 and how do i get the remainder of a devision in #remainder#? (see code 
 below for clarification)
 
 
 **CODE HERE
 cfscript
 
 YY = DateFormat(NOW(), YY);
 
 result = YY/12;
 
 remainder = YY%12;
 
 /cfscript
 
 cfoutput
 BrBR
 The result is : font size=+4#result#/fontBR
 The remainder is : font size=+4#remainder#/fontBR
 
 /cfoutput
 **NO MORE CODE**
 
 Any thoughts?
 
 Thanks
 Gabriel
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



Calendar App

2003-06-26 Thread Gabriel Robichaud
I developed a quick and simple calendar app.

its source is available here.

http://cfmtl.no-ip.info:8500/gabriel/date2.cfm

comments are welcome.
I did this today for heck of it. 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



Re: Macromedia needs your feedback

2003-06-25 Thread Gabriel Robichaud
Écoute toi là là!

Be very careful what you say about French people... we are everywhere.

Eric Creese wrote:
 That depends if you are French
 
 -Original Message-
 From: Thane Sherrington [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, June 25, 2003 2:55 PM
 To: CF-Talk
 Subject: Re: Macromedia needs your feedback
 
 
 At 03:01 PM 6/25/03 -0400, Christian Cantrell wrote:
 
 
* Sorry, as usual, US residents only.
 
 
 I filled out the survey anyway, but I think it's funny that Macromedia only 
 cares about the opinions of US developers.  What about those of us in 
 Canada?  What are we, chopped liver? :)
 
 T
 
 
 Tired of your bookmarks/favourites being limited to one computer?  Move 
 them to the Net!
 www.stuffbythane.com/webfavourites makes it easy to keep all your 
 favourites in one place and
 access them from any computer that's attached to the Internet. 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

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



Re: weird error

2003-06-19 Thread Gabriel Robichaud
Are you saying that we should never set coolie values to  in MX?

GAbriel

Dave Carabetta wrote:
Has anybody seen this error message?


Error Occurred While Processing Request



The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code. Null Pointers
are another name for undefined values.



There is this one user that is constantly getting this message.. but when
she logs on with another computer.. she is ok.  Working fine for everybody
else ( I hope ).

Using win2k  mx.
 
 
 Yep, just finished dealing with this useless error message. In my case, it 
 urns out it was a cookie issue where a value was set to an empty string. In 
 previous versions of CF, that was OK, but in MX it becomes NULL which CF 
 chokes on. Check your application for cookie usage and make sure that values 
 aren't being set to empty strings.
 
 Regards,
 Dave.
 
 _
 The new MSN 8: advanced junk mail protection and 2 months FREE*  
 http://join.msn.com/?page=features/junkmail
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



Re: weird error

2003-06-19 Thread Gabriel Robichaud
Great!! Thanks for the hint!

Gabriel

Dave Carabetta wrote:
Are you saying that we should never set coolie values to  in MX?

 
 
 I believe it's related to this TechNote, although you'll note that it was 
 last updated in November 2002.
 
 http://www.macromedia.com/support/coldfusion/ts/documents/tn17009.htm
 
 I think that in previous versions, you might get the Error Resolving 
 Parameter error they are describing, but in MX you get the error that 
 you're seeing.
 
 Again, my cookie theory is based on my own observations and headaches in 
 tracking down the problem. Your problem may be different.
 
 Regards,
 Dave.
 
 _
 Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
 http://join.msn.com/?page=features/junkmail
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



SSL, Cold Fusion part deux

2003-06-19 Thread Gabriel Robichaud
Ok.

So, i havea SSL certificates in place.
I am using IIS v 5 and have CF MX server.

Lets say i have a login feature that i want to do via SSL.  how the heck 
I do that? I mean I am sure i have to somehow integreat in my cf pages 
something from iis so that the ssl actually works right?  Is there a how 
to somewhere?  I am sure what i am doing has been done n number of times 
before, so someone must have a faq or help or one of those blogs i keep 
hearing about (whatever they are).

Any help or links would be great!!

Thanks
Gabriel Robichaud
Programmer
McGill University
[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



SSL, Cold Fusion part deux

2003-06-19 Thread Gabriel Robichaud
Ok...
I can view html files securely in that directory, but what about .cfm pages?

if i point my browser to .cfm it prompts me to download the .cfm file

any thoughts?
Gabriel

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



SSL, Cold Fusion part deux

2003-06-19 Thread Gabriel Robichaud
OH MY GOD THANK YOU MARK I HAVE SSL NOW :)

i found the connecter in the bin directory of cold fusion... did not know that.  wooo 
hooo i am one happy guy now :)
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

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



SSL, Cold Fusion

2003-06-18 Thread Gabriel Robichaud
Hey Gang...

I am still pertty new at this so bare with me please.

Ok... so lets say i have a web site that I need to secure with SSL. 
Where do I start? i know about getting SSL certificate, found that 
already, but what about this other stuff. Do I need another webserver 
along with the Cold Fusion server?   I think I do cause i cant create a 
CSR with cold fusion right?

How complicated is it to integrate all this? is there some documentation 
somehwere or a how to for people who have never done SSL before?  You 
know like SSL  Cold Fusion for dummies?

Any feedback would be great!
Gabriel


-- 
Gabriel Robichaud
Programmer
Development  Alumni Relations Services
McGill University
(514)398-5653
[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



Re: SSL, Cold Fusion

2003-06-18 Thread Gabriel Robichaud
We are running IIS 4 but that isnt set in stone if that is problematic. 
so as you can guess we are on a windows environment.  I actually found a 
site that gives free trial SSL cetificates? is that a good idea before 
we shell out cash for a real one?  I found it here 
http://www.instantssl.com/ssl-certificate-products/free-ssl-certificate.html

Gabriel



Jillian Carroll wrote:
 Gabriel,
 
 When adding SSL, it really has more to do with your web server than your
 ColdFusion server.
 
 If you can tell me a little more about your environment, I can probably help
 you out more easily.  Are you running IIS or Apache?  What version?  Are you
 on Windows or Linux?  
 
 As far as ColdFusion is concerned, it operates the same whether it's over
 SSL or not.
 
 --
 Jillian
 
 
-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] 
Sent: June 18, 2003 12:01 PM
To: CF-Talk
Subject: SSL, Cold Fusion


Hey Gang...

I am still pertty new at this so bare with me please.

Ok... so lets say i have a web site that I need to secure with SSL. 
Where do I start? i know about getting SSL certificate, found that 
already, but what about this other stuff. Do I need another webserver 
along with the Cold Fusion server?   I think I do cause i 
cant create a 
CSR with cold fusion right?

How complicated is it to integrate all this? is there some 
documentation 
somehwere or a how to for people who have never done SSL 
before?  You 
know like SSL  Cold Fusion for dummies?

Any feedback would be great!
Gabriel


-- 
Gabriel Robichaud
Programmer
Development  Alumni Relations Services
McGill University
(514)398-5653
[EMAIL PROTECTED]


 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



Re: SSL, Cold Fusion

2003-06-18 Thread Gabriel Robichaud
wow thats perfect!!

Thank you!!

Jillian Carroll wrote:
 Gabriel,
 
 There isn't any reason why you can't run IIS 4, so feel free to stick with
 it.
 
From my perspective... if you know you want a real SSL certificate, no point
 in wasting your time with a free trial certificate.  If you are concerned
 about setting it up correctly, however, you might find it is good practice
 and doesn't cost you anything.
 
 I found a few great tutorials on setting up the SSL certs on IIS:
 
 Microsoft:
 
 -
 http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
 80/support/kb/articles/Q218/4/45.ASPNoWebContent=1 (Windows NT specific)
 -
 http://www.microsoft.com/windows2000/en/server/iis/default.asp?url=/WINDOWS2
 000/en/server/iis/htm/core/iisslsc.htm (Windows 2000 specific)
 
 Non-Microsoft:
 
 -
 http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=209
 
 If you work through these and you are still having any problems, please let
 me know and I'll do my best to walk you through things myself.
 
 --
 Jillian
 
 
 
-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] 
Sent: June 18, 2003 12:37 PM
To: CF-Talk
Subject: Re: SSL, Cold Fusion


We are running IIS 4 but that isnt set in stone if that is 
problematic. 
so as you can guess we are on a windows environment.  I 
actually found a 
site that gives free trial SSL cetificates? is that a good 
idea before 
we shell out cash for a real one?  I found it here 
http://www.instantssl.com/ssl-certificate-products/free-ssl-ce
rtificate.html

Gabriel



Jillian Carroll wrote:

Gabriel,

When adding SSL, it really has more to do with your web server than 
your ColdFusion server.

If you can tell me a little more about your environment, I can 
probably help you out more easily.  Are you running IIS or Apache?  
What version?  Are you on Windows or Linux?

As far as ColdFusion is concerned, it operates the same 

whether it's 

over SSL or not.

--
Jillian



-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
Sent: June 18, 2003 12:01 PM
To: CF-Talk
Subject: SSL, Cold Fusion


Hey Gang...

I am still pertty new at this so bare with me please.

Ok... so lets say i have a web site that I need to secure with SSL.
Where do I start? i know about getting SSL certificate, found that 
already, but what about this other stuff. Do I need another 

webserver 

along with the Cold Fusion server?   I think I do cause i 
cant create a 
CSR with cold fusion right?

How complicated is it to integrate all this? is there some
documentation 
somehwere or a how to for people who have never done SSL 
before?  You 
know like SSL  Cold Fusion for dummies?

Any feedback would be great!
Gabriel


--
Gabriel Robichaud
Programmer
Development  Alumni Relations Services
McGill University
(514)398-5653
[EMAIL PROTECTED]




 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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



Re: OT~ but a good laugh:)

2003-06-13 Thread Gabriel Robichaud
My motto is, give them all the passwords and access they want because it 
will translate to one thing for me : BILLABLE HOUR$! ;)



Dana Tierney wrote:
 I have been there and am now exteeemely reluctant to enter into any 
 situation where a client has the password to the site and I am responsible 
 for maintaining it.
 
 Dana
 
 On Fri, 13 Jun 2003 11:31:39 -0700, Bryan Stevenson 
 [EMAIL PROTECTED] wrote:
 
 
Ah clients touching code.I had one open a bunch of CF files in
Studio with the design tabcan you say where'd my CF code go?? ;-)

Always nice to have your work obliteratedoh well I struck a deal with
him after thatany errors I found caused by him cost him $100
cashfunny...no more errors ;-)

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message -
From: Dan Phillips [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 11:15 AM
Subject: RE: OT~ but a good laugh:)



At my old job, part of my workload was teaching Office 97/2000 classes
to clients who were going to start using the software we designed for
them. One segment of the class was teaching FrontPage. That was
tourture. I change the corseload a bit and just showed them HTML and how
the generally use a WYSIWYG editor. At the end of the class, I handed
them CDs with trial versions of Dreamweaver 3.0 :-)

-Original Message-
From: Dana Tierney [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 2:08 PM
To: CF-Talk
Subject: Re: OT~ but a good laugh:)


I have had a few html encounters of the Word kind :) Clients trying to
help. Or something.

Dana

On Fri, 13 Jun 2003 14:04:26 -0400, Dan Phillips
[EMAIL PROTECTED]
wrote:


Hey know. I made my first netpage for the innerweb that way. :-)

I'm kidding!!!


-Original Message-
From: Dana Tierney [mailto:[EMAIL PROTECTED] Sent: Friday, June 13,
2003 1:56 PM
To: CF-Talk
Subject: Re: OT~ but a good laugh:)



Dreamweaver has commands to clean up HTML which would probably have
saved
you a lot of work. It even has a specific command to clean up Word-
generated HTML :)

Word generated HTML! (runs screaming)




--
Mr Jones and me
We're stumbling through the barrio




 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



  1   2   >