Re: passing multiple CF vaules to a javascript variable
But the onClick event doesn't recognize the CF variable. It has to be _javascript_. When I convert the #linkStyle# to _javascript_ - "target(){return #linkStyle#}" - and place the _javascript_ in the onClick event as "(target()", there is no way for the value to change from what was originally returned in the script. If the value of #linkstyle# returned in the script was "FellSvc", (probably the last value returned from the query), each instance of I'm thinking I need to loop over the variable from within the script or loop over the function from within the output of the query - loop over something, somehow, to get all the values for #linkSvc# separated out and into different onClick event instances. I tried placing all the values for #linkSvc# in a list, in an array (which the _javascript_ function didn't like because it was a complex datatype), but it's not getting me closer to placing different values in each onClick event generated by outputting the query results. I'm going to sleep on it. G'night, all and thanks for your input! >On Apr 13, 2004, at 1:07 PM, Joy Holman wrote: > > >but #linkStyle# is just the name of a CF variable, a container, if you >will (this one just cones from the db). > >that container can contain anything you want it to, for example: > > >' > > > > >myFunction( ) { > > alert("Hi"); >} >' >/> > > > > >so in your example, the columns in the current row of the query contain: > >columnName Content >-- --- >linkName Apple > >linkURL www.apple.com > >linkStyle MinorRts > > > >if column named linkStyle in the current row of the database contains >MinorRts > >then outputting: > > >#linkName# > >will yield: > > >Apple > > >As I understand it, that is exactly what you want. > >The next row will have different values so the next link will reflect >this > >HTH > >Dick > > > >>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Concepts
Is anyone aware of any concept search engines being developed with CFML. TIA!!! +++ Kevin Parker Web Services Manager WorkCover Corporation p: 08 8233 2548 e: [EMAIL PROTECTED] w: www.workcover.com +++ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Hi Joy, could you possibly make a dump of your query? So we can understand what you data looks like? Patric JH> onClick didn't understand a CF variable like: "#linkStyle#". It wants _javascript_. I don't know how to make the _javascript_ variable I create from the CF variable return each of the different JH> values in the onClick event. JH> I get: >> menu item one: ...> >> menu item two: ...> >> menu item two: ...> JH> How can I make the _javascript_ variable I create from the CF variable loop through the values properly? JH> Thanks for trying to help with this problem. >> But by the time the code gets to the browser, #linkStyle# will have >> been replaced by exactly what you show us here >> menu item one: ...> >> menu item two: ...> >> menu item two: ...> >> >> "view source" from your browser might help clear things up for you. >> >> Or like Dick, I don't understand :( >> >> - Original Message - >> From: Joy Holman >> To: CF-Talk >> Sent: Tuesday, April 13, 2004 4:12 PM >> Subject: Re: passing multiple CF vaules to a _javascript_ variable >> >> >> Would this information help explain what I need? >> >> Here's where the styles comes in: >> I have a CSS stylesheet with these values: >> #FellSvc{display:none;} >> #MinorRts{display:none;} >> #AmnInf{display:none;} >> #AnteSter{display:none;} >> >> In the db table, I have a column for the same styles from the >> stylesheet. Let's say the column name is "linkStyle" (like Dick's >> example). Another column in the db table has the text for the menu >> link that displays on the page. >> >> When a user clicks on a menu link (generated by the CF code prior to >> the user interaction), an assoicated DIV with an ID equal to the >> stylename displays its content because the onClick event tells the >> matching style in the stylesheet to change "display=none" to >> "display=block". >> >> Using Dick's example, just change the end to something like this: >> >Now, iterating over the query: >> > >> > >> > >> #linkName# >> > >> >> Now, that doesn't work because #linkStyle# is CF and onClick needs js. >> >> I don't know how to loop through this onClick variable to get the >> range of values to be produced - one for each iteration of the results, >> like: >> menu item one: ...> >> menu item two: ...> >> menu item two: ...> >> etc. >> >> Does that help? >> >> I need to be gone for a few hours, but I'll check back. >> Thank you and Dick so much for sticking with me on this!!! >> >> > It sounds like you need to combine the results from the 2 queries >> into >> > a single query objectOR write a more complex query to join all >> the >> > tables involved to produce a single recordset. >> > >> > Bryan Stevenson B.Comm. >> > VP & Director of E-Commerce Development >> > Electric Edge Systems Group Inc. >> > t. 250.920.8830 >> > e. [EMAIL PROTECTED] >> > >> > - >> > Macromedia Associate Partner >> > www.macromedia.com >> > - >> > Vancouver Island ColdFusion Users Group >> > Founder & Director >> > www.cfug-vancouverisland.com >> >> > - Original Message - >> >> > From: Joy Holman >> >> > To: CF-Talk >> >> > Sent: Tuesday, April 13, 2004 11:55 AM >> >> > Subject: Re: passing multiple CF vaules to a _javascript_ variable >> > >> > >> >> > The rendered output is a menu of links. One query column >> >> > returns the text for a link, another query column returns the target >> >> > for the link. The style name column is used in an onClick event to >> set >> > a CSS style to display content when clicked. >> > >> >> > The style name doesn't display on screen. >> > >> >> > I'm able to generate all the values I need except for all the >> >> > stylename values. If I only had one result from the query, it would >> >> > work fine. But I can't get the style name value to change as >> > additional menu items are generated from the query results. Maybe >> what >> > I need is help with _javascript_. >> > >> >> > I don't know how to explain it any better. I guess that's a drawback >> >> > of not being able to talk in real time. Thanks for your efforts. >> I'll >> > keep at it. >> > >> >> > event. >> > >> >> > From the query results, I create the js: target() which returns >> > >> >> > the value of the stylename field. How do I loop over the >> > >> >> > stylename values so that I get one value per onClick event which >> > >> >> > is generates multiple times based on the number of records in >> > >> >> > the query? >> > >> >>
Re: OT ? Emulation
On Wednesday 14 Apr 2004 03:38 am, "Nathan C. Smith" <[EMAIL PROTECTED]> wrote: > Certainly Perl has something - or more than one option- as well. LWP for instance. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MX: Scheduler firing off too often
On Tuesday 13 Apr 2004 15:45 pm, Scott Weikert <[EMAIL PROTECTED]> wrote: > great. Took it out... put it back... then it was running TWICE. Took it > out... put it back again... it would run THREE times. Two guesses - something is resetting your system clock, or CF is not removing the schedule correctly, I'm sure someone will know a neo-XXX.xml that holds this info, or you could try a grep for the URL concerned... -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
how to save a document/spreadsheet/pdf into a database table when it is open?
Hello Everybody, I'm hoping somebody will provide me with some help. I have this section on my site where a user can view his or her attachments. The attachments that can be a word documents, a spreadsheets or a pdf are stored in a database table as binary objects. I've done the bit to allow the user to view the document. I did this with the help of the cfx_getImage tag, which opens the document inside a browser window. - DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName#"> VALUE="application/msexcel"> FILE="E:\inetpub\wwwroot\testDocs.xls" deletefile="Yes"> -- I want to now add the code that saves back the contents of the document in the database table when the user clicks on File->Save option from the menu or ctrl-s from the keyboard. Is this possible, if so can someone please show me how to do this? Best regards, cfcoder __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
how to save a document/spreadsheet/pdf into a database table when it is open?
Hello Everybody, I'm hoping somebody will provide me with some help. I have this section on my site where a user can view his or her attachments. The attachments that can be a word documents, a spreadsheets or a pdf are stored in a database table as binary objects. I've done the bit to allow the user to view the document. I did this with the help of the cfx_getImage tag, which opens the document inside a browser window. - DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName#"> VALUE="application/msexcel"> FILE="E:\inetpub\wwwroot\testDocs.xls" deletefile="Yes"> -- I want to now add the code that saves back the contents of the document in the database table when the user clicks on File->Save option from the menu or ctrl-s from the keyboard. Is this possible, if so can someone please show me how to do this? Best regards, cfcoder __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
access and cf5 performace
Hi This may be a multiple list question, but I figured I would ask here since many of you are familiar with this setup. I have a windows 2000 dedicated server running about 15 ablecommerce websites using Access and CF 5 Server. Lately I have been getting timeout errors from the database and cf scripts. When I view the system resources during these timeouts, the hardware is completely fine. Only 1/3 of the physical ram in use and the processor toping 5%. I don't know what else to look at to determine what is causing the problem. Does anyone have any suggestions on where to look or what the issue may be? Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to streamline a request that uses many cfquery statements?
Hm. I wasn't implying that a stored procedure would run asynchronously. But, I was implying that if you're making 15 separate calls to the database, your bottle neck could be right there. If you can encapsulate those 15 queries into one call to the database, that returns one recordset, you may save some processing time. (Without knowing what they're doing for sure, though, I couldn't say more than "maybe.") - Original Message - From: "Steve Nelson" ? > Maybe I'm wrong, but I think even if you use a stored procedure it's going > to process in series. I doubt it's going to give you a huge performance > boost. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Timeout connecting to access DB
I just recently upgraded the Servers, Windows 2k and CF5.0 to Win2k3 and CFMX 6.1. The system is runs great for a few days and then all Access Database's start to timeout. This does not seem to affect any other system on the server just Access ODNC connections. OS is fully patched Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
new--->win
In IE, doing a CTRL-N or NEW--->WINDOW, doesn't fully run the CF code again. I have a variable based on a timestamp, so when opening a new window, the variable doesn't get the new time. I put in all of the cfheader and meta tags for disabling caching. Anything else I can do? -seth [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: Flash Remoting vs Web Services vs XML
> I recommend Colin Moock's book 'Flash Remoting' the > definitive guide. I pretty much agree with everything Brook Davies said, except that I think Tom Muck wrote the O'Reilly "Flash Remoting: The Definitive Guide". 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]
Writing/Opeing txt files
How can get ColdFusion to open a text file on my server in notepad and not the browser? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Flash loop question
I am returning an array of state abbreviations to Flash and I have a map of the US with each state as a separate button with the instance named as the state 2-letter abbreviation. I'm trying to do the following: for(i=0;i stateList[i].enabled = false; } If I trace stateList[i], I get the 2 letter abbreviation for the state, but the loop doesn't disable the button. Do I have to do something so that Flash knows that stateList[i] is a variable and not a literal instance name? I'm sorry for the OT post, but I know that many of you also deal with Flash and could give me a faster answer than trying to find a solid flash board or something to give me some info. Thanks. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: Flash Remoting vs Web Services vs XML
Chris, There's a good (IHMO) ramp-up article in MXDJ (vol 2 issue 4) (http://sys-con.com/mx/ - I can't find the exact link to the article) ) entitled FlashFusion that describes how to consume webservices based around SOAP. A short comparison to Remoting is included as well. Sincerely, Andrew On Apr 13, 2004, at 12:06 PM, Chris Alvarado wrote:) > Hello all, > > I am starting a new project that will require some fairly heavy Flash > / > CF integration including but not limited to: visual display of data > stored in a database, insertion of data into a database supplied in > Flash forms, a complete security model that requires not only > authentication but user level access restrictions (role based model). > I > just ready the article on Macromedia DevNet about the various options > for developing RIAs (Remoting, Web Services, XML) and am having a bit > of > a hard time deciding which route to pursue. Are there any RIA specific > mailing lists etc that anyone can recommend. Additionally can anyone > here point me in the right direction? I am a complete rookie when it > comes to Flash but have nearly 7years of CF experience so the CF > concepts are easy to grasp for me, im just sort of a bit inundated > with > the Flash portion. If anyone has any suggestions on where to get > started > they would be greatly appreciated. I picked up "Macromedia Flash MX > Profession 2004 for Server Geeks" and it seems like an excellent book, > but if anyone has any other suggestions that would fit well within the > project described above I would really appreciate it. > > Thanks everyone, > > Looking forward to seeing any feedback. > > -chris.alvarado > > [ application developer ] > > 4 Guys Interactive, Inc. > > 281.807.4344 x1716 > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Backing up MySQL InnoDB DB
Hi all our app run this .bat file to create a sql script(backup) from our MySQL DB. c:\mysql\bin\mysqldump.exe --single-transaction -quick -u name_user -ppass_user ourDB > c:\mysql\data\backups\ourDB_#datePart#.sql But results 0(zero) size... what's happened? Do you have experience in backing up MySQL? Thanx for your time. p.s.: Windows 2003/MySQL 4.0.16/CF MX 6.1 -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX6.1 updater
>Hey does anyone have any idea when an updater for CFMX6.1 might be out? Following is the 3/19 CF-Talk email where there was specific mention of a "6.1 cumulative hotfix due in April". I've not seen any further information posted about it. Ken -Original Message- From: Stephen Dupre [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:14 AM To: CF-Talk Subject: Re: JRun 4 Updater 3 Now Available Just to clarify. The vast majority of what's in JRun Updater 3 is what was made available to CF customers in CFMX 6.1 Updater 3 gets these fixes to JRun 4 customers. There is a some small number items fixed in Updater 3 that aren't in CFMX 6.1. We're working on a cumulative hotfix due in April to make those available for CFMX 6.1 Server-configuration customers. Some other fixes available ***POST-U3*** (didn't make U3) for JRun and CFMX customers through hotfixes + other random thoughts I'll share: (note: all of these will be in the 6.1 cumulative hotfix due in April) - we expect to release new datadirect drivers soon to fix the oracle and sqlserver issues customers have reported (no more data, arrayindexoutofbounds, hangs) with the 3.2 drivers shipped with JRun 4 Updater 2 and CFMX 6.1. They are still in testing mode. JRun4 Updater 3 got the 3.1+ drivers since they were the most stable. 3.1+ was also made available as a hotfix for CFMX customers with issues. We expect to replace the 3.1+ for JRun and CFMX customers with newer drivers in the next few weeks if testing goes well. Please email me if you'd like to participate in the beta. - some connector enhancements - including failover in clustering working as expected (we will have a hotfix for this soon - please email me). These fixes are long overdue. - connection pooling fixes for "JRun datasources" to match the pooling fixes for ColdFusion datasources (see technote below). http://www.macromedia.com/support/coldfusion/ts/documents/conn_pool_hotf ix.htm (for apps like AbleCommerce that use "JRun datasources" ie entered through the JMC and available to all instances). Users of JRun J2EE CFMX versions would need these if they have connection-limited datasources *AND* the underlying application used JRun datasources. This fix will be made available in a few days. - Client variable purge fixes for SQL and registry datasources (there were 4 bugs fixed). This often showed up when the server hung every hour on the hour for the maintenance task of purging client variables older than [N] days. This hits many customers if they use "registry" and the registry grows to say 50,000 or 100,000+ entries. SQL datasources are recommended but even if users switched, the registry purges still occurred (in addition to SQL purges) and could hang the system. The fix now respects the unchecked "purge" setting for all client datasource types. These are the ones that come to mind that get reported most often hanging systems. ***For Dick AppleBaum***: 1) JRun and, therefore, CF use the JVM 1.3 instead of 1.4 (even with the fix posted Christian Cantrell's blog site) > Part of this is the installer not allowing the selection. There are > also issues with using JDK 1.4 (jvm.cfg issues). We've fixed this > post-Updater 3 in the launcher. (jrun stub) Please email me and I can get you some code to test. 2) When starting a CF 6.1 JRun server instance, the scheduler does not start (see below). > I've heard of this sporadically but can't reproduce it. Perhaps send me your neo-cron.xml and jrun.xml and I'll see if I can repro it on my machine. 6.1 definitely massaged this .xml file on an existing server. Perhaps the one in your new instance got corrupted somehow. Regards, Stephen Dupre Macromedia QA [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Check server memory and CFMX restarts>>>
Is there a way to check available memory for CFMX from code? (i.e. I do not have access to the physical server.) I've seen it done before for Java based custom tags, but I was wondering if there is a way to tell if CFMX is running out of memory (because I keep losing my application variables way before the specified timeouts.) And does CF record every time it restarts in the "server" log, or would it only be recorded in the actual server's log (from IIS for example)? Tyler S [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
onClick Nightmare!
Hello everybody. The below code works, however when I don't know how to put the same code in the windows.open. I've tried really hard but keep getting errors. Please can somebody show me how to do it. document.write(" href=""> I am trying to do this: > return false;" I would really appreciate your help Regards, cfcoder __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Challenge
I've got a challenge for any and all SQL guru's. I need to return a record set consisting of all records with a date in the future of today as well as one and only one record previous to the current date, if one exists. Would this best be done with a union of two selects, or is there a trick that would allow this to be done in one select? If it matters, this is against an Oracle 8 database and the date field is stored as an integer in the format of mmdd. Thanks -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: how to save a document/spreadsheet/pdf into a database table when it is open?
Nope, imagine the problems you'd have if you let users "save" directly to your server. That's a hacker's paradise. The only way I can think to do it would be to have some kind of an editor built into your page that creates the files or allow a user to upload files from their computer and save it into the database that way. You can't let them just edit the file in the browser and File->Save though. That's a local operation, not a server thing. John -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 5:49 AM To: CF-Talk Subject: how to save a document/spreadsheet/pdf into a database table when it is open? Hello Everybody, I'm hoping somebody will provide me with some help. I have this section on my site where a user can view his or her attachments. The attachments that can be a word documents, a spreadsheets or a pdf are stored in a database table as binary objects. I've done the bit to allow the user to view the document. I did this with the help of the cfx_getImage tag, which opens the document inside a browser window. - DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName#"> VALUE="application/msexcel"> FILE="E:\inetpub\wwwroot\testDocs.xls" deletefile="Yes"> -- I want to now add the code that saves back the contents of the document in the database table when the user clicks on File->Save option from the menu or ctrl-s from the keyboard. Is this possible, if so can someone please show me how to do this? Best regards, cfcoder __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Timeout connecting to access DB
We have had that problem quite a bit as well. Same set up. We tried both the standard install of CFMX and with JRUN with little luck. We are completely updated with all the patches from MM, even tried the garbage collecting fix on the MacroMedia website. Anyone knows how to correct this I would love to know as well. We are actually going to start turning back about 45 servers to CF5, which kinda sucks. So about 80 percent of out CFMX servers are going back to CF5, what a sad day. :( -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 9:28 AM To: CF-Talk Subject: Timeout connecting to access DB I just recently upgraded the Servers, Windows 2k and CF5.0 to Win2k3 and CFMX 6.1. The system is runs great for a few days and then all Access Database's start to timeout. This does not seem to affect any other system on the server just Access ODNC connections. OS is fully patched Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Writing/Opeing txt files
Christopher Farino wrote: > How can get ColdFusion to open a text file on my server in notepad and not the browser? Not. Which application is used for which MIME-type is defined by the visitor in his browser settings. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Concepts
Hey Kevin, I'm not aware of any other than the one I may be developing soon ;-) A current client recently mentioned his idea for just such a tool that he had worked with another developer a few years back and it lost steam (developer kept saying it couldn't be done). So there is a chance that after this client's current site launches (soft launch May 1st) that we may take a stab at it. Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Parker, Kevin To: CF-Talk Sent: Tuesday, April 13, 2004 9:24 PM Subject: Concepts Is anyone aware of any concept search engines being developed with CFML. TIA!!! +++ Kevin Parker Web Services Manager WorkCover Corporation p: 08 8233 2548 e: [EMAIL PROTECTED] w: www.workcover.com +++ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: new--->win
Ummm, it should get a new copy. It depends on your browser settings for caching and also your server settings with caching. If you want it to refresh you need to go through the headache of insuring that your page isn't cached. John Burns -Original Message- From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 9:30 AM To: CF-Talk Subject: new--->win In IE, doing a CTRL-N or NEW--->WINDOW, doesn't fully run the CF code again. I have a variable based on a timestamp, so when opening a new window, the variable doesn't get the new time. I put in all of the cfheader and meta tags for disabling caching. Anything else I can do? -seth [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing multiple CF values to a JavaScript variable
The concept that took me awhile to get my head around. You don't usually pass variables to _javascript_ in examples like this. If you need to truly pass variables to _javascript_ from CFML you need to use some kind of intermediary technology such as WDDX. But for what you seem to be trying to do, you just need to create some dynamically written _javascript_. This works just like dynamically written HTML that we all do on a daily basis. All the CFML mixed with _javascript_ code is rendered in the server and the completed _javascript_ is sent to the client where it is ran. Some basic examples: To create a list of links with a dynamic _javascript_ phrase: A gotcha in this syntax is the mixing of quotes on the onClick property. If you want the parameter of the JS function to be a string literal wrapped in quotes and the onClick property to be correctly wrapped in quotes you must properly nest double (") and single (') quotes. Also, if the JS complains about the string #aQuery.aColumn#, then the CFML variable was not rendered, which means that is was not inside tags for some reason. To create a dynamically generated JS function:
function aJSfunction ( foo, bar )
{
var sampleArray = new Array(1);
sampleArray[currentRow] = "#aQuery.aColumn#";
}
This would create a simple JS array out of the values in a column from a CFML query. This could also be done with WDDX if one so desired. If you are using a Macromedia IDE such as Studio, Homesite or Dreamweaver, the color coding feature gets confused with this kind of mixing of JS and CFML code, but that has no bearing on the correctness of the code so just ignore the strange coloring of the code. HTH If you are still unsure of how to accomplish your requirements and if you can provide a couple of snippets of your actual code we can probably help you more specifically with your syntax. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: onClick Nightmare!
> Hello everybody. The below code works, however when I > don't know how to put the same code in the > windows.open. Put it in a function
function openPopup(number, otherNumber) {
x = window.open(...);
}
... > Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: new--->win
It is possible that by disabling IE's cache you might be able to stop that behavior, but no bets. I don't think that there's anything you can do on the server side, though. I believe it's just IE's default behavior to replicate the page as loaded when creating a new window. --Ben Turetsky, Seth wrote: > In IE, doing a CTRL-N or NEW--->WINDOW, doesn't fully run the CF code again. > I have a variable based on a timestamp, so when opening a new window, the > variable doesn't get the new time. I put in all of the cfheader and > meta tags > for disabling caching. > > Anything else I can do? > > -seth > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Check server memory and CFMX restarts>>>
yes, restarts are logged in the server log. You should prob figure out why the restarts are occuring though, eh? You have an app with long running SQL or something? This will tell you the memory stuffs. Curteousy of Pete Frietag's blog. Free Allocated Memory: #Round(freeMemory)#mb Total Memory Allocated: #Round(totalMemory)#mb Max Memory Available to JVM: #Round(maxMemory)#mb Doug -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 10:38 AM To: CF-Talk Subject: Check server memory and CFMX restarts>>> Is there a way to check available memory for CFMX from code? (i.e. I do not have access to the physical server.) I've seen it done before for Java based custom tags, but I was wondering if there is a way to tell if CFMX is running out of memory (because I keep losing my application variables way before the specified timeouts.) And does CF record every time it restarts in the "server" log, or would it only be recorded in the actual server's log (from IIS for example)? Tyler S _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: access and cf5 performace
>>I don't know what else to look at to determine what is causing the problem. I would have a look at CFLOCKs and also see if all tables are correctly indexed. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: onClick Nightmare!
do something like var url =""> 'attachment.cfm?id=#url.Number#&filename="+escape(field s[n])' then > zable=Yes'); or atleast something along those lines -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 10:40 AM To: CF-Talk Subject: onClick Nightmare! Hello everybody. The below code works, however when I don't know how to put the same code in the windows.open. I've tried really hard but keep getting errors. Please can somebody show me how to do it. document.write(" href=""> ields[n])+">"+fields[n]+""); I am trying to do this: > lename="+escape(fields[n])','Document','top=10,left=10,height=500,width=600, resizable=Yes'); return false;" I would really appreciate your help Regards, cfcoder __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MX: Scheduler firing off too often
At 03:33 AM 4/14/2004, Thomas wrote: >Two guesses - something is resetting your system clock, or CF is not removing >the schedule correctly, I'm sure someone will know a neo-XXX.xml that holds >this info, or you could try a grep for the URL concerned... I've already looked over the neo-cron.xml file on the server in question - it's got just the data it should, based on what shows in the scheduler page in the CF admin. I don't think the system clock is being reset - I've got this task disabled except for a cfmail tag to myself with a timestamp on it. It'll run great for a while then occasionally, I'll get two emails with the same timestamp (down to the second - can't display the millisecond though). Sometimes it'll fire off three times - it did that this morning around 3am, in fact. The other data I send in the mail confirms it's the scheduler and not an external source kicking off the page. Plus, I had the same cfmail tag at the top of the same task script on another box, which runs fine, emailing me the same data. The two timestamps never got out of whack - server 2's task is scheduled to run one minute later than server 1's task, and I got hours of emails that were right on time as far as when the tasks should run and the time offsets in the respective servers' schedulers. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: new--->win
Ben/John, Yeah doesn't seem to be something I can reliably do. So, I switched things up, so that it is created in _javascript_ with an onLoad and form submitted. Thanks, seth -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 11:15 AM To: CF-Talk Subject: Re: new--->win It is possible that by disabling IE's cache you might be able to stop that behavior, but no bets. I don't think that there's anything you can do on the server side, though. I believe it's just IE's default behavior to replicate the page as loaded when creating a new window. --Ben Turetsky, Seth wrote: > In IE, doing a CTRL-N or NEW--->WINDOW, doesn't fully run the CF code again. > I have a variable based on a timestamp, so when opening a new window, the > variable doesn't get the new time. I put in all of the cfheader and > meta tags > for disabling caching. > > Anything else I can do? > > -seth > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Check server memory and CFMX restarts>>>
Awesome, that is exactly what I was looking for! And, it doesn't look like the server's restarting from what I can tell, I just wanted to make it would list it in the logs if it did...thanks for the help-> Tyler S _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 11:19 AM To: CF-Talk Subject: RE: Check server memory and CFMX restarts>>> yes, restarts are logged in the server log. You should prob figure out why the restarts are occuring though, eh? You have an app with long running SQL or something? This will tell you the memory stuffs. Curteousy of Pete Frietag's blog. Free Allocated Memory: #Round(freeMemory)#mb Total Memory Allocated: #Round(totalMemory)#mb Max Memory Available to JVM: #Round(maxMemory)#mb Doug -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 10:38 AM To: CF-Talk Subject: Check server memory and CFMX restarts>>> Is there a way to check available memory for CFMX from code? (i.e. I do not have access to the physical server.) I've seen it done before for Java based custom tags, but I was wondering if there is a way to tell if CFMX is running out of memory (because I keep losing my application variables way before the specified timeouts.) And does CF record every time it restarts in the "server" log, or would it only be recorded in the actual server's log (from IIS for example)? Tyler S _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
You know what...we may be experiencing a similar issue. Up until now I've chalked it up to a code anomaly (not having the time to hunt it down yet) but perhaps it's related to what you're seeing. All of our scheduled items seem to be running just fine except for this one that runs once right before midnight every day. All it does is send out an email with a log file. About once a week I receive two emails rather than just the usual single one...as if it were run twice. Hmmm Stace _ From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 11:33 AM To: CF-Talk Subject: Re: MX: Scheduler firing off too often At 03:33 AM 4/14/2004, Thomas wrote: >Two guesses - something is resetting your system clock, or CF is not removing >the schedule correctly, I'm sure someone will know a neo-XXX.xml that holds >this info, or you could try a grep for the URL concerned... I've already looked over the neo-cron.xml file on the server in question - it's got just the data it should, based on what shows in the scheduler page in the CF admin. I don't think the system clock is being reset - I've got this task disabled except for a cfmail tag to myself with a timestamp on it. It'll run great for a while then occasionally, I'll get two emails with the same timestamp (down to the second - can't display the millisecond though). Sometimes it'll fire off three times - it did that this morning around 3am, in fact. The other data I send in the mail confirms it's the scheduler and not an external source kicking off the page. Plus, I had the same cfmail tag at the top of the same task script on another box, which runs fine, emailing me the same data. The two timestamps never got out of whack - server 2's task is scheduled to run one minute later than server 1's task, and I got hours of emails that were right on time as far as when the tasks should run and the time offsets in the respective servers' schedulers. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: onClick Nightmare!
cfcoder I am trying to do this: > return false;" The first two problems I see is that the "+" operator is the concatenate operator in _javascript_ the "&" operator is the concatenate operator in CFML, so you will need to change the + to an &. Secondly escape is a JS function not a CFML function, I think the equivalent you need would be urlEncodedFormat(). That should get you closer to your goal. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: AXIS error
Check for a file in your WEB-INF directory named server-config.wsdd. This is the Axis configuration file. See if the class you are having problems with is mentioned in there, possibly as a . It should not be. -- Tom Jordahl Macromedia Server Development -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 12:13 PM To: CF-Talk Subject: Re: AXIS error >On Wednesday 07 Apr 2004 16:57 pm, Dave Carabetta wrote: > > org.xml.sax.SAXException: Fatal Error: URI=null Line=2: Illegal >character > > at end of document, <. > >What character code is that ? > It's the "<" symbol. However, I think that the error above is cause by the stack trace error returned that I pasted in as opposed to my code. As I said, I can call this CFC using createObject("component") just without issue. The real problem (I think, but who knows) is that AXIS is looking for a class in webservices.jar called SimpleHTTPSender that doesn't exist is any version of webservices.jar that I've unzipped (originally shipped, hotfix, and security bulletin versions). Regards, Dave. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Generating WSDL
I can't get the example 'echo' cfc working on my CFMX6.1 box. I've cut'n'pasted the code from http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/webser28.htm and am accessing http://charles-compaq.bluefinger.com:7001/echo.cfc?wsdl All I get is a 500 error, nothing in the CF logs. Could something in my Application.cfm be screwing things up ? It attempts to cache a few things into various shared scopes, but not a lot else. There is this in the weblogic domain log, however: <[ServletContext(id=3285908,name=ceo_platform,context-path=)] Root cause of ServletException coldfusion.runtime.AbortException at coldfusion.tagext.lang.AbortTag.doStartTag(AbortTag.java:59) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfApplication2ecfm1153779603._factor0 (/opt/bea7-SP2/user_projects/lv_platform/cf_codebase/ceo_platform/Application.cfm:230) at cfApplication2ecfm1153779603._factor2 (/opt/bea7-SP2/user_projects/lv_platform/cf_codebase/ceo_platform/Application.cfm:178) at cfApplication2ecfm1153779603.runPage(/opt/bea7-SP2/user_projects/lv_platform/cf_codebase/ceo_platform/Application.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:93) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:24) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:62) at coldfusion.xml.rpc.CFCServlet.doGet(CFCServlet.java:113) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:339) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: AXIS error
>Check for a file in your WEB-INF directory named server-config.wsdd. > >This is the Axis configuration file. > > > >See if the class you are having problems with is mentioned in there, >possibly as a . It should not be. > Since I didn't get an initial response to my post, I just never posted back when I solved it (sorry). I forgot that I made a tweak to server-config.wsdd to try and get MapPoint working with CFMX a few months back. I did indeed put in a reference to SimpleHTTPSender. When I deleted the MapPoint files, I forgot to change server-config.wsdd back. Thanks for getting back to me though. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Flash Remoting vs Web Services vs XML
Chris, Theres a great (IHMO) ramp-up article in MXDJ (vol 2 issue 4) (http://sys-con.com/mx/ - I cant find the exact link to the article) entitled FlashFusion that describes how to consume webservices based around SOAP. A short comparison to Remoting is included as well. Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generating WSDL
On Wednesday 14 Apr 2004 16:55 pm, Thomas Chiverton wrote: > I can't get the example 'echo' cfc working on my CFMX6.1 box. Of course, following up my own idea (!) I checked the line in Application.cfm, and that's where the login checks are :-) Whoops. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Timeout connecting to access DB
On Wednesday 14 Apr 2004 15:56 pm, Robert Bailey wrote: > We have had that problem quite a bit as well. Same set up. There are apperently updated DB drivers coming soon from MM. Don't give up yet ! -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Hi Patric, I'll try to consolidate information I've provided so far. I'm not at work today so I can't generate the exact code, but I'll do my best to simulate it. Here goes: Purpose of the code: When a user clicks on a menu link (generated by the CF code prior to the user interaction), an associated DIV, with an ID equal to the stylename, displays the link's content. This is because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block". These are a sample of the values in the stylesheet: #FellSvc{display:none;} #MinorRts{display:none;} #AmnInf{display:none;} #AnteSter{display:none;} The names of these styles are included as a column menu_bmarkLink in the db table. Other relevant columns in the db table are: menu_Text and menu_nonBmarkLink. (menu_nonBmarkLink is included in the query for a condition where a link doesn't have a bookmark, but has an external link instead. I don't think that matters for this post.) The query is something like this: Select * from faq_menulinks The output would be something like this: menu_Text menu_bmarkLink menu_nonBmarkLink link1 MinorRts link2 FellSvc link3 AmnInf link4 AnteSter link5 http://gosomewhereelse.com My output would be inserted into HTML list items something like this: "">"#q_menu.menu_nonBmarkLink#">"##Ans" which could produce output like: For links 1-4, the "#Ans" is the position in the screen where the content is displayed now that the onClick target style is set to display=block. (As mentioned previously, there is a div with the same name as the style that contains the content. Something like this: A minor has a lot of rights but they never think they have enough. They think they're old enough to make decisions for themselves, but some of those decisions could be deadly. If the solution to my problem is including another set of tags somewhere in this code so that the value for:#menu_bmarkLink# displays properly (a different value for it in each list item instance), then great. "">"#q_menu.menu_nonBmarkLink#">"##Ans" I got on this not-so-wild ride, when I got an error on the output code above saying something like, "onClick didn'tunderstand the variable". I took the tact of trying to make the #menu_bmarkLink# a js variable - which worked, but only to the extent that it returned only one value for the variable and repeated that value in each instance of a generated list item. Can you help? Appreciatively, Joy > Hi Joy, > > could you possibly make a dump of your query? So we can understand > what you data looks like? > > Patric > > > JH> onClick didn't understand a CF variable like: "#linkStyle#". It > wants _javascript_. I don't know how to make the _javascript_ variable I > create from the CF variable return each of the different > JH> values in the onClick event. > > JH> I get: > >> menu item one: ...> > > >> menu item two: ...> > > >> menu item two: ...> > > JH> How can I make the _javascript_ variable I create from the CF > variable loop through the values properly? > > JH> Thanks for trying to help with this problem. > > > >> But by the time the code gets to the browser, #linkStyle# will > have > >> been replaced by exactly what you show us here > > >> menu item one: ...> > > >> menu item two: ...> > > >> menu item two: ...> > >> > >> "view source" from your browser might help clear things up for you. > > >> > >> Or like Dick, I don't understand :( > > >> > > >> - Original Message - > > >> From: Joy Holman > > >> To: CF-Talk > > >> Sent: Tuesday, April 13, 2004 4:12 PM > > >> Subject: Re: passing multiple CF vaules to a _javascript_ variable > >> > >> > > >> Would this information help explain what I need? > >> > > >> Here's where the styles comes in: > > >> I have a CSS stylesheet with these values: > > >> #FellSvc{display:none;} > > >> #MinorRts{display:none;} > > >> #AmnInf{display:none;} > > >> #AnteSter{display:none;} > >> > > >> In the db table, I have a column for the same styles from the > >> stylesheet. Let's say the column name is "linkStyle" (like Dick's > >> example). Another column in the db table has the text for the menu > > >> link that displays on the page. > >> > > >> When a user clicks on a menu link (generated by the CF code prior > to > >> the user interaction), an assoicated DIV with an ID equal to the > >> stylename displays its content because the onClick event tells the > > >> matching style in the stylesheet to change "display=none" to > >> "display=block". > >> > > >> Using Dick's example, just change the end to something like this: > > >> >Now, iterating over the query: > > >> > > > >> > > > >> > > >> #linkName# > > >> > > >> > > >> Now, that doesn't work because #linkStyle# is CF and onClick needs > js. > >> > >
Re: onClick Nightmare!
> lename=' + escape(fields[n]), 'document', 'top=10,left=10,height=500,width=600,resizable=yes'); return false;" - Original Message - From: "Ian Skinner" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 14, 2004 8:24 AM Subject: RE: onClick Nightmare! > cfcoder > > I am trying to do this: > > > lename="+escape(fields[n])','Document','top=10,left=10,height=500,width=600, resizable=Yes'); > return false;" > > > > The first two problems I see is that the "+" operator is the concatenate operator in _javascript_ the "&" operator is the concatenate operator in CFML, so you will need to change the + to an &. Secondly escape is a JS function not a CFML function, I think the equivalent you need would be urlEncodedFormat(). That should get you closer to your goal. > > HTH > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Timeout connecting to access DB
> > We have had that problem quite a bit as well. Same set up. > > There are apperently updated DB drivers coming soon from MM. > Don't give up yet ! They have recently been released. 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: Backing up MySQL InnoDB DB
That's very similar to what we do, though we only do a dump once a month, and use the binary log (you do keep a binary log, right?) for incremental backups. If we need to restore near the end of the month, it's a bit of a pain, but better than forking all that cash for the bandwidth to do complete backups every day. Have you doublechecked that you can connect to the server with those credentials, and that the user has the needed access to the DB in question? Here's the specific command line we run (on RedHat 8, MySQL 4.0): mysqldump -u -p --add-drop-table --add-locks --all --quick --disable-keys --extended-insert --single-transaction --quote-names | gzip > /path/to/backup/dir/..sql.gz Cheers, barneyb > -Original Message- > From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 7:31 AM > To: CF-Talk > Subject: Backing up MySQL InnoDB DB > > Hi all > > our app run this .bat file to create a sql script(backup) > from our MySQL DB. > > c:\mysql\bin\mysqldump.exe --single-transaction -quick -u name_user > -ppass_user ourDB > c:\mysql\data\backups\ourDB_#datePart#.sql > > But results 0(zero) size... what's happened? > > > Do you have experience in backing up MySQL? > > Thanx for your time. > > p.s.: Windows 2003/MySQL 4.0.16/CF MX 6.1 > -- > ___ > Sign-up for Ads Free at Mail.com > http://promo.mail.com/adsfreejump.htm > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
striping url again...
Hello all... I am trying to strip a url up into sections... for example: If a have a url like http://www.mysite.com/ I want to take just the "mysite" part a store as a variable and then store the .com part as another variable then remove all the http:// and www parts. So far I have come up with this... but it only partially works. Thanks for any help on this... Neal Bailey Internet Marketing Manager E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Timeout connecting to access DB
Here is the link to the MM hotfix list :'http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm#MX61 ' By OS fully patched, do you mean it was run through all the Windows update patches? If so you may still be missing a recent MDAC update, you may wish to check that too. I can't remember off hand if 2.8 is the same version that shipped with Win2k3 or not. -Nate Nathan Smith McKee, Voorhees & Sease, P.L.C. 515.288.3667 -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 8:28 AM To: CF-Talk Subject: Timeout connecting to access DB I just recently upgraded the Servers, Windows 2k and CF5.0 to Win2k3 and CFMX 6.1. The system is runs great for a few days and then all Access Database's start to timeout. This does not seem to affect any other system on the server just Access ODNC connections. OS is fully patched Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Timeout connecting to access DB
That is what we heard when we contacted them about these issues about 3 months ago, lol. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 12:08 PM To: CF-Talk Subject: Re: Timeout connecting to access DB On Wednesday 14 Apr 2004 15:56 pm, Robert Bailey wrote: > We have had that problem quite a bit as well. Same set up. There are apperently updated DB drivers coming soon from MM. Don't give up yet ! -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Timeout connecting to access DB
Which one? We have installed all the patches current as of about a week ago, and nothing has changed, problems are still going on with any access databases. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 12:19 PM To: CF-Talk Subject: RE: Timeout connecting to access DB > > We have had that problem quite a bit as well. Same set up. > > There are apperently updated DB drivers coming soon from MM. > Don't give up yet ! They have recently been released. 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: Timeout connecting to access DB
Yeah, we tried that one, and did not help, made the problem not happen 10 times a day down to like 2 or 3 times a day. -Original Message- From: Nathan C. Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 12:23 PM To: CF-Talk Subject: RE: Timeout connecting to access DB Here is the link to the MM hotfix list :'http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm#MX61 ' By OS fully patched, do you mean it was run through all the Windows update patches? If so you may still be missing a recent MDAC update, you may wish to check that too. I can't remember off hand if 2.8 is the same version that shipped with Win2k3 or not. -Nate Nathan Smith McKee, Voorhees & Sease, P.L.C. 515.288.3667 -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 8:28 AM To: CF-Talk Subject: Timeout connecting to access DB I just recently upgraded the Servers, Windows 2k and CF5.0 to Win2k3 and CFMX 6.1. The system is runs great for a few days and then all Access Database's start to timeout. This does not seem to affect any other system on the server just Access ODNC connections. OS is fully patched Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MX: Scheduler firing off too often
On Wednesday 14 Apr 2004 16:33 pm, Scott Weikert wrote: > I've already looked over the neo-cron.xml file on the server in question - > it's got just the data it should, based on what shows in the scheduler page > in the CF admin. And I assume stopping and starting the server doesn't cure the problem ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing multiple CF vaules to a javascript variable
Hi Joy, It looks like your query results must not be what you expect. I've included a skeleton example of what I think you're aiming for, but which loops through a list since I don't have your data. Untitled
#aaa {display:none;}
#bbb {display:none;}
#ccc {display:none;}
> I am aaa I am bbb I am ccc -Original Message- From: Joy Holman [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 12:12 PM To: CF-Talk Subject: Re: passing multiple CF vaules to a _javascript_ variable Hi Patric, I'll try to consolidate information I've provided so far. I'm not at work today so I can't generate the exact code, but I'll do my best to simulate it. Here goes: Purpose of the code: When a user clicks on a menu link (generated by the CF code prior to the user interaction), an associated DIV, with an ID equal to the stylename, displays the link's content. This is because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block". These are a sample of the values in the stylesheet: #FellSvc{display:none;} #MinorRts{display:none;} #AmnInf{display:none;} #AnteSter{display:none;} The names of these styles are included as a column menu_bmarkLink in the db table. Other relevant columns in the db table are: menu_Text and menu_nonBmarkLink. (menu_nonBmarkLink is included in the query for a condition where a link doesn't have a bookmark, but has an external link instead. I don't think that matters for this post.) The query is something like this: Select * from faq_menulinks The output would be something like this: menu_Text menu_bmarkLink menu_nonBmarkLink link1 MinorRts link2 FellSvc link3 AmnInf link4 AnteSter link5 http://gosomewhereelse.com My output would be inserted into HTML list items something like this: "">"#q_menu.menu_nonBmarkLink#">"##Ans" > which could produce output like: For links 1-4, the "#Ans" is the position in the screen where the content is displayed now that the onClick target style is set to display=block. (As mentioned previously, there is a div with the same name as the style that contains the content. Something like this: A minor has a lot of rights but they never think they have enough. They think they're old enough to make decisions for themselves, but some of those decisions could be deadly. content If the solution to my problem is including another set of tags somewhere in this code so that the value for:#menu_bmarkLink# displays properly (a different value for it in each list item instance), then great. "">"#q_menu.menu_nonBmarkLink#">"##Ans" > I got on this not-so-wild ride, when I got an error on the output code above saying something like, "onClick didn'tunderstand the variable". I took the tact of trying to make the #menu_bmarkLink# a js variable - which worked, but only to the extent that it returned only one value for the variable and repeated that value in each instance of a generated list item. Can you help? Appreciatively, Joy > Hi Joy, > > could you possibly make a dump of your query? So we can understand > what you data looks like? > > Patric > > > JH> onClick didn't understand a CF variable like: "#linkStyle#". It > wants _javascript_. I don't know how to make the _javascript_ variable I > create from the CF variable return each of the different > JH> values in the onClick event. > > JH> I get: > >> menu item one: ...> > > >> menu item two: ...> > > >> menu item two: ...> > > JH> How can I make the _javascript_ variable I create from the CF > variable loop through the values properly? > > JH> Thanks for trying to help with this problem. > > > >> But by the time the code gets to the browser, #linkStyle# will > have > >> been replaced by exactly what you show us here > > >> menu item one: ...> > > >> menu item two: ...> > > >> menu item two: ...> > >> > >> "view source" from your browser might help clear things up for you. > > >> > >> Or like Dick, I don't understand :( > > >> > > >> - Original Message - > > >> From: Joy Holman > > >> To: CF-Talk > > >> Sent: Tuesday, April 13, 2004 4:12 PM > > >> Subject: Re: passing multiple CF vaules to a _javascript_ variable > >> > >> > > >> Would this information help explain what I need? > >> > > >> Here's where the styles comes in: > > >> I have a CSS stylesheet with these values: > > >> #FellSvc{display:none;} > > >> #MinorRts{display:none;} > > >> #AmnInf{display:none;} > > >> #AnteSter{display:none;} > >> > > >> In the db table, I have a column for the same styles from the > >> stylesheet. Let's say the column name is "linkStyle" (like Dick's > >> example). Another column in the db table has
RE: Timeout connecting to access DB
> Which one? We have installed all the patches current as of > about a week ago, and nothing has changed, problems are still > going on with any access databases. They've been out for about a week or two, I forget the exact date. You might try using the Unicode Access driver, instead of the regular one. 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: passing multiple CF values to a JavaScript variable
Hi Patric, I'll try to consolidate information I've provided so far. I'm not at work today so I can't generate the exact code, but I'll do my best to simulate it. Here goes: Purpose of the code: When a user clicks on a menu link (generated by the CF code prior to the user interaction), an associated DIV with an ID equal to the stylename displays its content. This is because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block". These are a sample of the values in the stylesheet: #FellSvc{display:none;} #MinorRts{display:none;} #AmnInf{display:none;} #AnteSter{display:none;} The names of these styles are included as a column (menu_bmarkLink) in the db table. Other relevant columns in the db table are: menu_Text and menu_nonBmarkLink. For the issue at hand, the column menu_Text and menu_bmarkLink. (menu_nonBmarkLink is included in the query for a condition where a link doesn't have a bookmark, but has an external link instead. I don't think that matters for this post.) The query is something like this: Select * from faq_menulinks The output would be something like this: menu_Text menu_bmarkLink menu_nonBmarkLink link1 MinorRts link2 FellSvc link3 AmnInf link4 AnteSter link5 http://gosomewhereelse.com My output would be inserted into HTML list items something like this: "">"#q_menu.menu_nonBmarkLink#">"##Ans" which could produce output like: For links 1-4, the "#Ans" is the position in the screen where the content is displayed now that the onClick target style is set to display=block. (As mentioned previously, there is a div with the same name as the style that contains the content. Something like this: A minor has a lot of rights but they never think they have enough. They think they're old enough to make decisions for themselves, but some of those decisions could be deadly. If the solution to my problem is including another set of tags somewhere in this code so that the value for:#menu_bmarkLink# displays properly (a different value for it in each list item instance), then great. "#q_menu.menu_nonBmarkLink#">"##Ans" I got on this not-so-wild ride, when I got an error on the output code above saying something like, "onClick didn'tunderstand the variable". I took the tact of trying to make the #menu_bmarkLink# a js variable - which worked, but only to the extent that it returned only one value for the variable and repeated that value in each instance of a generated list item. Can you help? Appreciatively, Joy > The concept that took me awhile to get my head around. You don't > usually pass variables to _javascript_ in examples like this. If you > need to truly pass variables to _javascript_ from CFML you need to use > some kind of intermediary technology such as WDDX. But for what you > seem to be trying to do, you just need to create some dynamically > written _javascript_. This works just like dynamically written HTML > that we all do on a daily basis. All the CFML mixed with _javascript_ > code is rendered in the server and the completed _javascript_ is sent to > the client where it is ran. Some basic examples: > > To create a list of links with a dynamic _javascript_ phrase: > > > > aColumn#')">#aQuery.anotherColumn# > > > A gotcha in this syntax is the mixing of quotes on the onClick > property. If you want the parameter of the JS function to be a string > literal wrapped in quotes and the onClick property to be correctly > wrapped in quotes you must properly nest double (") and single (') > quotes. Also, if the JS complains about the string #aQuery.aColumn#, > then the CFML variable was not rendered, which means that is was not > inside tags for some reason. > > > > > To create a dynamically generated JS function: > >
>
> function aJSfunction ( foo, bar )
> {
> var sampleArray = new Array(1);
>
>
> sampleArray[currentRow] = "#aQuery.aColumn#";
>
> }
> > > This would create a simple JS array out of the values in a column from > a CFML query. This could also be done with WDDX if one so desired. > If you are using a Macromedia IDE such as Studio, Homesite or > Dreamweaver, the color coding feature gets confused with this kind of > mixing of JS and CFML code, but that has no bearing on the correctness > of the code so just ignore the strange coloring of the code. > > HTH > > If you are still unsure of how to accomplish your requirements and if > you can provide a couple of snippets of your actual code we can > probably help you more specifically with your syntax. > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia
Re: passing multiple CF values to a JavaScript variable
Hi Patric, I'll try to consolidate information I've provided so far. I'm not at work today so I can't generate the exact code, but I'll do my best to simulate it. Here goes: Purpose of the code: When a user clicks on a menu link (generated by the CF code prior to the user interaction), an associated DIV, with an ID equal to the stylename, displays the link's content. This is because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block". These are a sample of the values in the stylesheet: #FellSvc{display:none;} #MinorRts{display:none;} #AmnInf{display:none;} #AnteSter{display:none;} The names of these styles are included as a column menu_bmarkLink in the db table. Other relevant columns in the db table are: menu_Text and menu_nonBmarkLink. (menu_nonBmarkLink is included in the query for a condition where a link doesn't have a bookmark, but has an external link instead. I don't think that matters for this post.) The query is something like this: Select * from faq_menulinks The output would be something like this: menu_Text menu_bmarkLink menu_nonBmarkLink link1 MinorRts link2 FellSvc link3 AmnInf link4 AnteSter link5 http://gosomewhereelse.com My output would be inserted into HTML list items something like this: "">"#q_menu.menu_nonBmarkLink#">"##Ans" which could produce output like: For links 1-4, the "#Ans" is the position in the screen where the content is displayed now that the onClick target style is set to display=block. (As mentioned previously, there is a div with the same name as the style that contains the content. Something like this: A minor has a lot of rights but they never think they have enough. They think they're old enough to make decisions for themselves, but some of those decisions could be deadly. If the solution to my problem is including another set of tags somewhere in this code so that the value for:#menu_bmarkLink# displays properly (a different value for it in each list item instance), then great. "">"#q_menu.menu_nonBmarkLink#">"##Ans" I got on this not-so-wild ride, when I got an error on the output code above saying something like, "onClick didn'tunderstand the variable". I took the tact of trying to make the #menu_bmarkLink# a js variable - which worked, but only to the extent that it returned only one value for the variable and repeated that value in each instance of a generated list item. Can you help? Appreciatively, Joy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing multiple CF values to a JavaScript variable
I created the following test code and it runs just fine, I believe it does basically what you are asking code to do. HTH aQuery = queryNew("menu_bmarkLink,menu_Text,menu_nonBmarkLink"); tmp = QueryAddRow(aQuery,4); tmp = QuerySetCell(aQuery,"menu_bmarkLink","MinorRts",1); tmp = QuerySetCell(aQuery,"menu_bmarkLink","FellSvc",2); tmp = QuerySetCell(aQuery,"menu_bmarkLink","AmnInf",3); tmp = QuerySetCell(aQuery,"menu_bmarkLink","AnteSter",4); tmp = QuerySetCell(aQuery,"menu_Text","MinorRts Link",1); tmp = QuerySetCell(aQuery,"menu_Text","FellSvc Link",2); tmp = QuerySetCell(aQuery,"menu_Text","AmnInf Link",3); tmp = QuerySetCell(aQuery,"menu_Text","AnteSter Link",4); Untitled Document
#FellSvc{display:none;}
#MinorRts{display:none;}
#AmnInf{display:none;}
#AnteSter{display:none;}
FellSvc MinorRts AmnInf AnteSter -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
help needed with variables, loops, and multi-step forms
Please bear with me as this is the first time I have attempted this. I am creating variables that will be used as initial empty values for form fields in a multi-step process. I am creating the variables as follows: variables.numPeople = 3; variables.stPeople = structNew(); for (i=1; i LTE variables.numPeople; i=i+1) { variables.stPeople['stPerson' & i] = structNew(); variables.stPeople['stPerson' & i]['firstName'] = ""; variables.stPeople['stPerson' & i]['lastName'] = ""; } Based on the numPeople value I want to dispaly as many sets of form fields for a user to fill in as follows: So my question is how do I populate the value attribute of the form fields that are created in a loop with the initial empty variables that were also created in a loop? Basically I want the value attribute of the form fields to be value="#variables.stPeople.stPerson1.firstName#" and the stPerson1 changes numbers as the loop increments. Is it just a matter of using the proper syntax? If so I am missing it completely. Hopefully I have expressed myself clearly! Thanks, Nate [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
'this' in CFCs
Is it right that 'this' does not exist in CFC's where invoked with '?wsdl' to generate a WSDL description ? I'd say it was a bug, rather than a feature if so... Either, any good work arounds ? Our objects call a logger on init., and pass in '#this#'. The logger uses getMetaData() to write log messages. I'd really rather not go through all the objects and put round all the loging statements... -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Proving you are legitimate from CFMail
I am developing a service that sends email to registered users about upcoming events. I keep getting errors about my mails being bounced as spam. Even test emails I am sending to myself are getting bounced by my ISP. What procedures does a business need to go through to prove they are legitimate? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF values to a JavaScript variable
So there was nothing wrong with my original code and I shouldn't have gotten an error saying that onClick didn't understand the CF variable #menu_bmarkLink#. Maybe it failed because there was no value for #menu_bmarkLink# when that variable was blank - which would be the case when the menu_nonBmarkLink column had a value. So maybe that column is relevant after all. I'll pull out the record containing the menu_nonBmarkLink value and see if I get the results you did. At least that will pinpoint the problem better. Thanks. Joy > I created the following test code and it runs just fine, I believe it > does basically what you are asking code to do. > > HTH > > > > aQuery = queryNew("menu_bmarkLink,menu_Text,menu_nonBmarkLink"); > tmp = QueryAddRow(aQuery,4); > tmp = QuerySetCell(aQuery,"menu_bmarkLink","MinorRts",1); > tmp = QuerySetCell(aQuery,"menu_bmarkLink","FellSvc",2); > tmp = QuerySetCell(aQuery,"menu_bmarkLink","AmnInf",3); > tmp = QuerySetCell(aQuery,"menu_bmarkLink","AnteSter",4); > > tmp = QuerySetCell(aQuery,"menu_Text","MinorRts Link",1); > tmp = QuerySetCell(aQuery,"menu_Text","FellSvc Link",2); > tmp = QuerySetCell(aQuery,"menu_Text","AmnInf Link",3); > tmp = QuerySetCell(aQuery,"menu_Text","AnteSter Link",4); > > > > > > Untitled Document > >
> #FellSvc{display:none;}
> #MinorRts{display:none;}
> #AmnInf{display:none;}
> #AnteSter{display:none;}
>
> > > > > > > > display='block'">#menu_Text# > > > > FellSvc > display='none'">Hide content > MinorRts > display='none'">Hide content > AmnInf > display='none'">Hide content > AnteSter > display='none'">Hide content > >
> > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Proving you are legitimate from CFMail
A few things to look out for 1) make sure the FROM address is a valid account with your ISP 2) alter the subject line for each recipient as sometimes a bunch of mails with the same subject get caught up 3) talk to your ISP about their e-mail policies...they know best ;-) HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Craig Earls To: CF-Talk Sent: Wednesday, April 14, 2004 10:05 AM Subject: Proving you are legitimate from CFMail I am developing a service that sends email to registered users about upcoming events. I keep getting errors about my mails being bounced as spam. Even test emails I am sending to myself are getting bounced by my ISP. What procedures does a business need to go through to prove they are legitimate? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 'this' in CFCs
> Is it right that 'this' does not exist in CFC's where invoked > with '?wsdl' to generate a WSDL description ? > I'd say it was a bug, rather than a feature if so... Incorrect. Consider... When I call this cfc's test method via web services, it works just fine. > Either, any good work arounds ? Our objects call a logger on > init., and pass in '#this#'. The logger uses getMetaData() to > write log messages. > I'd really rather not go through all the objects and put > round all the loging statements... Remember that when using a CFC as a WS, you are not using an object per se, it's more of a service. The CFC gets created then destroyed once you are done. So, for example, if my test method above we to say... the value will _always_ be 1. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help needed with variables, loops, and multi-step forms
Use value="#variables.stPeople['stPerson#i#'].firstname#" -Raymond Camden > variables.numPeople = 3; > > variables.stPeople = structNew(); > > for (i=1; i LTE variables.numPeople; i=i+1) { > variables.stPeople['stPerson' & i] = structNew(); > variables.stPeople['stPerson' & i]['firstName'] = ""; > variables.stPeople['stPerson' & i]['lastName'] = ""; > } > > > > Based on the numPeople value I want to dispaly as many sets > of form fields for a user to fill in as follows: > > > > > > > > > > > So my question is how do I populate the value attribute of > the form fields that are created in a loop with the initial > empty variables that were also created in a loop? Basically I > want the value attribute of the form fields to be > value="#variables.stPeople.stPerson1.firstName#" and the > stPerson1 changes numbers as the loop increments. Is it just > a matter of using the proper syntax? If so I am missing it completely. > > Hopefully I have expressed myself clearly! > > Thanks, > > Nate > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: passing multiple CF values to a JavaScript variable
I think you might be right, when I added a row to my test query with a blank "menu_bmarkLink" it produced output such as this: That is definitely incorrect syntax in the onClick property and my test threw a JS error, but it did not say anything about not understanding #menu_bmarkLink# You should just need to trap for blanks in that column and not output an onClick property for those rows. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Proving you are legitimate from CFMail
Also, you may want to consider running your email message through a spam checker first. This will flag for potential problems. There's a free message checker at www.lyris.com/contentchecker Thanks, Mark _ From: Craig Earls [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 1:05 PM To: CF-Talk Subject: Proving you are legitimate from CFMail I am developing a service that sends email to registered users about upcoming events. I keep getting errors about my mails being bounced as spam. Even test emails I am sending to myself are getting bounced by my ISP. What procedures does a business need to go through to prove they are legitimate? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF values to a JavaScript variable
Joy, taht's what I think too. The code sample Dave provided does the same thing your code should render. That's why I thought you could provide a dump of your database query to see if it's serving unexpected data... Patric > So there was nothing wrong with my original code and I shouldn't have gotten an error saying that onClick didn't understand the CF variable #menu_bmarkLink#. > Maybe it failed because there was no value for #menu_bmarkLink# when that variable was blank - which would be the case when the menu_nonBmarkLink column had a value. So maybe that column is > relevant after all. > I'll pull out the record containing the menu_nonBmarkLink value and see if I get the results you did. At least that will pinpoint the problem better. > Thanks. > Joy >> I created the following test code and it runs just fine, I believe it >> does basically what you are asking code to do. >> >> HTH >> >> >> >> aQuery = queryNew("menu_bmarkLink,menu_Text,menu_nonBmarkLink"); >> tmp = QueryAddRow(aQuery,4); >> tmp = QuerySetCell(aQuery,"menu_bmarkLink","MinorRts",1); >> tmp = QuerySetCell(aQuery,"menu_bmarkLink","FellSvc",2); >> tmp = QuerySetCell(aQuery,"menu_bmarkLink","AmnInf",3); >> tmp = QuerySetCell(aQuery,"menu_bmarkLink","AnteSter",4); >> >> tmp = QuerySetCell(aQuery,"menu_Text","MinorRts Link",1); >> tmp = QuerySetCell(aQuery,"menu_Text","FellSvc Link",2); >> tmp = QuerySetCell(aQuery,"menu_Text","AmnInf Link",3); >> tmp = QuerySetCell(aQuery,"menu_Text","AnteSter Link",4); >> >> >> >> >> >> Untitled Document >> >>
>> #FellSvc{display:none;}
>> #MinorRts{display:none;}
>> #AmnInf{display:none;}
>> #AnteSter{display:none;}
>>
>> >> >> >> >> >> >> >> display='block'">#menu_Text# >> >> >> >> FellSvc >> display='none'">Hide content >> MinorRts >> display='none'">Hide content >> AmnInf >> display='none'">Hide content >> AnteSter >> display='none'">Hide content >> >> >
> >
> > >> >> >> -- >> Ian Skinner >> Web Programmer >> BloodSource >> www.BloodSource.org >> Sacramento, CA >> >> "C code. C code run. Run code run. Please!" >> - Cynthia Dunning >> >> >> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF values to a JavaScript variable
Thank you for testing that,Ian. I must have jumped to the wrong conclusion. I didn't expect that onClick would read the portion of my when the condition was met for the menu_nonbmarkLink. > I think you might be right, when I added a row to my test query with a > blank "menu_bmarkLink" it produced output such as this: > > > That is definitely incorrect syntax in the onClick property and my > test threw a JS error, but it did not say anything about not > understanding #menu_bmarkLink# > > You should just need to trap for blanks in that column and not output > an onClick property for those rows. > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF values to a JavaScript variable
I see. I'll definitely incorporate that strategy. Thanks, Patric. Joy > Joy, > > taht's what I think too. The code sample Dave provided does the same > thing your code should render. That's why I thought you could provide > a dump of your database query to see if it's serving unexpected > data... > > Patric > > > So there was nothing wrong with my original code and I shouldn't > have gotten an error saying that onClick didn't understand the CF > variable #menu_bmarkLink#. > > Maybe it failed because there was no value for #menu_bmarkLink# when > that variable was blank - which would be the case when the > menu_nonBmarkLink column had a value. So maybe that column is > > relevant after all. > > > I'll pull out the record containing the menu_nonBmarkLink value and > see if I get the results you did. At least that will pinpoint the > problem better. > > > Thanks. > > Joy > > > >> I created the following test code and it runs just fine, I believe > it > >> does basically what you are asking code to do. > > >> > >> HTH > > >> > >> > >> > > >> aQuery = queryNew("menu_bmarkLink,menu_Text,menu_nonBmarkLink"); > > >> tmp = QueryAddRow(aQuery,4); > > >> tmp = QuerySetCell(aQuery,"menu_bmarkLink","MinorRts",1); > > >> tmp = QuerySetCell(aQuery,"menu_bmarkLink","FellSvc",2); > > >> tmp = QuerySetCell(aQuery,"menu_bmarkLink","AmnInf",3); > > >> tmp = QuerySetCell(aQuery,"menu_bmarkLink","AnteSter",4); > > >> > > >> tmp = QuerySetCell(aQuery,"menu_Text","MinorRts Link",1); > > >> tmp = QuerySetCell(aQuery,"menu_Text","FellSvc Link",2); > > >> tmp = QuerySetCell(aQuery,"menu_Text","AmnInf Link",3); > > >> tmp = QuerySetCell(aQuery,"menu_Text","AnteSter Link",4); > > >> > >> > >> > >> > >> > >> Untitled Document > >> > >>
> >> #FellSvc{display:none;}
> >> #MinorRts{display:none;}
> >> #AmnInf{display:none;}
> >> #AnteSter{display:none;}
>
> >>
> >> > >> > > >> > >> > >> > >> > > >> > >> display='block'">#menu_Text# > >> > >> > > >> > >> FellSvc > >> display='none'">Hide content > >> MinorRts > > >> display='none'">Hide content > >> AmnInf > >> display='none'">Hide content > >> AnteSter > > >> display='none'">Hide content > >> > >> > >
> > >
> > > > >
> >> > >> > >> -- > >> Ian Skinner > >> Web Programmer > >> BloodSource > >> www.BloodSource.org > >> Sacramento, CA > >> > >> "C code. C code run. Run code run. Please!" > > >> - Cynthia Dunning > >> > >> > >> > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Issue with Loops and queries
I am running into an issue where Cf doesn't want to execute a query. Here is what I'm doing cfloop query cfquery cfloop query cfquery cfloop query cfquery The last cfquery isn't executing. The query is good as for testing purposes I copied a query from above in the loop, and renamed it and it woudln't execute it. If I mess the code up on the last query it will error out. Is there some kind of limit I am hitting that I didn't know about. Bob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Issue with Loops and queries
I don't have an answer to your question, but that looks like a REALLY bad way to have a page execute. Surely you can avoid some of those nested queries with JOINs, and then use CFOUTPUT with a GROUP attribute? You might be running into some variable collisions. I've had "interesting" situations arise when several queries are all being used at the same time, though nothing careful scoping has failed to address. Cheers, barneyb > -Original Message- > From: Robert Everland III [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 10:58 AM > To: CF-Talk > Subject: Issue with Loops and queries > > I am running into an issue where Cf doesn't want to execute a > query. Here is what I'm doing > > cfloop query > cfquery > cfloop query > cfquery > cfloop query > cfquery > > The last cfquery isn't executing. The query is good as for > testing purposes I copied a query from above in the loop, and > renamed it and it woudln't execute it. If I mess the code up > on the last query it will error out. Is there some kind of > limit I am hitting that I didn't know about. > > > Bob > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Issue with Loops and queries
> From: Robert Everland III > > I am running into an issue where Cf doesn't want to execute a > query. Here is what I'm doing > > cfloop query > cfquery > cfloop query > cfquery > cfloop query > cfquery > > The last cfquery isn't executing. The query is good as for > testing purposes I copied a query from above in the loop, and > renamed it and it woudln't execute it. If I mess the code up > on the last query it will error out. Is there some kind of > limit I am hitting that I didn't know about. Are these queries from the same datasource? If so, do it in one query with joins (probably left outer join) You'll save processing on the CF end, and will end up with one CFOUTPUT GROUP= instead [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Issue with Loops and queries
yah, can you show the query? we can probably dress it up real nice... tw -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 2:19 PM To: CF-Talk Subject: RE: Issue with Loops and queries > From: Robert Everland III > > I am running into an issue where Cf doesn't want to execute a query. > Here is what I'm doing > > cfloop query > cfquery > cfloop query > cfquery > cfloop query > cfquery > > The last cfquery isn't executing. The query is good as for testing > purposes I copied a query from above in the loop, and renamed it and > it woudln't execute it. If I mess the code up on the last query it > will error out. Is there some kind of limit I am hitting that I didn't > know about. Are these queries from the same datasource? If so, do it in one query with joins (probably left outer join) You'll save processing on the CF end, and will end up with one CFOUTPUT GROUP= instead [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Advanced search examples, field based searches
I'm looking for examples of search interfaces for end users that provide fully query type functionality in an interface simple enough for a non-technical end user to take advantage of. Specifically we're searching for values in named fields, allowing the user to specify groupings (parenthesis), and relationships between field groups (and/or/not). Thanks, Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Check server memory and CFMX restarts>>>
When I try this I get an error that the maxMemory function does not exist. The other two functions work fine. CFMX 6.1 on windows 2000 sp4. Brook At 08:41 AM 4/14/2004, you wrote: >Awesome, that is exactly what I was looking for! > > >And, it doesn't look like the server's restarting from what I can tell, I >just wanted to make it would list it in the logs if it did...thanks for the >help-> > > >Tyler S > > _ > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 14, 2004 11:19 AM >To: CF-Talk >Subject: RE: Check server memory and CFMX restarts>>> > >yes, restarts are logged in the server log. You should prob figure out why >the restarts are occuring though, eh? You have an app with long running SQL >or something? > >This will tell you the memory stuffs. Curteousy of Pete Frietag's blog. > > > > > > > Free Allocated Memory: #Round(freeMemory)#mb > Total Memory Allocated: #Round(totalMemory)#mb > Max Memory Available to JVM: #Round(maxMemory)#mb > > >Doug > >-Original Message- >From: Tyler Silcox [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 14, 2004 10:38 AM >To: CF-Talk >Subject: Check server memory and CFMX restarts>>> > >Is there a way to check available memory for CFMX from code? (i.e. I do not >have access to the physical server.) > >I've seen it done before for Java based custom tags, but I was wondering if >there is a way to tell if CFMX is running out of memory (because I keep >losing my application variables way before the specified timeouts.) > >And does CF record every time it restarts in the "server" log, or would it >only be recorded in the actual server's log (from IIS for example)? > >Tyler S > _ > _ > >-- >[Todays Threads] >[This Message] >[Subscription] >[Fast > Unsubscribe] [User Settings] > >-- > >[] > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advanced search examples, field based searches
besides crystal reports? -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 2:23 PM To: CF-Talk Subject: Advanced search examples, field based searches I'm looking for examples of search interfaces for end users that provide fully query type functionality in an interface simple enough for a non-technical end user to take advantage of. Specifically we're searching for values in named fields, allowing the user to specify groupings (parenthesis), and relationships between field groups (and/or/not). Thanks, Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Advanced search examples, field based searches
Crystal reports is not an end user tool, it's a developer tool. I'm looking for something for an end user to within the HTML application. Thanks, Sam > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 06:26 PM > To: 'CF-Talk' > Subject: RE: Advanced search examples, field based searches > > besides crystal reports? > > -Original Message- > From: Samuel Neff [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 2:23 PM > To: CF-Talk > Subject: Advanced search examples, field based searches > > I'm looking for examples of search interfaces for end users that provide > fully query type functionality in an interface simple enough for a > non-technical end user to take advantage of. > > Specifically we're searching for values in named fields, allowing the user > to specify groupings (parenthesis), and relationships between field groups > (and/or/not). > > Thanks, > > Sam > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Issue with Loops and queries
Here you go, I've been thinking of a better way of doing it and haven't come up with anything. Select CatID as itemid , Category as description, ParentId as ParentItemID, catlevel, catid, category, parentid From Categories_internal where catlevel = 0 order by Orderby desc
// You can find instructions for this file at http://www.treeview.net
//Environment variables are usually set at the top of this file.
USETEXTLINKS = 1
STARTALLOPEN = 0
USEFRAMES = 0
USEICONS = 0
WRAPTEXT = 1
PERSERVESTATE = 1
ICONPATH = "js/tree/"
foldersTree = gFld("", "")
foldersTree.treeID = "viewcontent"
aux1 = insFld(foldersTree, gFld("#category#", "#request.self#?fuseaction=#fusebox.targetcircuit#.content&catid=#catid#"))
Select Categories_internal.CatID as itemid ,
Categories_internal.Category as description,
Categories_internal.ParentId as ParentItemID,
Categories_internal.catlevel,
Categories_internal.catid,
Categories_internal.category,
Categories_internal.parentid
From Categories_internal inner join articles on (Categories_internal.catid = articles.catid_internal)
Where Categories_internal.parentID = #listcategories.catid#
and #now()# between articles.starttime and articles.endtime
aux2 = insFld(aux1, gFld("#category#", "#request.self#?fuseaction=#fusebox.targetcircuit#.content&catid=#catid#"))
Select Categories_internal.CatID as itemid ,
Categories_internal.Category as description,
Categories_internal.ParentId as ParentItemID,
Categories_internal.catlevel,
Categories_internal.catid,
Categories_internal.category,
Categories_internal.parentid
From Categories_internal inner join articles on (Categories_internal.catid = articles.catid_internal)
Where Categories_internal.parentID = #listsubcategories.catid#
and #now()# between articles.starttime and articles.endtime
aux3 = insFld(aux2, gFld("#category#", "#request.self#?fuseaction=#fusebox.targetcircuit#.content&catid=#catid#"))
Select Categories_internal.CatID as itemid ,
Categories_internal.Category as description,
Categories_internal.ParentId as ParentItemID,
Categories_internal.catlevel,
Categories_internal.catid,
Categories_internal.category,
Categories_internal.parentid
From Categories_internal inner join articles on (Categories_internal.catid = articles.catid_internal)
Where Categories_internal.parentID = #listsubcategories.catid#
and #now()# between articles.starttime and articles.endtime
test
initializeDocument() >yah, can you show the query? > >we can probably dress it up real nice... > >tw > >-Original Message- >From: Philip Arnold [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 14, 2004 2:19 PM >To: CF-Talk >Subject: RE: Issue with Loops and queries > > >Are these queries from the same datasource? > >If so, do it in one query with joins (probably left outer join) > >You'll save processing on the CF end, and will end up with one CFOUTPUT >GROUP= instead [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1 & Active Directory
We have a new test environment setup (isloated envrionment) utilizing Active Directory (AD). I was asked to look into tying AD authentication into our 4 main CFMX apps. I am doing my homework on AD, and would like to know if anyone knows of some articles, papers, blogs, etc, that might have some information on how to get started. Right now, each application authenticates in its own way off of a SQL 2K server... we are looking to bring all the apps together under one authentication method, that being AD. Any help is much appreciated. Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Proving you are legitimate from CFMail
CFMail has an attribute to set the mail agent, which by default identifies the mailer as CF. Set this to be something more common like the Outlook agent. X-Mailer: Microsoft Office Outlook, Build 11.0.5510 It won't fix all things that cause mail to be caught as spam, but it's a biggie. HTH, Sam -Original Message- From: Craig Earls [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 1:05 PM To: CF-Talk Subject: Proving you are legitimate from CFMail I am developing a service that sends email to registered users about upcoming events. I keep getting errors about my mails being bounced as spam. Even test emails I am sending to myself are getting bounced by my ISP. What procedures does a business need to go through to prove they are legitimate? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Proving you are legitimate from CFMail
Craig, One of the mail headers (I can't remember which one) identifies the sender as "ColdFusion Application Server" (or something like that). I think the header is something like "X-Mailer". Anyhow, this is one of the things that spam filters look out for. Fortunatly, you can change this header's value using . Also, make sure that you are following the new "Can Spam" legislation so that you don't get identified as a spammer because you aren't clearly identifying yourself in the body of the email. There are also services out there that will verify that you are legit. If changing the header doen't fix your problem, I would check these out. Paul Kenney [EMAIL PROTECTED] 916-212-4359 > -Original Message- > From: Mark Leder [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 10:29 AM > To: CF-Talk > Subject: RE: Proving you are legitimate from CFMail > > > Also, you may want to consider running your email message > through a spam > checker first. This will flag for potential problems. There's a free > message checker at www.lyris.com/contentchecker > > > Thanks, Mark > > > > _ > > From: Craig Earls [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 1:05 PM > To: CF-Talk > Subject: Proving you are legitimate from CFMail > > > I am developing a service that sends email to registered users about > upcoming events. I keep getting errors about my mails being > bounced as > spam. Even test emails I am sending to myself are getting > bounced by my > ISP. What procedures does a business need to go through to > prove they are > legitimate? > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFLDAP and French characters on CFMX
Hi, I am having trouble with CFLDAP and Fench (accented) characters. Any accented character is being returned as a non-printable character. I used the ASC() function to see what it was and it is a 65533. This worked fine on CF 5. So far I have tried CFCONTENT and CFProcessingDirective to to specify encodings but to no avail. Any help would be appreciated. -Frank [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Issue with Loops and queries
How about this. I didn't take into account the joins on the article table, nor selecting all your columns, but those should be straightforward. SELECT cat.CatID AS itemID, sub.CatID AS subitemID, subsub.CatID AS subsubitemID, subsubsub.CatID AS subsubsubitemID FROM Categories_internal cat LEFT OUTER JOIN Categories_internal sub ON cat.CatID = sub.parentID LEFT OUTER JOIN Categories_internal subsub ON sub.CatID = subsub.parentID LEFT OUTER JOIN Categories_internal subsubsub ON subsub.CatID = subsubsub.parentID WHERE cat.catlevel = 0 blah blah blah blah Cheers, barneyb > -Original Message- > From: Robert Everland III [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 11:39 AM > To: CF-Talk > Subject: Re: Issue with Loops and queries > > Here you go, I've been thinking of a better way of doing it > and haven't come up with anything. > > > > > > dbtype="ODBC"> > Select CatID as itemid , > Category as description, > ParentId as ParentItemID, > catlevel, > catid, > category, > parentid > From Categories_internal > where catlevel = 0 > order by Orderby desc > > > >
> // You can find instructions for this file at http://www.treeview.net
>
> //Environment variables are usually set at the top of this file.
> USETEXTLINKS = 1
> STARTALLOPEN = 0
> USEFRAMES = 0
> USEICONS = 0
> WRAPTEXT = 1
> PERSERVESTATE = 1
> ICONPATH = "js/tree/"
>
> foldersTree = gFld("", "")
> foldersTree.treeID = "viewcontent"
>
>
> aux1 = insFld(foldersTree, gFld("#category#",
> "#request.self#?fuseaction=#fusebox.targetcircuit#.content&cat
> id=#catid#"))
>> datasource="#request.dsn1#" dbtype="ODBC">
> Select Categories_internal.CatID as itemid ,
>
> Categories_internal.Category as description,
>
> Categories_internal.ParentId as ParentItemID,
> Categories_internal.catlevel,
> Categories_internal.catid,
> Categories_internal.category,
> Categories_internal.parentid
> From Categories_internal inner join
> articles on (Categories_internal.catid = articles.catid_internal)
> Where Categories_internal.parentID =
> #listcategories.catid#
> and #now()# between
> articles.starttime and articles.endtime
>
>
> aux2 = insFld(aux1, gFld("#category#",
> "#request.self#?fuseaction=#fusebox.targetcircuit#.content&cat
> id=#catid#"))
>> datasource="#request.dsn1#" dbtype="ODBC">
> Select
> Categories_internal.CatID as itemid ,
>
> Categories_internal.Category as description,
>
> Categories_internal.ParentId as ParentItemID,
>
> Categories_internal.catlevel,
>
> Categories_internal.catid,
>
> Categories_internal.category,
>
> Categories_internal.parentid
> From Categories_internal
> inner join articles on (Categories_internal.catid =
> articles.catid_internal)
> Where
> Categories_internal.parentID = #listsubcategories.catid#
> and #now()# between
> articles.starttime and articles.endtime
>
>
> aux3 = insFld(aux2, gFld("#category#",
> "#request.self#?fuseaction=#fusebox.targetcircuit#.content&cat
> id=#catid#"))
>> name="listsubcategories3" datasource="#request.dsn1#" dbtype="ODBC">
> Select
> Categories_internal.CatID as itemid ,
>
> Categories_internal.Category as description,
>
> Categories_internal.ParentId as ParentItemID,
>
> Categories_internal.catlevel,
>
> Categories_internal.catid,
>
> Categories_internal.category,
>
> Categories_internal.parentid
> From
> Categories_internal inner join articles on
> (Categories_internal.catid = articles.catid_internal)
> Where
> Categories_internal.parentID = #listsubcategories.catid#
> and #now()#
> between articles.starttime and articles.endtime
>
>
> test
>
>
>
>
> > initializeDocument() > > > > >yah, can you show the query? > > > >we can probably dress it up real nice... > > > >tw > > > >-Original Message- > >From: Philip Arnold [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, April 14, 2004 2:19 PM > >To: CF-Talk > >Subject: RE: Issue with Loops and queries > > > > > >Are these queries from the same datasource? > >
RE: Issue with Loops and queries
so its one table...correct? Select CatID as itemid , Category as description, ParentId as ParentItemID, catlevel, catid, category, parentid From Categories_internal ci where group by catId order by Orderby, parentID desc then in your display layer you can deal with the output...but this shouldn't be as hard as it looked...unless im missing something... Im a parent category Im a child, and I should be under my parent if the ordering works. tony -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 2:39 PM To: CF-Talk Subject: Re: Issue with Loops and queries Here you go, I've been thinking of a better way of doing it and haven't come up with anything. Select CatID as itemid , Category as description, ParentId as ParentItemID, catlevel, catid, category, parentid From Categories_internal where catlevel = 0 order by Orderby desc
// You can find instructions for this file at http://www.treeview.net
//Environment variables are usually set at the top of this file.
USETEXTLINKS = 1
STARTALLOPEN = 0
USEFRAMES = 0
USEICONS = 0
WRAPTEXT = 1
PERSERVESTATE = 1
ICONPATH = "js/tree/"
foldersTree = gFld("", "")
foldersTree.treeID = "viewcontent"
aux1 = insFld(foldersTree, gFld("#category#",
"#request.self#?fuseaction=#fusebox.targetcircuit#.content&catid=#catid#"))
datasource="#request.dsn1#" dbtype="ODBC">
Select Categories_internal.CatID as itemid ,
Categories_internal.Category as
description,
Categories_internal.ParentId as
ParentItemID,
Categories_internal.catlevel,
Categories_internal.catid,
Categories_internal.category,
Categories_internal.parentid
From Categories_internal inner join articles on
(Categories_internal.catid = articles.catid_internal)
Where Categories_internal.parentID =
#listcategories.catid#
and #now()# between articles.starttime
and articles.endtime
aux2 = insFld(aux1, gFld("#category#",
"#request.self#?fuseaction=#fusebox.targetcircuit#.content&catid=#catid#"))
datasource="#request.dsn1#" dbtype="ODBC">
Select Categories_internal.CatID as itemid
,
Categories_internal.Category
as description,
Categories_internal.ParentId
as ParentItemID,
Categories_internal.catlevel,
Categories_internal.catid,
Categories_internal.category,
Categories_internal.parentid
From Categories_internal inner join
articles on (Categories_internal.catid = articles.catid_internal)
Where Categories_internal.parentID =
#listsubcategories.catid#
and #now()# between
articles.starttime and articles.endtime
aux3 = insFld(aux2, gFld("#category#",
"#request.self#?fuseaction=#fusebox.targetcircuit#.content&catid=#catid#"))
datasource="#request.dsn1#" dbtype="ODBC">
Select Categories_internal.CatID as
itemid ,
Categories_internal.Category as description,
Categories_internal.ParentId as ParentItemID,
Categories_internal.catlevel,
Categories_internal.catid,
Categories_internal.category,
Categories_internal.parentid
From Categories_internal inner
join articles on (Categories_internal.catid = articles.catid_internal)
Where Categories_internal.parentID
= #listsubcategories.catid#
and #now()# between
articles.starttime and articles.endtime
test
initializeDocument() >yah, can you show the query? > >we can probably dress it up real nice... > >tw > >-Original Message- >From: Philip Arnold [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 14, 2004 2:19 PM >To: CF-Talk >Subject: RE: Issue with Loops and queries > > >Are these queries from the same datasource? > >If so, do it in one query with joins (probably left outer join) > >You'll save processing on the CF end, and will end up with one CFOUTPUT >GROUP= instead [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Proving you are legitimate from CFMail
On Apr 14, 2004, at 1:05 PM, Craig Earls wrote: > I am developing a service that sends email to registered users about > upcoming events. I keep getting errors about my mails being bounced as > spam. Even test emails I am sending to myself are getting bounced by > my > ISP. What procedures does a business need to go through to prove they > are > legitimate? There is no silver bullet. To paraphrase an old adage, "one man's email is another man's spam." The problem is that the definition of spam is subjective. Some people (and software) will tell you that using certain phrases ("Earn money in your sleep while increasing the size of your manhood and losing weight by working from your home.") qualifies as spam. Others will tell you that email you didn't specifically ask for is spam ("Click here to receive mail from anyone that pays us enough money to be loosely defined as a business partner"). Still more will define as being anything they just don't want to read, regardless of the source or reason for reception. At work (not hofo.com), my employer sends out millions (no joke) of emails a week through companies that have lists of email addresses that supposedly meet one demographic or another. These companies have all signed statements that affirm the lists were obtained "legitimately". That is, these people knowingly (or unknowingly) checked (or unchecked) a little box on a form somewhere that said "send me information about something". Of course, I personally don't believe that all the addresses are legitimate, there are just too many of them (but I also don't have the pull to force the validation of these millions of addresses). Some of the lists had to have had beginnings with address harvesters. Or the user may have signed up for information from some company back before privacy statements were de rigeur for websites. The company sold your email address and interest preferences to someone else, who resold it, ad nauseum. Then again, my employer also sends email to people who went to our website and filled out a form that said "I'm interested in this product, send me information." They send something out right away. In the absence of a sale, they also do a followup 60 to 90 days or a year later (an accepted marketing practice), the person doesn't remember they wanted information and cries foul. Thus it is spam, even though the recipient initiated the one-to-one contact. The best you can do is to: - make all information requests obviously opt-in - keep decent records of when the person asked for email (the lawyers will come for you, trust me): their name, email address, IP address used for the request, and timestamp. - keep records of what you sent when to whom, matchable to when the person asked for the information. - make opt-out provisions obvious on the email and your website. - be sure the opt-out solution is functional, and record these actions as well - some people are cynical enough not to believe any opt-out form is actually going to do so, but you can't not have it. IMHO, I wouldn't even bother with the spam filter testing. The phrase triggers and thresholds in SpamAssassin and the like are admin configurable and thus subjective at the admin level. Bayesian filtering (you gotta love it) is even more subjective, but better because this can be done at the user level, and will in theory separate spam from ham. In my experience with Bayesian filtering in OS X Mail, this can be defeated by conversational phrasing or the latest trick, using a paragraph of words that are legitimate dictionary words but aren't in most people's common vocabulary. These words don't appear in the token list from previous emails and skew the probability towards ham. -- Howard Fore, [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help needed with variables, loops, and multi-step forms
Thanks Raymond. Nate Quoting Raymond Camden <[EMAIL PROTECTED]>: > Use > > value="#variables.stPeople['stPerson#i#'].firstname#" > > -Raymond Camden > > > > variables.numPeople = 3; > > > > variables.stPeople = structNew(); > > > > for (i=1; i LTE variables.numPeople; i=i+1) { > > variables.stPeople['stPerson' & i] = structNew(); > > variables.stPeople['stPerson' & i]['firstName'] = ""; > > variables.stPeople['stPerson' & i]['lastName'] = ""; > > } > > > > > > > > Based on the numPeople value I want to dispaly as many sets > > of form fields for a user to fill in as follows: > > > > > > > > > > > > > > > > > > > > > > So my question is how do I populate the value attribute of > > the form fields that are created in a loop with the initial > > empty variables that were also created in a loop? Basically I > > want the value attribute of the form fields to be > > value="#variables.stPeople.stPerson1.firstName#" and the > > stPerson1 changes numbers as the loop increments. Is it just > > a matter of using the proper syntax? If so I am missing it completely. > > > > Hopefully I have expressed myself clearly! > > > > Thanks, > > > > Nate > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Printable forms in HTML
Does anyone have experience with producing an official form in HTML that can also be printed? I am required to take a pre-existing official form (hard copy, not electronic) and make it appear in HTML for end users. I have to query some of the information on the form from a database. The user needs to be able to print this HTML page to local printer and not lose the formatting. Any help, suggestions would be greatly appreciated. Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 & Active Directory
We're beginning to do this ourselves. I have found it takes a lot of trial and error to get this to work. This resource has helped some. This link provides a lot of useful information for the User field attributes in Active Directory. http://msdn.microsoft.com/library/default.asp?url=""> Here is some test code I've worked up; name="Entity" username="xxx" password="xxx" server="xxx" action="" attributes="displayname,mail,sn,cn,givenName,name,userPrincipalName,samAccountName,sAMAccountType,memberOf,extensionName,telephoneNumber" scope="subtree" start="DC=smfbc,DC=org" filter = "#filtersetting#"> #groups#[#len(groups)#] #getAuthUser()# webTrainingAdmin:#isUserInRole("webTrainingAdmin")# Training & Education - Chg:#isUserInRole("Training & Education - Chg")# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Advanced search examples, field based searches
Sam, sounds like I may have some tools that fit the bill. Question though, you mentioned about "non-technical end user", well, if so, IMHO, they are less likely to know AND/OR/NOT operators and let alone RELATIONS etc., on the other hands, there might be a group of savvy users who know about them, and I have tools for both types of users. Please contact me at donli at hegelsoftware.com for further discussion. Thanks. Don >I'm looking for examples of search interfaces for end users that provide >fully query type functionality in an interface simple enough for a >non-technical end user to take advantage of. > >Specifically we're searching for values in named fields, allowing the user >to specify groupings (parenthesis), and relationships between field groups >(and/or/not). > >Thanks, > >Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Printable forms in HTML
Well printing from the web is a nasty piece of work ;-) If you can I'd suggest making a PDF document instead of doing this in HTML. There are packages such as iText.jar (found on SorceForge) that will allow you to dynamically create the PDF (as you mentioned needing to run some queries which I assume means the form may have a few versions) HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Wednesday, April 14, 2004 12:17 PM Subject: Printable forms in HTML Does anyone have experience with producing an official form in HTML that can also be printed? I am required to take a pre-existing official form (hard copy, not electronic) and make it appear in HTML for end users. I have to query some of the information on the form from a database. The user needs to be able to print this HTML page to local printer and not lose the formatting. Any help, suggestions would be greatly appreciated. Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Proving you are legitimate from CFMail
>> I keep getting errors about my mails being bounced as spam. I know someone who has the same problem. Messages sent by his CF server are rejected by my ISP because the message header does not contain a Message-ID header although this is mandatory according to standard. I don't think the CF server should put this header, but you should check with the Mail server your CF server is sending messages through. It might also be some other reason. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Issue with Loops and queries
Here is what I ended up coming up with. Select CatID as itemid , Category as description, ParentId as ParentItemID, catlevel, catid, category, parentid From Categories_internal order by Orderby desc Query="#listcategories#" ReturnVar="listcategories"> Select id,catid_internal From articles Where catid_internal = #catid# and getdate() between starttime and endtime aux1 = insFld(foldersTree, gFld("#category#", "#request.self#?fuseaction=#fusebox.targetcircuit#.content&catid=#catid#")) aux#(catlevel+1)# = insFld(aux#catlevel#, gFld("#category#", "#request.self#?fuseaction=#fusebox.targetcircuit#.content&catid=#catid#")) Now the issue I have and Mike D I hope you're reading this, when I write the query like this, whether it's in a stored procedure or not, the make tree tag chokes completely and takes up all processor time. Select Categories_internal.CatID as itemid , Categories_internal.Category as description, Categories_internal.ParentId as ParentItemID, Categories_internal.catlevel, Categories_internal.catid, Categories_internal.category, Categories_internal.parentid From Categories_internal inner join articles on (Categories_internal.catid = articles.catid_internal) Where getdate() between articles.starttime and articles.endtime order by Categories_internal.Orderby desc This would have allowed me to do one query instead of looping over the queries to see which associated category has an article that has expired and shouldn't be used. I'm using the latest version of your tag Mike. Any insight? Bob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Advanced search examples, field based searches
Sam, I think the best model you can use is the one employed by google. Some users may already be familiar with the syntax, as its more usable than AND/OR/NOT. It's not that hard to roll your own based on the principles google uses, as I've done it a number of times before. You should also check into your database to see if it offers and sort of amplifier support. I belive Oracle does, as well as phonetic engines. -adam > -Original Message- > From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 14, 2004 07:30 PM > To: 'CF-Talk' > Subject: Re: Advanced search examples, field based searches > > Sam, sounds like I may have some tools that fit the bill. Question though, you mentioned about "non-technical end user", well, if so, > IMHO, they are less likely to know AND/OR/NOT operators and let alone RELATIONS etc., on the other hands, there might be a group of savvy users who know about them, and I have tools for both types of users. > Please contact me at donli at hegelsoftware.com for further discussion. > > Thanks. > > Don > > >I'm looking for examples of search interfaces for end users that provide > >fully query type functionality in an interface simple enough for a > >non-technical end user to take advantage of. > > > >Specifically we're searching for values in named fields, allowing the user > >to specify groupings (parenthesis), and relationships between field groups > >(and/or/not). > > > >Thanks, > > > >Sam > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: qForms v2.0 News...
For those of you using qForms, there's some news over at my blog about the upcoming release: http://www.pengoworks.com/index.cfm?action=""> - Dan : Dan G. Switzer, II : : e-mail: [EMAIL PROTECTED] : : url: http://www.pengoworks.com/ : : blog: http://blog.pengoworks.com/ : : _ : : |_) _ _ _ _ | | _ _|_ _ : : | (/_| )(_|(_)|/\|(_)| |\ _) : : _| : :... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: qForms v2.0 News...
qforms rocks. saved me tons of work and time. Nick Han >>> [EMAIL PROTECTED] 04/14/04 01:55PM >>> For those of you using qForms, there's some news over at my blog about the upcoming release: http://www.pengoworks.com/index.cfm?action="" - Dan : Dan G. Switzer, II : : e-mail: [EMAIL PROTECTED] : : url: http://www.pengoworks.com/ : : blog: http://blog.pengoworks.com/ : : _: : |_) _ _ _ _ | | _ _|_ _ : : | (/_| )(_|(_)|/\|(_)| |\ _) : : _| : :... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Proving you are legitimate from CFMail
Make sure your e-mail server has a reverse lookup in DNS so that your IP can be validated to your host-name. This is a huge problem in my limited experience with SMTP. You may want to consider adding an SPF or caller-ID record to DNS as well. In case you are not familiar with SPF here is a link: "http://spf.pobox.com". It isn't very widely implemented yet but many antispam vendors and even AOL are in various stages of implementation. If the messages are HTML you might want to make them mulitpart MIME, HTML only messages send up a red flag. -Nate -Original Message- From: Craig Earls [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 12:05 PM To: CF-Talk Subject: Proving you are legitimate from CFMail I am developing a service that sends email to registered users about upcoming events. I keep getting errors about my mails being bounced as spam. Even test emails I am sending to myself are getting bounced by my ISP. What procedures does a business need to go through to prove they are legitimate? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Proving you are legitimate from CFMail
I should have added make sure your messages are going through a legitimate mail host or a smart host with valid DNS information. -Original Message- From: Nathan C. Smith Sent: Wednesday, April 14, 2004 4:08 PM To: CF-Talk Subject: RE: Proving you are legitimate from CFMail Make sure your e-mail server has a reverse lookup in DNS so that your IP can be validated to your host-name. This is a huge problem in my limited experience with SMTP. You may want to consider adding an SPF or caller-ID record to DNS as well. In case you are not familiar with SPF here is a link: "http://spf.pobox.com". It isn't very widely implemented yet but many antispam vendors and even AOL are in various stages of implementation. If the messages are HTML you might want to make them mulitpart MIME, HTML only messages send up a red flag. -Nate -Original Message- From: Craig Earls [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 12:05 PM To: CF-Talk Subject: Proving you are legitimate from CFMail I am developing a service that sends email to registered users about upcoming events. I keep getting errors about my mails being bounced as spam. Even test emails I am sending to myself are getting bounced by my ISP. What procedures does a business need to go through to prove they are legitimate? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Printable forms in HTML
Will the user be required to print the form after completing the form or will the form be popluated with information from the database? For printing solutions I would go the PDF route. You can use either FDF (http://partners.adobe.com/asn/acrobat/forms.jsp) some useful tutorials on this can be found at http://www.cfcomet.com or you can use iText (http://www.lowagie.com/iText/), a free Java based API for creating and manipulating PDF documents. You can create your form in PDF not HTML and force it to load in the browser and use either FDF or iText (of the FDF options in iText!) to populate the information from the DB. If the user has to enter additional information on the form then they can do so and then print it straight from the browser with no loss in formatting. Printing HTML forms especially in IE can be a pain. The only caveat is that the client must have Adobe Acrobat Reader installed. If you need to use HTML and know that your clients will be using IE (windows) only you can try ScriptX (http://www.meadroid.com/scriptx/index.asp) which allows you to specify certain printing options. There is a free and commercial license, you can obviously do much more using the commercial version but the free option gives you quite a rich set of options. HTH. Best Regards, Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 "Nitendo Vinces - By Striving You Shall Conquer" [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ANNOUNCE: ColdFusion and Fusebox classes April and May 2004; New Hal Helms class
Here are upcoming ColdFusion and Fusebox classes in Wash DC area including a new class by Hal Helms in two weeks on complex variables. Class Schedule ** Mon 4/26/04 CF 208 - Hal Helms Mastering Complex Variables $349 - NEW! Sat 5/01/04 CF 101 - Welcome to ColdFusion $9.95 Tue 5/04/04 CF 102 - Introduction to ColdFusion $349 Tue 5/11/04 CF 201 - Building ColdFusion Skills $349 Tue 5/25/04 FB 101 - Intro to Fusebox $199 Tue 6/01/04 FB 201 - Intermediate Fusebox $349 Classes limited to 12 students each so that you can be sure to get your own questions answered! Sign up today to guarantee a place at http://www.teratech.com/training/ - Michael Smith, TeraTech, Inc PS If you can't make a class we have one-on-one mentoring and on site classes too. Just email me if you are interested. TeraTech was a finalist for Best ColdFusion Training in USA in both 2003 and 2002. *TeraTech 100% Learning Guarantee* We want you to be happy with our classes. If you are not 100% sure you learned everything you could from any of our classes then you may take it again at no charge on a space available basis. Class details: CF 208 - Mastering "Complex" Variables ** Taught by Hal Helms Full Day course Sign-in 9:30am, Class 10am-5pm Just $349, includes lunch Get up to speed with the complex variables in ColdFusion! For many ColdFusion programmers, arrays and structures are ColdFusion tools they just don't use very often. That's too bad: mastering "complex" variables can actually make your code simpler and is an essential step in becoming a highly skilled (read "well-paid") programmer. In this one-day class, you'll master the use of arrays, structures (and lists). Did you know that structures were the precursor for objects? More importantly, do you know where to use arrays and structures in real-world applications? Take advantage of this class to add these powerful new tools to your programming toolbox. Each student will receive hand- outs and a copy of Jeff Peters' new book, ColdFusion Lists, Arrays, and Structures. CF 101 - Welcome to ColdFusion ** 2 hour course Sign-in 9:30am, Class 10am - noon Just $9.95 ~ Introduction to ColdFusion ~ Samples of sites currently using ColdFusion ~ When to/when not to use ColdFusion ~ Basic coding samples ~ How ColdFusion interacts with databases ~ Q&A CF 102 - Introduction to ColdFusion *** Full Day course Sign-in 9:30am, Class 10am-5pm Just $349, includes lunch Get up to speed with the basics of ColdFusion! * About ColdFusion * CF Tag Processing * Server vs Client Processing * Why Dynamic Pages? vs Site Updating: Old Way * Using variables and functions * Performing conditional processing * Form processing, Including form validation * Reusing code with CFINCLUDE * Using (and perhaps creating) custom tags * Passing data among programs * Using CFMAIL to generate Email *Database Integration - ColdFusion Query Processing - DataSource Definition - Executing SQL in CF - Query Builder - Result of SQL Statement - Viewing CFQUERY results - Looping Through Results - Using Results to Build HTML - Dynamic SQL - refer to CF variables and functions, conditional SQL - Building a Search Interface - Dont Do the Databases Work * CF Studio tips - integrated dev env (IDE) * Where to Learn More * Q & A time CF 201 - Building ColdFusion Skills *** Full Day course Sign-in 9:30am, Class 10am-5pm Just $349, includes lunch Learn how to easily secure all or parts of your sites in a reliable way. Protect your sites from hackers and web vandals. Improve the speed and stability of your ColdFusion applications. Prerequisite: Basic ColdFusion experience. * In depth overview of ColdFusion Administrator * Performance & Stability - Locking - CFLOCK tag - CFAdmin settings - Request scope * Security - basic concepts - login - closing backdoors - forgotten password * Members Only - session, client and cookies - refresh issues - timeouts - remember me * Session Tracking - who is logged on now - variable and structure dump * Form Validation - why it is important - underscore validation - CFFORM validation - _javascript_ validation - CF validation - SQL validation * Q & A FB 101 - Introduction to Fusebox Half Day course noon-4pm Just $199 FB101 is ideal for any ColdFusion users interested in learning the basics of Fusebox. Whether you're just getting started with ColdFusion or you're an experienced developer, Fusebox can help you build better applications. * What is Fusebox? * How can Fusebox help you code? * index.cfm organization * Naming conventions * fuseaction + Learn all the basics of how the Fusebox architecture can help you build ColdFusion Applications. + Learn to tie together all the queries, display elements, and actions of your application in a consistent model. + Study a sample fusebox app
RE: Printable forms in HTML
Does this stuff or anything else allow me to take a formatted pdf (that contains merged data) and print it to disk... specifically, to a .ps like what Acrobat Distiller would use? I need to store a .ps source document for every document. I have a system I built for an insurance company that churns out documents constantly. Presently the system prints everything to disk in .ps, where its stored forever. From there it either gets distilled to a PDF or sent to a postscript printer. I want to move this thing to a CF-based intranet if I can. I can use CF to send a .ps to a printer and have it print, no problem at all. What I can't figure out is how to make the .ps file programmatically. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]