RE: FB4 catching fusebox exceptions
B, your on fire tonight, thanks for all the insight. :-) The point is that I am accustomed to using cftry/cfcatch around potential problematic code; so wrapping the entire index with cftry rose a flag for me as to what the downsides might be? Right now it is a necessary evil, but 4.1 will hopefully rectify the issue. I am not even going to comment on the importance of planning/design/architecture because that is a 'gimme' and I always take performance into consideration while planning, that's a good thing. Mike > > I have no idea if wrapping the entire request in a > CFTRY..CFCATCH will slow down the request. In fact, I don't > even care, unless app performace becomes a problem, and I've > spent time optimizing the rest of the system (particularly > the DB). IMHO, you should NEVER make high-level architecture > decisions based on performace. Design the system as well as > possible from an architecture standpoint. Experience shows > that good architecture usually leads to good performance, and > the places that it doesn't are usually because the need for > maintainability or abstraction were more important than raw > speed. Six months down the road, it's a lot easier to do > optimization than rearchitecting, so put them in the right > order on the priorities list up front. > > > In FB4's case, if you've got a exception handling plugin, > you're entire parse file is wrapped in a CFTRY..CFCATCH > anyway, so adding one to index.cfm isn't going to matter > much. The only different will be the runtime core, which is > quite trivial (the vast majority of the core code is in the > other three files). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: FB4 catching fusebox exceptions
I'm going to speak for John (since I agree with him), that it was intentionally removed from FB4, because it's a Bad Thing (tm). The non-runtime nature of FB4 is a good thing for a couple reasons: 1) it provides some primitive types of compile-time checking. 2) it forces you to clearly define the tasks (external or internal) that make up the application's flow 2a) it utterly prevents such hackery as modifying the fusebox.fuseaction variable inside the request, as was possible in FB3, and was never useful for anything more than a crutch to avoid more complete planning and better design (which isn't to say I'm not guilty ;) Dynamic fuseactions (including the default fuseaction concept) go against both those idea, for very small gain. The only benefit I can think of is that you can change the fuseaction name within the circuit that is the default, without having to change any external links of XFAs. You can accomplish that by picking a fuseaction name that has "specialness", such as 'default', which is NEVER used for an actual fuseaction, but rather resides at the top of your circuit and simple does a DO on whatever fuseaction you deem to be the default. If you're looking for backwards compatibilty, you can do that as well, in your index.cfm file. When a compound fuseaction comes in with a zero-length fuseaction name, set it to that same "special" fuseaction name, and away you go. Cheers, barneyb > -Original Message- > From: Kenneth Wilson [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 6:03 PM > To: CF-Talk > Subject: RE: FB4 catching fusebox exceptions > > Any known plans for FB to add back the default fuseaction > functionality from earlier days? > > Ken > > > > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Thu 6/17/2004 8:10 PM > To: CF-Talk > Subject: RE: FB4 catching fusebox exceptions > > > > Despite what people have said, FB4 is unable to catch > exceptions arising > from invalid circuits or fuseactions. This makes sense when > you think about > it, if you know how things work internally. A sample request > goes like this > (roughly): > > - Application.cfm runs > - index.cfm runs and includes the runtime > - the runtime does some preprocessing > - the runtime calls the loader to load the XML files, if needed > - the runtime passes the circuit and fuseaction name to the > parser to build > the parse file, if needed, and saves it to the 'parsed' directory > - the runtime executes the parse file > - the runtime returns to index.cfm > - OnRequestEnd.cfm runs > > You can probably see the issue. The runtime needs to know > the circuit and > fuseaction to hand to the parser to generate the parse file. > If it doesn't > have valid info, it pukes, and generates the exception you > included. Your > processError plugin is rolled into the parse file, so it can > only execute > during actual request execution, which is far to late to catch invalid > circuit and fuseaction exceptions. > > If you need to catch this type of exception (and you should), > you have to do > it with a CFTRY..CFCATCH in your index.cfm, or via a CFERROR > tag, either in > index.cfm or Application.cfm. > > Cheers, > barneyb > > > -Original Message- > > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 17, 2004 4:54 PM > > To: CF-Talk > > Subject: FB4 catching fusebox exceptions > > > > In the processError phase I have a plugin called > > "fuseboxExceptions". In > > that file I have: > > > > > > > > > > > > > > > > > > When I put in an invalid fuseaction in the URL it should get > > caught and the > > cfcatch structure should dump to the screen but instead I get > > the standard > > CF error page (below): > > > > "You specified a Fuseaction of junkVal which is not defined > > in Circuit main. > > " > > > > Can any FB4 people see my problem? > > > > Thanks, > > > > Mike > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: FB4 catching fusebox exceptions
Any known plans for FB to add back the default fuseaction functionality from earlier days? Ken From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thu 6/17/2004 8:10 PM To: CF-Talk Subject: RE: FB4 catching fusebox exceptions Despite what people have said, FB4 is unable to catch exceptions arising from invalid circuits or fuseactions. This makes sense when you think about it, if you know how things work internally. A sample request goes like this (roughly): - Application.cfm runs - index.cfm runs and includes the runtime - the runtime does some preprocessing - the runtime calls the loader to load the XML files, if needed - the runtime passes the circuit and fuseaction name to the parser to build the parse file, if needed, and saves it to the 'parsed' directory - the runtime executes the parse file - the runtime returns to index.cfm - OnRequestEnd.cfm runs You can probably see the issue. The runtime needs to know the circuit and fuseaction to hand to the parser to generate the parse file. If it doesn't have valid info, it pukes, and generates the exception you included. Your processError plugin is rolled into the parse file, so it can only execute during actual request execution, which is far to late to catch invalid circuit and fuseaction exceptions. If you need to catch this type of exception (and you should), you have to do it with a CFTRY..CFCATCH in your index.cfm, or via a CFERROR tag, either in index.cfm or Application.cfm. Cheers, barneyb > -Original Message- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 4:54 PM > To: CF-Talk > Subject: FB4 catching fusebox exceptions > > In the processError phase I have a plugin called > "fuseboxExceptions". In > that file I have: > > > > > > > > > When I put in an invalid fuseaction in the URL it should get > caught and the > cfcatch structure should dump to the screen but instead I get > the standard > CF error page (below): > > "You specified a Fuseaction of junkVal which is not defined > in Circuit main. > " > > Can any FB4 people see my problem? > > Thanks, > > Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: FB4 catching fusebox exceptions
I have no idea if wrapping the entire request in a CFTRY..CFCATCH will slow down the request. In fact, I don't even care, unless app performace becomes a problem, and I've spent time optimizing the rest of the system (particularly the DB). IMHO, you should NEVER make high-level architecture decisions based on performace. Design the system as well as possible from an architecture standpoint. Experience shows that good architecture usually leads to good performance, and the places that it doesn't are usually because the need for maintainability or abstraction were more important than raw speed. Six months down the road, it's a lot easier to do optimization than rearchitecting, so put them in the right order on the priorities list up front. In FB4's case, if you've got a exception handling plugin, you're entire parse file is wrapped in a CFTRY..CFCATCH anyway, so adding one to index.cfm isn't going to matter much. The only different will be the runtime core, which is quite trivial (the vast majority of the core code is in the other three files). Cheers, barneyb > -Original Message- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 5:14 PM > To: CF-Talk > Subject: RE: FB4 catching fusebox exceptions > > > > - Application.cfm runs > > - index.cfm runs and includes the runtime > > - the runtime does some preprocessing > > - the runtime calls the loader to load the XML files, if needed > > - the runtime passes the circuit and fuseaction name to the > > parser to build the parse file, if needed, and saves it to > > the 'parsed' directory > > - the runtime executes the parse file > > - the runtime returns to index.cfm > > - OnRequestEnd.cfm runs > > Thanks Barney, makes sense. However wrapping the contents of > index.cfm in a > cftry essentially wraps the entire request in a cftry does it not?... > Potentially hindering performance? > > My understanding of the execution of the events you outlined > above was a bit > off, thanks for the clarification. > > Mike > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: isDefined(collection)?
Just because I perfer not to rely on CFTRY/CFCATCH, here are some options: 1. Do a DirectoryExists() to see if the collection name exists as a directory whereever you keep your collections. All collections get a new dir that holds all it's data. 2. Do a registry call (CF 5) or an XML file call (CFMX) to read the admin settings for the collections. 3. Use the factory object to access a list of all collections. This is the best, but last resort as the factory object is not supported outside the admin and is a major security risk. Hello all, I would like to create a collection if it is not already defined. How can I do that? i.e. thanx - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd. Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: FB4 catching fusebox exceptions
> - Application.cfm runs > - index.cfm runs and includes the runtime > - the runtime does some preprocessing > - the runtime calls the loader to load the XML files, if needed > - the runtime passes the circuit and fuseaction name to the > parser to build the parse file, if needed, and saves it to > the 'parsed' directory > - the runtime executes the parse file > - the runtime returns to index.cfm > - OnRequestEnd.cfm runs Thanks Barney, makes sense. However wrapping the contents of index.cfm in a cftry essentially wraps the entire request in a cftry does it not?... Potentially hindering performance? My understanding of the execution of the events you outlined above was a bit off, thanks for the clarification. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: FB4 catching fusebox exceptions
Despite what people have said, FB4 is unable to catch exceptions arising from invalid circuits or fuseactions. This makes sense when you think about it, if you know how things work internally. A sample request goes like this (roughly): - Application.cfm runs - index.cfm runs and includes the runtime - the runtime does some preprocessing - the runtime calls the loader to load the XML files, if needed - the runtime passes the circuit and fuseaction name to the parser to build the parse file, if needed, and saves it to the 'parsed' directory - the runtime executes the parse file - the runtime returns to index.cfm - OnRequestEnd.cfm runs You can probably see the issue. The runtime needs to know the circuit and fuseaction to hand to the parser to generate the parse file. If it doesn't have valid info, it pukes, and generates the exception you included. Your processError plugin is rolled into the parse file, so it can only execute during actual request execution, which is far to late to catch invalid circuit and fuseaction exceptions. If you need to catch this type of exception (and you should), you have to do it with a CFTRY..CFCATCH in your index.cfm, or via a CFERROR tag, either in index.cfm or Application.cfm. Cheers, barneyb > -Original Message- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 4:54 PM > To: CF-Talk > Subject: FB4 catching fusebox exceptions > > In the processError phase I have a plugin called > "fuseboxExceptions". In > that file I have: > > > > > > > > > When I put in an invalid fuseaction in the URL it should get > caught and the > cfcatch structure should dump to the screen but instead I get > the standard > CF error page (below): > > "You specified a Fuseaction of junkVal which is not defined > in Circuit main. > " > > Can any FB4 people see my problem? > > Thanks, > > Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: isDefined(collection)?
> I would like to create a collection if it is not already > defined. How can I do that? > > i.e. > > > The easiest way would be to simply wrap your CFCOLLECTION tag within CFTRY/CFCATCH. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
FB4 catching fusebox exceptions
In the processError phase I have a plugin called "fuseboxExceptions". In that file I have: When I put in an invalid fuseaction in the URL it should get caught and the cfcatch structure should dump to the screen but instead I get the standard CF error page (below): "You specified a Fuseaction of junkVal which is not defined in Circuit main. " Can any FB4 people see my problem? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
isDefined(collection)?
Hello all, I would like to create a collection if it is not already defined. How can I do that? i.e. thanx - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd. Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ODBC Socket connection to Oracle database server.
Can anybody suggest where else I can troubleshoot this problem. I can not get an ODBC socket DSN set up to our Oracle databases on one server from my local development box. 1) The ODBC socket DSN connections on my box to our other Oracle Servers work just fine. 2) Testing of the service in question in the Oracle Net8 Assistant tool works correctly. 3) The ODBC DSN configuration in MS ODBC Data Source Administration works correctly, I can link to tables in the these databases with Access from my box using the MS ODBC DSN. But when I try to set up the DSN on my CF Administrator it fails telling me to check my user name, password, URL, and other connectivity info. Well I have checked and rechecked all that as many ways as I can figure out how to, but I can not find the problem. The problem does seem to be something specific to this one Oracle server and my local box. There are two databases on that server and I can not connect to either one of them. But I can connect to any database on our other Oracle servers just fine. As well as all these DSN's work just fine on our staging server between all the Oracle servers As far as I can tell all the connectivity information is the same between the staging box and my local box. Help greatly appreciated. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: question about "server" variable
On Thu, 17 Jun 2004 13:31:59 -0500, Mark A. Kruger - CFG wrote: > > What does the variable "server.Coldfusion.expiration" mean? > I'm examining a users current host. I can't say for certain, but I'd think it's the expiration of an evaluation license [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IIS Automation questions
My client's access there log files and reports through our control panel. I have a Sandbox setup to run the scripts for the control panel (Not all my Clients have CF and other scripting tools) I do not change the name IIS assigns to the logfile folder only the path. MySandBox LogFiles --- TheDomain.com Archives 20040617 (One for each Report/Archive) Reports 20040617 (One for each Report/Archive) Logfiles W3SVC* IN my Control panel I have a virtual directory setup to point to the Reports Folder. Each Sunday a new Report is created and the old is Archived along with the logfiles. Each Archive is listed and I use CFFILE to retrieve Raw LogFiles into a Textarea field. Everything Is ran out of the database (RootPath, LogFilePath, LogFileDirectory, domains and so on) and Cold Fusion Generates the report each Sunday using Funnel Web Analyzer. So I do not have away to automate the setup completely as I have to manually enter the logfileDirectory. So I am pretty close. Rick Eidson Partner & CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ Kansas City Musicians http://www.1sourceentertainment.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IIS Automation questions
My client's access there log files and reports through our control panel. I have a Sandbox setup to run the scripts for the control panel (Not all my Clients have CF and other scripting tools) I do not change the name IIS assigns to the logfile folder only the path. MySandBox LogFiles --- TheDomain.com Archives 20040617 (One for each Report/Archive) Reports 20040617 (One for each Report/Archive) Logfiles W3SVC* IN my Control panel I have a virtual directory setup to point to the Reports Folder. Each Sunday a new Report is created and the old is Archived along with the logfiles. Each Archive is listed and I use CFFILE to retrieve Raw LogFiles into a Textarea field. Everything Is ran out of the database (RootPath, LogFilePath, LogFileDirectory, domains and so on) and Cold Fusion Generates the report each Sunday using Funnel Web Analyzer. So I do not have away to automate the setup completely as I have to manually enter the logfileDirectory. So I am pretty close. Rick Eidson Partner & CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ Kansas City Musicians http://www.1sourceentertainment.com/ -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 2:40 PM To: CF-Talk Subject: RE: IIS Automation questions Rick, How/where do you store the log files? I have the following structure set up: Websites |_site1 |_www (iis root) |_logs (where I want the logs to go but IIS puts the W3SVC### folder in here) |_stats (virtual directory /stats for the site where I output the log stats) |_site2 (just like site1 and so on) What you described is most of what I want to automate. John -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 2:59 PM To: CF-Talk Subject: RE: IIS Automation questions 2) This is what I do to create Sub-Domains for current Sites but with a little modification it will work for new sites. You need to use the mkw3site.vbs script that comes with IIS. AdminScripts is the Directory mkw3site script is located in. RootPath is the Root directory where I want to create the website. sandbox is the 3rd level Domain in your case it would be "www". VDomain is second level domain and the Top Level Domain "kchost.net" File="#RootPath#\Sandbox\sandbox.txt" output="#Trim(CMDCommand)#"> destination="#RootPath#\Sandbox\sandbox.cmd"> 1) I am not sure about this one but if you figure it out let me know. I automate our clients Stats and Archive the logfiles each Sunday but I have to go in and modify IIS manually. Rick Eidson Partner & CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ Kansas City Musicians http://www.1sourceentertainment.com/ -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:13 PM To: CF-Talk Subject: SOT: IIS Automation questions Ok, this is more specific than the average "I want to automate IIS stuff in CF questions". I have 2 specific questions that I'd like to see if I can get a little bit of help with. 1) In IIS, I'm choosing custom paths for each sites logs to be stored in. My question is if there's any way to have IIS store the logs directly in the directory I choose as opposed to /W3SVC##. I want to automate some other stuff based on this location and that is screwing me up. Any suggestions would be great. 2) Along the same lines (and this may partially solve my first problem), I'm trying to create a new site from a file. I was thinking I could create a site with the generic setup that I use across all of my sites and use CF to automatically edit the specifics of the site (host headers, path for logs, home directory, etc), but as far as the unique identifier for the site goes, is that just up to me to keep that unique or is the a larger purpose for that which needs to be handled by IIS? I know the second question is more along the lines of a typical "how do I automate IIS" but any specific answers toward my questions would be helpful. (Even if it's just to expand my knowledge) Thanks! John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Queries Queries Queies
First, move the distance calculation into a UDF. That already goes a long way to clean up your code: Distance(fromLat, fromLon, toLat, toLon) UDF: SQR(((69 * ($3 - $1))*(69 * ($3 - $1))) + ((69 * ($4 - $2))*(69 * ($4 - $2 Obviously you need to tailor this to whatever SQL dialect your database uses. Then just join everything together: Select DISTINCT z.zip as returnZip, z.city, z.state, Distance(#getZip.laitude#, #getZip.longitude#, z.longitude, z.latitude) AS Distance, d.* FROM zipcode_data z INNER JOIN dealers d ON (d.Zip=z.zip AND d.AudLoc='str' OR left(dealers.Zip, LeftVar)=z.retrunZip AND d.AudLoc = 'bsw') WHERE (latitude BETWEEN #Val(Val(getZip.latitude) - deg_latitude)# AND #Val(Val(getZip.latitude) + deg_latitude)#) AND (longitude BETWEEN #Val(Val(getZip.longitude)-deg_longitude)# AND #Val(Val(getZip.longitude)+deg_longitude)#) AND Distance(#getZip.laitude#, #getZip.longitude#, longitude, latitude) <= #Replace(radius,",","","all")# You just need to fix the Left() in the join condition to whatever your database uses and add the appropriate cfqueryparam calls. The size of everything that is in the WHERE and SELECT might make this intimidating at first, but if you start out with building the FROM, then the WHERE and then the SELECT it really isn't that bad. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dta comparison from identical tables, but different data
Thanks. While I was waiting I thought of an interesting way to accomplish what I wanted to do in the first place. If you like I can send the code off line. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dta comparison from identical tables, but different data
Thanks. While I was waiting I thought of an interesting way to accomplish what I wanted to do in the first place. If you like I can send the code off line. -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 3:26 PM To: CF-Talk Subject: RE: dta comparison from identical tables, but different data Sorry 'bout that, I wasn't thinking clearly this morning. Anyway I'm assuming that the eagleid is your pk field. If so, this should work. Also if you want to check to see how many dups you have, the UNION will join both tables and automatically eliminate duplicate rows. Therefore, in the union, you should have 11,000,008 records instead of 11,000,000. SELECT eagleid FROM( SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig ht,aircraft,pilotid FROM eagles UNION SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig ht,aircraft,pilotid FROM eagles2 ) temp GROUP BY eagleid HAVING count(eagleid) > 1 > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 1:55 PM > To: CF-Talk > Subject: RE: dta comparison from identical tables, but different data > > Per your suggestion I ran the following but no records were returned and I > should have had at least eight records that have changes > > SELECT > eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig > ht,aircraft,pilotid > FROM( > SELECT > eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig > ht,aircraft,pilotid > FROM eagles > UNION > SELECT > eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig > ht,aircraft,pilotid > FROM eagles2 > ) > temp > GROUP BY > eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig > ht,aircraft,pilotid > HAVING count(eagleid) > 1 > > > -Original Message- > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 1:32 PM > To: CF-Talk > Subject: RE: dta comparison from identical tables, but different data > > > SELECT col1,col2,etc FROM > ( > SELECT col1,col2,etc FROM TABLE1 > UNION > SELECT col1,col2,etc FROM TABLE2 > ) temp > GROUP BY col1,col2,etc > HAVING count(col1) > 1 > > Marlon > > > -Original Message- > > From: Eric Creese [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 17, 2004 12:36 PM > > To: CF-Talk > > Subject: SQL: dta comparison from identical tables, but different data > > > > Got a table with approximately 11 columns and 1 million records. I > have a > > another table with the same columns and records but want to compare if > the > > data is different. Changes could be in one or more of the columns. How > can > > I compare these. MS SQL2000? > > > > > > > > > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dta comparison from identical tables, but different data
Sorry 'bout that, I wasn't thinking clearly this morning. Anyway I'm assuming that the eagleid is your pk field. If so, this should work. Also if you want to check to see how many dups you have, the UNION will join both tables and automatically eliminate duplicate rows. Therefore, in the union, you should have 11,000,008 records instead of 11,000,000. SELECT eagleid FROM( SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig ht,aircraft,pilotid FROM eagles UNION SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig ht,aircraft,pilotid FROM eagles2 ) temp GROUP BY eagleid HAVING count(eagleid) > 1 > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 1:55 PM > To: CF-Talk > Subject: RE: dta comparison from identical tables, but different data > > Per your suggestion I ran the following but no records were returned and I > should have had at least eight records that have changes > > SELECT > eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig > ht,aircraft,pilotid > FROM( > SELECT > eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig > ht,aircraft,pilotid > FROM eagles > UNION > SELECT > eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig > ht,aircraft,pilotid > FROM eagles2 > ) > temp > GROUP BY > eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateoffl ig > ht,aircraft,pilotid > HAVING count(eagleid) > 1 > > > -Original Message- > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 1:32 PM > To: CF-Talk > Subject: RE: dta comparison from identical tables, but different data > > > SELECT col1,col2,etc FROM > ( > SELECT col1,col2,etc FROM TABLE1 > UNION > SELECT col1,col2,etc FROM TABLE2 > ) temp > GROUP BY col1,col2,etc > HAVING count(col1) > 1 > > Marlon > > > -Original Message- > > From: Eric Creese [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 17, 2004 12:36 PM > > To: CF-Talk > > Subject: SQL: dta comparison from identical tables, but different data > > > > Got a table with approximately 11 columns and 1 million records. I > have a > > another table with the same columns and records but want to compare if > the > > data is different. Changes could be in one or more of the columns. How > can > > I compare these. MS SQL2000? > > > > > > > > > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Oracle - Incorrect Number of Arguments or Type
CFMX 6 - Oracle 8.173 CFMX 6.1 - Oracle 8.173 After performing a security lockdown on the Oracle server, namely removing DBA from the role which access the package, CF cannot call store procedures which return a result set. The error message claims that there is an incorrect number of arguments or type. What is tricky is that if we reapply DBA, we still get the error. The only way to get it working again is to reapply DBA and then recompile the package. I ran into this problem once before and I believe it was a permission issue. The problem is that the guy who finally fixed it, is no longer employed here and didn't tell any of our dbas what it was. Anyone have any ideas? -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Back Button Issue?
Or wrong depending on your last answer :) > -Original Message- > From: Kristopher Pilles [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 3:17 PM > To: CF-Talk > Subject: RE: Back Button Issue? > > Noticed a problem with the quiz is if you press the back button then > refresh, when the next question loads up it makrs teh previous one as > correct... > > -Original Message- > From: Asim Manzur [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 4:12 PM > To: CF-Talk > Subject: Re: Back Button Issue? > > > Thanks for appreciation > > >Now that's interesting. Never thought of that, I like it! > > > >Asim Manzur wrote: > > > >> http://quiz.rr.nu > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Back Button Issue?
Still, as long as the user doesn't have _javascript_ enabled, you can still go back. Nice solution though. > -Original Message- > From: Asim Manzur [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 3:12 PM > To: CF-Talk > Subject: Re: Back Button Issue? > > Thanks for appreciation > > > > >Now that's interesting. Never thought of that, I like it! > > > >Asim Manzur wrote: > > > >> http://quiz.rr.nu > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Back Button Issue?
Noticed a problem with the quiz is if you press the back button then refresh, when the next question loads up it makrs teh previous one as correct... -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 4:12 PM To: CF-Talk Subject: Re: Back Button Issue? Thanks for appreciation >Now that's interesting. Never thought of that, I like it! > >Asim Manzur wrote: > >> http://quiz.rr.nu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Back Button Issue?
you could add window.history.forward() on your pages... - Original Message - From: Asim Manzur <[EMAIL PROTECTED]> Date: Thu, 17 Jun 2004 16:12:15 -0400 Subject: Re: Back Button Issue? To: CF-Talk <[EMAIL PROTECTED]> Thanks for appreciation >Now that's interesting. Never thought of that, I like it! > >Asim Manzur wrote: > >> http://quiz.rr.nu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Back Button Issue?
Thanks for appreciation >Now that's interesting. Never thought of that, I like it! > >Asim Manzur wrote: > >> http://quiz.rr.nu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Why does this work in one environment and not another?
Could not find the template cfc.profile 9 : Can somebody explain all the places CF would look for the cfc.profile template? It finds it in one environment, but not in another? Thank You -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Timed links
At 01:31 PM 6/17/2004, you wrote: > > ...links... > shouldn't it be... GE (greater or equal to) on the 16 so you get all of the 4pm hour (GT would have precluded 4:00 to 4:59) and "OR" as there's no way the hour could be GT (or GE) 16 and LT 2 at the same time. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Accessing the Java Network API through CF
You'll have to be a little more specific about "accessed the Java network API". I haven't ever used Sockets and such from CF, but I just finished writing a java.net.HttpURLConnection-based client for a faxing service entirely in CFCs. If that's what you're referering to, I can provide some more detail, or answer any specific questions. Cheers, barneyb > -Original Message- > From: Scott Stewart [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 12:11 PM > To: CF-Talk > Subject: Accessing the Java Network API through CF > > Has anyone ever successfully accessed the Java network API > via Cold Fusion? > > sas > > Scott Stewart > Developer & Spam Desk > > RealMagnet > 5039 Connecticut Avenue, NW > Suite 6B > Washington, DC 20008 > > Phone: 202-244-7845 > Fax: 202-244-7926 > Email: [EMAIL PROTECTED] > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IIS Automation questions
Dave, I am using IIS 6 on Win2k3. By definition file, do you mean the xml file that is created by IIS when you "save configuration to file"? What do I do for the line where it uses the site number? Can I just create a unique one myself or does IIS have to do that? Can I create sites from that "definition file" programatically through CF without accessing IIS via the Windows GUI or is the GUI my only option? John -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 3:49 PM To: CF-Talk Subject: RE: IIS Automation questions > 1) In IIS, I'm choosing custom paths for each sites logs to be stored > in. My question is if there's any way to have IIS store the logs > directly in the directory I choose as opposed to /W3SVC##. I want > to automate some other stuff based on this location and that is > screwing me up. Any suggestions would be great. To the best of my knowledge, you can't change the exact directory in which log files will be created. You can specify where that directory will be placed, but that's it. Fortunately, though, you can programmatically determine the name of the directory based on the site number. Each IIS virtual server is issued a unique number, which is used to name the directory. > 2) Along the same lines (and this may partially solve my first > problem), I'm trying to create a new site from a file. > I was thinking I could create a site with the generic setup that I use > across all of my sites and use CF to automatically edit the specifics > of the site (host headers, path for logs, home directory, etc), but as > far as the unique identifier for the site goes, is that just up to me > to keep that unique or is the a larger purpose for that which needs to > be handled by IIS? The unique identifier is the site number, as mentioned above. If you're using IIS 6, you can easily create a new site from a definition file. If you're using IIS 5, you can still script the creation of sites. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHARTFX & ColdFusion MX
the documentation comes with the product doesn't show much information the following example comes with the doc #Chart.GetHtmlTag(500,350)# now my problem is I need to use the SQL server so I can't use it with ADODB component (i don't know how to create the connection with sQL with ADODB). I tried to do it with cfquery but the above line doesnt like the recordset. its name like its using the Ado styple query, not the cfquery. will appriciate your responses. Asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IIS Automation questions
Rick, How/where do you store the log files? I have the following structure set up: Websites |_site1 |_www (iis root) |_logs (where I want the logs to go but IIS puts the W3SVC### folder in here) |_stats (virtual directory /stats for the site where I output the log stats) |_site2 (just like site1 and so on) What you described is most of what I want to automate. John -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 2:59 PM To: CF-Talk Subject: RE: IIS Automation questions 2) This is what I do to create Sub-Domains for current Sites but with a little modification it will work for new sites. You need to use the mkw3site.vbs script that comes with IIS. AdminScripts is the Directory mkw3site script is located in. RootPath is the Root directory where I want to create the website. sandbox is the 3rd level Domain in your case it would be "www". VDomain is second level domain and the Top Level Domain "kchost.net" File="#RootPath#\Sandbox\sandbox.txt" output="#Trim(CMDCommand)#"> destination="#RootPath#\Sandbox\sandbox.cmd"> 1) I am not sure about this one but if you figure it out let me know. I automate our clients Stats and Archive the logfiles each Sunday but I have to go in and modify IIS manually. Rick Eidson Partner & CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ Kansas City Musicians http://www.1sourceentertainment.com/ -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:13 PM To: CF-Talk Subject: SOT: IIS Automation questions Ok, this is more specific than the average "I want to automate IIS stuff in CF questions". I have 2 specific questions that I'd like to see if I can get a little bit of help with. 1) In IIS, I'm choosing custom paths for each sites logs to be stored in. My question is if there's any way to have IIS store the logs directly in the directory I choose as opposed to /W3SVC##. I want to automate some other stuff based on this location and that is screwing me up. Any suggestions would be great. 2) Along the same lines (and this may partially solve my first problem), I'm trying to create a new site from a file. I was thinking I could create a site with the generic setup that I use across all of my sites and use CF to automatically edit the specifics of the site (host headers, path for logs, home directory, etc), but as far as the unique identifier for the site goes, is that just up to me to keep that unique or is the a larger purpose for that which needs to be handled by IIS? I know the second question is more along the lines of a typical "how do I automate IIS" but any specific answers toward my questions would be helpful. (Even if it's just to expand my knowledge) Thanks! John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IIS Automation questions
> 1) In IIS, I'm choosing custom paths for each sites logs to > be stored in. My question is if there's any way to have IIS > store the logs directly in the directory I choose as opposed > to /W3SVC##. I want to automate some other stuff based > on this location and that is screwing me up. Any suggestions > would be great. To the best of my knowledge, you can't change the exact directory in which log files will be created. You can specify where that directory will be placed, but that's it. Fortunately, though, you can programmatically determine the name of the directory based on the site number. Each IIS virtual server is issued a unique number, which is used to name the directory. > 2) Along the same lines (and this may partially solve my > first problem), I'm trying to create a new site from a file. > I was thinking I could create a site with the generic setup > that I use across all of my sites and use CF to automatically > edit the specifics of the site (host headers, path for logs, > home directory, etc), but as far as the unique identifier for > the site goes, is that just up to me to keep that unique or > is the a larger purpose for that which needs to be handled by > IIS? The unique identifier is the site number, as mentioned above. If you're using IIS 6, you can easily create a new site from a definition file. If you're using IIS 5, you can still script the creation of sites. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Musings CFAnywhere, Bandwidth, RIAs Part 1
> > > Why can't Hal's site have a richer UI -- think of it > > > -- Hal's voice, explaining the animated preso? > > > > There's already a great answer for this, though - > > Macromedia Breeze. It's a really good product for this > > sort of thing, and it makes building presentations very > > easy. > > Isn't it a little pricey for most users? It's well worth the price, if you want to publish training materials online. Yes, it's pricey, but I suspect it's cheaper than building your own infrastructure to do the same thing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Timed links
...links... -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 3:35 PM To: CF-Talk Subject: Timed links I have several links that come from a db. How can I only have these links display between the hours of 4pm and 2am daily? Cutter _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Timed links
I have several links that come from a db. How can I only have these links display between the hours of 4pm and 2am daily? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Back Button Issue?
Now that's interesting. Never thought of that, I like it! Asim Manzur wrote: > http://quiz.rr.nu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Back Button Issue?
http://quiz.rr.nu does this works in your case? >I think they are referring to the page expiring after the form is being >submitted. AFAIK you cannot disable a back button - even if you could it is >part of client browser of which you have only as much control as the user >(owner) of the browser gives you. > >TK > -Original Message- > From: Greg Luce [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 9:14 AM > To: CF-Talk > Subject: Back Button Issue? > > > Here's my situation, we have a form submission that processes a payment >and > takes the user to a confirmation page. I have programmed logic in the > processing page to prohibit duplicate entries. But the clients are asking > that if the user is on the confirmation page and hit's the browser "Back" > button, that they don't get the form again. Is this possible? They tell me > "The banks do it". > > > Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CHARTFX & ColdFusion MX
hi, does anyone successfully implemented chartfx with coldfusion, if yes , I am looking for some sample codes (with cfquery or ADODB whichever is available) thanks in advance. asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Accessing the Java Network API through CF
Has anyone ever successfully accessed the Java network API via Cold Fusion? sas Scott Stewart Developer & Spam Desk RealMagnet 5039 Connecticut Avenue, NW Suite 6B Washington, DC 20008 Phone: 202-244-7845 Fax: 202-244-7926 Email: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dta comparison from identical tables, but different data
Per your suggestion I ran the following but no records were returned and I should have had at least eight records that have changes SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateofflight,aircraft,pilotid FROM( SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateofflight,aircraft,pilotid FROM eagles UNION SELECT eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateofflight,aircraft,pilotid FROM eagles2 ) temp GROUP BY eagleid,firstname,lastname,middleinit,suffix,city,state,country,dateofflight,aircraft,pilotid HAVING count(eagleid) > 1 -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:32 PM To: CF-Talk Subject: RE: dta comparison from identical tables, but different data SELECT col1,col2,etc FROM ( SELECT col1,col2,etc FROM TABLE1 UNION SELECT col1,col2,etc FROM TABLE2 ) temp GROUP BY col1,col2,etc HAVING count(col1) > 1 Marlon > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 12:36 PM > To: CF-Talk > Subject: SQL: dta comparison from identical tables, but different data > > Got a table with approximately 11 columns and 1 million records. I have a > another table with the same columns and records but want to compare if the > data is different. Changes could be in one or more of the columns. How can > I compare these. MS SQL2000? > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IIS Automation questions
You should be able to find the info you are looking for here: http://www.iisanswers.com/ What version of IIS are you running; IIS 6 (Windows 2003 server) uses a XML file to hold the IIS meta base C:\Windows\system32\inetsrv\metabase.xml. I have not yet tried to see if you can make live changes to this OR not. My first guess is you would have to reset IIS to see any changes. I did some research a while back to see if I could deal with the log folders issue W3SVC, I seem to remember that there way a way of removing the folder names, but as I recall it created more problems for me than it solved. We settled for making a folder with the client's name then putting the W3SVCxxx log folder in inside the client folder. Check out the Adsutil.vbs it is a utility that uses Microsoft Visual Basic Scripting Edition to manipulate the IIS configuration http://www.microsoft.com/resources/documentation/iis/6/all/proddocs/en-us/pr og_use_adsutil.mspx Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IIS Automation questions
2) This is what I do to create Sub-Domains for current Sites but with a little modification it will work for new sites. You need to use the mkw3site.vbs script that comes with IIS. AdminScripts is the Directory mkw3site script is located in. RootPath is the Root directory where I want to create the website. sandbox is the 3rd level Domain in your case it would be "www". VDomain is second level domain and the Top Level Domain "kchost.net" File="#RootPath#\Sandbox\sandbox.txt" output="#Trim(CMDCommand)#"> destination="#RootPath#\Sandbox\sandbox.cmd"> 1) I am not sure about this one but if you figure it out let me know. I automate our clients Stats and Archive the logfiles each Sunday but I have to go in and modify IIS manually. Rick Eidson Partner & CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ Kansas City Musicians http://www.1sourceentertainment.com/ -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:13 PM To: CF-Talk Subject: SOT: IIS Automation questions Ok, this is more specific than the average "I want to automate IIS stuff in CF questions". I have 2 specific questions that I'd like to see if I can get a little bit of help with. 1) In IIS, I'm choosing custom paths for each sites logs to be stored in. My question is if there's any way to have IIS store the logs directly in the directory I choose as opposed to /W3SVC##. I want to automate some other stuff based on this location and that is screwing me up. Any suggestions would be great. 2) Along the same lines (and this may partially solve my first problem), I'm trying to create a new site from a file. I was thinking I could create a site with the generic setup that I use across all of my sites and use CF to automatically edit the specifics of the site (host headers, path for logs, home directory, etc), but as far as the unique identifier for the site goes, is that just up to me to keep that unique or is the a larger purpose for that which needs to be handled by IIS? I know the second question is more along the lines of a typical "how do I automate IIS" but any specific answers toward my questions would be helpful. (Even if it's just to expand my knowledge) Thanks! John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: About Scoping mostly url and form
If you used fusebox, you wouldn't need to worry about whether the variable came through get or post method. The famework copy url and form variables to attributes scoped variables. This also makes it interoperable with cfmodule calls when you call it recursively. If you are not using fusebox, you can write your own structCopy() and copy url and form to attributes or request variables, and put it the application.cfm. Nick Han >>> [EMAIL PROTECTED] 06/17/04 09:47AM >>> At the risk of looking not too bright I have a question maybe I can get help, or someone can put me in my place So about scope. when I started coding CF (about 7 years ago) I really didn't know about scope at all, then I started using cgi session application client query struct form url and request scopes. But then I had a massive problems and had to change lots of code especialy when I had forms and urls passing variables to the same page to do the same thing. (mostly I had to write code to dump them all into request scope but I never put together a script to do it, which right now I'm sure I'll find, working with php fusebox form and url vars were dumped into an attributes array easily and I can probably base it on that) One day I just quit on the whole thing and ever since I realy haven't as many problems. What do you folks do when you want a variable that can be passed over form or url? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dta comparison from identical tables, but different data
SELECT col1,col2,etc FROM ( SELECT col1,col2,etc FROM TABLE1 UNION SELECT col1,col2,etc FROM TABLE2 ) temp GROUP BY col1,col2,etc HAVING count(col1) > 1 Marlon > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 12:36 PM > To: CF-Talk > Subject: SQL: dta comparison from identical tables, but different data > > Got a table with approximately 11 columns and 1 million records. I have a > another table with the same columns and records but want to compare if the > data is different. Changes could be in one or more of the columns. How can > I compare these. MS SQL2000? > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
question about "server" variable
What does the variable "server.Coldfusion.expiration" mean? I'm examining a users current host. -mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx and CAPTCHA
Ryan, anyway we can change the background image with your tag? Ryan Emerle wrote: > I have posted the tag i created on my site. You can grab a copy from here: > > http://www.emerle.net/programming/display.cfm/t/cfx_captcha > > Included is an example file which shows how you can use session variables. > > Basically, the example file will act as an image. You simply add an > IMG tag pointing to that file: > > > And it will serve up the generated image with CFCONTENT right after it > sets the session variable. All you have to do is check the posted > value against the session value. Of course, you will have to watch > out for session timeouts.. :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: IIS Automation questions
Ok, this is more specific than the average "I want to automate IIS stuff in CF questions". I have 2 specific questions that I'd like to see if I can get a little bit of help with. 1) In IIS, I'm choosing custom paths for each sites logs to be stored in. My question is if there's any way to have IIS store the logs directly in the directory I choose as opposed to /W3SVC##. I want to automate some other stuff based on this location and that is screwing me up. Any suggestions would be great. 2) Along the same lines (and this may partially solve my first problem), I'm trying to create a new site from a file. I was thinking I could create a site with the generic setup that I use across all of my sites and use CF to automatically edit the specifics of the site (host headers, path for logs, home directory, etc), but as far as the unique identifier for the site goes, is that just up to me to keep that unique or is the a larger purpose for that which needs to be handled by IIS? I know the second question is more along the lines of a typical "how do I automate IIS" but any specific answers toward my questions would be helpful. (Even if it's just to expand my knowledge) Thanks! John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SQL: dta comparison from identical tables, but different data
Got a table with approximately 11 columns and 1 million records. I have a another table with the same columns and records but want to compare if the data is different. Changes could be in one or more of the columns. How can I compare these. MS SQL2000? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Client wants to add data from spreadsheets - HELP!
I deal a lot with Excel and SQL and routinely use CF for data input and output. I like Excel for data entry because it is so flexible. If you want to get fancy try what I did: write a simple vba function in Excel that creates an xml file. Then write a CF script to upload the data into SQL Server. By doing this you use Excel as a front end. You can create a web front end also or whatever you like. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Musings CFAnywhere, Bandwidth, RIAs Part 1
On Jun 17, 2004, at 9:31 AM, Dave Watts wrote: > > Why can't Hal's site have a richer UI -- think of it -- Hal's > > voice, explaining the animated preso? > > There's already a great answer for this, though - Macromedia Breeze. > It's a > really good product for this sort of thing, and it makes building > presentations very easy. Isn't it a little pricey for most users? Dick "In times like these, it helps to recall that there have always been times like these." - Paul Harvey - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: About Scoping mostly url and form
Ben Doom wrote: > What do you folks do when you want a variable that can be passed over > form or url? -- make a decision (which does what) & then make 'em mutually exclusive [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Jrun Closed Connection : Help
I have been fighting this for sometime now and have now started moving sites off one at a time to see if the problem went with it. The first site I moved was BlueEar.com. BlueEar.com is the largest of our sites and generates the most traffic on my servers. It also has Scheduled Task that runs daily. Some of these tasks create another task. I have an HTML Daily that does an HTTP request to BlueEar.com and writes the content to file then schedules the Send_HTML task using cfschedule. The Send_HTML loops over the few thousand members sending the message and then deletes its self again using cfschedule. When I was on CF5 this had no problems but now apparently CFMX has a bug that when you delete a task with cfschedule it only removes it from the Scheduled Task list but continues to run until you restart the server. In addition to this one there are a few more that work much in the same matter. Each time I restarted it was just a matter of time depending on the traffic and incoming messages to the BlueEar Community. Just a thought but since I did this I haven't seen the error. I am now setting up a low end server running CF5 to handle all scheduled task. Rick Eidson Partner & CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ Kansas City Musicians http://www.1sourceentertainment.com/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 10:43 AM To: CF-Talk Subject: Jrun Closed Connection : Help OK, I know of a few technotes on this error but to be honest the results it returns are pretty much useless...anyone know why a perfectly healthy server would start to generate the Jrun Closed Connection Error while ColdFusion crashes and restarts? It all seems to work fine on a development server but the crash happens every 2 or 3 mins on the test one. I would be very surprised. not to mention angry if its code causing it as it works AOK on the dev. ColdFusion 6.1 FULLY patched Windows 2000 IIS 5.x Default Vanilla install JVM Any help here would be mucho appreciato..seriously losing my patience with CFMX on this front - 5 was never this flakeyI seriously hope Blackstone goes the distance as we are about to consider regression back to ColdFusion 5 This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: About Scoping mostly url and form
If you use fusebox, it dumps them all in the attributes scope. You can still use the CT formurl2attributes (I think) to do that in the application.cfm. You could also not use the prefix, but I wouldn't recommend it. Pascal PS I use fusebox -Oorspronkelijk bericht- Van: Joshua O'Connor-Rose [mailto:[EMAIL PROTECTED] Verzonden: do 17/06/2004 18:47 Aan: CF-Talk CC: Onderwerp: About Scoping mostly url and form At the risk of looking not too bright I have a question maybe I can get help, or someone can put me in my place So about scope. when I started coding CF (about 7 years ago) I really didn't know about scope at all, then I started using cgi session application client query struct form url and request scopes. But then I had a massive problems and had to change lots of code especialy when I had forms and urls passing variables to the same page to do the same thing. (mostly I had to write code to dump them all into request scope but I never put together a script to do it, which right now I'm sure I'll find, working with php fusebox form and url vars were dumped into an attributes array easily and I can probably base it on that) One day I just quit on the whole thing and ever since I realy haven't as many problems. What do you folks do when you want a variable that can be passed over form or url? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT Plagiarism accusation stops posting
Charlie Griefer >I'm going to reply in (and hopefully move the thread to) cf-community :) Same here, and just did. I can speak more freely there than we need to see here, anyway. I won't post here on this again. Sorry to all for the OT... Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: advanced search
> Thanks guys for helping me with this. I looked more in > Verity. Verity only looks at static pages. Since my page is > generated dynamically by the database at runtime, this option > will not work. I'm still kinda new to CF and so didn't know > about CFQUERYPARAM...but I do now :-) You can index database content using Verity and the CFINDEX tag. You can't easily index the generated pages that use that content, but it's very easy to index the content itself. Then, when someone searches Verity, the search results can contain the primary keys of the relevant records, and you can easily display links to pages that show those records. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Palm OS development
For palm development or pocket pc, we used sattelite form by pumatech Pat _ From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: June 17, 2004 12:01 To: CF-Talk Subject: OT: Palm OS development Hey All, We've been asked to develop an application for PDAs (Pocket PC and Palm OS). We use Pocket Builder for Pocket PC...so development there is a snap...but we haven't tackled Palm before. So if anyone has any advice/resources about Palm OS application development (data mining essentially) that a CFer would understandfire away!! ;-) Thanks in advance 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 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfun
One area where I would say CFUN and MAX differentiate is that MAX tends to have mostly beginner and intermediate sessions and CFUN has a broader range. Of course if you're interested in the other stuff (non-CF sessions, Birds of a Feather, Sneak Peaks) then MAX certainly has an advantage. If you're interested in accessiblity, as many in this region are (I'm also just a few miles from the CFUN location) then CFUN has a huge plus with an entire track on accessibility issues. Tradeoffs, tradeoffs, which to go to... Sam -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:00 PM To: CF-Talk Subject: Re: cfun I wouldn't go that far. I think that MAX is definitely well worth the price tag. It's true that you don't get as many CF-specific topics at MAX, but that is a good or a bad thing depending on who you ask. Personally, I learn a hell of a lot more at non CF-specific sessions, so I like that. I also don't believe CFUN is technically a "user group conference", though I could well be wrong about that (it doesn't really matter, does it?). Last I heard, it's a TeraTech event that is sponsored by several CFUGs/MMUGs and other companies (see the CFUN site for a complete list of sponsors). I do believe that if all you're interested in is CF - you may well get more for your money at CFUN, but there's no denying that the quality of sessions and speakers at MAX is terrific. Bottom line is that I hold them equal in terms of value for money. If you're on a tight budget or have no interest in anything but CF then CFUN may well be the way to go. If your interests vary, you are interested in hearing more MM people speak (or in socializing with them more), and/or you can afford it then I recommend MAX. Personally, I wouldn't miss either. ~Simon Simon Horwith [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: About Scoping mostly url and form
Thanks I'm sure I'll work with FB again, not happening where I'm at right now. But I've made the recommendation. Love the stuff. -Joshua O'Connor-Rose -All is Good --- Sandy Clark <[EMAIL PROTECTED]> wrote: > I use fusebox, which dumps all form and url values > to an attributes scope. > > You can emulate it if you don't want to make the > move to FB. > > if (NOT IsDefined("attributes")) > attributes=structNew(); > StructAppend(attributes, url, "yes"); > StructAppend(attributes, form, "yes"); > > > _ > > From: Joshua O'Connor-Rose > [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 12:47 PM > To: CF-Talk > Subject: About Scoping mostly url and form > > > At the risk of looking not too bright I have a > question maybe I can get > help, or someone can put me in my place > > So about scope. > > when I started coding CF (about 7 years ago) I > really didn't know about > scope at all, then I started using cgi session > application client query > struct form url and request scopes. > > But then I had a massive problems and had to change > lots of code especialy > when I had forms and urls passing variables to the > same page to do the same > thing. (mostly I had to write code to dump them all > into request scope but I > never put together a script to do it, which right > now I'm sure I'll find, > working with php fusebox form and url vars were > dumped into an attributes > array easily and I can probably base it on that) > > One day I just quit on the whole thing and ever > since I realy haven't as > many problems. > > What do you folks do when you want a variable that > can be passed over form > or url? > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfun
Parklawn was their old office, they haven't gotten around to taking off the sign there (neither has the landlord). They moved to Gude drive about a year ago. _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:23 PM To: CF-Talk Subject: Re: cfun I'm going to wait until after to conference to form an opinion of which is better. This year is shaping up to be great for CFUN. However you'd be a fool if you didnt try to convince your company to send you to New Orleans on thier budget! btw. Did TeraTech move to Parklawn? I just noticed thier sign on a building there. Last I was at thier office it was off Gude. -Adam - Original Message - From: Simon Horwith <[EMAIL PROTECTED]> Date: Thu, 17 Jun 2004 17:59:33 +0100 Subject: Re: cfun To: CF-Talk <[EMAIL PROTECTED]> I wouldn't go that far. I think that MAX is definitely well worth the price tag. It's true that you don't get as many CF-specific topics at MAX, but that is a good or a bad thing depending on who you ask. Personally, I learn a hell of a lot more at non CF-specific sessions, so I like that. I also don't believe CFUN is technically a "user group conference", though I could well be wrong about that (it doesn't really matter, does it?). Last I heard, it's a TeraTech event that is sponsored by several CFUGs/MMUGs and other companies (see the CFUN site for a complete list of sponsors). I do believe that if all you're interested in is CF - you may well get more for your money at CFUN, but there's no denying that the quality of sessions and speakers at MAX is terrific. Bottom line is that I hold them equal in terms of value for money. If you're on a tight budget or have no interest in anything but CF then CFUN may well be the way to go. If your interests vary, you are interested in hearing more MM people speak (or in socializing with them more), and/or you can afford it then I recommend MAX. Personally, I wouldn't miss either. ~Simon Simon Horwith CTO, eTRILOGY ltd. Member of Team Macromedia Macromedia Certified Master Instructor http://www.cfstandards.org Sandy Clark wrote: > Its the largest user group conference specifically for ColdFusion in > the US. > This is the 5th year. > > > Last year it was something like 350 people. This year its 525 people, 2 > days, 5 tracks, 36 speakers and a heck of a lot less expensive than MAX. > > > Also since most of the topics are CF/programming oriented you get a lot > more bang for your buck than MAX. (I think MAX's schedule last year, only > 15% of its talks were CF oriented. someone correct me if I am wrong). > > > http://www.cfconf.org/cfun-04/ > > _ > > From: Tim Laureska [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 8:27 AM > To: CF-Talk > Subject: RE: cfun > > Where is this event and what is it... I'm in Maryland and was just > curious > > Tim > > -Original Message- > From: Sandy Clark [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 8:17 AM > To: CF-Talk > Subject: RE: cfun > > I will be there, speaking twice on Sunday! > > Looking forward to it. > > Btw, at last count (Wednesday morning), there were 525 people > registered. > It should be absolutely amazing > > Sandy > > _ > > From: Whittingham, P > > Anyone going to CFUN in MD later this month? This is a thread in cfdj. > Is > their a networking/fun gathering on Friday? > > TIA, > Patrick Whittingham > United Space Alliance > > _ > _ > _ > _ > _ > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfun
> Snap. I had no idea there were other Rock Vegas people on the list. > I actually just moved to right off Randolph Rd and Rocking Horse. I just moved from Randolph and Glenallen (Winexburg Manor) to Avalon Bay over in North Bethesda/ Rockville. :-) Randolph traffic sucks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: advanced search
Nando, Thanx for that Frank From: Nando [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 12:03 PM To: CF-Talk Subject: RE: advanced search Frank, IF creating the index for dynamic pages is all that's holding you up, look a little deeper into Verity (although i'm not sure it's what you need overall). You CAN index dynamic pages that are generated from different tables and/or datasources, static pages, and uploaded documents, and all three can be combined into one index to create a powerful search capability. That's how we handle search functionality on all our projects. :) n. -Original Message- From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 6:20 PM To: CF-Talk Subject: RE: advanced search Thanks guys for helping me with this. I looked more in Verity. Verity only looks at static pages. Since my page is generated dynamically by the database at runtime, this option will not work. I'm still kinda new to CF and so didn't know about CFQUERYPARAM...but I do now :-) I am using Microsoft SQL Enterprise Manager. After the user enters there string, then I am going to parse it for " (Double quotes - of course there must be two), - (minus sign - for NOT), and + (addition sign - for AND). By default, the words will be separated by spaces and an OR operation will be applied to them. Then I am thinking about using some combination of LIKEs, Full Text Indexing, and/or cfqueryparam. Of course I want the application to run fast so I might nix the LIKE '%#word#%'. Thanx again for the help - Frank From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 3:59 PM To: CF-Talk Subject: advanced search Hello all, I'm looking into searching a website for a particular string or occurence of a string. I would like for this to be an advanced search (what I am looking for is something more complex than a simple LIKE). In the database - QBOS_HELPFILE (id, name,keywords) - I am storing a list of words separated only by spaces. And I am starting out with this query: SELECT * FROM QBOS_HELPFILE WHERE keywords LIKE '%#form.words#%' I've tried separating the words by commas and using the IN operator, but that only works if the field (keywords) contains one word Maybe a combination of the In operator and LIKE depending on the search text - if the search text has quotes or not. Of course the text should be first parsed. I'm not sure what the best way to go about this is. Are their some good examples out there? I've looked at Verity a little...but I'm not sure that is what I need. Are there any suggestions/help on this matter that ya'll can help me with? Thank you - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd. Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfun
I'm going to wait until after to conference to form an opinion of which is better. This year is shaping up to be great for CFUN. However you'd be a fool if you didnt try to convince your company to send you to New Orleans on thier budget! btw. Did TeraTech move to Parklawn? I just noticed thier sign on a building there. Last I was at thier office it was off Gude. -Adam - Original Message - From: Simon Horwith <[EMAIL PROTECTED]> Date: Thu, 17 Jun 2004 17:59:33 +0100 Subject: Re: cfun To: CF-Talk <[EMAIL PROTECTED]> I wouldn't go that far. I think that MAX is definitely well worth the price tag. It's true that you don't get as many CF-specific topics at MAX, but that is a good or a bad thing depending on who you ask. Personally, I learn a hell of a lot more at non CF-specific sessions, so I like that. I also don't believe CFUN is technically a "user group conference", though I could well be wrong about that (it doesn't really matter, does it?). Last I heard, it's a TeraTech event that is sponsored by several CFUGs/MMUGs and other companies (see the CFUN site for a complete list of sponsors). I do believe that if all you're interested in is CF - you may well get more for your money at CFUN, but there's no denying that the quality of sessions and speakers at MAX is terrific. Bottom line is that I hold them equal in terms of value for money. If you're on a tight budget or have no interest in anything but CF then CFUN may well be the way to go. If your interests vary, you are interested in hearing more MM people speak (or in socializing with them more), and/or you can afford it then I recommend MAX. Personally, I wouldn't miss either. ~Simon Simon Horwith CTO, eTRILOGY ltd. Member of Team Macromedia Macromedia Certified Master Instructor http://www.cfstandards.org Sandy Clark wrote: > Its the largest user group conference specifically for ColdFusion in > the US. > This is the 5th year. > > > Last year it was something like 350 people. This year its 525 people, 2 > days, 5 tracks, 36 speakers and a heck of a lot less expensive than MAX. > > > Also since most of the topics are CF/programming oriented you get a lot > more bang for your buck than MAX. (I think MAX's schedule last year, only > 15% of its talks were CF oriented. someone correct me if I am wrong). > > > http://www.cfconf.org/cfun-04/ > > _ > > From: Tim Laureska [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 8:27 AM > To: CF-Talk > Subject: RE: cfun > > Where is this event and what is it... I'm in Maryland and was just > curious > > Tim > > -Original Message- > From: Sandy Clark [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 8:17 AM > To: CF-Talk > Subject: RE: cfun > > I will be there, speaking twice on Sunday! > > Looking forward to it. > > Btw, at last count (Wednesday morning), there were 525 people > registered. > It should be absolutely amazing > > Sandy > > _ > > From: Whittingham, P > > Anyone going to CFUN in MD later this month? This is a thread in cfdj. > Is > their a networking/fun gathering on Friday? > > TIA, > Patrick Whittingham > United Space Alliance > > _ > _ > _ > _ > _ > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: advanced search
On Thu, 17 Jun 2004 11:19:46 -0500, Frank Dewey wrote: > > Thanks guys for helping me with this. I looked more in Verity. Verity > only looks at static pages. You're clearly not reading the Verity documentation properly Look at the QUERY attribute of CFINDEX [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfun
Snap. I had no idea there were other Rock Vegas people on the list. I actually just moved to right off Randolph Rd and Rocking Horse. -Adam - Original Message - From: Tangorre, Michael <[EMAIL PROTECTED]> Date: Thu, 17 Jun 2004 12:13:27 -0400 Subject: RE: cfun To: CF-Talk <[EMAIL PROTECTED]> Adam, Whereabouts do you live... I am right off of Tuckerman! Mike > I'll be there, along with my lovely fiance as always. This > will be my 3rd year going. I'm not cool enough to be > speaking, so I'll be drinking instead. It's my birthday that > Saturday so I hope I wont have to drink alone :( > > btw. also bringing 5 other coworkers along. > > Did I mention its only a few blocks from my home? If there is > enough interest I _could_ be persuaded to throw a kegger > saturday night. > > -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfun
Oh! Count me in!!! ME! Me! I'm always ready for a party! :D Hubby and I are coming along! CFUN is the best ... This will be my third one I think - I lose track after the Saturday night parties ... - Original Message - From: Adrocknaphobia Did I mention its only a few blocks from my home? If there is enough interest I _could_ be persuaded to throw a kegger saturday night. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: advanced search
Frank, IF creating the index for dynamic pages is all that's holding you up, look a little deeper into Verity (although i'm not sure it's what you need overall). You CAN index dynamic pages that are generated from different tables and/or datasources, static pages, and uploaded documents, and all three can be combined into one index to create a powerful search capability. That's how we handle search functionality on all our projects. :) n. -Original Message- From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 6:20 PM To: CF-Talk Subject: RE: advanced search Thanks guys for helping me with this. I looked more in Verity. Verity only looks at static pages. Since my page is generated dynamically by the database at runtime, this option will not work. I'm still kinda new to CF and so didn't know about CFQUERYPARAM...but I do now :-) I am using Microsoft SQL Enterprise Manager. After the user enters there string, then I am going to parse it for " (Double quotes - of course there must be two), - (minus sign - for NOT), and + (addition sign - for AND). By default, the words will be separated by spaces and an OR operation will be applied to them. Then I am thinking about using some combination of LIKEs, Full Text Indexing, and/or cfqueryparam. Of course I want the application to run fast so I might nix the LIKE '%#word#%'. Thanx again for the help - Frank From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 3:59 PM To: CF-Talk Subject: advanced search Hello all, I'm looking into searching a website for a particular string or occurence of a string. I would like for this to be an advanced search (what I am looking for is something more complex than a simple LIKE). In the database - QBOS_HELPFILE (id, name,keywords) - I am storing a list of words separated only by spaces. And I am starting out with this query: SELECT * FROM QBOS_HELPFILE WHERE keywords LIKE '%#form.words#%' I've tried separating the words by commas and using the IN operator, but that only works if the field (keywords) contains one word Maybe a combination of the In operator and LIKE depending on the search text - if the search text has quotes or not. Of course the text should be first parsed. I'm not sure what the best way to go about this is. Are their some good examples out there? I've looked at Verity a little...but I'm not sure that is what I need. Are there any suggestions/help on this matter that ya'll can help me with? Thank you - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd. Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: About Scoping mostly url and form
I use fusebox, which dumps all form and url values to an attributes scope. You can emulate it if you don't want to make the move to FB. if (NOT IsDefined("attributes")) attributes=structNew(); StructAppend(attributes, url, "yes"); StructAppend(attributes, form, "yes"); _ From: Joshua O'Connor-Rose [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 12:47 PM To: CF-Talk Subject: About Scoping mostly url and form At the risk of looking not too bright I have a question maybe I can get help, or someone can put me in my place So about scope. when I started coding CF (about 7 years ago) I really didn't know about scope at all, then I started using cgi session application client query struct form url and request scopes. But then I had a massive problems and had to change lots of code especialy when I had forms and urls passing variables to the same page to do the same thing. (mostly I had to write code to dump them all into request scope but I never put together a script to do it, which right now I'm sure I'll find, working with php fusebox form and url vars were dumped into an attributes array easily and I can probably base it on that) One day I just quit on the whole thing and ever since I realy haven't as many problems. What do you folks do when you want a variable that can be passed over form or url? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Frame Effect With CF?
I either use a iframe but the irame creates a lot more overhead, especially if the information you want to display in the frame is computed byt the page you want to include it on. For circumstances like these i use a quick custom tag to put a span with a scrollbar around it. Tyler Clendenin GSL Solutions _ From: Nick Baker [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 11:53 AM To: CF-Talk Subject: Frame Effect With CF? Is there any way to embed a Frame within a table cell? From my limited knowledge of frames, frames have a lot of conflicts that make it very difficult to embed. Or is there a custom CF Tag (or _javascript_ function) that will accomplish the same thing? I am sure this is old hat to most of you. The goal is to eliminate so many accesses to the server. Download one document with Bookmarks. Current thinking is to use something like a table with two columns. Have the left col hold the links to Bookmarks and the right col contain the content. Thanks, Nick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfun
I wouldn't go that far. I think that MAX is definitely well worth the price tag. It's true that you don't get as many CF-specific topics at MAX, but that is a good or a bad thing depending on who you ask. Personally, I learn a hell of a lot more at non CF-specific sessions, so I like that. I also don't believe CFUN is technically a "user group conference", though I could well be wrong about that (it doesn't really matter, does it?). Last I heard, it's a TeraTech event that is sponsored by several CFUGs/MMUGs and other companies (see the CFUN site for a complete list of sponsors). I do believe that if all you're interested in is CF - you may well get more for your money at CFUN, but there's no denying that the quality of sessions and speakers at MAX is terrific. Bottom line is that I hold them equal in terms of value for money. If you're on a tight budget or have no interest in anything but CF then CFUN may well be the way to go. If your interests vary, you are interested in hearing more MM people speak (or in socializing with them more), and/or you can afford it then I recommend MAX. Personally, I wouldn't miss either. ~Simon Simon Horwith CTO, eTRILOGY ltd. Member of Team Macromedia Macromedia Certified Master Instructor http://www.cfstandards.org Sandy Clark wrote: > Its the largest user group conference specifically for ColdFusion in > the US. > This is the 5th year. > > > Last year it was something like 350 people. This year its 525 people, 2 > days, 5 tracks, 36 speakers and a heck of a lot less expensive than MAX. > > > Also since most of the topics are CF/programming oriented you get a lot > more bang for your buck than MAX. (I think MAX's schedule last year, only > 15% of its talks were CF oriented. someone correct me if I am wrong). > > > http://www.cfconf.org/cfun-04/ > > _ > > From: Tim Laureska [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 8:27 AM > To: CF-Talk > Subject: RE: cfun > > Where is this event and what is it... I'm in Maryland and was just > curious > > Tim > > -Original Message- > From: Sandy Clark [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 17, 2004 8:17 AM > To: CF-Talk > Subject: RE: cfun > > I will be there, speaking twice on Sunday! > > Looking forward to it. > > Btw, at last count (Wednesday morning), there were 525 people > registered. > It should be absolutely amazing > > Sandy > > _ > > From: Whittingham, P > > Anyone going to CFUN in MD later this month? This is a thread in cfdj. > Is > their a networking/fun gathering on Friday? > > TIA, > Patrick Whittingham > United Space Alliance > > _ > _ > _ > _ > _ > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: About Scoping mostly url and form
Here, we've created an "artificial" scope that contains the contents of both URL and FORM scopes. If something exists in both, FORM overwrites URL. --Ben Doom Joshua O'Connor-Rose wrote: > At the risk of looking not too bright I have a question maybe I can get > help, or someone can put me in my place > > So about scope. > > when I started coding CF (about 7 years ago) I really didn't know about > scope at all, then I started using cgi session application client query > struct form url and request scopes. > > But then I had a massive problems and had to change lots of code > especialy when I had forms and urls passing variables to the same page > to do the same thing. (mostly I had to write code to dump them all into > request scope but I never put together a script to do it, which right > now I'm sure I'll find, working with php fusebox form and url vars were > dumped into an attributes array easily and I can probably base it on that) > > One day I just quit on the whole thing and ever since I realy haven't as > many problems. > > What do you folks do when you want a variable that can be passed over > form or url? > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfun
that implies that the speakers won't be drinking. tsk, tsk... you should know better than that. especially if this is your 3rd one ;) ~Simon Simon Horwith CTO, eTRILOGY ltd. Member of Team Macromedia Macromedia Certified Master Instructor http://www.cfstandards.org Adrocknaphobia wrote: > I'll be there, along with my lovely fiance as always. This will be my > 3rd year going. I'm not cool enough to be speaking, so I'll be > drinking instead. It's my birthday that Saturday so I hope I wont have > to drink alone :( > > btw. also bringing 5 other coworkers along. > > Did I mention its only a few blocks from my home? If there is enough > interest I _could_ be persuaded to throw a kegger saturday night. > > -Adam > > - Original Message - > From: Whittingham, P <[EMAIL PROTECTED]> > Date: Thu, 17 Jun 2004 07:17:37 -0400 > Subject: cfun > To: CF-Talk <[EMAIL PROTECTED]> > > Anyone going to CFUN in MD later this month? This is a thread in > cfdj. Is their a networking/fun gathering on Friday? > > TIA, > Patrick Whittingham > United Space Alliance > > _ > _ > _ > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT Plagiarism accusation stops posting
I'm going to reply in (and hopefully move the thread to) cf-community :) - Original Message - From: "John Munyan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 9:08 AM Subject: RE: OT Plagiarism accusation stops posting > I should start by saying I have never written a tutorial so I don't know what it feels like to have my IP stolen personally. I am far from an expert with CF, maybe proficient. I have bennefited from tutorials across the web to help me with my website, the purpose of which to simple provide Hiking information to people around Washington State. I don't do this to make money, just a philantropic undertaking ( I like the feeling of knowing people are getting value out of something I created). > > Seems to me the purpose of my website and tutorials are generally the same, to provide information to the masses to make the overall picture we all live in better. If I had the skill to create a valuable tutorial I think the bennefit to the community outweighs the possibility/likelyhood that it will be ripped off. Isn't the point of the whole undertaking to put these great ideas into the hands of those who can use them to in turn make something valuable to the greater community? Either way it is being accomplished. I can only imagine it is painful to have others claim your work as their own, but I think the overall good of putting information on the web to be used by others outweighs that pain. > > Just my 2cents. > > John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfun
I live in the Hungerford area, about 10 minutes from the hotel. Btw, there will be party for everyone on Saturday, so you might not want to schedule anything that night unless it is much later in the evening say around 9 or 10pm _ From: Tangorre, Michael Adam, Whereabouts do you live... I am right off of Tuckerman! Mike > I'll be there, along with my lovely fiance as always. This > will be my 3rd year going. I'm not cool enough to be > speaking, so I'll be drinking instead. It's my birthday that > Saturday so I hope I wont have to drink alone :( > > btw. also bringing 5 other coworkers along. > > Did I mention its only a few blocks from my home? If there is > enough interest I _could_ be persuaded to throw a kegger > saturday night. > > -Adam _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Frame Effect With CF?
Try iframes Its part of the HTML 4.01 spec _ From: Nick Baker [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 11:53 AM To: CF-Talk Subject: Frame Effect With CF? Is there any way to embed a Frame within a table cell? From my limited knowledge of frames, frames have a lot of conflicts that make it very difficult to embed. Or is there a custom CF Tag (or _javascript_ function) that will accomplish the same thing? I am sure this is old hat to most of you. The goal is to eliminate so many accesses to the server. Download one document with Bookmarks. Current thinking is to use something like a table with two columns. Have the left col hold the links to Bookmarks and the right col contain the content. Thanks, Nick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
About Scoping mostly url and form
At the risk of looking not too bright I have a question maybe I can get help, or someone can put me in my place So about scope. when I started coding CF (about 7 years ago) I really didn't know about scope at all, then I started using cgi session application client query struct form url and request scopes. But then I had a massive problems and had to change lots of code especialy when I had forms and urls passing variables to the same page to do the same thing. (mostly I had to write code to dump them all into request scope but I never put together a script to do it, which right now I'm sure I'll find, working with php fusebox form and url vars were dumped into an attributes array easily and I can probably base it on that) One day I just quit on the whole thing and ever since I realy haven't as many problems. What do you folks do when you want a variable that can be passed over form or url? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Palm OS development
> We've been asked to develop an application for PDAs (Pocket > PC and Palm OS). We use Pocket Builder for Pocket PC...so > development there is a snap...but we haven't tackled Palm > before. > > So if anyone has any advice/resources about Palm OS application > development (data mining essentially) that a CFer would > understandfire away!! ;-) If you need to deploy the same application to both platforms, I've heard good things about this product: http://www.appforge.com/ I haven't used it, though. My PDA development experience is limited to eVB and .NET Compact Framework for Pocket PC. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx and CAPTCHA
> I'm not saying it ever receives that variable. However, > CF somehow associates that session with that client, > therefore, the spider appears to be a valid client. I would go a step farther and say that it is a valid client. There's no difference between one HTTP client and another, from the web server's perspective, beyond the User-Agent string that each client sends to identify itself. > Once it has the session, what keeps it from posting a > million times on that session? Your code would have to prevent this, if you didn't want it to be a possibility. > CF has to set something on the client (cookie or token or > something) to keep the session alive, and couldn't the > browser/spider spoof that? If by "spoof", you mean that one HTTP client could send a token that belonged to another HTTP client, yes. If one HTTP client simply returns the same token it received, it's not spoofing anything, whether it's a spider or a browser. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Musings CFAnywhere, Bandwidth, RIAs Part 1
> Why can't Hal's site have a richer UI -- think of it -- Hal's > voice, explaining the animated preso? There's already a great answer for this, though - Macromedia Breeze. It's a really good product for this sort of thing, and it makes building presentations very easy. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Version Management Inquiry
> >I am not sure of what kind of integration you are looking for. > > >Massimo > > Same way MS VSS integrates. For the most part, I do not need the > VSS interface to do my work. Map a Homesite project to a VSS DB > and you can check in/out directly in Homesite. > I never use it, sorry Massimo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Frame Effect With CF?
> Is there any way to embed a Frame within a table cell? From > my limited knowledge of frames, frames have a lot of > conflicts that make it very difficult to embed. > > Or is there a custom CF Tag (or _javascript_ function) that > will accomplish the same thing? > > I am sure this is old hat to most of you. The goal is to > eliminate so many accesses to the server. Download one > document with Bookmarks. Current thinking is to use something > like a table with two columns. Have the left col hold the > links to Bookmarks and the right col contain the content. How about an iFrame? Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Palm OS development
isnt code warrior the app that ports vb type apps to palm? tw -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 12:01 PM To: CF-Talk Subject: OT: Palm OS development Hey All, We've been asked to develop an application for PDAs (Pocket PC and Palm OS). We use Pocket Builder for Pocket PC...so development there is a snap...but we haven't tackled Palm before. So if anyone has any advice/resources about Palm OS application development (data mining essentially) that a CFer would understandfire away!! ;-) Thanks in advance 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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Frame Effect With CF?
CF is out of the picture. You want an iframe. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: advanced search
Thanks guys for helping me with this. I looked more in Verity. Verity only looks at static pages. Since my page is generated dynamically by the database at runtime, this option will not work. I'm still kinda new to CF and so didn't know about CFQUERYPARAM...but I do now :-) I am using Microsoft SQL Enterprise Manager. After the user enters there string, then I am going to parse it for " (Double quotes - of course there must be two), - (minus sign - for NOT), and + (addition sign - for AND). By default, the words will be separated by spaces and an OR operation will be applied to them. Then I am thinking about using some combination of LIKEs, Full Text Indexing, and/or cfqueryparam. Of course I want the application to run fast so I might nix the LIKE '%#word#%'. Thanx again for the help - Frank From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 3:59 PM To: CF-Talk Subject: advanced search Hello all, I'm looking into searching a website for a particular string or occurence of a string. I would like for this to be an advanced search (what I am looking for is something more complex than a simple LIKE). In the database - QBOS_HELPFILE (id, name,keywords) - I am storing a list of words separated only by spaces. And I am starting out with this query: SELECT * FROM QBOS_HELPFILE WHERE keywords LIKE '%#form.words#%' I've tried separating the words by commas and using the IN operator, but that only works if the field (keywords) contains one word Maybe a combination of the In operator and LIKE depending on the search text - if the search text has quotes or not. Of course the text should be first parsed. I'm not sure what the best way to go about this is. Are their some good examples out there? I've looked at Verity a little...but I'm not sure that is what I need. Are there any suggestions/help on this matter that ya'll can help me with? Thank you - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd. Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 & PowerPoint
> I successfully got a nice PPT application working on CFMX > using the PPT COM objects. However it was just not very > stable. I've been meaning to come back to the issue now with > Office 2003. O'Reily just relased an Office2k3 XML book, you > may want to look into it. PowerPoint 2003 got shafted in regards to XML. MS focused on other office applications and never got back to PowerPoint support for XML. Word, Excel, etc have it... PPT does not... Last I heard that is. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfun
Adam, Whereabouts do you live... I am right off of Tuckerman! Mike > I'll be there, along with my lovely fiance as always. This > will be my 3rd year going. I'm not cool enough to be > speaking, so I'll be drinking instead. It's my birthday that > Saturday so I hope I wont have to drink alone :( > > btw. also bringing 5 other coworkers along. > > Did I mention its only a few blocks from my home? If there is > enough interest I _could_ be persuaded to throw a kegger > saturday night. > > -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFC Response Delay Bug in ColdFusion 6.1???
I'm currently developing a Flashcom application that interacts with the Coldfusion server. Since we upgraded our CF MX 6.0 server to 6.1 version, i noticed that there's a delay with the CFC response from the Coldfusion to the FlashCom server. When my flashcom's client-side action script calls a CFC component, like to check the username and password in the database, it takes a quite long period before the ColdFusion sends back the needed data to the Flashcom server -- this response delay really affects the performance of my applications. I had no problem before with the CFMX6.0 regarding this CFC calls and I have encountered the same delay issue when i installed it locally and tested my programs. Anyone of you who has also encountered this same problem after upgrading to ColdFusion 6.1??? > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT Plagiarism accusation stops posting
I should start by saying I have never written a tutorial so I don't know what it feels like to have my IP stolen personally. I am far from an expert with CF, maybe proficient. I have bennefited from tutorials across the web to help me with my website, the purpose of which to simple provide Hiking information to people around Washington State. I don't do this to make money, just a philantropic undertaking ( I like the feeling of knowing people are getting value out of something I created). Seems to me the purpose of my website and tutorials are generally the same, to provide information to the masses to make the overall picture we all live in better. If I had the skill to create a valuable tutorial I think the bennefit to the community outweighs the possibility/likelyhood that it will be ripped off. Isn't the point of the whole undertaking to put these great ideas into the hands of those who can use them to in turn make something valuable to the greater community? Either way it is being accomplished. I can only imagine it is painful to have others claim your work as their own, but I think the overall good of putting information on the web to be used by others outweighs that pain. Just my 2cents. John From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Thu 6/17/2004 3:47 AM To: CF-Talk Subject: RE: OT Plagiarism accusation stops posting I think my real mistake was, despite the best intentions, it was my material. Big mistake which I have learnt from. My inentions were good but I stuffed up basically! _ From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Thursday, 17 June 2004 3:38 PM To: CF-Talk Subject: OT Plagiarism accusation stops posting This fuss is the main reason I haven't posted up the tutorials I've written for myself. As I've learned how to do many things I've kept them as tutorials on my own intranet but I wont post them on the web, because there's bound to be someone who says "That's mine!! I wrote that!. The issue is, while I didn't invent the techniques in the tutorials, I certainly wrote the tutorials, but the language and style is similar to others I've seen. And some of the text will be out of the emails here on CF-TALK, where I've learned how to do the thing in the tutorial. I understand about copyright and intellectual property - I spend a lot of my off-work time working with musicians and record labels in that field. But also the fear of being accused of plagiarism in my case is keeping me from sticking my head up and saying "I'll share what I know". The origins of some of the stuff I have is so mixed up now I'll never be able to say "that bit's from him, and that bits from him". Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx migration (laptop)
Dwayne Cole wrote: > I did this and now I'm having problems. Could it be that my old system > was running CFMX 6 and the new syste is running 6.1. > > Here's the messages I'm receiving. > > Macromedia][SequeLink JDBC Driver][SequeLink Server]Required user name > is missing I guess I missed the part where you stated the versions were different. That COULD be the problem but I couldn't tell you for sure. My recommendation would be to upgrade your old laptop to 6.1 (temporarily), then do the migration of the settings. No guarantees that'll actually solve your problem :) - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: Musings CFAnywhere, Bandwidth, RIAs Part 2
What if my preso of family memories could show a high-quality video/shideshow with sound -- and the user could click on something (say an individual in a group photo of the new years party) and get a hint who she is-- then click again and see their position in the family tree. Say... Hal, Matt or anyone... could use the same techniques to improve the UI of their apps. Hey, that's similar to how you can control a DVD movie in your computer or DVD player. Why can't I have a richer interface?... continued. We certainly have all the tools to be able to *create* this type of preso -- some free, some not. CFML, DBs Flash, HTML/DHTML, What we don't have is *all* the tools to *deliver* this type of preso. Consider this, you can put together a pretty rich preso with CFML Flash and some others ... but the richer the preso, the less accessible it becomes. We know this, it is in the back of our mind, as we develop every web app ... we are limited by bandwidth! The final reel! I don't know about you, but I am guilty of thinking inside the box. What if we remove (or mitigate) the bandwidth restriction? Some of those RRRIA (ReallyReallyRich) 200 meg Flash files would load in a few seconds, Or, we could stream large-size, high-quality audio and video (without expensive streaming software). It would be practical to extend or supplement A/V with control, interaction and background data -- hey with the right setup, we could even dim the lights while the movie plays & bring them back up when it's time for popcorn. Or, how about a preso with picture-in-picture -- See and Hear Hal as he does his thing. (certainly would be harder to plagiarize) Or, your monitor/status reporting app looks like the cockpit display of the latest jet fighter (or video game)! Or, your app gathers/references (rather than uploads) the users photos/movies/audio and helps him create/burn his own "family memories" CDs. Are you with me, so far? OK, how do we remove (or mitigate) the bandwidth restriction? We run on the desktop! That changes everything! Thoughts? Dick "In times like these, it helps to recall that there have always been times like these." - Paul Harvey - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF adm Image storage
Technologically, you do it as BLObs (Binary Large Objects). There are prior threads that discuss the pros/cons of whether these are best stored in the DB or in the file structure (with a reference in the DB). Search the archives for more info! Dick On Jun 17, 2004, at 8:35 AM, Sam komolafe wrote: > Hi, > > How do I store image files (attachments from customers) to a SQL > Server database using ColdFusion AND is this a better way to store > attachements? > > Thanks > Sam > --- > [This E-mail scanned for viruses.] > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFC Response Delay Bug in ColdFusion 6.1???
Since we upgraded our CF MX 6.0 server to 6.1 version, i noticed that there's a delay with the CFC response from the Coldfusion to the FlashCom server. When my flashcom's client-side action script calls a CFC component, like to check the username and password in the database, it takes a quite long period before the ColdFusion sends back the needed data to the Flashcom server -- this response delay really affects the performance of my applications. I had no problem before with the CFMX6.0 regarding this CFC calls and I have encountered the same delay issue when i installed it locally and tested my programs. Anyone of you who has also encountered this same problem after upgrading to ColdFusion 6.1??? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Palm OS development
Hey All, We've been asked to develop an application for PDAs (Pocket PC and Palm OS). We use Pocket Builder for Pocket PC...so development there is a snap...but we haven't tackled Palm before. So if anyone has any advice/resources about Palm OS application development (data mining essentially) that a CFer would understandfire away!! ;-) Thanks in advance 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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF adm Image storage
You can store them in the database, but most people (and most examples you'll see) save the attachment to a directory on the server, and a reference to the filename in the database. -joe -Original Message- From: Sam komolafe [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 11:35 AM To: CF-Talk Subject: CF adm Image storage Hi, How do I store image files (attachments from customers) to a SQL Server database using ColdFusion AND is this a better way to store attachements? Thanks Sam --- [This E-mail scanned for viruses.] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX 6.1 & PowerPoint
You might be able to do it by CFExecuting an OSA script: Here's some info on the Mac using AppleScript (Apple's OSA scripting language). http://www.apple.com/applescript/powerpoint/ It says you can create and edit slides! Since MS put the hooks into PowerPoint, I assume they have an OSA scripting facility that can exploit them. HTH Dick On Jun 17, 2004, at 8:22 AM, George Abraham wrote: > Welcome to my world, Mike! I am saddled with somewhat the same > problem. I > managed to do some stunts with CF5 and make it work. Right now CFMX > just > plain doesn't like the same code. I do have some time before I have to > change the code for CFMX. Anyway, have you seen anything with the > Jintegra > Java-COM bridge supplied with CFMX? That's one way of manipulating > PowerPoint on the server. > > Also, Sam Neff had a Breeze presentation about MS Office and CFMX on > his > website. Just search the list archive for it. > > George > > At 11:17 AM 6/17/2004, Tangorre, Michael wrote: > >Has anyone looked into, or successfully integrated CF with > PowerPoint. A > >requirement came in today whereby some upper management people want a > >PowerPoint presentation dynamically populated from data within the > >application. If the application were written in ASP.NET or something > MS, I'm > >sure it would be much easier, but it is written in CFMX 6.1 and I am > not > >even sure if it is possible. > > > >Anyone have any insight? > > > >Thanks, > > > >Mike > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF adm Image storage
You store them on the file system and store the locations to them in the database. I do not suggest to store the binary data in your DB. Sam komolafe wrote: > How do I store image files (attachments from customers) to a SQL Server > database using ColdFusion AND is this a better way to store attachements? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Frame Effect With CF?
Is there any way to embed a Frame within a table cell? From my limited knowledge of frames, frames have a lot of conflicts that make it very difficult to embed. Or is there a custom CF Tag (or _javascript_ function) that will accomplish the same thing? I am sure this is old hat to most of you. The goal is to eliminate so many accesses to the server. Download one document with Bookmarks. Current thinking is to use something like a table with two columns. Have the left col hold the links to Bookmarks and the right col contain the content. Thanks, Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Jrun Closed Connection : Help
OK, I know of a few technotes on this error but to be honest the results it returns are pretty much useless...anyone know why a perfectly healthy server would start to generate the Jrun Closed Connection Error while ColdFusion crashes and restarts? It all seems to work fine on a development server but the crash happens every 2 or 3 mins on the test one. I would be very surprised. not to mention angry if its code causing it as it works AOK on the dev. ColdFusion 6.1 FULLY patched Windows 2000 IIS 5.x Default Vanilla install JVM Any help here would be mucho appreciato..seriously losing my patience with CFMX on this front - 5 was never this flakeyI seriously hope Blackstone goes the distance as we are about to consider regression back to ColdFusion 5 This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx and CAPTCHA
Burns, John D wrote: > Well, I'm just trying to figure out why it wouldn't be easier to have a > unique string passed with each request that is also tied to the correct > "answer" for the image. There is nothing wrong with that if you store it in the session. That way, the spider could not post multiple > times with the same unique string. It just seems like that would even > rule out the brute force attempt. You can do that by setting another session var that only allows them to post within a certain time period on a certain form. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Version Management Inquiry
>I am not sure of what kind of integration you are looking for. >Massimo Same way MS VSS integrates. For the most part, I do not need the VSS interface to do my work. Map a Homesite project to a VSS DB and you can check in/out directly in Homesite. Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF adm Image storage
On Thursday 17 Jun 2004 16:35 pm, Sam komolafe wrote: > How do I store image files (attachments from customers) to a SQL Server > database using ColdFusion AND is this a better way to store attachements? CLOB or BLOB, normal. base64 encoded is another way (because it's just varchar2 then). Unless there is some pressing reason, though, it's usualy better to store the images on disk, renamed to some unique key that is stored in the DB against the relavent record. -- 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] [Donations and Support]
Re: CFMX 6.1 & PowerPoint
I successfully got a nice PPT application working on CFMX using the PPT COM objects. However it was just not very stable. I've been meaning to come back to the issue now with Office 2003. O'Reily just relased an Office2k3 XML book, you may want to look into it. -Adam - Original Message - From: George Abraham <[EMAIL PROTECTED]> Date: Thu, 17 Jun 2004 11:22:47 -0400 Subject: Re: CFMX 6.1 & PowerPoint To: CF-Talk <[EMAIL PROTECTED]> Welcome to my world, Mike! I am saddled with somewhat the same problem. I managed to do some stunts with CF5 and make it work. Right now CFMX just plain doesn't like the same code. I do have some time before I have to change the code for CFMX. Anyway, have you seen anything with the Jintegra Java-COM bridge supplied with CFMX? That's one way of manipulating PowerPoint on the server. Also, Sam Neff had a Breeze presentation about MS Office and CFMX on his website. Just search the list archive for it. George At 11:17 AM 6/17/2004, Tangorre, Michael wrote: >Has anyone looked into, or successfully integrated CF with PowerPoint. A >requirement came in today whereby some upper management people want a >PowerPoint presentation dynamically populated from data within the >application. If the application were written in ASP.NET or something MS, I'm >sure it would be much easier, but it is written in CFMX 6.1 and I am not >even sure if it is possible. > >Anyone have any insight? > >Thanks, > >Mike > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]