RE: Adding a dbase column via CF/ODBC
Hi, I'm having problem to use ALTER TABLE on a dbase file using DSN-less connection. It' an online conversion application where users submit their dbase files and the app will add some columns before posting it back to the user via email. The code only works if there is no data in the table. My workaround solution was 1. to create another dbase table based on the original structure of submitted dbase file 2. add 2 additional columns 3. populate the new table from original dbase file I'm not too sure what SQL statement to get an exisiting table strucutre. Below are the code snippets. dbtype="DYNAMIC"> ALTER TABLE india drop Address Thanks Nyon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFTP, sandbox security and PORT mode
Friends, I'm not sure but I think I've found a bug in the CFMX Enterprise. The problem happens when you use CFFTP tag in a sandboxed account. As you may know CFFTP uses PORT by default (the "passive" attribute is "no" by default). So far so good except for the fact that CFMX is not dealing the connection and it's returning a java.net.SocketPermission error that follows: Security: The requested template has been denied access to localhost:1024-. The following is the internal exception message: access denied (java.net.SocketPermission localhost:1024- listen,resolve). Some could ask to add 1024 (and higher) TCP port in the "Server/Port" settings but it doesn't change anything (not to mention that 1024 port is not used in PORT mode(?)). I've added all possible weirdness as TCP ports (20, 21, various ranges etc, etc) with no sucess. The tag (in it's defaults) doesn't work under a default sandbox context (with all IP/Ports open and availble for connection). The only workaround for it is to use passive mode (passive="yes") and (if you're restricting access to "Server/Ports") add the FTP host wide opened (leaving the "port" field blank) or add two entries (1) ftp.somehost.com:21 and (2) ftp.somehost.com:1024- (1024 and higher). To exemplify: 1) http://www.alexhubner.com/ftp_port/ (using the default port mode) 2) http://www.alexhubner.com/ftp_pasv/ (using pasv mode) And if my FTP server (or even the firewall ahead of it) doesn't allow me to use PASV mode? Does anybody faced a similar issue? I've googled around and didn't found any mention to it. Many thanks! Alex Hübner PS: the cfml template I'm using in the examples above is here: http://www.alexhubner.com/ftp_pasv/index.zip and a screenshot of my "server/ports" config in the sandbox is here: http://www.alexhubner.com/ftp_pasv/pic.gif -- Alex Hübner [EMAIL PROTECTED] http://www.cfgigolo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about populating pulldown menus with queries (Beginner)
I am getting a context validation error for tag cfloop. Any ideas? Context validation error for tag cfloop. The start tag must have a matching end tag. An explicit end tag can be provided by adding . If the body of the tag is empty you can use the shortcut . The CFML compiler was processing: a cfif tag beginning on line 73, column 61. a cfif tag beginning on line 73, column 61. The error occurred in D:\Inetpub\wwwroot\test\editgloballink.cfm: line 70 68 : 69 : 70 : 71 : 72 : isdefined("recordset1.CatergoryHeading") AND recordset1.CatergoryHeading eq The code as it stands: isdefined("recordset1.CatergoryHeading") AND recordset1.CatergoryHeading eq RecordsetGetMenu.LinkCatergory[i]>selected>selected>#Recor dset GetMenu.LinkCatergory# -Original Message- From: Daniel Mackey [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 3:59 PM To: CF-Talk Subject: RE: Question about populating pulldown menus with queries (Beginner) Hi John, Try this code for the select bit: isdefined("recordset1.CatergoryHeading") AND recordset1.CatergoryHeading eq RecordsetGetMenu.LinkCatergory[i]>selected>selected>#Recor dset GetMenu.LinkCatergory# This makes sure there is no ambiguity in the variables which I think may be causing your problems: Full code with my changes: --- SELECT * FROM globallinks WHERE UserName = '#getauthuser()#' SELECT LinkCatergory FROM dbo.GlobalLinkCatergory WHERE LinkCatergory IS NOT null action=""> CatergoryHeading: isdefined("recordset1.CatergoryHeading") AND recordset1.CatergoryHeading eq RecordsetGetMenu.LinkCatergory[i]>selected>selected>#Recor dset GetMenu.LinkCatergory# This is what the value should be! #recordset1.catergoryheading# Regards, Dan. -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 23:49 To: CF-Talk Subject: Question about populating pulldown menus with queries (Beginner) I am creating a page to allow users to edit links they have created. The links are grouped into categories such as personal hiking sites, or weather sites, etc. When users are editing their links I want to display the current value in the database as the currently selected value in a pull down menu. The pull down menu category values are in a separate table. The specific problem I am having (and haven't been able to solve - in an embarrassing amount of time) is that when looping over the form the first query results values are populated into all the pull down menus. Other fields I have which are represented as text don't have this problem. I am at a loss to explain/figure out what to do to properly populate the pull down menu with the current version. Any help would be most appreciated :-) I have included what I have below in hopes someone might be able to point me in the right direction - again thanks! The globallinks table has user specified data that should be editable (recordset1). The RecordsetGetMenu query has the categories I am trying to populate to the pulldown menu. select * from globallinks where UserName = '#getauthuser()#' SELECT LinkCatergory FROM dbo.GlobalLinkCatergory where LinkCatergory is not null action=""> CatergoryHeading: (isDefined("Recordset1.CatergoryHeading") AND RecordsetGetMenu.LinkCatergory EQ Recordset1.CatergoryHeading)>selected>#RecordsetGetMenu.LinkCater gory# This is what the value should be! #recordset1.catergoryheading# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about populating pulldown menus with queries (Beginner)
Hi John, Try this code for the select bit: isdefined("recordset1.CatergoryHeading") AND recordset1.CatergoryHeading eq RecordsetGetMenu.LinkCatergory[i]>selected>selected>#Recordset GetMenu.LinkCatergory# This makes sure there is no ambiguity in the variables which I think may be causing your problems: Full code with my changes: --- SELECT * FROM globallinks WHERE UserName = '#getauthuser()#' SELECT LinkCatergory FROM dbo.GlobalLinkCatergory WHERE LinkCatergory IS NOT null action=""> CatergoryHeading: isdefined("recordset1.CatergoryHeading") AND recordset1.CatergoryHeading eq RecordsetGetMenu.LinkCatergory[i]>selected>selected>#Recordset GetMenu.LinkCatergory# This is what the value should be! #recordset1.catergoryheading# Regards, Dan. -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 23:49 To: CF-Talk Subject: Question about populating pulldown menus with queries (Beginner) I am creating a page to allow users to edit links they have created. The links are grouped into categories such as personal hiking sites, or weather sites, etc. When users are editing their links I want to display the current value in the database as the currently selected value in a pull down menu. The pull down menu category values are in a separate table. The specific problem I am having (and haven't been able to solve - in an embarrassing amount of time) is that when looping over the form the first query results values are populated into all the pull down menus. Other fields I have which are represented as text don't have this problem. I am at a loss to explain/figure out what to do to properly populate the pull down menu with the current version. Any help would be most appreciated :-) I have included what I have below in hopes someone might be able to point me in the right direction - again thanks! The globallinks table has user specified data that should be editable (recordset1). The RecordsetGetMenu query has the categories I am trying to populate to the pulldown menu. select * from globallinks where UserName = '#getauthuser()#' SELECT LinkCatergory FROM dbo.GlobalLinkCatergory where LinkCatergory is not null action=""> CatergoryHeading: (isDefined("Recordset1.CatergoryHeading") AND RecordsetGetMenu.LinkCatergory EQ Recordset1.CatergoryHeading)>selected>#RecordsetGetMenu.LinkCater gory# This is what the value should be! #recordset1.catergoryheading# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Question about populating pulldown menus with queries (Beginner)
I am creating a page to allow users to edit links they have created. The links are grouped into categories such as personal hiking sites, or weather sites, etc. When users are editing their links I want to display the current value in the database as the currently selected value in a pull down menu. The pull down menu category values are in a separate table. The specific problem I am having (and haven't been able to solve - in an embarrassing amount of time) is that when looping over the form the first query results values are populated into all the pull down menus. Other fields I have which are represented as text don't have this problem. I am at a loss to explain/figure out what to do to properly populate the pull down menu with the current version. Any help would be most appreciated :-) I have included what I have below in hopes someone might be able to point me in the right direction - again thanks! The globallinks table has user specified data that should be editable (recordset1). The RecordsetGetMenu query has the categories I am trying to populate to the pulldown menu. select * from globallinks where UserName = '#getauthuser()#' SELECT LinkCatergory FROM dbo.GlobalLinkCatergory where LinkCatergory is not null action=""> CatergoryHeading: (isDefined("Recordset1.CatergoryHeading") AND RecordsetGetMenu.LinkCatergory EQ Recordset1.CatergoryHeading)>selected>#RecordsetGetMenu.LinkCater gory# This is what the value should be! #recordset1.catergoryheading# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Site wide error template
As Dave said, all you need is a cfswitch on cgi.server_name. Inside each case you can then do whatever you want. It can be either very simple or very complex depending on what you need. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFTP list directory problem with space.
Hi all, I'm trying to do a name="myListDir" directory='/usr/"I have spaces"'> And it always fails. When I use the win2k command line I can change into the directory with cd /usr/"I have spaces", so why won't the list work? Anyone have any insights? Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Unblocking Ports
> I thought that Windows Server 2003 was supposed to be the first > Windows shipped that by default blocked everything and you would > have to explicitly open ports. Is this not the case? No, I don't think so. Admittedly, I don't have a Windows Server 2003 machine handy, but I seem to recall having to create an IP security policy for it. However, many more services and processes are turned off by default, especially on the Web Edition, which is very good. In addition, IIS 6 is much more secure by default than previous versions - how could it not be, I guess? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:connecting tables from multiple databases
You may want to check out synchronization with BOL. Don Li >This is not really a CF question, but I notice that people have posted SQL >questions before and nobody minded that. > >I have an employee table in database A, I am using it in database A but now >I also want to use it in database B. I.e. I want to include its primary key >as a foreign key in tables that are part of database B (and the other way as >well). I am not sure how I go about that or whatever it is possible to do. >So far the only solution I can think of is to duplicate employee table >inside database B and keep it in synch with employee table inside A. For >that I don't know how to implement some MS SQL server 2000 based >synchronization (I don't really want to have to schedule/call a CF template >once a while that does the synchronization). I hope I am making some sense >her, I am much better with CF than SQL. Thanks for any help, > >Best Wishes, > >Tom Kitta >Advanced ColdFusion Programmer > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JJ Allaire?
Thanks Mike! No wonder he prefers JJ :) Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 "Haggerty, Mike" <[EMAIL PROTECTED]To: CF-Talk <[EMAIL PROTECTED]> ov> cc: Subject: RE: JJ Allaire? 20/11/2003 08:30 Please respond to cf-talk | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Unblocking Ports
I thought that Windows Server 2003 was supposed to be the first Windows shipped that by default blocked everything and you would have to explicitly open ports. Is this not the case? Marlon Dave Watts wrote: > > I was just reading this article on Macromedia's site: > > http://www.macromedia.com/support/coldfusion/ts/documents/tn18336.htm, > > and this may be a stupid question but how do I unblock ports on my > > Windows server? > > By default, Windows doesn't block any ports. You have to explicitly block > them yourself, using Windows' own functionality (IP security policies or > TCP/IP Filtering) or using a host-based firewall application. > > If you're installing CF and, say, IIS on a single machine, you shouldn't > have to worry about anything unless, as stated above, you are blocking > ports. If you're installing CF in distributed mode, with IIS on one server > and CF on another, then you or your network administrator will have to > ensure that traffic is allowed between the appropriate ports on both > machines. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Macromedia launches Flex (Was Royale)
> So it looks like Flex is a JSP application 1st, and an ASP.NET > 2nd...but there's not any real mention of CFMX in the presentation. > Hmmm... >From my understanding, having sat through the keynote and one other Flex presentation, Flex is all just client-side code, which can interoperate with CFMX, webservices, local Java objects, and whatever else you have laying around, more or less. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Unblocking Ports
> I was just reading this article on Macromedia's site: > http://www.macromedia.com/support/coldfusion/ts/documents/tn18336.htm, > and this may be a stupid question but how do I unblock ports on my > Windows server? By default, Windows doesn't block any ports. You have to explicitly block them yourself, using Windows' own functionality (IP security policies or TCP/IP Filtering) or using a host-based firewall application. If you're installing CF and, say, IIS on a single machine, you shouldn't have to worry about anything unless, as stated above, you are blocking ports. If you're installing CF in distributed mode, with IIS on one server and CF on another, then you or your network administrator will have to ensure that traffic is allowed between the appropriate ports on both machines. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Which patches installed on a CF5 server
> How do you determine which patches are installed on an instance > of CF5 Server? Unfortunately, I don't think there's an easy answer for this question. Some patches replace the cfserver.exe file, and I suspect you might see those represented by later version numbers in CF Administrator, but beyond that, I suspect you'll have to examine DLLs, etc, and compare them to an untouched CF 5 server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Site wide error template
> I remember a good while ago (6 months maybe) somebody made a > site-wide error template for shared hosting pages, which could > be used to display a page styled to each site... All you need to do, I imagine, is use conditional logic within your site-wide error handler, and have it CFINCLUDE the appropriate file based on the outcome of the condition. The big thing (to the extent that there is one) is to figure out how you'll differentiate between one site and another - I'd recommend using CGI.SERVER_NAME, I think - and where the CFINCLUDEd files should be located, but those are essentially just conventions. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Site wide error template
Hello again I remember a good while ago (6 months maybe) somebody made a site-wide error template for shared hosting pages, which could be used to display a page styled to each site... I searched the archives and couldn¹t find it, does anybody have it handy? Care to share? Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Php to coldfusion
Hello I have the following php code which I need to convert into coldfusion... preg_match_all('#\{(([a-z0-9\-_]+?\.)+?)([a-z0-9\-_]+?)\}#is', $code, $varrefs); $varcount = sizeof($varrefs[1]); for ($i = 0; $i < $varcount; $i++) { $namespace = $varrefs[1][$i]; $varname = $varrefs[3][$i]; $new = $this->generate_block_varref($namespace, $varname); $code = str_replace($varrefs[0][$i], $new, $code); } I've used the reGet udf off cflib and ive got it to: reGet(code,'\{(([a-z0-9\-_]+?\.)+?)([a-z0-9\-_]+?)\}')> ReReplace(varrefs[i],'\{(([a-z0-9\-_]+?\.)+?)([a-z0-9\-_]+?)\}','\1')> ReReplace(varrefs[i],'\{(([a-z0-9\-_]+?\.)+?)([a-z0-9\-_]+?)\}','\3')> It supposed to take variables within a template such as {T_FONT_COLOR} and replace them with a value, but it doesn¹t seem to be picking them up right. Im thinking its a problem with the regex, but I'm not too hot on them... Can somebody point me in the right direction?? Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JJ Allaire?
Jeremiah Jonah. He was named after a famous newspaper editor. M -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 6:01 PM To: CF-Talk Subject: OT: JJ Allaire? Does anyone know what JJ Allaire'es full name is (ie what is JJ short for). I saw it somewhere years ago but can't remember what it is. Also any ColdFusion trivia tidbits? Thanks! Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multipe file uploads
it sure is:) > Is it possible to upload several files through one from with multiple > file fields, ala AspUpload? Thanks! > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: RE: JJ Allaire?
You should ask JJ what it stands for! Did you ever watch M*A*S*H ? Hawkeye spent a whole episode trying to find out what "B.J." stands for in Hunnicutt's name. He finally finds that his birth certificate says "B.J." Sorry none of us could help with this one. Jevo (who is also known by her initials) -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:32 AM To: CF-Talk Subject: RE: JJ Allaire? Hey ppl - this was a serious request. JJ it must be if the best anyone can "prove" is Jumping Jellybeans. As I am not allowed to laugh at work, or have fun of any sort, this response was most distressing. I myself have always known JJ as JJ and admire him to a high degree - but as tasked with converting developers to CF and telling it's history I thought it would be nice to know for when the casual smart-arse "What does JJ stand for?" question crops up. Would be nice for the rest of us to for trivia sake. I know that Jeremy has moved on to other things but WTF is JJ up to these days? Regards, Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 19 November 2003 10:01 AM To: CF-Talk Subject: OT: JJ Allaire? Does anyone know what JJ Allaire'es full name is (ie what is JJ short for). I saw it somewhere years ago but can't remember what it is. Also any ColdFusion trivia tidbits? Thanks! Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Important: This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament. If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: RE: JJ Allaire?
Ok. It is actually Joey Joe Jeneau Shabadoo. - Original Message - From: Peter Tilbrook <[EMAIL PROTECTED]> Date: Wednesday, November 19, 2003 1:32 am Subject: RE: JJ Allaire? > Hey ppl - this was a serious request. JJ it must be if the best > anyone can > "prove" is Jumping Jellybeans. As I am not allowed to laugh at > work, or have > fun of any sort, this response was most distressing. I myself have > alwaysknown JJ as JJ and admire him to a high degree - but as > tasked with > converting developers to CF and telling it's history I thought it > would be > nice to know for when the casual smart-arse "What does JJ stand for?" > question crops up. Would be nice for the rest of us to for trivia > sake. > I know that Jeremy has moved on to other things but WTF is JJ up > to these > days? > > Regards, > Peter Tilbrook > ColdFusion Applications Developer > ColdGen Internet Solutions > Manager, ACT and Region ColdFusion Users Group - > http://www.actcfug.com4/73 Tharwa Road > Queanbeyan, NSW, 2620 > AUSTRALIA > > Telephone: +61-2-6284-2727 > Mobile: +61-0439-401-823 > E-mail: [EMAIL PROTECTED] > > World Wide Web: http:/www.coldgen.com/ > > -Original Message- > From: [EMAIL PROTECTED] > [EMAIL PROTECTED] > Sent: Wednesday, 19 November 2003 10:01 AM > To: CF-Talk > Subject: OT: JJ Allaire? > > > Does anyone know what JJ Allaire'es full name is (ie what is JJ > shortfor). > I saw it somewhere years ago but can't remember what it is. > > Also any ColdFusion trivia tidbits? > > Thanks! > > Peter Tilbrook > Transitional Services - Enterprise eSolutions > Centrelink (http://www.centrelink.gov.au) > 2 Faulding Street > Symonston ACT 2609 > > Tel: (02) 62115927 > > > > Important: This e-mail is intended for the use of the addressee > and may > contain information that is confidential, commercially valuable or > subjectto legal or parliamentary privilege. If you are not the > intended recipient > you are notified that any review, re-transmission, disclosure, use or > dissemination of this communication is strictly prohibited by several > Commonwealth Acts of Parliament. If you have received this > communication in > error please notify the sender immediately and delete all copies > of this > transmission together with any attachments. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multipe file uploads
Yeah, you bet. Just need a CFFILE ACTION="" for each file field. _ From: stas [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:54 PM To: CF-Talk Subject: Multipe file uploads Is it possible to upload several files through one from with multiple file fields, ala AspUpload? Thanks! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Which Authorize.net tag/CFX?
I was very pleased with cfx_aim from Al Nichols of cfxworks (available in the MM exchange), especially the utility he gives you to encode the authnet password into the tag. It is currently only for Windows, but he's working on java versions of much of his stuff now, and I can't wait. Carol Chandler At 09:43 AM 11/19/2003, you wrote: >Could anyone comment on their experiences with available tags? > >Thanks! > > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: connecting tables from multiple databases
You can reference across dbs db1..table.column is the syntax I think. That should plug in any query as needed; I think you can alias it to keep things clean as well. -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 1:51 PM To: CF-Talk Subject: connecting tables from multiple databases This is not really a CF question, but I notice that people have posted SQL questions before and nobody minded that. I have an employee table in database A, I am using it in database A but now I also want to use it in database B. I.e. I want to include its primary key as a foreign key in tables that are part of database B (and the other way as well). I am not sure how I go about that or whatever it is possible to do. So far the only solution I can think of is to duplicate employee table inside database B and keep it in synch with employee table inside A. For that I don't know how to implement some MS SQL server 2000 based synchronization (I don't really want to have to schedule/call a CF template once a while that does the synchronization). I hope I am making some sense her, I am much better with CF than SQL. Thanks for any help, Best Wishes, Tom Kitta Advanced ColdFusion Programmer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Multipe file uploads
Is it possible to upload several files through one from with multiple file fields, ala AspUpload? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JJ Allaire?
J.J. stands for "Joseph J." and I can't figure out what the middle name is, but that should get you further along. http://corp.sec.state.ma.us/corp/corpsearch/CorpSearchSummary.asp?ReadFr omDB=True&UpdateAllowed=&FEIN=411830792 Or if wrapping is a problem: http://tinyurl.com/vq8y I would imagine that any legal documentation available through the Commonwealth of Massachusetts would have his full legal name, but I'm not going to do that much legwork for you. Happy searching, Bill Brown http://www.bbrown.info/ -Original Message- From: Peter Tilbrook Sent: 11/19/03 1:32 AM Subject: RE: JJ Allaire? Hey ppl - this was a serious request. JJ it must be if the best anyone can "prove" is Jumping Jellybeans. As I am not allowed to laugh at work, or have fun of any sort, this response was most distressing. I myself have always known JJ as JJ and admire him to a high degree - but as tasked with converting developers to CF and telling it's history I thought it would be nice to know for when the casual smart-arse "What does JJ stand for?" question crops up. Would be nice for the rest of us to for trivia sake. I know that Jeremy has moved on to other things but WTF is JJ up to these days? Regards, Peter Tilbrook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Timezone capture
If you record/store everything in the same time zone (UTC for example) then everything will be correct. You simply do the time zone conversion before you display the data to the user's screen. I might post something at 2pm my time (PST) but it's really being posted 5pm eastern time (EST). But when I surf the site, all times are shown according to MY time zone. -Novak -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:41 AM To: CF-Talk Subject: Timezone capture This was mentioned earlier I think but I would like to add a brief comment. It is Wednesday, 19 November, about 19:40 here in Australia. Yet when I blogged on Sean Corfields blog (http://www.corfield.org/blog) it is about 8 hours behind - about right. What do others think about the discrepancy of "hey I posted this 8 hours after your website states". I actually have sites hosted in the US so it works backwards. Any suggestions? Regards, Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JJ Allaire?
Hey ppl - this was a serious request. JJ it must be if the best anyone can "prove" is Jumping Jellybeans. As I am not allowed to laugh at work, or have fun of any sort, this response was most distressing. I myself have always known JJ as JJ and admire him to a high degree - but as tasked with converting developers to CF and telling it's history I thought it would be nice to know for when the casual smart-arse "What does JJ stand for?" question crops up. Would be nice for the rest of us to for trivia sake. I know that Jeremy has moved on to other things but WTF is JJ up to these days? Regards, Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 19 November 2003 10:01 AM To: CF-Talk Subject: OT: JJ Allaire? Does anyone know what JJ Allaire'es full name is (ie what is JJ short for). I saw it somewhere years ago but can't remember what it is. Also any ColdFusion trivia tidbits? Thanks! Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Important: This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament. If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Trapping COM Errors - MSXML
FYI, I came across the below information in the ColdFusion forums that seems related to my MSXML problems. Are there any alternatives or patches to winhttp? [begin snip] I've been able to isolate part of the timeout problem with ServerXMLHTTP as it pertains to the winhttp stack. Because ServerXMLHTTP uses winhttp and winsock to open and send data, when the server you're sending data TO does not respond or even does not exist, winsock and winhttp will timeout but NOT return anything to ColdFusion Server. This results in an open thread on ColdFusion that will eventually cause it to hang. I've traced the winhttp stack with the winhttp 5.0 sdk and can see that timeout does occur: 16:20:45.322 ::*Session* :: winhttp Version 5.0 Build 5.0.2613 Sep 7 2001 04:26:33Process cfserver.exe [1996 (0x7cc)] started at 16:20:45.312 07/07/2002 16:20:49.327 ::*001* :: Winsock/RPC/SSL/Transport error: 0x2ee2 [ERROR_WINHTTP_TIMEOUT] 16:20:49.327 ::*001* :: winhttpSendRequest: error 12002 [ERROR_WINHTTP_TIMEOUT] [end snip] Thank you, Mike Chabot [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Timezone capture
This was mentioned earlier I think but I would like to add a brief comment. It is Wednesday, 19 November, about 19:40 here in Australia. Yet when I blogged on Sean Corfields blog (http://www.corfield.org/blog) it is about 8 hours behind - about right. What do others think about the discrepancy of "hey I posted this 8 hours after your website states". I actually have sites hosted in the US so it works backwards. Any suggestions? Regards, Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
using cffile to set privs (cloodge)
I am using: ... to make a file writeable... it works much of the time, but not consistently sometimes I get: Attribute validation error for tag CFFILE. The value of the attribute source, which is currently "...", is invalid. The thing is, I can copy the path string out and put it into a windows explorer and it works... Can anyone think of what else it might be? Thank you! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Quick question- give text area focus
You need to use _javascript_ in order for this to work. I think it is something like or place it inside href=""> document.yourFormName.yourTextAreaName.focus();" I am not an expert in JS but that should do the trick. TK -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:41 PM To: CF-Talk Subject: Quick question- give text area focus I have a page that the users wanted multiple textarea fields that could be spell checked. They also wanted to be able to review all of their previous work as they were submitting it AND for the page to advance to the next box. To do that plus to keep it from being a mess of huge textarea boxes (2000 characters/each one) I made it so that it is a page of links Link1 blah blah info for users to read whats in this section Link2 blah blah info for users to read whats in this section Link3 blah blah info for users to read whats in this section Link4 blah blah info for users to read whats in this section If a user clicks on Link2- link2 becomes a textarea box while all the other links look exactly the same. (So only one thing is editable at a time). When the user saves the information in the textarea box of link2 it is saved then the user is returned to find Link3 now a textarea to be edited. Looks good/saves space/easy to use. 1 problem though. I'd like the cursor to automatically be in the textarea box. So they click save and the new textarea shows up- the cursor is there and they just have to start typing. Right now they have to always click in the box before typing. Is there any way to do that? TIA, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
connecting tables from multiple databases
This is not really a CF question, but I notice that people have posted SQL questions before and nobody minded that. I have an employee table in database A, I am using it in database A but now I also want to use it in database B. I.e. I want to include its primary key as a foreign key in tables that are part of database B (and the other way as well). I am not sure how I go about that or whatever it is possible to do. So far the only solution I can think of is to duplicate employee table inside database B and keep it in synch with employee table inside A. For that I don't know how to implement some MS SQL server 2000 based synchronization (I don't really want to have to schedule/call a CF template once a while that does the synchronization). I hope I am making some sense her, I am much better with CF than SQL. Thanks for any help, Best Wishes, Tom Kitta Advanced ColdFusion Programmer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Quick question- give text area focus
I have a page that the users wanted multiple textarea fields that could be spell checked. They also wanted to be able to review all of their previous work as they were submitting it AND for the page to advance to the next box. To do that plus to keep it from being a mess of huge textarea boxes (2000 characters/each one) I made it so that it is a page of links Link1 blah blah info for users to read whats in this section Link2 blah blah info for users to read whats in this section Link3 blah blah info for users to read whats in this section Link4 blah blah info for users to read whats in this section If a user clicks on Link2- link2 becomes a textarea box while all the other links look exactly the same. (So only one thing is editable at a time). When the user saves the information in the textarea box of link2 it is saved then the user is returned to find Link3 now a textarea to be edited. Looks good/saves space/easy to use. 1 problem though. I'd like the cursor to automatically be in the textarea box. So they click save and the new textarea shows up- the cursor is there and they just have to start typing. Right now they have to always click in the box before typing. Is there any way to do that? TIA, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: getRowCount() differences
Because I need the number of rows the query is returning not a count of all the items. Because the part numbers are being grouped so we only display one part number and how many clicks that particular part number gets if I used recordcount it would give me all the records returned. Ben -Original Message- From: Patricia G. L. Hall [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 10:14 AM To: CF-Talk Subject: Re: getRowCount() differences > Is there a difference in the getRowCount() method between CF 5 and MX > 6.1? We just upgraded our development server to MX but our live server > is still at 5 for the time being. I was using getRowCount() to count the > rows in my query which worked great on the development server but when I > uploaded to the live server it get an error message that getRowCount is > not present in my query, so I looked in the docs in 5 and it says > getRowCount() is to be used with a wddx packet. > > Ben I can't answer the question about getRowCount(), but why aren't you using recordcount... as in myquery.recordcount? -Patti _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: getRowCount() differences
> Is there a difference in the getRowCount() method between CF 5 and MX > 6.1? We just upgraded our development server to MX but our live server > is still at 5 for the time being. I was using getRowCount() to count the > rows in my query which worked great on the development server but when I > uploaded to the live server it get an error message that getRowCount is > not present in my query, so I looked in the docs in 5 and it says > getRowCount() is to be used with a wddx packet. > > Ben I can't answer the question about getRowCount(), but why aren't you using recordcount... as in myquery.recordcount? -Patti [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Scheduled Tasks
I have a scheduled task set up to check the database to see if we have any mass mailings pending to go out at that time, then cfmail is used to handle the mailing, and finally the database is updated so the mailing is marked as sent. My question is how do I handle potential problems...I'm not terribly worried about the database going down because the mailing will still be considered unsent and will go out the next time the task is executed. But, suppose the mail server is down, will a try/catch block handle that, even though it's not a programming problem? Will cfmail error if there is a mail server problem, and if so how do you handle a situation where maybe half of your mail went out prior to the server going down? The "to" emails are read from an uploaded text file so it's not like there's an easy way to flag the database at the point of failure. And what if it's a scheduler error---how would I ever know the emails weren't going out, other than to make sure I always have them cc the sender? Thanks in advance for any advice. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Which Authorize.net tag/CFX?
Hi Stas, We have had good experiences with an updated version (see below) of CF_Authorize_Net_3 by Frank Banks, available in the Developer's Exchange. Tried and true, this includes the collective experience of our staff and hosting customers over several years. Granted, in that time, we have discovered and corrected a couple of bugs in the tag and I don't see that Frank has uploaded anything since, so you're welcome to our updated copy if you'd like me to zip it on over to you. If I recall, the two tweaks corrected for a missing zipcode field (affecting those who employ strict AVS) and an improper CF list function which choked when AuthorizeNet returned an empty field (rare -- affects only AUTH_ONLY transactions, I believe, which are seldom used in website transactions). If there weren't already so many AuthorizeNet tags in the Developer's Exchange, I might comment our modifications and upload the new version. Any point? Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 stas wrote: > > Could anyone comment on their experiences with available tags? > > Thanks! > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REPOST: Creating "treeview" structure using
IS the book called "Advanced ColdFUsion 4.0 Application Development" by QUE? --Original Message Text--- From: J E VanOver Date: Wed, 19 Nov 2003 10:31:05 -0800 There are many excellent examples of using CFFILE and CFFTP in all versions of Ben Forta's CFWACK. His books can be bought for less than $5 on Amazon. I can't recommend highly enough that anyone programming ColdFusion should own at least ONE copy of this book. Many of the answers you seek are there. J -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:31 AM To: CF-Talk Subject: REPOST: Creating "treeview" structure using ONE IS REPLYING??? Hi, Is it possible to create a "treeview" structure using the following and by clicking on the directory will drilldown? + dir1 + dir2 + dir3 + dir4 Click on "dir2" + dir2 + subdir1 + subdir2 file1 file1 file1 I've done something similar using on how to achive this using Pleasesomeone help George Bush! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PayPal...
Thanks -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 1:20 PM To: CF-Talk Subject: RE: PayPal... easycfm.com has a tutorial -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:21 PM To: CF-Talk Subject: PayPal... Does anyone have info on using PayPal with Cold Fusion, is it easy, hard, etc .etc. Any free tags out there and the such or links? Thanks, Stephen _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REPOST: Creating "treeview" structure using
There are many excellent examples of using CFFILE and CFFTP in all versions of Ben Forta's CFWACK. His books can be bought for less than $5 on Amazon. I can't recommend highly enough that anyone programming ColdFusion should own at least ONE copy of this book. Many of the answers you seek are there. J -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:31 AM To: CF-Talk Subject: REPOST: Creating "treeview" structure using ONE IS REPLYING??? Hi, Is it possible to create a "treeview" structure using the following and by clicking on the directory will drilldown? + dir1 + dir2 + dir3 + dir4 Click on "dir2" + dir2 + subdir1 + subdir2 file1 file1 file1 I've done something similar using on how to achive this using Pleasesomeone help George Bush! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PayPal...
easycfm.com has a tutorial -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:21 PM To: CF-Talk Subject: PayPal... Does anyone have info on using PayPal with Cold Fusion, is it easy, hard, etc .etc. Any free tags out there and the such or links? Thanks, Stephen _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cftag for Zipping
These will work on CFMX 6.1, any OS: zip: http://www.cflib.org/udf.cfm?ID=744 unzip: http://www.rewindlife.com/archives/41.cfm btw, both of these are on cflib.org--it's a good resource for udf's. Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- > -Original Message- > From: BOUDOT Christian [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2003 8:53 AM > To: CF-Talk > Subject: cftag for Zipping > > Hi, > > Does anyone have a cftag for zipping files witch works on a SUN? > > many thanks > > Chris > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PayPal...
Does anyone have info on using PayPal with Cold Fusion, is it easy, hard, etc .etc. Any free tags out there and the such or links? Thanks, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:REPOST: Creating
I'll agree with Steven on this one for the most part. CFTP is for moving files from/to an FTP server to a Cold Fusion Server. To put it in another way, the Cold Fusion Server is the client and some FTP server out there is the server! There is a list function within FTP, however in my experiance its been flackey at best. (I've assumed that you've opened the connection, locked the connection and commands with CFLOCK and trapped the statements with a try/catch block and checked for error codes) Once you've closed the connection you can do the following: #name# #path# #URL# #length# DirectoryFile (Code modified from Programing Cold Fusion Page 407-409) Jeremy Brodie Intelix an Edgewater Technology Solutions Company web: http://www.edgewater.com phone:(703) 815-2500 nasdaq symbol: EDGE >Bushy, > >I don't think what you are asking is possible. Unless in your cfftp you >loop through and get the directories and subdirectories first and then >display them in the tree form. > >Could you post your cfdirectory code and I will see if I can come up with >something. > >Steve > > >-Original Message- >From: Bushy [mailto:[EMAIL PROTECTED] >Sent: Wednesday, November 19, 2003 7:31 AM >To: CF-Talk >Subject: REPOST: Creating "treeview" structure using >IS REPLYING??? > > >Hi, > >Is it possible to create a "treeview" structure using >following and by clicking on the directory will drilldown? > >+ dir1 >+ dir2 >+ dir3 >+ dir4 > >Click on "dir2" > >+ dir2 > + subdir1 > + subdir2 > file1 > file1 > file1 > >I've done something similar using >how to achive this using > >Pleasesomeone help George Bush! > > > > _ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
it's my IE6.0 Browser error ?
Hi all: Some times when i trying to make chart using cfchart tag i can't see the image/flash as a result in the browser however in the CFusionMX\charting\cache the files are created... Regards, -- M.Sc. Hassan Arteaga Rodríguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
it's my IE6.0 Browser error ?
Hi all: Some times when i trying to make chart using cfchart tag i can't see the image/flash as a result in the browser however in the CFusionMX\charting\cache the files are created... Regards, -- M.Sc. Hassan Arteaga Rodríguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
getRowCount() differences
Is there a difference in the getRowCount() method between CF 5 and MX 6.1? We just upgraded our development server to MX but our live server is still at 5 for the time being. I was using getRowCount() to count the rows in my query which worked great on the development server but when I uploaded to the live server it get an error message that getRowCount is not present in my query, so I looked in the docs in 5 and it says getRowCount() is to be used with a wddx packet. Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array Sum
Thanks Patti that worked. Ben -Original Message- From: Patricia G. L. Hall [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 8:44 AM To: CF-Talk Subject: RE: Array Sum > Yeah I didn't realize I was recreating the array at every iteration, > that was an oversight. clicks_per_product.click[i] is a query but I > thought by putting setting prodLinkTotal which is an array to > clicks_per_product.click[i] would turn that into an array? I can get the > values I need just can't seem to add them together. Any ideas? > try arraysum(listtoarray(valuelist(clicks_per_product.click))) -Patti _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array Sum
> Yeah I didn't realize I was recreating the array at every iteration, > that was an oversight. clicks_per_product.click[i] is a query but I > thought by putting setting prodLinkTotal which is an array to > clicks_per_product.click[i] would turn that into an array? I can get the > values I need just can't seem to add them together. Any ideas? > try arraysum(listtoarray(valuelist(clicks_per_product.click))) -Patti [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array Sum
Steven, The arrayappend function doesn't like the clicks_per_product.click[i], it's treating it as a Boolean value and I'm not sure why when it is actually a number. Ben -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:08 PM To: CF-Talk Subject: RE: Array Sum Ben, First, you should be creating the array outside of the loop. Next, you are always displaying the sum of the current position of the array not a sum of the whole array. I think that this should work better. clicks_per_product.click[i])> #arraySum(prodLinkTotal)# Steve -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 11:51 AM To: CF-Talk Subject: Array Sum Can someone tell me why this won't work correctly. I have the following code #ArraySum(prodLinkTotal[i])# Rightnow the clickcount is at 4 so if I output just prodLinkTotal[i] I get the total number of clicks for each product(303 289 95 89). I now need to add these up and thought ArraySum() would do it but I keep getting this error: Object of type class java.lang.Integer cannot be used as an array Is there a better way to accomplish this? Thanks, Ben _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array Sum
Yeah I didn't realize I was recreating the array at every iteration, that was an oversight. clicks_per_product.click[i] is a query but I thought by putting setting prodLinkTotal which is an array to clicks_per_product.click[i] would turn that into an array? I can get the values I need just can't seem to add them together. Any ideas? Ben -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:08 PM To: CF-Talk Subject: RE: Array Sum Why are you re-creating the array every iteration of the loop? Also, is clicks_per_product.click[i] an array? if not, then you can't ArraySum it -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 11:51 AM To: CF-Talk Subject: Array Sum Can someone tell me why this won't work correctly. I have the following code #ArraySum(prodLinkTotal[i])# Rightnow the clickcount is at 4 so if I output just prodLinkTotal[i] I get the total number of clicks for each product(303 289 95 89). I now need to add these up and thought ArraySum() would do it but I keep getting this error: Object of type class java.lang.Integer cannot be used as an array Is there a better way to accomplish this? Thanks, Ben _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How are UDFs referenced/created...
I'm trying something new out for all my UDFs and I wanted to get a little feedback if I could... I just started loading all my UDFs into a structure in the application scope called UDFs. So that if I wanted to call GetFileSizeFormat, I would do: #application.UDFs.GetFileSizeFormat(123456)# The benefits to this, of course, is that if I have 1 or 1000 visitors to my site within the cfapplication applicationtimeout, I should only have to load each UDFs once (on the first request), instead of 1 time for every page for every visitor. So if I have 1000 visitors who hit or refresh pages on average 10 times, the UDFs will load 1 time vs 10,000 times. And the cons against this are increased application scope management (loading and locking), and the extra long reference I now have to include on every UDF (which could be interpreted as forced scoping and organization, and therefore a pro for this method.) I remember reading something about CFMX 6.0 or 6.1 greatly speeding up UDFs, CustomTags, etc instantiation. So I'm not even sure if this is doing anything in the larger scope of things. I'm getting ready to get start developing on my current project and I'd like to make a final decision for future projects as to whether this is a good idea, or even necessary...and feedback would be appreciated-> Tyler Silcox P.S. I know this is purely for optimization sake, and that it probably wouldn't greatly affect my application's performance either way. But I would like to know which way is "best", because it is going to affect just about every part of my development... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REPOST: Creating "treeview" structure using
Bushy, I don't think what you are asking is possible. Unless in your cfftp you loop through and get the directories and subdirectories first and then display them in the tree form. Could you post your cfdirectory code and I will see if I can come up with something. Steve -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:31 AM To: CF-Talk Subject: REPOST: Creating "treeview" structure using IS REPLYING??? Hi, Is it possible to create a "treeview" structure using following and by clicking on the directory will drilldown? + dir1 + dir2 + dir3 + dir4 Click on "dir2" + dir2 + subdir1 + subdir2 file1 file1 file1 I've done something similar using how to achive this using Pleasesomeone help George Bush! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array Sum
Ben, First, you should be creating the array outside of the loop. Next, you are always displaying the sum of the current position of the array not a sum of the whole array. I think that this should work better. clicks_per_product.click[i])> #arraySum(prodLinkTotal)# Steve -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 11:51 AM To: CF-Talk Subject: Array Sum Can someone tell me why this won't work correctly. I have the following code #ArraySum(prodLinkTotal[i])# Rightnow the clickcount is at 4 so if I output just prodLinkTotal[i] I get the total number of clicks for each product(303 289 95 89). I now need to add these up and thought ArraySum() would do it but I keep getting this error: Object of type class java.lang.Integer cannot be used as an array Is there a better way to accomplish this? Thanks, Ben _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array Sum
Why are you re-creating the array every iteration of the loop? Also, is clicks_per_product.click[i] an array? if not, then you can't ArraySum it -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 11:51 AM To: CF-Talk Subject: Array Sum Can someone tell me why this won't work correctly. I have the following code #ArraySum(prodLinkTotal[i])# Rightnow the clickcount is at 4 so if I output just prodLinkTotal[i] I get the total number of clicks for each product(303 289 95 89). I now need to add these up and thought ArraySum() would do it but I keep getting this error: Object of type class java.lang.Integer cannot be used as an array Is there a better way to accomplish this? Thanks, Ben _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Array Sum
Can someone tell me why this won't work correctly. I have the following code #ArraySum(prodLinkTotal[i])# Rightnow the clickcount is at 4 so if I output just prodLinkTotal[i] I get the total number of clicks for each product(303 289 95 89). I now need to add these up and thought ArraySum() would do it but I keep getting this error: Object of type class java.lang.Integer cannot be used as an array Is there a better way to accomplish this? Thanks, Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IE6.0 Error!!
Microsoft Developer Network ..i'm talking about the last action i made in my PC after that IE 6.0 in Cold Fusion Administrator send me error. Regards -- M.Sc. Hassan Arteaga Rodríguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 10:41 AM To: CF-Talk Subject: RE: IE6.0 Error!! You installed MSDN? Can you clarify what you mean by that, do you mean MSDE? -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: 19 November 2003 17:29 To: CF-Talk Subject: IE6.0 Error!! I installed MSDN in my PC with IE6.0. Now when i try to access to the left frame in ColdFusion Administrator i got an error message. I can't remember where i read about it.who can help me to remember? Regards, -- M.Sc. Hassan Arteaga Rodríguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Active Directory LDAP and Security on Windows 2003
I am trying to follow the process set up by Macromedia to authenticate on an active directory through LDAP on a Windows 2003 server. Does anyone know if any security needs to be changed in order to authenticate on it? I am having issues getting a domain user to authenticate. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IE6.0 Error!!
You installed MSDN? Can you clarify what you mean by that, do you mean MSDE? -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: 19 November 2003 17:29 To: CF-Talk Subject: IE6.0 Error!! I installed MSDN in my PC with IE6.0. Now when i try to access to the left frame in ColdFusion Administrator i got an error message. I can't remember where i read about it.who can help me to remember? Regards, -- M.Sc. Hassan Arteaga Rodríguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: AOL and Macromedia and AIM-ICQ
Yes, I think that's awesome...especially since IM is seeping deeper and deeper into our workflow. Great news. Stace _ From: Mike Brunt [mailto:[EMAIL PROTECTED] Sent: November 19, 2003 11:16 AM To: CF-Talk Subject: AOL and Macromedia and AIM-ICQ I just came across this article on C-Net, "Macromedia developers get a shot at AIM". It revolves around Macromedia Central which if you have not tried yet is well worth a look. What with Flex and now this MM are really giving us many opportunities to prosper IMHO. http://rss.com.com/2100-1032_3-5109001.html?part=rss&tag=feed&subj=news Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IE6.0 Error!!
I installed MSDN in my PC with IE6.0. Now when i try to access to the left frame in ColdFusion Administrator i got an error message. I can't remember where i read about it.who can help me to remember? Regards, -- M.Sc. Hassan Arteaga Rodríguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Installing ImageMagick
Well, you need to call it via , so if they have it installed, that probably just means they have it unzipped in a directory somewhere. Ask them where it is and if you have access to it... If not, you could upload it with your site. It's just a bunch of EXE files and some extra library files. On windows it's about 120 files at 7 MB, on unix it's only like 30 files. You don't have to register it with coldfusion like a CFX tag, you just call it, pass it arguments and expect a result. Here's my only Imagemagick bookmark: http://www.imagemagick.org/www/utilities.html (if it shows up as only a couple pages of info, reload it, there's something screwy with their web server) -nathan strutz -Original Message- From: John Burns [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:41 AM To: CF-Talk Subject: Installing ImageMagick Does anyone know of any instructions for installing ImageMagick for CF? I'm new to using external libraries and the only one I've installed before is ImageJ which came with CF instructions. If someone could let me know what I need to do (if anything) for CF to see the ImageMagick install and then how I would access ImageMagick via CF 5. I'm waiting on my host for CFMX. They say they already have imageMagick installed on their servers, I'm just not sure if it needs to be "installed" into CF or if I can reference it from where it already is. Any information would be helpful. Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and Java integration..
Thanks a lot !! -- M.Sc. Hassan Arteaga Rodríguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 3:09 AM To: CF-Talk Subject: RE: CF and Java integration.. Not specific to CFMX< but have a look at http://javaalmanac.com/egs/? Some very useful examples. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: 18 November 2003 22:26 To: CF-Talk Subject: CF and Java integration.. Hi all: I'm looking for a Java reference in PDF or chm format about the most used packages and short examples. I'd like to start develop some examples with CF MX 6.1 using java classes. Just to start !!! *in CFLib.org it's a good example how to implement zip features with java.util.zip package Regards, -- M.Sc. Hassan Arteaga Rodríguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
AOL and Macromedia and AIM-ICQ
I just came across this article on C-Net, Macromedia developers get a shot at AIM. It revolves around Macromedia Central which if you have not tried yet is well worth a look. What with Flex and now this MM are really giving us many opportunities to prosper IMHO. http://rss.com.com/2100-1032_3-5109001.html?part=rss&tag=feed&subj=news Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with Dates and Access
Thanks :) - Original Message - From: Pascal Peters To: CF-Talk Sent: Wednesday, November 19, 2003 10:56 AM Subject: RE: Problem with Dates and Access Yes, should work -Oorspronkelijk bericht- Van: Mickael [mailto:[EMAIL PROTECTED] Verzonden: wo 19/11/2003 15:40 Aan: CF-Talk CC: Onderwerp: Re: Problem with Dates and Access And then just mask the display on the website? - Original Message - From: Pascal Peters To: CF-Talk Sent: Wednesday, November 19, 2003 9:40 AM Subject: RE: Problem with Dates and Access No dateformat. Just do CreateODBCDate(Now()) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Trapping COM Errors - MSXML
Our ColdFusion 5 server has been restarting once per day because it is set to "Restart when requests terminate abnormally." I tracked down the error to the MSXML COM object, which behaves similar to CFHTTP. Occasionally, when it does not receive a response from the server it is calling, it throws an error that triggers a ColdFusion restart. The specific COM object being used is "Msxml2.ServerXMLHTTP.4.0" and the specific function is "send(xml)." When I turn off the ColdFusion restarting feature, the error that displays on the screen is: "unknown exception condition-unknown error while executing a tag." Using try/catch blocks to catch "Any" exception does not catch the error. The request error handler seems to pick it up, but the request error handler is not the ideal place to recover from this type of error. Is there a better way to trap this COM object error? Thank you, Mike Chabot [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Problem with Dates and Access
Yes, should work -Oorspronkelijk bericht- Van: Mickael [mailto:[EMAIL PROTECTED] Verzonden: wo 19/11/2003 15:40 Aan: CF-Talk CC: Onderwerp: Re: Problem with Dates and Access And then just mask the display on the website? - Original Message - From: Pascal Peters To: CF-Talk Sent: Wednesday, November 19, 2003 9:40 AM Subject: RE: Problem with Dates and Access No dateformat. Just do CreateODBCDate(Now()) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Sheduled Tasks
Hello All, Is there a way to set a scheduled task to run once a month on the last day of the month. How is this done using the CF5 admin? TIA Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Which Authorize.net tag/CFX?
Could anyone comment on their experiences with available tags? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Inappropriate Authentication
Trying to get CFMX 6.1 to talk to ActiveDirectory and I get the above error. Since I do not control the AD setup what do I need to tell our admin in order to get this to work? Thanks! - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with Dates and Access
And then just mask the display on the website? - Original Message - From: Pascal Peters To: CF-Talk Sent: Wednesday, November 19, 2003 9:40 AM Subject: RE: Problem with Dates and Access No dateformat. Just do CreateODBCDate(Now()) -Oorspronkelijk bericht- Van: Mickael [mailto:[EMAIL PROTECTED] Verzonden: wo 19/11/2003 15:26 Aan: CF-Talk CC: Onderwerp: Problem with Dates and Access Hello All, I am having a little problem with writing a date in the format mm/dd/ to an access database. I have a text file that is uploaded to a server which I insert into a database, the file fields are is importing properly there is one field in my database for when the file is run. So I do this some code some code When I do this #PreserveSingleQuotes(sqlstring)# And view the SQL on the screen the date is fine but when I display it from the database I get 1899/12/30 , I also tried #dateformat(createODBCDate(now(),"mm/dd/"))# but I get errors. Can someone point me in the right direction? Thanks Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Installing ImageMagick
Does anyone know of any instructions for installing ImageMagick for CF? I'm new to using external libraries and the only one I've installed before is ImageJ which came with CF instructions. If someone could let me know what I need to do (if anything) for CF to see the ImageMagick install and then how I would access ImageMagick via CF 5. I'm waiting on my host for CFMX. They say they already have imageMagick installed on their servers, I'm just not sure if it needs to be "installed" into CF or if I can reference it from where it already is. Any information would be helpful. Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Problem with Dates and Access
No dateformat. Just do CreateODBCDate(Now()) -Oorspronkelijk bericht- Van: Mickael [mailto:[EMAIL PROTECTED] Verzonden: wo 19/11/2003 15:26 Aan: CF-Talk CC: Onderwerp: Problem with Dates and Access Hello All, I am having a little problem with writing a date in the format mm/dd/ to an access database. I have a text file that is uploaded to a server which I insert into a database, the file fields are is importing properly there is one field in my database for when the file is run. So I do this some code some code When I do this #PreserveSingleQuotes(sqlstring)# And view the SQL on the screen the date is fine but when I display it from the database I get 1899/12/30 , I also tried #dateformat(createODBCDate(now(),"mm/dd/"))# but I get errors. Can someone point me in the right direction? Thanks Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem with Dates and Access
Hello All, I am having a little problem with writing a date in the format mm/dd/ to an access database. I have a text file that is uploaded to a server which I insert into a database, the file fields are is importing properly there is one field in my database for when the file is run. So I do this some code some code When I do this #PreserveSingleQuotes(sqlstring)# And view the SQL on the screen the date is fine but when I display it from the database I get 1899/12/30 , I also tried #dateformat(createODBCDate(now(),"mm/dd/"))# but I get errors. Can someone point me in the right direction? Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: kloodge
rename with attributes="normal" does the trick on windows: source="#GetCurrentTemplatePath()#" destination="#GetCurrentTemplatePath()#" attributes="Normal"> Not sure if thats a "kloodge"... Bert > -Original Message- > From: Kyle McNamara [mailto:[EMAIL PROTECTED] > Sent: 18 November 2003 20:49 > To: CF-Talk > Subject: kloodge > > > hey, > does anyone have ideas about how to cloodge the process of > making a file writeable? > i thought about renaming it to itself or something... > thanks, > k > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Query to structure
There's also a UDF on cflib.org that does this. -d - Original Message - From: "Ryan Mitchell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 19, 2003 7:14 AM Subject: Re: Query to structure > Thanks :) > > On 19/11/03 12:51 pm, "Tim Blair" <[EMAIL PROTECTED]> wrote: > > > Ryan, > > > >> > I want to take the query and convert it to a structure, with > >> > the key being the column name and the value being the value > >> > of the column... > > > > Simply loop over the column list: > > > > > > > > > > > > > > Tim. > > > > --- > > RAWNET LTD - Internet, New Media and ebusiness Gurus. > > Visit our new website at http://www.rawnet.com for > > more information about our company, or call us free > > anytime on 0800 294 24 24. > > --- > > Tim Blair > > Web Application Engineer, Rawnet Limited > > Direct Phone : +44 (0) 1344 393 441 > > Switchboard : +44 (0) 1344 393 040 > > --- > > This message may contain information which is legally > > privileged and/or confidential. If you are not the > > intended recipient, you are hereby notified that any > > unauthorised disclosure, copying, distribution or use > > of this information is strictly prohibited. Such > > notification notwithstanding, any comments, opinions, > > information or conclusions expressed in this message > > are those of the originator, not of rawnet limited, > > unless otherwise explicitly and independently indicated > > by an authorised representative of rawnet limited. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: OO Design
There is no relational model yet. There's only thoughts and a few rough diagrams on paper. So, it's not "too late" for anything. The "hours/funny money vs. consumables" thing is just coming from our use-case type discussions. They seem vastly different to me. For example: Hours: must be related to a day & task. need to be totaled by task, project, and person. may be multiplied by a billing rate to figure cost, but might not be. Total "cost" can be overwritten to be anything. Consumables: must be described textually and related to a task. Do not need to be related to a day, though can be. Cost is fixed and can't be overridden. Not related to a "billing rate." The only common things between them is that they're related to a task. At the UML class I took, they said it's better to not try to force inheritance where it doesn't really exist, and this seems like it would be one of those cases. Thoughts? -Deanna - Original Message - From: "Dwayne Cole" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 18, 2003 5:42 PM Subject: Re: SOT: OO Design > From a OO prospective both "funny Money" and Time may be considered consumables and both would have a method called consume. You would then model "funny Money" and "real" money as childern of the parent class consumable. Well no need to transfer you Relational model to an OO one it's probably to late that. The thing is how can you take advantage of the power of elegance cfc's you can do that with out going OO. OO cfc's is good for persistant objects and it sounds like you might be able to create a persistant object called project. Task and Deliverables and Consumbles can all have a .cfc or .cfm page that holds all functions related to their database interaction. It's not a complete OO model but at least it gets you moving in the right direction and alows you to leverage the component framework. > > > > -- Original Message -- > From: "Deanna Schneider" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 18 Nov 2003 16:03:10 -0600 > > >It's anything that costs actual money (as opposed to our time, which is > >tracked differently and is only "funny money"). For example, it's an outside > >contractor's services (because we actually pay them) as well as blank disks > >for a CD duplication job. You have to bill consumables to a particular task > >which is part of a particular project. Make sense? > > > >This is just one tiny piece of this whole wonky system. Don't even get me > >started on how a budget isn't really required, but if there is one, > >sometimes you bill out the whole budget even if we haven't provided services > >or goods that meet the whole budget, and other times we go over and don't > >bill at all. It's a university. What can I say. > > > >-d > > > > > >- Original Message - > >From: "Dwayne Cole" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Tuesday, November 18, 2003 3:51 PM > >Subject: Re: SOT: OO Design > > > > > >> What is a consumable? > >> > >> Dwayne Cole, MS in MIS, MBA > >> Florida A&M University > >> Certified Advanced ColdFusion Developer > >> 850-591-0212 > >> > >> "It can truly be said that nothing happens until there is vision. But it > >is equally true that a vision with no underlying sense of purpose, no > >calling, is just a good idea - all "sound and fury, signifying nothing." > >The Fifth Discipline - Peter Senge > >> > >> > >> > >> -- Original Message -- > >> From: Ben Doom <[EMAIL PROTECTED]> > >> Reply-To: [EMAIL PROTECTED] > >> Date: Tue, 18 Nov 2003 16:09:18 -0500 > >> > >> >> Okay, so if I go with a two object model (grossly simplified, of > >course), > >> >> then I have a "consumables" object as an attribute of my task object? > >Is > >> >> that correct? So, if I instantiate a consumables object inside my task > >> >> object, I can then call the method "getallConsumables" and get all the > >> >> consumables for that task. > >> > > >> >In this case, does "get" imply that the Task goes and gets them, or that > >> >the caller gets them from the Task? > >> > > >> >> Do I do all my new consumable creation from within my task object, too? > >Or, > >> >> do I instantiate outside the task object and just pass in a taskid when > >I > >> >> want to add a consumable (to the database)? > >> > > >> >Huh? First, let's ignore database storage for the moment. > >> > > >> >If you are using the Consumable as a portable object -- that is, other > >> >things know about Consumables besides just Tasks, then I'd create an > >> >object and pass the whole object into the Task. An example: You create > >> >an object called a Project which contains Tasks. It has a function > >> >which collects all Consumables from the contained Tasks and flags > >> >duplicates. It needs to know what Consumables are. Therefore, it makes > >> >a lot of sense for the Task to send and recieve Consumable data as
RE: Altering Date Objects?
Date is not an object in cf, just a string. Cf just recognizes some strings as dates. -Oorspronkelijk bericht- Van: Craig Earls [mailto:[EMAIL PROTECTED] Verzonden: wo 19/11/2003 12:39 Aan: CF-Talk CC: Onderwerp: Re: Altering Date Objects? An immutable object is one that cannot be changed . Like a string in Java. The only way to change it is to create a new one based on the old with with the modifications you need. The answer to your last question is that it doesn't really matter. I am just so new to CF that I thought I was missing some simple method of changing the properties of a date object. It didn't make sense to me that there would be a dateAdd() function, but no "set" functions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Query to structure
Thanks :) On 19/11/03 12:51 pm, "Tim Blair" <[EMAIL PROTECTED]> wrote: > Ryan, > >> > I want to take the query and convert it to a structure, with >> > the key being the column name and the value being the value >> > of the column... > > Simply loop over the column list: > > > > > > > Tim. > > --- > RAWNET LTD - Internet, New Media and ebusiness Gurus. > Visit our new website at http://www.rawnet.com for > more information about our company, or call us free > anytime on 0800 294 24 24. > --- > Tim Blair > Web Application Engineer, Rawnet Limited > Direct Phone : +44 (0) 1344 393 441 > Switchboard : +44 (0) 1344 393 040 > --- > This message may contain information which is legally > privileged and/or confidential. If you are not the > intended recipient, you are hereby notified that any > unauthorised disclosure, copying, distribution or use > of this information is strictly prohibited. Such > notification notwithstanding, any comments, opinions, > information or conclusions expressed in this message > are those of the originator, not of rawnet limited, > unless otherwise explicitly and independently indicated > by an authorised representative of rawnet limited. > --- > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query to structure
Ryan, > I want to take the query and convert it to a structure, with > the key being the column name and the value being the value > of the column... Simply loop over the column list: Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query to structure
You could try something like... HTH -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:42 To: CF-Talk Subject: Query to structure Hello I have a query which returns one row with a lot of columns... I want to take the query and convert it to a structure, with the key being the column name and the value being the value of the column... How do you do this? Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: nesting output from 2 queries
Yes Bert... I discovered that in my attempts Thanks for sharing that Tim -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:35 AM To: CF-Talk Subject: RE: nesting output from 2 queries One "feature" of nesting you should be aware of is that if you reference the outer query from inside the inner query it will always return the first row: #query1.myCol# #query1.myCol# <--- this will always be row 1 of query1, i.e #query1.myCol[1]# ---> #query2.myCol# I seem to remember reading the justification for this strange behaviour, but can't rember what it was... Cheers Bert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: nesting output from 2 queries
Thanks to all that replied ...I ended up not having to do the nested loop scenario, but now at least I know that capability is there -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 3:15 PM To: CF-Talk Subject: RE: nesting output from 2 queries The simplest fix to your posted code is to use the cfloop tag for at least one of the queries. Cfloop tags can be nested. SELECT fields_various FROM table1 /cfquery> SELECT columns_various FROM table2 #fields_various# #columns_various# Now when you start to nest queries, the automatic scoping of queries can get confused and problematic, so it's evan more important to scope your query variables (query1.fields_various, query2.fields_various). Beyond this you can get into using the array notation form of queries and do some really sophisticated mixing. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 12:08 PM To: CF-Talk Subject: nesting output from 2 queries If you have two different queries and you want to put the output of one of those queries within the other, is that possible, if so how (group processing doesn't appear to be an option)? Such as: SELECT fields_various FROM table1 /cfquery> SELECT columns_various FROM table2 #fields_various# #columns_various# TIA Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Query to structure
Hello I have a query which returns one row with a lot of columns... I want to take the query and convert it to a structure, with the key being the column name and the value being the value of the column... How do you do this? Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: nesting output from 2 queries
One "feature" of nesting you should be aware of is that if you reference the outer query from inside the inner query it will always return the first row: #query1.myCol# #query1.myCol# <--- this will always be row 1 of query1, i.e #query1.myCol[1]# ---> #query2.myCol# I seem to remember reading the justification for this strange behaviour, but can't rember what it was... Cheers Bert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
REPOST: Creating "treeview" structure using
Hi, Is it possible to create a "treeview" structure using + dir1 + dir2 + dir3 + dir4 Click on "dir2" + dir2 + subdir1 + subdir2 file1 file1 file1 I've done something similar using Pleasesomeone help George Bush! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Which patches installed on a CF5 server
Hi, I've had a root about and sorry, just can't find the info anywhere. How do you determine which patches are installed on an instance of CF5 Server? It's for a ISO 9001 procedure Thanks, -dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Altering Date Objects?
An immutable object is one that cannot be changed . Like a string in Java. The only way to change it is to create a new one based on the old with with the modifications you need. The answer to your last question is that it doesn't really matter. I am just so new to CF that I thought I was missing some simple method of changing the properties of a date object. It didn't make sense to me that there would be a dateAdd() function, but no "set" functions. On Tue, 18 Nov 2003 19:06:11 -0700, you wrote: >Why do you think dates are immutable, and even if they are, why does it matter? > >- Original Message - >From: Craig Earls <[EMAIL PROTECTED]> >Date: Tuesday, November 18, 2003 6:58 pm >Subject: Re: Altering Date Objects? > >> Thanks, as it turns out that is what I am doing in a way. So I have >> just wasted a lot of bandwidth. I was hoping someone was going to tell >> me I had missed something big about accessing properties in CF >> objects. But it looks like dates really are immutable. >> >> On Tue, 18 Nov 2003 17:46:00 -0800, you wrote: >> >> >Ah, HA! >> > >> >I see three solutions, given that after submitting the second >> page you'll >> >have 4 pieces of info: a date (myDate), an hours value (hr), a >> minutes value >> >(min), and a seconds value (sec). >> > >> >1) myDate = createDate(year(myDate), month(myDate), day(myDate), hr, >> >min,sec); >> >2) myDate = dateAdd(myDate, "h", hr); >> > myDate = dateAdd(myDate, "n", min); >> > myDate = dateAdd(myDate, "s", sec); >> >3) myDate = parseDate(dateFormat(myDate, "mm/dd/") & " >> >#hr#:#min#:#sec#"); >> > >> >I think the first is best, but thats just opinion. >> > -Original Message- >> > From: Craig Earls [EMAIL PROTECTED] >> > Sent: Tuesday, November 18, 2003 5:22 PM >> > To: CF-Talk >> > Subject: Re: Altering Date Objects? >> > >> > >> > I am talking in circles, sorry. Let me clarify the question: >> I am >> > ultimately going to stick a ODBCDateTime object into a >> database, but >> > first I have to create it. >> > >> > My workflow is such that the user selects the date from a widget >> > (system creates the object using createDate()). On the next >> page (this >> > is a wizard type of thing, don't get me started) the user sets the >> > time of a meeting. So now I have a date object with the actual >> date> of the meeting, and I want to set the time in that date >> object so I >> > can feed it to createODBCDateTime and stuff it into a database. >> > >> > On Tue, 18 Nov 2003 17:58:49 -0700, you wrote: >> > >> > >Databases are a persistent data store, not an object store. >> So yes, >> >you'd have to change the date somewhere and update the >> corresponding entry >> >in the database (you can do these two operations in one SQL >> statement).> > >> > >- Original Message - >> > >From: Craig Earls <[EMAIL PROTECTED]> >> > >Date: Tuesday, November 18, 2003 5:49 pm >> > >Subject: Re: Altering Date Objects? >> > > >> > >> I thought of that, but for the sake of argument let's say I >> am storing >> > >> a date object in my DB. If I reschedule the meeting then I >> would like >> > >> to just directly alter the values, not compute an offest >> then add >> > >> them. Their is no copy ocntructor that I can see, so I have >> been> >> creating a new datetime object using the individual >> properties of the >> > >> old date object. It seems clumsy. >> > >> >> > >> On Tue, 18 Nov 2003 16:19:29 -0800, you wrote: >> > >> >> > >> >just hit it with a dateAdd() and specify "h", "n", or "s" >> for the >> > >> date part. >> > >> >Yes, that's an "n", not an "m". "m" is month, "n" is minute. >> > >> > >> > >> > -Original Message- >> > >> > From: Craig Earls [EMAIL PROTECTED] >> > >> > Sent: Tuesday, November 18, 2003 4:13 PM >> > >> > To: CF-Talk >> > >> > Subject: Altering Date Objects? >> > >> > >> > >> > >> > >> > I need to allow a user to specify a time and date for a >> > >> meeting. I am >> > >> > using a calendar widget to choose the date, and a few >> > >> comboboxes to >> > >> > choose the time. This brught the following question up: >> > >> > >> > >> > Suppose I create a date object with CreateDate(Year, Month, >> > >> Day), then >> > >> > later want to modify the time in that date object. How >> would I do >> > >> > that? Are date objects immutable? >> > >> > >> > >> > >> > >> > >> > >> >> > > >> > >> > >> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Unblocking Ports
It all depends on the version of your server(s) and your network configuration and what you need to do. Normally anymore, ports in & out of your system are opened and closed at the firewall(s), but depending on your equipment, layout, & needs there are other places and methods that need to be checked as well. If you're attaching to a VPN, it gets even more murky. If you've stood up your own stand alone server--again depending on version--without a firewall, there's a very good chance that your machine installed with all or nearly all of the most common ports open. In this case, the place to start would be in IIS. If I remember correctly, when you install CF Server it configures the web server ports automatically. If you're working in a shop with a LAN administrator, now's the time to be chatting him up about what you need. If you need firewall or router ports cracked open, you'll need the LAN administrator, Security administrator, or Router administrator's help. Perhaps, all three. Can't really be anymore specific, I'm afraid. It's a very individualized and complicated subject. Rick -Original Message- From: Lee Ramsey [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 November, 2003 16:28 To: CF-Talk Subject: OT: Unblocking Ports Hi All, I was just reading this article on Macromedia's site: http://www.macromedia.com/support/coldfusion/ts/documents/tn18336.htm, and this may be a stupid question but how do I unblock ports on my Windows server? TIA, Lee _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and Java integration..
Not specific to CFMX< but have a look at http://javaalmanac.com/egs/? Some very useful examples. -Original Message- From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED] Sent: 18 November 2003 22:26 To: CF-Talk Subject: CF and Java integration.. Hi all: I'm looking for a Java reference in PDF or chm format about the most used packages and short examples. I'd like to start develop some examples with CF MX 6.1 using java classes. Just to start !!! *in CFLib.org it's a good example how to implement zip features with java.util.zip package Regards, -- M.Sc. Hassan Arteaga Rodríguez. Microsoft Certified System Engineer. Grupo de Desarrollo. DIGI COPEXTEL, S.A _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]