Re: cfc error
cfset var qLF = cfset dsn=it cfset un=that cfset pw=this cfquery name=qLF datasource=#dsn# username=#un# password=#pw# SELECT * FROM patterns ORDER BY parentID DESC /cfquery cfreturn qLF Heh, hi Taco btw. umm, be careful and remember that if you use cfset dsn= instead of cfset var dsn= then that DSN is now a global variable FOR That cfc... ie try the above and do a dump on the actual CFC afterwards :) just an FYI. On Apr 5, 2005 2:47 PM, Taco Fleur [EMAIL PROTECTED] wrote: cfcomponent !--- function getQLF Generated by the CFC Recordset ColdFusion MX Extension Mon Apr 04 22:08:12 GMT-0600 (Mountain Daylight Time) 2005 --- cffunction name=getQLF output=false access=private returntype=query cfset var qLF = cfset dsn=it cfset un=that cfset pw=this cfquery name=qLF datasource=#dsn# username=#un# password=#pw# SELECT * FROM patterns ORDER BY parentID DESC /cfquery cfreturn qLF /cffunction /cfcomponent -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 April 2005 2:47 PM To: CF-Talk Subject: Re: cfc error here it is cfcomponent !--- function getQLF Generated by the CFC Recordset ColdFusion MX Extension Mon Apr 04 22:08:12 GMT-0600 (Mountain Daylight Time) 2005 --- cffunction name=getQLF output=false access=private returntype=query cfset dsn=it cfset un=that cfset pw=this cfset var qLF = cfquery name=qLF datasource=#dsn# username=#un# password=#pw# SELECT * FROM patterns ORDER BY parentID DESC /cfquery cfreturn qLF /cffunction /cfcomponent From: Jon Austin [EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 12:43 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: cfc error Are all of your statements grouped under your ? //got nuthin On Apr 5, 2005 2:40 PM, dave wrote: anyone know what this error means? Local variable qLF on line 18 must be grouped at the top of the function body. ~| 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:201470 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfc error
it did work on 1 of the 4 and the only thing different i did was add space between, I will go try others again Thanks :) From: Scott Barnes [EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 2:37 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: cfc error SELECT * FROM patterns ORDER BY parentID DESC Heh, hi Taco btw. umm, be careful and remember that if you use instead of then that DSN is now a global variable FOR That cfc... ie try the above and do a dump on the actual CFC afterwards :) just an FYI. On Apr 5, 2005 2:47 PM, Taco Fleur wrote: function getQLF Generated by the CFC Recordset ColdFusion MX Extension Mon Apr 04 22:08:12 GMT-0600 (Mountain Daylight Time) 2005 --- returntype=query SELECT * FROM patterns ORDER BY parentID DESC -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 April 2005 2:47 PM To: CF-Talk Subject: Re: cfc error here it is function getQLF Generated by the CFC Recordset ColdFusion MX Extension Mon Apr 04 22:08:12 GMT-0600 (Mountain Daylight Time) 2005 --- returntype=query SELECT * FROM patterns ORDER BY parentID DESC From: Jon Austin Sent: Tuesday, April 05, 2005 12:43 AM To: CF-Talk Subject: Re: cfc error Are all of your statements grouped under your ? //got nuthin On Apr 5, 2005 2:40 PM, dave wrote: anyone know what this error means? Local variable qLF on line 18 must be grouped at the top of the function body. ~| 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:201471 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
Anyone creating and reading Excel or Word docs using XML?
Hi Just wondering if anyone on the list is using CF and XML to create and / or read Excel or Word docs. We have apps using Excel and Word server-side to create and read Excel files and create Word files. We know this is not recommened but the app is almost 3 years old and using Excel and Word server-side was the most appropriate option at the time. MS finally released the XML schema for Excel and Word last year (http://www.microsoft.com/office/xml/default.mspx) and we are now considering using XML (or POI) using CFMX on Linux If you have attempted (whether successfully or not) to create and read Excel or Word docs using XML (or POI) I'd appreciate it if you could share your experience here. Cheers Nathan ~| 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:201472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX7 clustering and load balance
Hi Thanks Adam for your help. I have another problem now. I have two instances cfusion2 + cfusion3 on one machine, when i test cluster it always point to cfusion2... I have loose IPaddress:JCP port in jrunserver.store file of IIS6 connector. I added IPaddress:JCP port reboot the machine, after rebooting jrunserver.store file have only one IPaddress:JCP port for cfusion2 instance. Any one have idea how to solve this probelm. Regards Sana I replied to your post on CF-DEV. Did you look into multicasting? -Adam On Apr 4, 2005 6:34 AM, Sana Ullah [EMAIL PROTECTED] wrote: ~| 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:201473 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
var groups
hey, just a thought while I am var ing about 20 variables for a large function: Anyone know if MM have looked at/dismissed the idea of multiple vars i.e. var filepath,filename,extension as String; var linesread,lineswritten,timeout as Int; ? ~| 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:201474 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: var groups
Kerry wrote: hey, just a thought while I am var ing about 20 variables for a large function: Anyone know if MM have looked at/dismissed the idea of multiple vars i.e. var filepath,filename,extension as String; var linesread,lineswritten,timeout as Int; no idea but it's cheap enough to do: var fileStuff=structNew(); var lineStuff=structNew(); fileStuff.filePath=d:\cheapThrills\; fileStuff.fileName=drunkAsaSkunk.doc; ~| 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:201475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: var groups
thats partly true, except that I like to have all my vars declared and initialised to a type at the top of the function. so this: var fileStuff=structNew(); var lineStuff=structNew(); fileStuff.filePath=; fileStuff.fileName=; fileStuff.extension=; linestuff.linesread = 0; linestuff.lineswritten = 0; linesruff.timeout = 0; doesnt reduce the amount of code required to declare and type all the vars. -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 12:48 To: CF-Talk Subject: Re: var groups Kerry wrote: hey, just a thought while I am var ing about 20 variables for a large function: Anyone know if MM have looked at/dismissed the idea of multiple vars i.e. var filepath,filename,extension as String; var linesread,lineswritten,timeout as Int; no idea but it's cheap enough to do: var fileStuff=structNew(); var lineStuff=structNew(); fileStuff.filePath=d:\cheapThrills\; fileStuff.fileName=drunkAsaSkunk.doc; ~| 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:201476 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: WebServices
bit of a stab in the dark here, but I notice a number of different
capitalisation in the mypalauth name.
Mypalauth
MyPalAuth
mypalauth
while CF is not case sensitive - java is.
just a thought..
On Apr 4, 2005 3:17 AM, David Brown [EMAIL PROTECTED] wrote:
Thanks for the reply Dave,
I changed the folder name from com to cfcs and made the folder directly
under the root of the virtual web I am accessing. I find though unless I
create a mapping to the cfcs folder it does not work. Why would I need a
mapping to a folder that is under the root of the vitural website? For
example:
http://intratest/com was reallying pointing to a virtual folder up one
level to I:\inetpub\wwwroot\com the cfm files were in
i:\inetpub\wwwroot\intratest\userprofiles
I have now changed it to i:\inetpub\wwwroot\intratest\cfcs\mypalauth.cfc
with no mapping in cf admin. But nothing works unless I add the mapping.
When I do I add the mapping I can explorer the cfc file and view the wsdl of
it. But I get the same error I sent before.
coldfusion.jsp.CompilationFailedException: Errors reported by Java compiler:
Found 1 semantic error compiling
I:/CFusionMX7/stubs/WS-497956411/cfcs/MyPalAuthLocator.java: 10. public
class MyPalAuthLocator extends org.apache.axis.client.Service implements
cfcs.MyPalAuth { --- *** Error: Type cfcs/MyPalAuth was not found. .
~|
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:201477
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: search engines
For more information, here's a slashdot article: http://slashdot.org/article.pl?sid=05/03/31/196220tid=217 On Apr 4, 2005 4:26 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Good to knowthanks for the heads up, Dave! Rick -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 5:15 PM To: CF-Talk Subject: RE: search engines Someone brought up serving up different content to a bot then to the viewers as being a viable solution but wordpress just found out the hard way thats not the way to go. Google officials declined to comment on why WordPress.org pages had dropped from the company's index, but its Webmaster policies bar techniques that display different content to its crawler than to site visitors. ~| 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:201478 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
Bugzilla
There is a new article on the Macromedia site titled How to Bulletproof Your Web Application. It mentioned an app built in perl named Bugzilla that is used for bug tracking. Has anyone used it or know of something similar that is written in CF? I want to get some thing like this in place so any other recommendations would be helpful as well. -- Phillip B. ~| 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:201479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: search engines
Oh, and one other where Google punished an internal (Adwords) unit for doing serving up different content to the bot vs user: http://www.eweek.com/article2/0,1759,1774677,00.asp?kc=EWRSS03119TX1K594 Marty On Apr 5, 2005 8:39 AM, Marty Johll [EMAIL PROTECTED] wrote: For more information, here's a slashdot article: http://slashdot.org/article.pl?sid=05/03/31/196220tid=217 On Apr 4, 2005 4:26 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Good to knowthanks for the heads up, Dave! Rick -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 5:15 PM To: CF-Talk Subject: RE: search engines Someone brought up serving up different content to a bot then to the viewers as being a viable solution but wordpress just found out the hard way thats not the way to go. Google officials declined to comment on why WordPress.org pages had dropped from the company's index, but its Webmaster policies bar techniques that display different content to its crawler than to site visitors. ~| 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:201480 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
Renaming a GIF - CFFILE
Anyone seen the following error/oddity.. All Files upload OK, and FileExists() confirms that CF can see them, but it always gives a tag validation error when trying to rename the GIF files. I have tried uploading GIF and JPG versions of the same file, and the JPG will rename, but the GIF won't. completely bonkers... This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| 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:201481 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bugzilla
Bugzilla has been around since I can remember - maybe even years !? ...it is Netscape/Mozilla's bug tracking tool - it is huge and complicated - way too much for the average joe. - and a bitch to get it working on Windows. Have a look at Ray Camdens Lighthouse bug tool or search out cfticket application online - sorry cannot remember the link. -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 14:42 To: CF-Talk Subject: Bugzilla There is a new article on the Macromedia site titled How to Bulletproof Your Web Application. It mentioned an app built in perl named Bugzilla that is used for bug tracking. Has anyone used it or know of something similar that is written in CF? I want to get some thing like this in place so any other recommendations would be helpful as well. -- Phillip B. ~| 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:201482 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: var groups
hey, just a thought while I am var ing about 20 variables
for a large
function:
Anyone know if MM have looked at/dismissed the idea of
multiple vars i.e.
var filepath,filename,extension as String;
var linesread,lineswritten,timeout as Int;
?
Seems to me like that would be against the grain of CFML being a
weakly typed or untyped language, since there isn't any int or
String data type... Though it wouldn't be difficult at all to
produce this sort of thing on your own...
function declare(list,type) {
var x = 0;
var v = structnew();
if (arraylen(arguments) gt
2 and isstruct(arguments[3])
{ v = arguments[3] }
list = listtoarray(list);
for (x = 1; x lte arraylen(list); x = x + 1) {
switch (type) {
case string: { v[list[x]] = ; break; }
case int: { v[list[x]] = 0; break; }
case struct { v[list[x]] = structnew(); break; }
}
}
return v;
}
function somethingElsxe() {
var local = declare(filepath,filename,extension,string);
declare(linesread,lineswritten,timeout,int);
}
Granted, it does require you to place the variables in a var'ed local
structure, though personally I don't see that as any disadvantage. I'm
in the habbit of putting function variables in a structure anyway,
that way I only have to var the structure, and if I need to see what's
in the structure at any given time I can just dump that structure,
which isn't readily available with individually var'ed variables.
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://macromedia.breezecentral.com/p49777853/
http://www.sys-con.com/author/?id=4806
http://www.fusiontap.com
~|
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:201483
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bugzilla
Don't know if this could help http://www.cfdev.com/codereview is cheap and you can create your own rules. David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Phill B [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 9:42 Para: CF-Talk Asunto: Bugzilla There is a new article on the Macromedia site titled How to Bulletproof Your Web Application. It mentioned an app built in perl named Bugzilla that is used for bug tracking. Has anyone used it or know of something similar that is written in CF? I want to get some thing like this in place so any other recommendations would be helpful as well. -- Phillip B. ~| 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:201484 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: var groups
I can just dump that structure
good point
var local = declare(filepath,filename,extension,string);
interesting idea
-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 05 April 2005 17:52
To: CF-Talk
Subject: Re: var groups
hey, just a thought while I am var ing about 20 variables
for a large
function:
Anyone know if MM have looked at/dismissed the idea of
multiple vars i.e.
var filepath,filename,extension as String;
var linesread,lineswritten,timeout as Int;
?
Seems to me like that would be against the grain of CFML being a
weakly typed or untyped language, since there isn't any int or
String data type... Though it wouldn't be difficult at all to
produce this sort of thing on your own...
function declare(list,type) {
var x = 0;
var v = structnew();
if (arraylen(arguments) gt
2 and isstruct(arguments[3])
{ v = arguments[3] }
list = listtoarray(list);
for (x = 1; x lte arraylen(list); x = x + 1) {
switch (type) {
case string: { v[list[x]] = ; break; }
case int: { v[list[x]] = 0; break; }
case struct { v[list[x]] = structnew(); break; }
}
}
return v;
}
function somethingElsxe() {
var local = declare(filepath,filename,extension,string);
declare(linesread,lineswritten,timeout,int);
}
Granted, it does require you to place the variables in a var'ed local
structure, though personally I don't see that as any disadvantage. I'm
in the habbit of putting function variables in a structure anyway,
that way I only have to var the structure, and if I need to see what's
in the structure at any given time I can just dump that structure,
which isn't readily available with individually var'ed variables.
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://macromedia.breezecentral.com/p49777853/
http://www.sys-con.com/author/?id=4806
http://www.fusiontap.com
~|
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:201485
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What are optimal GC/JVM settings?
I could have sworn that I read this on MM site. Maybe I read it wrong. I have to check. Maybe I was increasing everything that had to do with JVM settings to stop the out of memory errors when I went from CF 5 to MX Anyways, I dropped it back to 128 on 3 servers over night and it looks like I had no problems. Guess I will but them back to 128. Jacob -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 4:46 PM To: CF-Talk Subject: Re: What are optimal GC/JVM settings? On Apr 4, 2005 1:30 PM, Jacob [EMAIL PROTECTED] wrote: What I read was that if you increase the heap size, you must also increase the perm size. Where did you read that (because it isn't true)? BUT... I can reduce the perm size on a couple of servers. Maybe I do not need it this high. I will start at 256 and see what happens. I'd be surprised if you need it set higher than 128Mb which is the install default I believe. -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:201486 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bugzilla
There is a new article on the Macromedia site titled How to Bulletproof Your Web Application. It mentioned an app built in perl named Bugzilla that is used for bug tracking. Has anyone used it or know of something similar that is written in CF? I want to get some thing like this in place so any other recommendations would be helpful as well. I'm using Mantis http://www.mantisbt.org/ . -- mack / ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201487 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: search engines
Hi, Marty...thanks for the article reference... I can see how techniques using unrelated keywords/phrases would be discouraged and even banned, but I wonder what Google's, et al, response would be to using legitimate keywords/phrases with techniques like white text over a white image. The keywords/phrases I would use, if I were to even use a technique (which I haven't found necessary to get good results), would be the same ones I would use in the text of the regular pages. I am interested in using such a technique (colored text over a same-colored image) primarily on opening splash pages, where the emphasis is on graphic design and not content. On pages such as these, there may not even be any text that is readable by the bot. I wouldn't even want to use an alt tag because I wouldn't want it to pop up when the image had mouse point over it. I may have to contact Google and ask that question... Rick -Original Message- From: Marty Johll [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:39 AM To: CF-Talk Subject: Re: search engines For more information, here's a slashdot article: http://slashdot.org/article.pl?sid=05/03/31/196220tid=217 On Apr 4, 2005 4:26 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Good to knowthanks for the heads up, Dave! Rick -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 5:15 PM To: CF-Talk Subject: RE: search engines Someone brought up serving up different content to a bot then to the viewers as being a viable solution but wordpress just found out the hard way thats not the way to go. Google officials declined to comment on why WordPress.org pages had dropped from the company's index, but its Webmaster policies bar techniques that display different content to its crawler than to site visitors. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201488 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT:SQL prob
SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| 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:201489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
From: Dave Francis [mailto:[EMAIL PROTECTED] SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON (r.eventID = d.eventID) HTH, Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT:SQL prob
SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON d.eventID = r.eventID On Apr 5, 2005 3:17 PM, Dave Francis [EMAIL PROTECTED] wrote: SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| 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:201491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
(OT) RE: search engines
The article points out some legitimate uses of cloaking that Google allows, but which violate their own rules. I like the idea that was proposed in the article that Google modify their guidelines and allow some controversial techniques. I don't like the permission idea...that could slow things down to a crawl. But to say that a webmaster could use cloaking if the cloaked material were relevant to the site content or contained in the site content to increase rankings would be a good idea to me... Rick -Original Message- From: Marty Johll [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:45 AM To: CF-Talk Subject: Re: search engines Oh, and one other where Google punished an internal (Adwords) unit for doing serving up different content to the bot vs user: http://www.eweek.com/article2/0,1759,1774677,00.asp?kc=EWRSS03119TX1K594 Marty On Apr 5, 2005 8:39 AM, Marty Johll [EMAIL PROTECTED] wrote: For more information, here's a slashdot article: http://slashdot.org/article.pl?sid=05/03/31/196220tid=217 On Apr 4, 2005 4:26 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Good to knowthanks for the heads up, Dave! Rick -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 5:15 PM To: CF-Talk Subject: RE: search engines Someone brought up serving up different content to a bot then to the viewers as being a viable solution but wordpress just found out the hard way thats not the way to go. Google officials declined to comment on why WordPress.org pages had dropped from the company's index, but its Webmaster policies bar techniques that display different content to its crawler than to site visitors. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201492 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201493 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| 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:201494 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: Bugzilla
Another vote for Mantis. Its easy to install, easy to use and purdy powerful. The forthcoming v1.0 release will add a lot of the flexibility that most people need regarding custom fields and modifying the main issues lister. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| 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:201495 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
This is the OLD way to perform a join - it should be avoided. -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:48 To: CF-Talk Subject: RE: SQL prob Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201496 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: Bugzilla
Thanks every one! On Apr 5, 2005 10:41 AM, Damien McKenna [EMAIL PROTECTED] wrote: Another vote for Mantis. Its easy to install, easy to use and purdy powerful. The forthcoming v1.0 release will add a lot of the flexibility that most people need regarding custom fields and modifying the main issues lister. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| 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:201497 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generating BarCodes in CF
Thanks for the links, but as I mentioned in my email these are in the category of... There are some off-the-shelf cfapps that generate barcodes but not in that format They don't support the 2D (PDF417) format that I'm looking for. Thanks anyway, Ali -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 4:58 PM To: CF-Talk Subject: RE: Generating BarCodes in CF http://www.fusionzone.com/ http://www.infosoftglobal.com/PoS4TallyPro/index1.html -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: April 4, 2005 18:48 To: CF-Talk Subject: Generating BarCodes in CF I was wondering if anyone knows of any CF apps, or used CF to connect to 3rd party apps to generate barcodes. Specifically 2D barcodes. If you are familiar with barcodes, you will know what that means :-) There are some off-the-shelf cfapps that generate barcodes but not in that format. Also, if not, does anyone have experience in using CF to embed an image into a Word Document. Help with any or both of those issues would be greatly appreciated. Thanks, Ali ~| 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:201498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generating BarCodes in CF
Is that format available in a font? If so, you could install the font on the server and generate PDF docs with the bar code in that font. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:07 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Thanks for the links, but as I mentioned in my email these are in the category of... There are some off-the-shelf cfapps that generate barcodes but not in that format They don't support the 2D (PDF417) format that I'm looking for. Thanks anyway, Ali -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 4:58 PM To: CF-Talk Subject: RE: Generating BarCodes in CF http://www.fusionzone.com/ http://www.infosoftglobal.com/PoS4TallyPro/index1.html -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: April 4, 2005 18:48 To: CF-Talk Subject: Generating BarCodes in CF I was wondering if anyone knows of any CF apps, or used CF to connect to 3rd party apps to generate barcodes. Specifically 2D barcodes. If you are familiar with barcodes, you will know what that means :-) There are some off-the-shelf cfapps that generate barcodes but not in that format. Also, if not, does anyone have experience in using CF to embed an image into a Word Document. Help with any or both of those issues would be greatly appreciated. Thanks, Ali ~| 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:201499 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Matt Osbun Web Developer Health Systems, International -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:42 AM To: CF-Talk Subject: RE: SQL prob This is the OLD way to perform a join - it should be avoided. -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:48 To: CF-Talk Subject: RE: SQL prob Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| 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:201500 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
Why - because it is deprecated. -Original Message- From: Matt Osbun [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 16:18 To: CF-Talk Subject: RE: SQL prob Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Matt Osbun Web Developer Health Systems, International -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:42 AM To: CF-Talk Subject: RE: SQL prob This is the OLD way to perform a join - it should be avoided. -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:48 To: CF-Talk Subject: RE: SQL prob Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| 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:201501 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
I should add - deprecated in SQL Server... -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 16:17 To: CF-Talk Subject: RE: SQL prob Why - because it is deprecated. -Original Message- From: Matt Osbun [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 16:18 To: CF-Talk Subject: RE: SQL prob Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Matt Osbun Web Developer Health Systems, International -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:42 AM To: CF-Talk Subject: RE: SQL prob This is the OLD way to perform a join - it should be avoided. -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:48 To: CF-Talk Subject: RE: SQL prob Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| 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:201502 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: Bugzilla
steve delray's bugtracker: http://www.delraysteve.com/index.cfm?fuseaction=main.tools ray camden's lighthouse: http://www.camdenfamily.com/morpheus/downloads/bugtracker.zip both written in CF... haven't tried either, but just FYI /t -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 5:01 PM To: CF-Talk Subject: Re: Bugzilla Thanks every one! On Apr 5, 2005 10:41 AM, Damien McKenna [EMAIL PROTECTED] wrote: Another vote for Mantis. Its easy to install, easy to use and purdy powerful. The forthcoming v1.0 release will add a lot of the flexibility that most people need regarding custom fields and modifying the main issues lister. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| 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:201503 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
I should add - deprecated in SQL Server. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 16:17 To: CF-Talk Subject: RE: SQL prob Why - because it is deprecated. -Original Message- From: Matt Osbun [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 16:18 To: CF-Talk Subject: RE: SQL prob Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Matt Osbun Web Developer Health Systems, International -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:42 AM To: CF-Talk Subject: RE: SQL prob This is the OLD way to perform a join - it should be avoided. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201504 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
application scope and CFMX(JRun) clusters
Ok, we have some apps that store CFC instances in the application scope. We just set up a CFMX cluster in our production environment. For those of you also doing this, how do you update your application scopes? For example, an instance of foo.cfc is stored in application.foo. If I update the code for foo.cfc, how do I get a new instance in all my CFMX instances easily? thoughts? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ~| 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:201505 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL prob
Hey Matt, From a semantic (easier / easier to read standpoint), using the (currently) standard JOIN sytax seperates your query nicely. When you use it, the FROM clause becomes where all your relations are defined, and the WHERE clause simply becomes filtering on everything you've JOINed together. -Joe On Apr 5, 2005 11:18 AM, Matt Osbun [EMAIL PROTECTED] wrote: Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Matt Osbun Web Developer Health Systems, International -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:42 AM To: CF-Talk Subject: RE: SQL prob This is the OLD way to perform a join - it should be avoided. -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:48 To: CF-Talk Subject: RE: SQL prob Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201506 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
I'm still using it cause a Microsoft Certified SQL professional show me the tracing and performance of LEFT/RIGHT/OUTHER/INNER JOIN and *=/=/=*/*=* and the last one is better and faster. David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Matt Osbun [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 11:18 Para: CF-Talk Asunto: RE: SQL prob Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Matt Osbun Web Developer Health Systems, International -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:42 AM To: CF-Talk Subject: RE: SQL prob This is the OLD way to perform a join - it should be avoided. -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:48 To: CF-Talk Subject: RE: SQL prob Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| 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:201507 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
From: David Manriquez [mailto:[EMAIL PROTECTED] I'm still using it cause a Microsoft Certified SQL professional show me the tracing and performance of LEFT/RIGHT/OUTHER/INNER JOIN and *=/=/=*/*=* and the last one is better and faster. A lot more goes into it than that... Indexes, keys, etc all play a role in how efficient your joins are... ~| 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:201508 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL prob
Indeed. Plus I was always under the impression that all other things being equal, explicity stating your joins would be faster. Seems to make sense logically too. From: David Manriquez [mailto:[EMAIL PROTECTED] I'm still using it cause a Microsoft Certified SQL professional show me the tracing and performance of LEFT/RIGHT/OUTHER/INNER JOIN and *=/=/=*/*=* and the last one is better and faster. A lot more goes into it than that... Indexes, keys, etc all play a role in how efficient your joins are... ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201509 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? One advantage of explicit JOIN syntax is that it eliminates the possibility of an accidental Cartesian product or cross join. If you have a query with three or four tables joined within the WHERE clause, you might forget one of your joins and the query will run successfully, but will fetch a Cartesian product (which you typically don't want, and which will typically annoy your DBA). If you use explicit JOIN syntax, you will get an error message if you forget a join, which is a much better result. Personally, I prefer explicit JOIN syntax because I find it a bit easier to read, although admittedly I used to find the old syntax easy to read as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:201510 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generating BarCodes in CF
John, Yes, it is available in a font. The font is called PDF417, I believe. This sounds like the direction I may want to go in. Can you elaborate on how I could do that? We have ActivePDF installed on our server, could I do it using that? However, we can't just take plain text and apply the font to it. The plain text gets encoded into a series of binary words I believe. (I think it's the right terminology a binary string of 16 bits). Some guy came up with a formula that does the encoding. The formula itself is open source, and there's a SourceForge project out there, that claims to convert a text string to the 2D barcode. I downloaded it and ran their sample app, and all it does is convert the text into WingDings. That was one dead-end. Next, I found the website of some French dude that posted the entire formula for creating 2D barcodes. But since I'm not a PhD in Discrete Math, nor in Computer Science, it was way above my understanding/abilities/comprehension. Otherwise, I believe we may be able to use Coldfusion to generate the barcode if we can decipher the formula. Here's the guy's website: http://grandzebu.net/informatique/codbar-en/pdf417.htm He too claims to have a tool to encode plain text into a barcode. I downloaded it and ran it and all it did was convert my text into WingDings. So I don't know how much we can trust the formula he posts. However it looks confusing enough to be trusted :S Thanks, Ali -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 8:09 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Is that format available in a font? If so, you could install the font on the server and generate PDF docs with the bar code in that font. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:07 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Thanks for the links, but as I mentioned in my email these are in the category of... There are some off-the-shelf cfapps that generate barcodes but not in that format They don't support the 2D (PDF417) format that I'm looking for. Thanks anyway, Ali -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 4:58 PM To: CF-Talk Subject: RE: Generating BarCodes in CF http://www.fusionzone.com/ http://www.infosoftglobal.com/PoS4TallyPro/index1.html -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: April 4, 2005 18:48 To: CF-Talk Subject: Generating BarCodes in CF I was wondering if anyone knows of any CF apps, or used CF to connect to 3rd party apps to generate barcodes. Specifically 2D barcodes. If you are familiar with barcodes, you will know what that means :-) There are some off-the-shelf cfapps that generate barcodes but not in that format. Also, if not, does anyone have experience in using CF to embed an image into a Word Document. Help with any or both of those issues would be greatly appreciated. Thanks, Ali ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL prob
I don't think one test can be seen as proof of either way being better or faster - there's a lot more that goes into DB performance than JOIN vs. =. Indexes, constraints, what mood your OS is in, etc. True story: a company I worked for had to fire a Microsoft Certified Professional (actually, an MCSE) after watching him try to install a 3Com NIC into a Windows 2k box for two days. Not to say there aren't good ones, but I've a shifty amount of trust ever since. -Joe ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201513 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL prob
I don't think one test can be seen as proof of either way being better or faster - there's a lot more that goes into DB performance than JOIN vs. =. Indexes, constraints, what mood your OS is in, etc. True story: a company I worked for had to fire a Microsoft Certified Professional (actually, an MCSE) after watching him try to install a 3Com NIC into a Windows 2k box for two days. Not to say there aren't good ones, but I've a shifty amount of trust ever since. -Joe On Apr 5, 2005 11:28 AM, David Manriquez [EMAIL PROTECTED] wrote: I'm still using it cause a Microsoft Certified SQL professional show me the tracing and performance of LEFT/RIGHT/OUTHER/INNER JOIN and *=/=/=*/*=* and the last one is better and faster. David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Matt Osbun [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 11:18 Para: CF-Talk Asunto: RE: SQL prob Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Matt Osbun Web Developer Health Systems, International -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:42 AM To: CF-Talk Subject: RE: SQL prob This is the OLD way to perform a join - it should be avoided. -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:48 To: CF-Talk Subject: RE: SQL prob Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| 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:201511 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: Generating BarCodes in CF
John, Yes, it is available in a font. The font is called PDF417, I believe. This sounds like the direction I may want to go in. Can you elaborate on how I could do that? We have ActivePDF installed on our server, could I do it using that? However, we can't just take plain text and apply the font to it. The plain text gets encoded into a series of binary words I believe. (I think it's the right terminology a binary string of 16 bits). Some guy came up with a formula that does the encoding. The formula itself is open source, and there's a SourceForge project out there, that claims to convert a text string to the 2D barcode. I downloaded it and ran their sample app, and all it does is convert the text into WingDings. That was one dead-end. Next, I found the website of some French dude that posted the entire formula for creating 2D barcodes. But since I'm not a PhD in Discrete Math, nor in Computer Science, it was way above my understanding/abilities/comprehension. Otherwise, I believe we may be able to use Coldfusion to generate the barcode if we can decipher the formula. Here's the guy's website: http://grandzebu.net/informatique/codbar-en/pdf417.htm http://grandzebu.net/informatique/codbar-en/pdf417.htm He too claims to have a tool to encode plain text into a barcode. I downloaded it and ran it and all it did was convert my text into WingDings. So I don't know how much we can trust the formula he posts. However it looks confusing enough to be trusted :S Thanks, Ali -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, April 05, 2005 8:09 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Is that format available in a font? If so, you could install the font on the server and generate PDF docs with the bar code in that font. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201514 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL prob
Also, instead of running the queries (not a very valid test unless you do each way many times under similar conditions), try looking at estimated execution plans, etc. You'll probably notice that in a lot of cases the optimizer (in SQL server, at least) will create the same execution plan for either way. -Joe -- Get Glued! The Model-Glue ColdFusion Framework http://www.model-glue.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201515 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: Create Excel file??
I have used POI with great success - http://jakarta.apache.org/poi/ - to read and write excel files. I've also used http://jexcelapi.sourceforge.net/ on a couple of cf projects and it worked well too. Both are pure java and allow you to create binary versions xls files Cheers On Apr 4, 2005 7:57 PM, Nathan Drury [EMAIL PROTECTED] wrote: G'day Scott We are looking to use XML to generate Excel and Word files using CF. Your example is great - thanks! Do you know of any other resources that would assist us with doing this sort of thing? Have you run into any limitations or problems? We have an app that uses COM generate Excel and Word files using CF. As you probably know, it's not particularly stable! So we're looking at alternatives. Cheers Nathan -- ~Blog~ http://www.robrohan.com ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~| 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:201516 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
Once again, someone pops in with this reason for doing something. It troubles me that this manner of thinking is so prevalent, as it most certainly means it's come about from actual experiences dealing with people. I don't feel that this sort of because-you-might-not-be-smart-enough type of argument is a good reason to do anything one way or another. I'm not taking a shot at you here Dave, far from it, but it seems that every time someone asks why shouldn't I do x this way, someone points out that a good reason has to do with the fact that people won't be able to do it right or won't be able to understand... Are people getting LESS capable out there or are we just accepting their (I should say our to include myself or just drop the possessive altogether) inadequacies more willingly or what? On the other hand, I suppose we could be ascribing inadequacies to people unfairly, though I rather doubt it. My argument on these type of things is always along the lines of do it the way it works and performs best and if someone else isn't smart/good/experienced enough to 'get it' then they should learn more. Does this bother anyone else, or is it just me? It could easily be just me; I've had it up to here with people in general this morning. If it is, maybe I should just hit the power button and take the rest of the day. --Ferg -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:18 AM To: CF-Talk Subject: RE: SQL prob One advantage of explicit JOIN syntax is that it eliminates the possibility of an accidental Cartesian product or cross join. If you have a query with three or four tables joined within the WHERE clause, you might forget one of your joins and the query will run successfully, but will fetch a Cartesian product (which you typically don't want, and which will typically annoy your DBA). If you use explicit JOIN syntax, you will get an error message if you forget a join, which is a much better result. Personally, I prefer explicit JOIN syntax because I find it a bit easier to read, although admittedly I used to find the old syntax easy to read as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201517 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
From: Ken Ferguson [mailto:[EMAIL PROTECTED] Does this bother anyone else, or is it just me? It could easily be just me; I've had it up to here with people in general this morning. If it is, maybe I should just hit the power button and take the rest of the day. Click that button... ~| 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:201518 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 app as EAR/WAR file
Hey All, I've been asked to give a CF talk to a group of mainly Java folks. My Java skills are fairly new (mostly using Java packages like iText via CFCs). One thing this crowd will be VERY interested in is deploying a CF app on J2EE servers (so enhancing productivity through rapid dev in CF and deploying as Java). I want to clarify exactly what the EAR/WAR file deployment option does in CF. AFAIK -compiles an entire CF app as and EAR/WAR file -EAR/WAR file can be deployed on a J2EE server without installing CF What I'm unclear on: 1) When you choose the EAR/WAR file option during CF install... -Is that to package up an exisiting app? or create a CF instance that you can create your app in and then package up? 2) How is the EAR/WAR file deployed on the J2EE server (remember I'm a Java newb) Answers to the above and anything else you think Java folks might like about the CF/Java combo would be greatly appreciated ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
Once again, someone pops in with this reason for doing something. It troubles me that this manner of thinking is so prevalent, as it most certainly means it's come about from actual experiences dealing with people. I don't feel that this sort of because-you-might-not-be-smart-enough type of argument is a good reason to do anything one way or another. I'm not taking a shot at you here Dave, far from it, but it seems that every time someone asks why shouldn't I do x this way, someone points out that a good reason has to do with the fact that people won't be able to do it right or won't be able to understand... Are people getting LESS capable out there or are we just accepting their (I should say our to include myself or just drop the possessive altogether) inadequacies more willingly or what? On the other hand, I suppose we could be ascribing inadequacies to people unfairly, though I rather doubt it. My argument on these type of things is always along the lines of do it the way it works and performs best and if someone else isn't smart/good/experienced enough to 'get it' then they should learn more. Does this bother anyone else, or is it just me? It could easily be just me; I've had it up to here with people in general this morning. If it is, maybe I should just hit the power button and take the rest of the day. I don't think this reason has anything to do with not being smart enough. No matter how good a programmer you are, everyone makes mistakes, and one of the traits of a good programmer is to be able to identify and recover from those mistakes as quickly as possible - we call this debugging! Now, with this specific example, the advantage that I pointed out is that if you make the specific mistake of overlooking a join, you'll get an error instead of a Cartesian product, and thus you (and your database server and your DBA) will be able to clearly identify the problem and fix it more quickly. After all, if you're working with enough tables, you might not even immediately identify that you have a problem if you fetch a Cartesian product. If there were any clear performance implications of choosing one syntax over the other, that would be a viable argument for choosing that syntax, but in my experience it simply doesn't affect performance beyond a negligible amount. Even if the old syntax did generally perform better than the new syntax, you might be better off choosing the new syntax if it results in clearer and more maintainable code. If you were to take your argument to its logical conclusion, we should clearly all be using C++ at a minimum, or perhaps even assembler, since those will generally perform better than using a high-level, loosely-typed scripting language that is compiled into bytecode that is then run within a virtual machine that runs within a real machine. But we don't, since hardware costs less than skilled programmers' time. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:201521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
Can't say I really took it as a You-Might-Not-Be-Smart-Enough sort of thing. And even if it was, it really wouldn't bother me much. For one, generally speaking, I'm pretty careful about my table joins. For two, specifically speaking, I can point to a couple instances where I've annoyed the heck out of a DBA by forgetting to join a couple of million+ record tables before running the query. Point is, mistakes happen and if a particular method can help prevent them, that's worth keeping in mind. Should it be the only concern? Certainly not, but other factors being more or less equal, I'm all for something that will keep a minor mistake into becoming a larger problem. Anyway, thanks for the responses, all. Matt -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:33 AM To: CF-Talk Subject: RE: SQL prob Once again, someone pops in with this reason for doing something. It troubles me that this manner of thinking is so prevalent, as it most certainly means it's come about from actual experiences dealing with people. I don't feel that this sort of because-you-might-not-be-smart-enough type of argument is a good reason to do anything one way or another. I'm not taking a shot at you here Dave, far from it, but it seems that every time someone asks why shouldn't I do x this way, someone points out that a good reason has to do with the fact that people won't be able to do it right or won't be able to understand... Are people getting LESS capable out there or are we just accepting their (I should say our to include myself or just drop the possessive altogether) inadequacies more willingly or what? On the other hand, I suppose we could be ascribing inadequacies to people unfairly, though I rather doubt it. My argument on these type of things is always along the lines of do it the way it works and performs best and if someone else isn't smart/good/experienced enough to 'get it' then they should learn more. Does this bother anyone else, or is it just me? It could easily be just me; I've had it up to here with people in general this morning. If it is, maybe I should just hit the power button and take the rest of the day. --Ferg -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:18 AM To: CF-Talk Subject: RE: SQL prob One advantage of explicit JOIN syntax is that it eliminates the possibility of an accidental Cartesian product or cross join. If you have a query with three or four tables joined within the WHERE clause, you might forget one of your joins and the query will run successfully, but will fetch a Cartesian product (which you typically don't want, and which will typically annoy your DBA). If you use explicit JOIN syntax, you will get an error message if you forget a join, which is a much better result. Personally, I prefer explicit JOIN syntax because I find it a bit easier to read, although admittedly I used to find the old syntax easy to read as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:201521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
For two, specifically speaking, I can point to a couple instances where I've annoyed the heck out of a DBA by forgetting to join a couple of million+ record tables before running the query. I can think of a million ways a dba's annoyed me :) sorry, I'll get back to work -- dc ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201523 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generating BarCodes in CF
If you can install the font on your PC and open word and write some text in that font to get the result you want, then you can do it on the server. Perhaps the reason you were seeing wingdings when you viewed their formula output is because you don't have the required fonts installed? If there is indeed a font that you can type and the font outputs the barcode (like in Word) then you can just use CF to call ActivePDF and send over the characters necessary to create the output and tell ActivePDf to use that font (which must be installed on the server to work correctly). John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 12:08 PM To: CF-Talk Subject: RE: Generating BarCodes in CF John, Yes, it is available in a font. The font is called PDF417, I believe. This sounds like the direction I may want to go in. Can you elaborate on how I could do that? We have ActivePDF installed on our server, could I do it using that? However, we can't just take plain text and apply the font to it. The plain text gets encoded into a series of binary words I believe. (I think it's the right terminology a binary string of 16 bits). Some guy came up with a formula that does the encoding. The formula itself is open source, and there's a SourceForge project out there, that claims to convert a text string to the 2D barcode. I downloaded it and ran their sample app, and all it does is convert the text into WingDings. That was one dead-end. Next, I found the website of some French dude that posted the entire formula for creating 2D barcodes. But since I'm not a PhD in Discrete Math, nor in Computer Science, it was way above my understanding/abilities/comprehension. Otherwise, I believe we may be able to use Coldfusion to generate the barcode if we can decipher the formula. Here's the guy's website: http://grandzebu.net/informatique/codbar-en/pdf417.htm He too claims to have a tool to encode plain text into a barcode. I downloaded it and ran it and all it did was convert my text into WingDings. So I don't know how much we can trust the formula he posts. However it looks confusing enough to be trusted :S Thanks, Ali -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 8:09 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Is that format available in a font? If so, you could install the font on the server and generate PDF docs with the bar code in that font. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:07 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Thanks for the links, but as I mentioned in my email these are in the category of... There are some off-the-shelf cfapps that generate barcodes but not in that format They don't support the 2D (PDF417) format that I'm looking for. Thanks anyway, Ali -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 4:58 PM To: CF-Talk Subject: RE: Generating BarCodes in CF http://www.fusionzone.com/ http://www.infosoftglobal.com/PoS4TallyPro/index1.html -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: April 4, 2005 18:48 To: CF-Talk Subject: Generating BarCodes in CF I was wondering if anyone knows of any CF apps, or used CF to connect to 3rd party apps to generate barcodes. Specifically 2D barcodes. If you are familiar with barcodes, you will know what that means :-) There are some off-the-shelf cfapps that generate barcodes but not in that format. Also, if not, does anyone have experience in using CF to embed an image into a Word Document. Help with any or both of those issues would be greatly appreciated. Thanks, Ali ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201523 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL prob
I don't feel that this sort of because-you-might-not-be-smart-enough type of argument is a good reason to do anything one way or another. I don't think that Dave was saying people shouldn't use *= because they might not be smart enough. I think that good developers like Dave recognize error-prone code and avoid it because they accept that they aren't perfect and look for less error-prone alternatives (especially when the less-error-prone alternative is a standard). My argument on these type of things is always along the lines of do it the way it works and performs best and if someone else isn't smart/good/experienced enough to 'get it' then they should learn more. A purely spaghetti-code app may work (functionallty) and perform better than an OO-alternative, but the OO approach seems to have caught on nicely. There are tradeoffs to be made. -Joe -- Get Glued! The Model-Glue ColdFusion Framework http://www.model-glue.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201524 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: Generating BarCodes in CF
If you can install the font on your PC and open word and write some text in that font to get the result you want, then you can do it on the server. Perhaps the reason you were seeing wingdings when you viewed their formula output is because you don't have the required fonts installed? If there is indeed a font that you can type and the font outputs the barcode (like in Word) then you can just use CF to call ActivePDF and send over the characters necessary to create the output and tell ActivePDf to use that font (which must be installed on the server to work correctly). John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 12:08 PM To: CF-Talk Subject: RE: Generating BarCodes in CF John, Yes, it is available in a font. The font is called PDF417, I believe. This sounds like the direction I may want to go in. Can you elaborate on how I could do that? We have ActivePDF installed on our server, could I do it using that? However, we can't just take plain text and apply the font to it. The plain text gets encoded into a series of binary words I believe. (I think it's the right terminology a binary string of 16 bits). Some guy came up with a formula that does the encoding. The formula itself is open source, and there's a SourceForge project out there, that claims to convert a text string to the 2D barcode. I downloaded it and ran their sample app, and all it does is convert the text into WingDings. That was one dead-end. Next, I found the website of some French dude that posted the entire formula for creating 2D barcodes. But since I'm not a PhD in Discrete Math, nor in Computer Science, it was way above my understanding/abilities/comprehension. Otherwise, I believe we may be able to use Coldfusion to generate the barcode if we can decipher the formula. Here's the guy's website: http://grandzebu.net/informatique/codbar-en/pdf417.htm He too claims to have a tool to encode plain text into a barcode. I downloaded it and ran it and all it did was convert my text into WingDings. So I don't know how much we can trust the formula he posts. However it looks confusing enough to be trusted :S Thanks, Ali ~| 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:201525 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF app as EAR/WAR file
What I'm unclear on: 1) When you choose the EAR/WAR file option during CF install... -Is that to package up an exisiting app? or create a CF instance that you can create your app in and then package up? It's to package an existing application. 2) How is the EAR/WAR file deployed on the J2EE server (remember I'm a Java newb) This will depend on the application server in question. If you're using JRun, it's a simple matter of deploying the EAR file like you'd deploy any other EAR file. I have less experience with other J2EE app servers, but each has its own mechanisms for deploying these files. However, there are some caveats - if you're using Verity within your application, that will have to be set up outside of the EAR/WAR deployment, I think, and there are other similar issues, such as not being able to deploy ODBC datasources. Answers to the above and anything else you think Java folks might like about the CF/Java combo would be greatly appreciated ;-) If you have existing Java web applications, CF integrates very nicely with those, to the extent that you could have JSP, servlets, and CF pages all within the same application. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:201526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: application scope and CFMX(JRun) clusters
I don't think there is any way except to write a script (or use something like Apache ANT) that you can run that will automatically refresh the application-scoped CFCs after you update the code. On Apr 5, 2005 11:29 AM, Douglas Knudsen [EMAIL PROTECTED] wrote: Ok, we have some apps that store CFC instances in the application scope. We just set up a CFMX cluster in our production environment. For those of you also doing this, how do you update your application scopes? For example, an instance of foo.cfc is stored in application.foo. If I update the code for foo.cfc, how do I get a new instance in all my CFMX instances easily? thoughts? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ~| 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:201527 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generating BarCodes in CF
Sorry to join in late. I use CF_BarCode: Company : fusionZONE, Inc. Application : barcodeZONE Version : 1.0 Build Date: 03/18/2004 Developer : Kevin Maloy Copyright (c) 2004 fusionZONE, Inc. All Rights Reserved http://www.fusionzone.com DO NOT REMOVE THIS NOTICE Works like a charm. Andy -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:31 AM To: CF-Talk Subject: RE: Generating BarCodes in CF John, Yes, it is available in a font. The font is called PDF417, I believe. This sounds like the direction I may want to go in. Can you elaborate on how I could do that? ~| 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:201528 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: CF app as EAR/WAR file
If I could ride the coat tails of this question... what license do you need when you ear/war up a cf project to sell (someone just asked me).. On Apr 5, 2005 9:42 AM, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, I've been asked to give a CF talk to a group of mainly Java folks. My Java skills are fairly new (mostly using Java packages like iText via CFCs). One thing this crowd will be VERY interested in is deploying a CF app on J2EE servers (so enhancing productivity through rapid dev in CF and deploying as Java). I want to clarify exactly what the EAR/WAR file deployment option does in CF. AFAIK -compiles an entire CF app as and EAR/WAR file -EAR/WAR file can be deployed on a J2EE server without installing CF What I'm unclear on: 1) When you choose the EAR/WAR file option during CF install... -Is that to package up an exisiting app? or create a CF instance that you can create your app in and then package up? 2) How is the EAR/WAR file deployed on the J2EE server (remember I'm a Java newb) Answers to the above and anything else you think Java folks might like about the CF/Java combo would be greatly appreciated ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| 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:201529 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: Generating BarCodes in CF
John, I do indeed have the font(s) installed in Word. And yes, I can type certain characters and it will display in somewhat of a barcode font. However, I do know, from however much research I have done this far, is that a series of binary strings are necessary to display the barcode correctly. I know this because I download the evaluation versions of some of the software that does the 2D barcode conversion. Those are all blackbox implementations though. I need something that I can invoke via CF via a webapp, and then embed in my documents. You cannot just type Hello world in word and apply the font and get the correct barcode. You will get something in the barcode font, but not the desired result. Hello world has to go through a conversion into a binary string based on a specific formula. That string has to be entered into word or ActivePDF or Adobe Acrobat or Notepad, and then the font can be applied to it to get the proper bar code. The reason I know this is because there are websites out there which do an on-the-fly conversion to the 2-D barcode and show you what the result is supposed to look like. Cheers, Ali -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 10:04 AM To: CF-Talk Subject: RE: Generating BarCodes in CF If you can install the font on your PC and open word and write some text in that font to get the result you want, then you can do it on the server. Perhaps the reason you were seeing wingdings when you viewed their formula output is because you don't have the required fonts installed? If there is indeed a font that you can type and the font outputs the barcode (like in Word) then you can just use CF to call ActivePDF and send over the characters necessary to create the output and tell ActivePDf to use that font (which must be installed on the server to work correctly). John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 12:08 PM To: CF-Talk Subject: RE: Generating BarCodes in CF John, Yes, it is available in a font. The font is called PDF417, I believe. This sounds like the direction I may want to go in. Can you elaborate on how I could do that? We have ActivePDF installed on our server, could I do it using that? However, we can't just take plain text and apply the font to it. The plain text gets encoded into a series of binary words I believe. (I think it's the right terminology a binary string of 16 bits). Some guy came up with a formula that does the encoding. The formula itself is open source, and there's a SourceForge project out there, that claims to convert a text string to the 2D barcode. I downloaded it and ran their sample app, and all it does is convert the text into WingDings. That was one dead-end. Next, I found the website of some French dude that posted the entire formula for creating 2D barcodes. But since I'm not a PhD in Discrete Math, nor in Computer Science, it was way above my understanding/abilities/comprehension. Otherwise, I believe we may be able to use Coldfusion to generate the barcode if we can decipher the formula. Here's the guy's website: http://grandzebu.net/informatique/codbar-en/pdf417.htm He too claims to have a tool to encode plain text into a barcode. I downloaded it and ran it and all it did was convert my text into WingDings. So I don't know how much we can trust the formula he posts. However it looks confusing enough to be trusted :S Thanks, Ali ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF app as EAR/WAR file
If I could ride the coat tails of this question... what license do you need when you ear/war up a cf project to sell (someone just asked me).. You will need a CFMX Enterprise license to deploy an EAR/WAR. You can enter the license number when creating the EAR/WAR, or after deploying it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201531 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
Help with NAT and DSN setups in CF Admin
Greetings. Our IIS 6/CF server is on a 10 dot network, and mapped to an external IP via our firewall appliance. When trying to set up a DSN to our MS SQL Server, I keep getting a connection refused error message. I am using the server name (UNC name) and the correct username/password. The SQL server is across the 'net on another network. The CF/Web server's public IP has open access through the firewall into the network where the SQL server is kept. What's strange, is that I created a system datasource in the ODBC control panel applet, and I connect to the SQL server just fine. I then used the CF Admin to create an ODBC socket DSN to connect to the local DSN on the web server. Any ideas on why I can connect to the remote SQL server via a Microsoft local system DSN, but not directly to the SQL box from CF Admin using the stock SQL server drivers? Any help would be greatly appreciated! -- Alex Sherwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201532 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: Generating BarCodes in CF
Thanks Andy, But you are too late,j/k :P Somebody already suggested that. And that is actually one of the first places I looked before posting to CF-Talk. Unfortunately, FusionZone is limited in the Barcoding Symbologies that they encode. I'm looking for an app that converts to the 2D symbologies, mainly PDF417. To my knowledge FusionZone doesn't support that. The ones that I have found which do support it, are so far 2: Morovia and TEC-IT. However those are mainly desktop apps written in VB. One of them has an ActiveX control, but they don't explain how to access it, and what methods/variables etc, are available. Even then, that's only half the battle, the second part is how to programmatically embed the info I need into a word doc. These were the same kinds of problems that we faced as CF developers before ActivePDF and MX7, when we tried to generate PDF's on the fly. I was looking for some Coldfusion-friendly apps, or a method by which I could write an app myself in CF. Thanks, Ali -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:57 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Sorry to join in late. I use CF_BarCode: Company : fusionZONE, Inc. Application : barcodeZONE Version : 1.0 Build Date: 03/18/2004 Developer : Kevin Maloy Copyright (c) 2004 fusionZONE, Inc. All Rights Reserved http://www.fusionzone.com DO NOT REMOVE THIS NOTICE Works like a charm. Andy -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:31 AM To: CF-Talk Subject: RE: Generating BarCodes in CF John, Yes, it is available in a font. The font is called PDF417, I believe. This sounds like the direction I may want to go in. Can you elaborate on how I could do that? ~| 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:201533 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: application scope and CFMX(JRun) clusters
On Apr 5, 2005 8:29 AM, Douglas Knudsen [EMAIL PROTECTED] wrote: Ok, we have some apps that store CFC instances in the application scope. We just set up a CFMX cluster in our production environment. For those of you also doing this, how do you update your application scopes? For example, an instance of foo.cfc is stored in application.foo. If I update the code for foo.cfc, how do I get a new instance in all my CFMX instances easily? thoughts? We have multiple instances per server and multiple servers. We use a build script to deploy code changes to all the servers (the instances on each server share the same webroot so only one copy of the code lives on each server). Then we have a bootstrap script that hits each server instance in turn and requests a URL that reload the appropriate CFC cache. -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:201534 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: CF app as EAR/WAR file
On Apr 5, 2005 1:17 PM, Rob [EMAIL PROTECTED] wrote: If I could ride the coat tails of this question... what license do you need when you ear/war up a cf project to sell (someone just asked me).. Enterprise, because EAR/WAR deployment only works when deploying into full J2EE servers, of which CF Standard is not. Regards, Dave. ~| 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:201535 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: Help with NAT and DSN setups in CF Admin
Make sure you have the correct port open. -Original Message- From: Alex Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 10:30 AM To: CF-Talk Subject: Help with NAT and DSN setups in CF Admin Greetings. Our IIS 6/CF server is on a 10 dot network, and mapped to an external IP via our firewall appliance. When trying to set up a DSN to our MS SQL Server, I keep getting a connection refused error message. I am using the server name (UNC name) and the correct username/password. The SQL server is across the 'net on another network. The CF/Web server's public IP has open access through the firewall into the network where the SQL server is kept. What's strange, is that I created a system datasource in the ODBC control panel applet, and I connect to the SQL server just fine. I then used the CF Admin to create an ODBC socket DSN to connect to the local DSN on the web server. Any ideas on why I can connect to the remote SQL server via a Microsoft local system DSN, but not directly to the SQL box from CF Admin using the stock SQL server drivers? Any help would be greatly appreciated! -- Alex Sherwood ~| 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:201536 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generating BarCodes in CF
FYI incase anyone is wondering. Here is what I mean by 2D barcodes. I have attached the gif of what one looks like. If you have ever shipped a UPS package where you generated the package slip on their website or via EBay, then you have probably seen this. -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:57 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Sorry to join in late. I use CF_BarCode: Company : fusionZONE, Inc. Application : barcodeZONE Version : 1.0 Build Date: 03/18/2004 Developer : Kevin Maloy Copyright (c) 2004 fusionZONE, Inc. All Rights Reserved http://www.fusionzone.com DO NOT REMOVE THIS NOTICE Works like a charm. Andy ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201537 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: Generating BarCodes in CF
It didn't make it I guess we can't send images on here Well the image is the first thing you see if you go to this page: http://grandzebu.net/informatique/codbar-en/pdf417.htm Ali -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 10:35 AM To: CF-Talk Subject: RE: Generating BarCodes in CF FYI incase anyone is wondering. Here is what I mean by 2D barcodes. I have attached the gif of what one looks like. If you have ever shipped a UPS package where you generated the package slip on their website or via EBay, then you have probably seen this. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201538 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: Generating BarCodes in CF
Well, since it's more than just a font, your problem does sound like it requires the specialized program. I'm not sure where to send you from here. Just search for a program that you can run from your desktop (perhaps command-line based) and get that working and then it's easy to move it over to CF. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 1:21 PM To: CF-Talk Subject: RE: Generating BarCodes in CF John, I do indeed have the font(s) installed in Word. And yes, I can type certain characters and it will display in somewhat of a barcode font. However, I do know, from however much research I have done this far, is that a series of binary strings are necessary to display the barcode correctly. I know this because I download the evaluation versions of some of the software that does the 2D barcode conversion. Those are all blackbox implementations though. I need something that I can invoke via CF via a webapp, and then embed in my documents. You cannot just type Hello world in word and apply the font and get the correct barcode. You will get something in the barcode font, but not the desired result. Hello world has to go through a conversion into a binary string based on a specific formula. That string has to be entered into word or ActivePDF or Adobe Acrobat or Notepad, and then the font can be applied to it to get the proper bar code. The reason I know this is because there are websites out there which do an on-the-fly conversion to the 2-D barcode and show you what the result is supposed to look like. Cheers, Ali -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 10:04 AM To: CF-Talk Subject: RE: Generating BarCodes in CF If you can install the font on your PC and open word and write some text in that font to get the result you want, then you can do it on the server. Perhaps the reason you were seeing wingdings when you viewed their formula output is because you don't have the required fonts installed? If there is indeed a font that you can type and the font outputs the barcode (like in Word) then you can just use CF to call ActivePDF and send over the characters necessary to create the output and tell ActivePDf to use that font (which must be installed on the server to work correctly). John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 12:08 PM To: CF-Talk Subject: RE: Generating BarCodes in CF John, Yes, it is available in a font. The font is called PDF417, I believe. This sounds like the direction I may want to go in. Can you elaborate on how I could do that? We have ActivePDF installed on our server, could I do it using that? However, we can't just take plain text and apply the font to it. The plain text gets encoded into a series of binary words I believe. (I think it's the right terminology a binary string of 16 bits). Some guy came up with a formula that does the encoding. The formula itself is open source, and there's a SourceForge project out there, that claims to convert a text string to the 2D barcode. I downloaded it and ran their sample app, and all it does is convert the text into WingDings. That was one dead-end. Next, I found the website of some French dude that posted the entire formula for creating 2D barcodes. But since I'm not a PhD in Discrete Math, nor in Computer Science, it was way above my understanding/abilities/comprehension. Otherwise, I believe we may be able to use Coldfusion to generate the barcode if we can decipher the formula. Here's the guy's website: http://grandzebu.net/informatique/codbar-en/pdf417.htm He too claims to have a tool to encode plain text into a barcode. I downloaded it and ran it and all it did was convert my text into WingDings. So I don't know how much we can trust the formula he posts. However it looks confusing enough to be trusted :S Thanks, Ali ~| 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:201539 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Help with NAT and DSN setups in CF Admin
For the time being, all ports on both boxes are open. If the port weren't open on the SQL server's network, then the local system DSN wouldn't be able to connect either, but it does! -- Alex Connie DeCinko wrote: Make sure you have the correct port open. -Original Message- From: Alex Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 10:30 AM To: CF-Talk Subject: Help with NAT and DSN setups in CF Admin Greetings. Our IIS 6/CF server is on a 10 dot network, and mapped to an external IP via our firewall appliance. When trying to set up a DSN to our MS SQL Server, I keep getting a connection refused error message. I am using the server name (UNC name) and the correct username/password. The SQL server is across the 'net on another network. The CF/Web server's public IP has open access through the firewall into the network where the SQL server is kept. What's strange, is that I created a system datasource in the ODBC control panel applet, and I connect to the SQL server just fine. I then used the CF Admin to create an ODBC socket DSN to connect to the local DSN on the web server. Any ideas on why I can connect to the remote SQL server via a Microsoft local system DSN, but not directly to the SQL box from CF Admin using the stock SQL server drivers? Any help would be greatly appreciated! -- Alex Sherwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201540 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generating BarCodes in CF
Ali, Do a search in google for pdf217 command-line and you'll get a bunch of results for software programs and stuff like that. Something should be out there for you. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 1:37 PM To: CF-Talk Subject: RE: Generating BarCodes in CF It didn't make it I guess we can't send images on here Well the image is the first thing you see if you go to this page: http://grandzebu.net/informatique/codbar-en/pdf417.htm Ali ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201541 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: CF app as EAR/WAR file
What I mean to ask is, does the receiver of the ear/war need to buy CF too, or is there a distribute license or something? From what you posted I get the impression that anyone who wants to run the ear/war I made with CF needs to have a CF license too - yes? On Apr 5, 2005 10:36 AM, Dave Watts [EMAIL PROTECTED] wrote: If I could ride the coat tails of this question... what license do you need when you ear/war up a cf project to sell (someone just asked me).. You will need a CFMX Enterprise license to deploy an EAR/WAR. You can enter the license number when creating the EAR/WAR, or after deploying it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:201542 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Renaming a GIF - CFFILE
First off, without code examples everyone will be guessing and guessing and nobody will be able to really provide specific help. There's really not much help I can give without code exmples. CFFILE's options when using the action=rename attribute are pretty simple and straightforward... I could guess that you've got a stray single quote getting mixed in to the file name when you activate your cffile scripting. Laterz, J On Apr 5, 2005 8:43 AM, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Anyone seen the following error/oddity.. All Files upload OK, and FileExists() confirms that CF can see them, but it always gives a tag validation error when trying to rename the GIF files. I have tried uploading GIF and JPG versions of the same file, and the JPG will rename, but the GIF won't. completely bonkers... -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://www.web-relevant.com/blogs/cfobjective ~| 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:201543 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL prob
Matt Osbun wrote: Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Ask 10 developers that got their BSc in CS during the last 12 months to explain both syntaxes. Extrapolate that to three or five years in the future. Will your replacement still be able to read your code? *= and (+) are deprecated, legacy, on their way out. They may very well last 4 more decades in some obscure COBOL application, but just as you should use IsDefined instead of ParameterExists, you should use LEFT JOIN syntax. Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201544 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: Generating BarCodes in CF
John, Firstly, thanks for taking the time to discuss this issue. Yeah, Google has been my friend for many years. Even as I posted this question on CF-Talk, I had downloaded and evaluated a couple of off-the-shelf solutions for generating the BarCodes that I needed. I can even invoke one of them through CF. But like I said, that is only half the battle. I need to be able to embed the generated code into an existing Word Doc, via CF. That's something I don't know how to do. All the googling, ends up with VB solutions. Even when I contacted tech-support for one of the software vendors, they responded with a VB solution. I'm not a VB guru, and don't know much about writing ActiveX objects, or using the OLEViewer to decipher all the hex codes and various and sundry variables that I would need to manipulate were I to use CF to access it. Oh well, this horse is pretty much dead. I'll walk away. If anyone's interested I can email them off-list if I come up with a CF interface that does what I need. Otherwise, thanks all, and good night, Ali -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 10:39 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Ali, Do a search in google for pdf217 command-line and you'll get a bunch of results for software programs and stuff like that. Something should be out there for you. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201545 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: CF app as EAR/WAR file
On Apr 5, 2005 9:42 AM, Bryan Stevenson [EMAIL PROTECTED] wrote:
One thing this crowd will be VERY interested in is deploying a CF app on J2EE
servers (so enhancing productivity through rapid dev in CF and deploying as
Java).
I demo'd this at Fusebox 2004 so I can walk you through it (contact me
off-list if you need more details).
I want to clarify exactly what the EAR/WAR file deployment option does in CF.
AFAIK
-compiles an entire CF app as and EAR/WAR file
Inside the CF Administrator, you can select J2EE packaging and pick a
directory (containing your application) to package up. At that point
you have the option to include the CF Administrator or not and to
include source or not.
- including the CF Administrator means that the deployed application
will also have a regular CF Administrator included, with the same
password as yours initially
- omitting the CF Administrator means that the deployed application
will have all the same settings as your CF Administrator but you will
only be able to change settings programmatically via the new CF Admin
API, using some code in your application
- including source code means your CFM / CFC files will be included in
the deployed application (just as if you'd copied them manually)
- omitting source code means that CF will couple all of your CFM / CFC
files to Java bytecode and include only the compiled bytecode files in
the deployed application (as if you'd manually run the cfcompile batch
file)
I recommend naming the WAR archive to match the top-level directory
name containing your application (so if you have webroot/myapp then
call the WAR file myapp.war). That makes it easier to deploy on most
J2EE servers if your code relies on /myapp as its home.
-EAR/WAR file can be deployed on a J2EE server without installing CF
Correct. For the Fusebox 2004 demo, I created the WAR archive, used
JRun to create a clean server instance, then deployed the WAR file to
that clean server instance (which had never seen ColdFusion). When I
started the server instance, the CF runtime started up (from the
packaged archive) and I ran my application.
For the demo, I did not include source (so I could show that the
foo.cfm files were Java bytecode rather than source code) and I did
not include the CF Administrator. I had a first-run wizard in my
application that offered a mini-admin console (using a tabbed Flash
form) to allow the user to type in database connectivity information
etc. Behind the scenes it used the Admin API to setup the data source
appropriately.
1) When you choose the EAR/WAR file option during CF install...
This is for initial installation of CF itself and has nothing to do
with J2EE packaging for application deployment. You can do J2EE
packaging on *any* edition, including Developer Edition but the
resulting EAR/WAR is effectively an Enterprise Edition since J2EE
*deployment* is an Enterprise feature.
2) How is the EAR/WAR file deployed on the J2EE server (remember I'm a Java
newb)
It depends on the J2EE server. For JRun, you must manually explode the
WAR into a server instance. For example, if you have a server instance
called foo, go to {jrun.home}/servers/foo/ and unpack the WAR there,
using the command:
jar xvf /path/to/the/myapp.war
This should create {jrun.home}/servers/foo/myapp/ containing your
application. Start that server instance and you can access your
application using:
http://{server}:{port}/myapp/
where {server} is the machine name (e.g., localhost) and {port} is the
appropriate port for the foo server instance, e.g., 8200.
Tomcat, on the other hand , auto-deploys war files for you. Just put
the war file in {tomcat.home}/webapps/ and start Tomcat. It will
unpack myapp.war automatically into {tomcat.home}/webapps/myapp/ and
you can access it using the same sort of URL as shown above, e.g.,
http://localhost:8180/myapp/
Rob asked about licensing. When you create the J2EE package (the
EAR/WAR file), you can optionally enter a serial number for a new
Enterprise Edition of CFMX (you need to buy the license from
Macromedia). If you do that, the deployed application will be a
fully-licensed, fully-functional copy of CFMX Enterprise Edition
(although it will only have a CF Administrator if you opted to include
it in the packaging).
If you omit a serial number, the deployed application will be
Developer Edition. You can turn it into Enterprise Edition by buying a
license and doing either of the following after deployment:
- if you included a CF Administrator, go in and enter the new serial
number under System Information
- if you did not include a CF Administrator, you can only update the
serial number through the Admin API so your application will need to
provide a way to do that
Feel free to ask further questions, either on cf-talk or privately.
--
Sean A Corfield -- http://corfield.org/
Team Fusebox -- http://fusebox.org/
Got Gmail? -- I have 50, yes 50, invites to give away!
If you're not annoying somebody, you're not
RE: Generating BarCodes in CF
Well, Word automation is basically unsupported by Microsoft so you might have trouble finding a good solution. Someone posted on here earlier today about an XML solution for generating Word docs. You may want to look at that. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 1:51 PM To: CF-Talk Subject: RE: Generating BarCodes in CF John, Firstly, thanks for taking the time to discuss this issue. Yeah, Google has been my friend for many years. Even as I posted this question on CF-Talk, I had downloaded and evaluated a couple of off-the-shelf solutions for generating the BarCodes that I needed. I can even invoke one of them through CF. But like I said, that is only half the battle. I need to be able to embed the generated code into an existing Word Doc, via CF. That's something I don't know how to do. All the googling, ends up with VB solutions. Even when I contacted tech-support for one of the software vendors, they responded with a VB solution. I'm not a VB guru, and don't know much about writing ActiveX objects, or using the OLEViewer to decipher all the hex codes and various and sundry variables that I would need to manipulate were I to use CF to access it. Oh well, this horse is pretty much dead. I'll walk away. If anyone's interested I can email them off-list if I come up with a CF interface that does what I need. Otherwise, thanks all, and good night, Ali ~| 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:201547 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: CF app as EAR/WAR file
On Apr 5, 2005 1:42 PM, Rob [EMAIL PROTECTED] wrote: What I mean to ask is, does the receiver of the ear/war need to buy CF too, or is there a distribute license or something? From what you posted I get the impression that anyone who wants to run the ear/war I made with CF needs to have a CF license too - yes? You can choose to package the CF runtime with your EAR/WAR package if you'd like. On the user's end, in this instance, all they would need is a valid CF Enterprise license number to enter in to start using it -- no separate CF installation is necessary. Regards, Dave. ~| 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:201548 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: Help with NAT and DSN setups in CF Admin
Our IIS 6/CF server is on a 10 dot network, and mapped to an external IP via our firewall appliance. When trying to set up a DSN to our MS SQL Server, I keep getting a connection refused error message. I am using the server name (UNC name) and the correct username/password. The SQL server is across the 'net on another network. The CF/Web server's public IP has open access through the firewall into the network where the SQL server is kept. What's strange, is that I created a system datasource in the ODBC control panel applet, and I connect to the SQL server just fine. I then used the CF Admin to create an ODBC socket DSN to connect to the local DSN on the web server. Any ideas on why I can connect to the remote SQL server via a Microsoft local system DSN, but not directly to the SQL box from CF Admin using the stock SQL server drivers? When you connect via ODBC, are you using TCP/IP, or Named Pipes? (Named Pipes uses Windows Networking (NetBIOS) on top of whatever protocol you're using, which is typically TCP/IP.) Named Pipes is the default, and JDBC doesn't support that. You may need to configure your SQL Server's network listeners to include TCP/IP. You can do this using the Server Network Utility from the SQL Server console. Also, is your SQL Server configured to allow native SQL logins (untrusted connections)? By default, SQL Server only accepts trusted connections that use Windows authentication. The JDBC drivers that come with CFMX don't support this, although apparently some third-party drivers like jTDS (http://jtds.sourceforge.net/) do. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:201549 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF app as EAR/WAR file
It depends on the J2EE server. For JRun, you must manually explode the WAR into a server instance. I've deployed other WARs to JRun without exploding them first. Flex works nicely this way, actually. Are you sure you need to do this with CF? You can do J2EE packaging on *any* edition, including Developer Edition but the resulting EAR/WAR is effectively an Enterprise Edition since J2EE *deployment* is an Enterprise feature. I'm pretty sure that you cannot do J2EE packaging on Standard Edition. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:201550 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: Running exe file from browser
Still no luck after playing with it further. To better explain... I am trying to create a Click here to start application button on my web site. The objective is to run the application at the following address: g:\shared\applications\Programs\PC.exe Note that the G drive is a SHARED network drive and is NOT the users local machine, nor is it the web server. This application starts and runs fine from either a shortcut placed on the end users desktop or from the command line with the very parameters shown above. No flags, etc. I know I cannot accomplish this solely with server-side CF, but I figured JavaScript or VBScript or ActiveX or SOMETHING could be put into my CF page to make this happen! Barring this possibility, what can I use to create a shortcut on the end users desktop that will allow them to launch the application themselves? I have found tutorials that show how to add shortcuts for websites, but not for applications. TIA, Tim ~| 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:201551 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: CF app as EAR/WAR file
What I mean to ask is, does the receiver of the ear/war need to buy CF too, or is there a distribute license or something? From what you posted I get the impression that anyone who wants to run the ear/war I made with CF needs to have a CF license too - yes? The receiver of the EAR/WAR needs to have a CFMX Enterprise license to be able to deploy the EAR/WAR on a production server. If you are creating an EAR/WAR for deployment on another server, and you have a valid license number for that server, you can enter it when you create the EAR/WAR. Alternatively, the receiver can enter it after deploying the EAR/WAR, either through the CF Administrator if you included that, or by editing the appropriate text file within the EAR/WAR, or through a custom interface you may provide within your CF code using the shiny new Admin API. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:201552 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
There's a good reason to use the new style of joins: because they are more powerful. Here is an example of a query that, to my knowledge, can't be done with *= syntax: select * from t1 left outer join t2 on (t1.id = t2.id and t1.rating t2.max_rating) This is very different from: select * from t1 left outer join t2 on (t1.id = t2.id) where t1.rating t2.max_rating so it must be different than the *= style This kind of complex outer join is what educated me to the new style of joins, and I've used them ever since. (And they read better too.) -Original Message- From: Matt Osbun [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:18 AM To: CF-Talk Subject: RE: SQL prob Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Matt Osbun Web Developer Health Systems, International -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:42 AM To: CF-Talk Subject: RE: SQL prob This is the OLD way to perform a join - it should be avoided. -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:48 To: CF-Talk Subject: RE: SQL prob Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201553 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob
I would ask him to give it back - this syntax is deprecated and could well be removed at any stage from SQL Server . David Manriquez [SMTP:[EMAIL PROTECTED] -Original Message- From: David Manriquez To: CF-Talk Sent: 05/04/2005 16:28 Subject: RE: SQL prob I'm still using it cause a Microsoft Certified SQL professional show me the tracing and performance of LEFT/RIGHT/OUTHER/INNER JOIN and *=/=/=*/*=* and the last one is better and faster. David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Matt Osbun [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 11:18 Para: CF-Talk Asunto: RE: SQL prob Why? Not a challenge, but a question. Using *= or (+) always seemed, at least to me, quicker, easier, and easier to read afterward. Now, I admit that I mostly got into the habit because, until fairly recently, I was stuck on an Oracle platform that was too old to use INNER JOIN/LEFT JOIN, but how much does it really matter? Matt Osbun Web Developer Health Systems, International -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 9:42 AM To: CF-Talk Subject: RE: SQL prob This is the OLD way to perform a join - it should be avoided. -Original Message- From: David Manriquez [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:48 To: CF-Talk Subject: RE: SQL prob Another way SELECT r.eventID, d.title FROM Events r,EventDescription d WHERE d.eventID *= r.eventID David Manriquez Desarrollador de Sistemas [EMAIL PROTECTED] (+56-2) 43 00 155 -Mensaje original- De: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Enviado el: Martes, 05 de Abril de 2005 10:17 Para: CF-Talk Asunto: RE: SQL prob You are using an INNER JOIN - you need to use a LEFT JOIN I believe. SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON WHERE d.eventID = r.eventID -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 05 April 2005 15:18 To: CF-Talk Subject: OT:SQL prob SQL Server 7. cfquery name=q1 datasource=newStuff SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID /cfquery This query only returns rows from Events table that have eventID present in EventDescription table. I need to return ALL rows from Events table whether thay have a description or not. As ever, thanks in advance, Dave ~| 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:201554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF app as EAR/WAR file
Rob asked about licensing. When you create the J2EE package (the EAR/WAR file), you can optionally enter a serial number for a new Enterprise Edition of CFMX (you need to buy the license from Macromedia). If you do that, the deployed application will be a fully-licensed, fully-functional copy of CFMX Enterprise Edition (although it will only have a CF Administrator if you opted to include it in the packaging). If you omit a serial number, the deployed application will be Developer Edition. You can turn it into Enterprise Edition by buying a license and doing either of the following after deployment: - if you included a CF Administrator, go in and enter the new serial number under System Information - if you did not include a CF Administrator, you can only update the serial number through the Admin API so your application will need to provide a way to do that Feel free to ask further questions, either on cf-talk or privately. I told the guy who asked me to call MM himself to get the skinny, but now I am curious. As usual I am a bit slow, and a confused mind says no so is this accurate... 1. I buy CF EE, write an app, make a war 2. I want to sell it to Joe Blow 3. Joe Blow likes the app, and wants to buy it 4. Joe Blow, who is running tomcat only, needs to buy a CF EE license to run my war in production or 4. Joe Blow, who is running tomcat only, can use the war without ever talking to MM I think it's the latter, but I can't seem to get it (as soon as I see license and serial number I start getting confused ;-D) ~| 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:201555 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Renaming a GIF - CFFILE
The file could be locked? Try performing a Copy, then a delete on the original.. It may give the call enough time to release the lock? HTH On Apr 5, 2005 2:43 PM, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Anyone seen the following error/oddity.. All Files upload OK, and FileExists() confirms that CF can see them, but it always gives a tag validation error when trying to rename the GIF files. I have tried uploading GIF and JPG versions of the same file, and the JPG will rename, but the GIF won't. completely bonkers... This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201556 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: Running exe file from browser
First: Does the server have permissions to read and execute that share? By default the CF service user would probably not. It would have to be given the appropriate permissions just is any other user. Second: When this runs, it is going to run from the server's point of view. Not the user who told the server to do it. Does this make sense to do from the point of view of the purpose of the application being run? Is this some sort of interactive program that is expecting inputs that the service can not provide, or does it just run a process that does it's job and then stops. The former is not going to work well with CF, that latter should be just fine. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:17 AM To: CF-Talk Subject: Re: Running exe file from browser Still no luck after playing with it further. To better explain... I am trying to create a Click here to start application button on my web site. The objective is to run the application at the following address: g:\shared\applications\Programs\PC.exe Note that the G drive is a SHARED network drive and is NOT the users local machine, nor is it the web server. This application starts and runs fine from either a shortcut placed on the end users desktop or from the command line with the very parameters shown above. No flags, etc. I know I cannot accomplish this solely with server-side CF, but I figured JavaScript or VBScript or ActiveX or SOMETHING could be put into my CF page to make this happen! Barring this possibility, what can I use to create a shortcut on the end users desktop that will allow them to launch the application themselves? I have found tutorials that show how to add shortcuts for websites, but not for applications. TIA, Tim ~| 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:201557 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: CF app as EAR/WAR file
The receiver of the EAR/WAR needs to have a CFMX Enterprise license to be able to deploy the EAR/WAR on a production server. If you are creating an EAR/WAR for deployment on another server, and you have a valid license number for that server, you can enter it when you create the EAR/WAR. Alternatively, the receiver can enter it after deploying the EAR/WAR, either through the CF Administrator if you included that, or by editing the appropriate text file within the EAR/WAR, or through a custom interface you may provide within your CF code using the shiny new Admin API. Holy Cow, this reminds me of that monty python the meaning of life scene when the Catholic teacher is explaining how to hang your coat... It's quite simple, you must put your coat on the lower hook before you collect your note after you go to the masters game unless your brother will be on vacation on Saturday then you get must get his note from the dean before you go to lunch move your brothers coat to the upper hook after you collect your... -- ~Blog~ http://www.robrohan.com ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~| 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:201558 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: CF app as EAR/WAR file
I told the guy who asked me to call MM himself to get the skinny, but now I am curious. As usual I am a bit slow, and a confused mind says no so is this accurate... 1. I buy CF EE, write an app, make a war 2. I want to sell it to Joe Blow 3. Joe Blow likes the app, and wants to buy it 4. Joe Blow, who is running tomcat only, needs to buy a CF EE license to run my war in production or 4. Joe Blow, who is running tomcat only, can use the war without ever talking to MM I think it's the latter, but I can't seem to get it (as soon as I see license and serial number I start getting confused ;-D) Given the above, here are your choices: 1. You omit the serial number when creating your EAR/WAR. Mr. Blow would then have to purchase his own CFMX Enterprise license to deploy your EAR/WAR for production use. If he doesn't enter a serial number, the EAR/WAR will essentially be a CFMX trial version for 30 days, after which it reverts to Developer Edition. 2. You enter your serial number when creating your EAR/WAR. Mr. Blow would then be able to deploy the EAR/WAR directly to production. However, you would then have to cease using that serial number with your own copy of CFMX Enterprise, as you would essentially have sold him your license. If you continue using the serial number for your own server, you would be violating the terms of your license, and Macromedia product resellers like me would track you down, skin you alive and make you into one of those bearskin rugs or something. I just saw Sin City last weekend, so I'm kind of in that mindset right now I guess. 3. Before creating your EAR/WAR, you get a valid CFMX Enterprise license from Mr. Blow, or on behalf of Mr. Blow. You enter that serial number when creating your EAR/WAR. Mr. Blow can then deploy it directly to production, and that license would legally belong to him. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201559 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL prob - a reason other than style
There's a good reason to use the new style of joins: because they are more powerful. Here is an example of a query that, to my knowledge, can't be done with *= syntax: select * from t1 left outer join t2 on (t1.id = t2.id and t1.rating t2.max_rating) This is very different from: select * from t1 left outer join t2 on (t1.id = t2.id) where t1.rating t2.max_rating .so it must be different than the *= style This kind of complex outer join is what educated me to the new style of joins, and I've used them ever since. (And they read better too.) Mark ~| 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:201560 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: JavaScript clock problem w/ Firefox
I have a clock javascript that works fine in IE 6.0, but does not
display correctly in Firefox 1.0.2 or Netscape 7.0. Can anyone tell me
what's up here? I've tried googling for tips, but didn't come up with
anything. Here is the script:
In the head section:
script type=text/javascript
function clock() {
var time = new Date();
var hours = time.getHours();
var minutes = time.getMinutes();
var seconds = time.getSeconds();
var amOrPm = AM;
if (hours 11) amOrPm = PM;
if (hours 12) hours = hours - 12;
if (hours == 0) hours = 12;
if (minutes = 9) minutes = 0 + minutes;
if (seconds = 9) seconds = 0 + seconds;
dispTime = hours + : + minutes + : + seconds + + amOrPm;
document.getElementById('clock').innerHTML = dispTime;
setTimeout(clock(), 1000);
}
window.onload = Clock;
/script
Inside the body:
div id=clock style=position:absolute;left:100;top:100;/div
In Firefox, it displays the time 8 hours ahead, but in IE it shows the
correct system time.
~|
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:201561
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
Mystified about select box
I am mystified about this one: Part A: billable=#billable# cfif billable is Yesprint yes/cfif cfif billable is Noprint no/cfif (billable is always yes or no) Part B: select name=clusterbillable option Value=Yes cfif billable is Yesselected/cfif Yes option Value=No cfif billable is Noselected/cfif No /select Part A works fine, indicating variables and data ok. Part B does not work, and I use the exact same method a little further down in the form. Can anyone see an error??? TNX if you can help. Richard Colman ~| 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:201562 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: CF app as EAR/WAR file
Holy Cow, this reminds me of that monty python the meaning of life scene when the Catholic teacher is explaining how to hang your coat... It's quite simple, you must put your coat on the lower hook before you collect your note after you go to the masters game unless your brother will be on vacation on Saturday then you get must get his note from the dean before you go to lunch move your brothers coat to the upper hook after you collect your... The details aren't that important, though. All you really need to know is that you need at least one CFMX Enterprise license for each production server, whether it's the one you used to create the EAR/WAR or the one you deploy it on. You may need more than one license per server, depending on the number of CPUs running the application server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201563 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generating BarCodes in CF
John, Oh well. Thanks for the tip though, I'll look into that. Ali -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 10:57 AM To: CF-Talk Subject: RE: Generating BarCodes in CF Well, Word automation is basically unsupported by Microsoft so you might have trouble finding a good solution. Someone posted on here earlier today about an XML solution for generating Word docs. You may want to look at that. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 1:51 PM To: CF-Talk Subject: RE: Generating BarCodes in CF John, Firstly, thanks for taking the time to discuss this issue. Yeah, Google has been my friend for many years. Even as I posted this question on CF-Talk, I had downloaded and evaluated a couple of off-the-shelf solutions for generating the BarCodes that I needed. I can even invoke one of them through CF. But like I said, that is only half the battle. I need to be able to embed the generated code into an existing Word Doc, via CF. That's something I don't know how to do. All the googling, ends up with VB solutions. Even when I contacted tech-support for one of the software vendors, they responded with a VB solution. I'm not a VB guru, and don't know much about writing ActiveX objects, or using the OLEViewer to decipher all the hex codes and various and sundry variables that I would need to manipulate were I to use CF to access it. Oh well, this horse is pretty much dead. I'll walk away. If anyone's interested I can email them off-list if I come up with a CF interface that does what I need. Otherwise, thanks all, and good night, Ali ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201564 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: CF app as EAR/WAR file
On Apr 5, 2005 10:36 AM, Dave Watts [EMAIL PROTECTED] wrote: You will need a CFMX Enterprise license to deploy an EAR/WAR. You can enter the license number when creating the EAR/WAR, or after deploying it. Otherwise it will be Developer Edition. -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201566 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: Mystified about select box
shot in the dark, do you not have to close the option tag i.e. option Value=Yes cfif billable is Yesselected/cfifYes/option From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Tue 05/04/2005 19:44 To: CF-Talk Subject: Mystified about select box I am mystified about this one: Part A: billable=#billable# cfif billable is Yesprint yes/cfif cfif billable is Noprint no/cfif (billable is always yes or no) Part B: select name=clusterbillable option Value=Yes cfif billable is Yesselected/cfif Yes option Value=No cfif billable is Noselected/cfif No /select Part A works fine, indicating variables and data ok. Part B does not work, and I use the exact same method a little further down in the form. Can anyone see an error??? TNX if you can help. Richard Colman ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201566 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: JavaScript clock problem w/ Firefox
I've had issues with getYear() after creating a js date before in
FireFox. It would display 2005 in IE, but in FF it displays 105. I had to
use getFullYear() for it to display correctly. I don't have time to look
into the getMinutes and getSeconds, etc, but I would be willing to bet a
cold brewski that might have something to do with it.
Ray
At 02:43 PM 4/5/2005, you wrote:
I have a clock javascript that works fine in IE 6.0, but does not
display correctly in Firefox 1.0.2 or Netscape 7.0. Can anyone tell me
what's up here? I've tried googling for tips, but didn't come up with
anything. Here is the script:
In the head section:
script type=text/javascript
function clock() {
var time = new Date();
var hours = time.getHours();
var minutes = time.getMinutes();
var seconds = time.getSeconds();
var amOrPm = AM;
if (hours 11) amOrPm = PM;
if (hours 12) hours = hours - 12;
if (hours == 0) hours = 12;
if (minutes = 9) minutes = 0 + minutes;
if (seconds = 9) seconds = 0 + seconds;
dispTime = hours + : + minutes + : + seconds + + amOrPm;
document.getElementById('clock').innerHTML = dispTime;
setTimeout(clock(), 1000);
}
window.onload = Clock;
/script
Inside the body:
div id=clock style=position:absolute;left:100;top:100;/div
In Firefox, it displays the time 8 hours ahead, but in IE it shows the
correct system time.
~|
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:201567
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: JavaScript clock problem w/ Firefox
Here is the code I use and it displays correctly in IE and FireFox.
==
!-- Begin
var timerID = null;
var timerRunning = false;
function stopclock (){
if(timerRunning)
clearTimeout(timerID);
timerRunning = false;
}
function showtime () {
var now = new Date();
var hours = now.getHours();
var minutes = now.getMinutes();
var seconds = now.getSeconds()
var timeValue = + ((hours 12) ? hours -12 :hours)
if (timeValue == 0) timeValue = 12;
timeValue += ((minutes 10) ? :0 : :) + minutes
timeValue += ((seconds 10) ? :0 : :) + seconds
timeValue += (hours = 12) ? PM : AM
//document.clock.face.value = timeValue;
document.getElementById('clock').innerHTML = timeValue;
timerID = setTimeout(showtime(),1000);
timerRunning = true;
}
function startclock() {
stopclock();
showtime();
}
// End --
==
-Original Message-
From: Rebecca Wells [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 11:43 AM
To: CF-Talk
Subject: OT: JavaScript clock problem w/ Firefox
I have a clock javascript that works fine in IE 6.0, but does not
display correctly in Firefox 1.0.2 or Netscape 7.0. Can anyone tell me
what's up here? I've tried googling for tips, but didn't come up with
anything. Here is the script:
In the head section:
script type=text/javascript
function clock() {
var time = new Date();
var hours = time.getHours();
var minutes = time.getMinutes();
var seconds = time.getSeconds();
var amOrPm = AM;
if (hours 11) amOrPm = PM;
if (hours 12) hours = hours - 12;
if (hours == 0) hours = 12;
if (minutes = 9) minutes = 0 + minutes;
if (seconds = 9) seconds = 0 + seconds;
dispTime = hours + : + minutes + : + seconds + + amOrPm;
document.getElementById('clock').innerHTML = dispTime;
setTimeout(clock(), 1000);
}
window.onload = Clock;
/script
Inside the body:
div id=clock style=position:absolute;left:100;top:100;/div
In Firefox, it displays the time 8 hours ahead, but in IE it shows the
correct system time.
~|
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:201568
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF app as EAR/WAR file
On Apr 5, 2005 10:42 AM, Rob [EMAIL PROTECTED] wrote: What I mean to ask is, does the receiver of the ear/war need to buy CF too, or is there a distribute license or something? Without a license, they end up with Developer Edition. A full Enterprise license purchase is required otherwise. I posted a long, full explanation of this whole process but the list manager software told me it was too long so I don't know whether it will post or not. If you are distributing a packaged application, you need to talk to Macromedia about OEM/ISV licenses. Grant Straker did this for his Shado CMS which packages CFMX and Flex so that it can be deployed as a self-contained application. From what you posted I get the impression that anyone who wants to run the ear/war I made with CF needs to have a CF license too - yes? Yes, or use it as Developer Edition. -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201569 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
