To Jeff Whatcott - Cost Structuring
I appologize ahead of time if it is inappropriate to continue to offer feedback to Jeff Whatcott in this forum. I wanted to make a point while Jeff has his ear to the ground, then I will do my best to stay off line G. I once worked for a prestigious engineering firm. In the late eighties, a whole new market developed, environmental engineering. The environmental department grew quickly and became the leading revenue generator for the entire company. However, special new expense costs were associated with the environmental engineering. They were foreign to the rest of the company and the manager's, in their wisdom, created a special surcharge for their CLIENTS. They explicitly stated on their invoices that the client was required to pay 1.5% of the labor as an environmental fee. Within the company, everyone was happy. It solved the problem among the INTERNAL profit centers. It was a solution created to solve an internal problem. However (and this is the point of this email), it totally backfired. Our best clients, our bread and butter clients absolutely refused to pay the fee. To the shock of the managers, the clients were ready to walk, and walk quickly. The amount was not the issue. The clients perceived that the costs were a cost of doing business for the engineering firm and that it was inappropriate for them to pay it as a surcharge. Nothing changed the client's preceptions. I agree with several of the CTO's comments in this forum, that Macromedia must create sufficient revenue to expand their products and their market. Without success, CF will die. But please stay sensitive to cost perceptions in the market and aware of internal issues vs true value offered to the client. IMO, there are two things that will stop CF dead in its tracks: 1) If we (developers who sell CF to clients who pay for CF development) cannot manage our client's perceptions of justified server costs, CF is dead. This is independent of ANY justification Macromedia has with regards to their internal revenue generating schemes. The client's perception is king, reality. As strange as it seems, clients will walk over a small server fee, regardless of how much they are paying for development. It's weird, but it's real. 2) The CF server is the engine. Everything else is hooked to the engine. Macromedia must satisfy the needs of hosts offering shared hosting, CF developers, and the bill-paying client when it comes to the server. ALL parties' needs must be satisfied. This is the challenge, because there are so many sensitive issues around the server. The rest of the product issues will take care of themselves over time. In summary, we need to go further than listening to developers. We need to be listening very carefully to the perceptions of the bill paying client. They will make the final choice and decision. Thanks. I'll stay offline now. Back to coding and real work... -- Eric Root ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
not displaying the action page
Hi everone i'm trying to force a submitted form page that is being browsed using the back button to display the following message. Warning: Page has Expired The page you requested was created using information you submitted in a form. This page is no longer available. As a security precaution, Internet Explorer does not automatically resubmit your information for you. To resubmit your information and view this Web page, click the Refresh button. Does anyone know how to do this? TIA Mark Mark Smyth Developer Systems Union eBusiness Solutions 01865 880800 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.systemsunion.com http://www.systemsunion.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Printing a structure in sorted order (repost)
i.e. sort by value (in perl foreach $name (sort {$r{$b} = $r{$a} } keys %r) does the same thing) Well, I've written it and posted it off to the allaire DevX :-) http://devex.allaire.com/developer/gallery/info.cfm?ID=C9C4AFF9-3A94-11D5-83 F400508B94F380method=Full ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can GIF can caught virus?
Yes. For instance, there was a problem with Netscape and GIF's a while back, and there is an overflow in the Flash player, though not yet exploitable. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 30 April 2001 18:15 To: CF-Talk Subject: can GIF can caught virus? This may sound stupid but can any format (GIF/JPG/BMP) other then EXE/COM can caught a virus? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Update in CFquery is failing, somone code check this ?
I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS and I cant sport the error. The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Making VisBasic into a com object
I asked one of my client's programmers for some info on how the database is organised for our web site, and what he's given me is a VBScript ASP page. I can see the function calls and subroutines in the file, which is 536 lines long. Can I take these functions and use them in CF somehow without having to re-write them all? How do I do this? Is this where I use CFScript? Do I call them as com objects? What do I have to do to make them Com Objects (there's nothing in the CF documentation anywhere about Com Objects. It's going to take a major meal of humble pie to admit I don't know what's going on inside his asp file and I'd rather not eat it if I can avoid it. Either that or long hours of wading through the code and figuring out what everything does. (sigh) Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Making VisBasic into a com object
At 09:08 PM 05/01/2001 +1000, you wrote: I asked one of my client's programmers for some info on how the database is organised for our web site, and what he's given me is a VBScript ASP page. I can see the function calls and subroutines in the file, which is 536 lines long. If I understand you... You asked for the table structure, and were given an ASP template? :Huh?: That doesn't make sense. Can I take these functions and use them in CF somehow without having to re-write them all? How do I do this? Is this where I use CFScript? Do I call them as com objects? What do I have to do to make them Com Objects (there's nothing in the CF documentation anywhere about Com Objects. If you are on a Windows unit (and IIS), you should be able to run the template as an ASP template and get whatever results are intended. To my knowledge, there is no way to run ASP in CFScript. For more information on com objects, you may want to check out cfcomet.com Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 Due out June 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Update in CFquery is failing, somone code check this ?
On 5/1/01, Thomas Chiverton penned: I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Off the top of my head it looks like note may be a number field. In which case you will get that error if you try to insert anything but a number. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
Off the top of my head it looks like note may be a number field. In which case you will get that error if you try to insert anything but a number. Nope, its an Acess ODBC datasource, and the field is marked as text, length 50. Next :-) Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
1000s of SQL updates
I'm trying to find the best possible way to update 1000s of SQL records at a time. I currently have a huge list that has all the colum values that need to have the change made (set the date to NOW()). Is there a better way then: SET colum=value WHERE CFLOOP listcolum=#listitem# OR /CFLOOP Thanks! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
If the field is marked as text, shouldn't there be ticks around the variables then? Like so: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = '#form.skill#' /cfquery Is uderid a text field or is skill a text field? Erika (with a *K*) Whatever you can do, or dream you can, begin it. Boldness has genius, power, and magic in it. - Goethe -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:08 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? Off the top of my head it looks like note may be a number field. In which case you will get that error if you try to insert anything but a number. Nope, its an Acess ODBC datasource, and the field is marked as text, length 50. Next :-) Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Verity creating duplicate records
You need to purge your collection before you update it. In the docs, it states that Verity will do just what you are describing. I have a little demo that I did for our local CFUG (MidOhioValley) where I have this little tidbit: CFINDEX ACTION=PURGE This action basically deletes all the data in the collection/index, but leaves all the necessary infrastructure in place ready to be re-populated with new data. It is important to perform this action after updating a database to ensure that you don't end up with duplicate, and possibly erroneous, data. Mind you, I did this for database indexing, not file indexing. Oh, the URL is http://lacer.cf-developer.net/VerityDemo/index.cfm HTH, Judith Gday For some reason when I try to update one of my collections with changes to a single record, verity is creating a new record with the SAME key (a spectra objectid) rather than updating the collection for that record. So Im getting multiple results referring to the same object in my search results. The call to cfindex is exactly the same, whether initially populating the index with all the records or updating this single record... the only difference is there is only 1 record in the query when updating a single record. The data in each record is going in fine, and this is working with my other collections. Judith Taylor ICQ: 67460562 Freelance ColdFusion Developer - Athens, OH Friends don't let friends code before coffee. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: More locking confusion...
** Macromedia Representative ** I think the author _implied_ that you should use duplicate() instead of 'cfset', but simply didn't say it. I haven't read the whole article, so I could be wrong. Anyway, you are correct. If you want to use the Request scope to store app and session stuff, use Duplicate(), and make sure you have the Duplicate() hotfix applied. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 6:49 PM To: CF-Talk Subject: More locking confusion... Ok I got the devcenter mailinglist today like a lot of us, and I was checking out the article titled ColdFusion Methodologies for Content Management at http://www.allaire.com/handlers/index.cfm?ID=20750. The author writes: An easy answer to this problem is to dump the entire SESSION or APPLICATION scope into the REQUEST scope. ColdFusion does not 'share' the REQUEST scope between threads and it does not need to be locked. So by dumping all the shared variables to this scope, we can lock our variables once and then forget about it. Well I thought that cfsetting a session or application variable to a request scoped variable only set a pointer to the original variable so these request variables need to be locked too. I thought this is what the duplicate() is supposed to do (when it's fixed :-)). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 1000s of SQL updates
Nopeanyway the code you have suggested won't work anyway as you will have an extra OR at the end of your SQL statement. Just one point to make. If your table that you are updating is being used for transactions (updates, selects, inserts) on a regular basis then you should rethink your database structure so that your table has less fields. You should really have a relational database structure and only have one table with lots of fields when building a data warehouse. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 14:13 To: CF-Talk Subject: 1000s of SQL updates I'm trying to find the best possible way to update 1000s of SQL records at a time. I currently have a huge list that has all the colum values that need to have the change made (set the date to NOW()). Is there a better way then: SET colum=value WHERE CFLOOP listcolum=#listitem# OR /CFLOOP Thanks! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
Get the value of the vars and run it directly in the db so you get a meaningfull error message -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Erika L Walker [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 13:26 To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? If the field is marked as text, shouldn't there be ticks around the variables then? Like so: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = '#form.skill#' /cfquery Is uderid a text field or is skill a text field? Erika (with a *K*) Whatever you can do, or dream you can, begin it. Boldness has genius, power, and magic in it. - Goethe -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:08 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? Off the top of my head it looks like note may be a number field. In which case you will get that error if you try to insert anything but a number. Nope, its an Acess ODBC datasource, and the field is marked as text, length 50. Next :-) Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
If the field is marked as text, shouldn't there be ticks around the Only 'note' is a text field, all the others are interger fields, and work fine (see bit in original post about the previous query). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
Get the value of the vars and run it directly in the db so you get a meaningfull error message How do you do that for Access ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFEXPRESS
the cfexpress page tells the goods about it but it doesn't compare cfexpress and it next bigger version. What's the diff? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
Create a query and use the SQL view -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 13:46 To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? Get the value of the vars and run it directly in the db so you get a meaningfull error message How do you do that for Access ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
access has its own query tool. you can even do it within CF studio. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 5:46 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? Get the value of the vars and run it directly in the db so you get a meaningfull error message How do you do that for Access ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
have you tried outputting those variables to make sure they're what you expect (ie - not null)? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 3:43 AM To: CF-Talk Subject: Update in CFquery is failing, somone code check this ? I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS and I cant sport the error. The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity Indexing a Remote Server
I am trying to create a verity collection that indexes a share on a remote server. (We have 2 front end clustered webservers, and a static data server - I am trying to index files on the static server, via a UNC path) I believe the systems are set up properly in regards to the user which the CF services are running as having proper permissions to the share. I can successfully create files on the remote server using CFFILE from the webservers using the same UNC path - so I would think that the verity indexer would be able to read those files. also of note is the fact that we currently use this file server to store our verity collections between servers - and that works fine. am I missing something? Here is the exact tag I use: cfindex action = refresh collection = somecollection key= \\Server\Path\To\My\Files type = path urlpath= ../images/mailings/ recurse= no Of course, when I change the key attribute to some local drive\directory (like D:\cf\is\ereet) it works just fine (and again, the collection datastructure itself is being stored on the static server) Also, when I try and use the CF Administrator to create the index, it gives me the same error. Am I forgetting something? Thanks in advance. Bryan Batchelder Web Application Developer ConnectWise, Inc. Phone: 813-935-7100 x 425 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Really large recordsets (40,015 records) won't return
I have a query that returns 40,015 records when run in Oracle SQL*Plus. When I try to run this query in a .cfm page, it just hangs - no timeout messages, no nothing, just sits there and hangs and occasionally locks up the browser. I tried setting the timeout (FORM ACTION =pc4DisplayResults.cfm?RequestTimeout=2000 METHOD=post NAME=ThisForm ID=ThisForm) which doesn't seem to help. Is there some setting I can change on CF Server? Something I can put in my code? Does anyone have any suggestions how to handle this? Gina Shillitani [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFEXPRESS
Next one up is Professional - you have a much wider range of functionality like CFX and custom tag generation, wddx, cfupdate etc. - you can link to a much wider range of odbc data-sources, you get verity search engine and loads of other stuff - the one up from that is Enterprise - which is the same, but with clustering capabilities... J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 13:49 To: CF-Talk Subject: CFEXPRESS the cfexpress page tells the goods about it but it doesn't compare cfexpress and it next bigger version. What's the diff? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: List Functions
Thank you ALL! I have it running now. You guys are great! Maybe one day I'll know enough to actually be able to contribute to the list as well. Thank you again, Loryn Williams Robert Segal wrote: Sorry,, typo, theloop should be thelist -Original Message- From: L Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 11:53 AM To: CF-Talk Subject: Re: List Functions Hi Robert, Thanks for the tip, but it didn't work. The server can't figure out what theLoop is I get : Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #listgetat(theloop,i)# Error near line 42, column 95. Error resolving parameter THELOOP ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: -You have misspelled the parameter name, or -You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (#listgetat(theloop,i)#), occupying document position (42:94) to (42:115) in the template file /opt/coldfusion/CustomTags/bestbets/rTreelw.cfm Any clues? Thanks in advance - I'm still stumped. Loryn Robert Segal wrote: Try something like this: cfloop from=1 to = #listlen(thelist)# index=i cfoutput a href=http://www.domain.com/search_children.cfm?parent=#listgetat(theloop,i) ##listgetat(theloop,i)#/a /cfouput /cfloop Assuming your list is in a variable called thelist (e.g. thelist = Corporate Life,Amenities,Cafeteria) -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 6:47 AM To: CF-Talk Subject: List Functions All, I think I have a fairly simple problem, but I can't for the life of me figure out how to get this done. I have a custom tag that traverses up a tree and produces a list (good) How do I make each list item (as it is output) contain a url reference and values to call another cf custom tag? For example my list produces Corporate Life - Amenities - Cafeteria I would like it to say a href=http://www.domain.com/search_children.cfm?parent=Corporate LifeCorporate Life /a etc.. I have not had any luck at all with this and any help would be GREATLY appreciated. Thank You in advance Loryn Williams ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: More locking confusion...
use Duplicate(), and make sure you have the Duplicate() hotfix applied. The hotfix download page says the problem exists in v4.51 SP2 but then goes on to say This fix is only available to CF Server Enterprise customers. Does this mean that the problem is only with the Enterprise version? Or are they only providing a fix for Enterprise customers leaving Pro customers vulnerable? Any info is appreciated. Ken ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFEXPRESS
Try this: http://www.allaire.com/documentcenter/partners/cf5_matrix.pdf HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 8:48 AM Subject: CFEXPRESS the cfexpress page tells the goods about it but it doesn't compare cfexpress and it next bigger version. What's the diff? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Really large recordsets (40,015 records) won't return
Depends what you want it to do. I'd suggest indexing your tables so you have optimum performance and then limit the number of records returned by the DB. I can't imagine you want to display all 40,000 recs do you? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 13:59 To: CF-Talk Subject: Really large recordsets (40,015 records) won't return I have a query that returns 40,015 records when run in Oracle SQL*Plus. When I try to run this query in a .cfm page, it just hangs - no timeout messages, no nothing, just sits there and hangs and occasionally locks up the browser. I tried setting the timeout (FORM ACTION =pc4DisplayResults.cfm?RequestTimeout=2000 METHOD=post NAME=ThisForm ID=ThisForm) which doesn't seem to help. Is there some setting I can change on CF Server? Something I can put in my code? Does anyone have any suggestions how to handle this? Gina Shillitani [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFEXPRESS
Sorry - my last answer was not correcttry this: http://www.allaire.com/handlers/index.cfm?ID=13570Method=FullTitle=Edition %20Comparison%20MatrixCache=False Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 8:48 AM Subject: CFEXPRESS the cfexpress page tells the goods about it but it doesn't compare cfexpress and it next bigger version. What's the diff? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Really large recordsets (40,015 records) won't return
That is too much to get the browser to render at a time, narrow the display results, if not the recordset. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 7:59 AM To: CF-Talk Subject: Really large recordsets (40,015 records) won't return I have a query that returns 40,015 records when run in Oracle SQL*Plus. When I try to run this query in a .cfm page, it just hangs - no timeout messages, no nothing, just sits there and hangs and occasionally locks up the browser. I tried setting the timeout (FORM ACTION =pc4DisplayResults.cfm?RequestTimeout=2000 METHOD=post NAME=ThisForm ID=ThisForm) which doesn't seem to help. Is there some setting I can change on CF Server? Something I can put in my code? Does anyone have any suggestions how to handle this? Gina Shillitani [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Really large recordsets (40,015 records) won't return
Part of the problem is that browsers just are not made to handle 40,000+ records, especially if the code is not really tight. CF can generate an awful lot of white space if you're not careful. Depending on how much info is in each record, the page you're trying to return is could very well be in excess of 10-20 megabytes in size. If your computer/browser has enough RAM and CPU horsepower to handle it, it must calculate it all out and render it. This takes time, if it will do it at all. You need to find some way to pare down what you're trying to return to the browser. Must you return it all to the browser? What would you even do with 40k records on your screen? How would you deal with that? Why not look for specific records? Explain more what you're trying to accomplish. Dave - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 8:59 AM Subject: Really large recordsets (40,015 records) won't return I have a query that returns 40,015 records when run in Oracle SQL*Plus. When I try to run this query in a .cfm page, it just hangs - no timeout messages, no nothing, just sits there and hangs and occasionally locks up the browser. I tried setting the timeout (FORM ACTION =pc4DisplayResults.cfm?RequestTimeout=2000 METHOD=post NAME=ThisForm ID=ThisForm) which doesn't seem to help. Is there some setting I can change on CF Server? Something I can put in my code? Does anyone have any suggestions how to handle this? Gina Shillitani [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Really large recordsets (40,015 records) won't return
What application do you need that is going to return that many records? You aren't planning on giving the user a single list of all records, are you? It may be better if you break up the list somehow. You can start by using 'top 1 * from mytable' to return the top row from your result set. Does the page still lock up, or does that work as expected? How about returning top 100? Or top 1000? If you are intent on not breaking up the list, you may look into the blockfactor attribute to the CFQUERY tag, which controls how the rows are processed by ColdFusion. For example, a blockfactor of 10, will process the rows 10 at a time before going back to [memory, database?] to get the next 10. At 08:59 AM 05/01/2001 -0400, you wrote: I have a query that returns 40,015 records when run in Oracle SQL*Plus. When I try to run this query in a .cfm page, it just hangs - no timeout messages, no nothing, just sits there and hangs and occasionally locks up the browser. I tried setting the timeout (FORM ACTION =pc4DisplayResults.cfm?RequestTimeout=2000 METHOD=post NAME=ThisForm ID=ThisForm) which doesn't seem to help. Is there some setting I can change on CF Server? Something I can put in my code? Does anyone have any suggestions how to handle this? Gina Shillitani [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: More locking confusion...
** Macromedia Representative ** Sorry, I don't know about the Pro version. You may want to try contacting Support? === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 9:16 AM To: CF-Talk Subject: Re: More locking confusion... use Duplicate(), and make sure you have the Duplicate() hotfix applied. The hotfix download page says the problem exists in v4.51 SP2 but then goes on to say This fix is only available to CF Server Enterprise customers. Does this mean that the problem is only with the Enterprise version? Or are they only providing a fix for Enterprise customers leaving Pro customers vulnerable? Any info is appreciated. Ken ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: More locking confusion...
The hotfix download page says the problem exists in v4.51 SP2 but then goes on to say This fix is only available to CF Server Enterprise customers. Does this mean that the problem is only with the Enterprise version? Or are they only providing a fix for Enterprise customers leaving Pro customers vulnerable? There's a separate patch for Pro. Unfortunately, I don't know where on the Allaire site it can be found. You might have to contact Allaire tech support. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: More locking confusion...
Was duplicate() not broken previous to sp2? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 10:15 AM To: CF-Talk Subject: RE: More locking confusion... The hotfix download page says the problem exists in v4.51 SP2 but then goes on to say This fix is only available to CF Server Enterprise customers. Does this mean that the problem is only with the Enterprise version? Or are they only providing a fix for Enterprise customers leaving Pro customers vulnerable? There's a separate patch for Pro. Unfortunately, I don't know where on the Allaire site it can be found. You might have to contact Allaire tech support. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Feedback to Jeff Whatcott - Macromedia
I think cfexpress was onthe cover DVD of PCPLUS last month. Previous to that I had not heard of it before. -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 00:27 To: CF-Talk Subject: Re: Feedback to Jeff Whatcott - Macromedia Yeah, I remember there being CF Express, and as soon as say Sir Forta's name with a reply to me, it jogged my memory. Like I was trying to say, it was crippled in really weird ways. I think I remember cfabort being a tag that didn't work. Anyways. Yes, having it available on a varying basis would be good. Also - CF Express is almost unknown of as far as I know. Maybe just some marketing would be in order. Hey, if ya need a commercial, let me know - that's what we REALLY do. ;) -Bill Creative director, broadcast designer, and CF developer... not always in that order... www.brainbox.tv BTW...I can sit here and make ?jokes?, because our dedicated server is experiencing the worst downtime ever... Nervous habit. Unfortunately I am not physically near the box, and remote admin won't start either! Argh.At least I know it's in good hands, and minds... Speaking of which - anyone know why CF Exec RDS would start but CF server wouldn't? Please email me direct if ya do! - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 6:42 PM Subject: Re: Feedback to Jeff Whatcott - Macromedia Makes sense. Once again, we're getting into the realm of features that would be desired only by hosting providers. How about the ability, on a site by site basis, to severely limit CF's functionality, essentially to the level of Express functionality. One problem with this, however, is that the first level really must have some kind of CFMAIL capability, which Express (last time I looked) does not. Jim - Original Message - From: David Schmidt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 4:06 PM Subject: RE: Feedback to Jeff Whatcott - Macromedia Hi, Ben Forta [EMAIL PROTECTED] wrote: That's what CF Express is, although it does have basic DB support too. Go to www.allaire.com/cfexpress. What _would_ be cool is for cfexpress to coexist with CFPro or CFEnterprise to offer some sort of a teaser to clients that don't want to pay for CF functionality...Thoughts? David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT but VIQ: Denial of Service Attacks - UPDATE
Well, to those who are interested, I've combed through the log files. Found my attacker and even the commands he executed to put up those pages. (PoisonBOx..blah..blah...blah) ---not that I've caught the creep. That won't happen! :) The client is still installing patches, and we're tightening every bolt on the machine. I've also been advised to delete the default website IIS automatically sets up as well as disable all Front Page extensions, should they be running. (Front Page! EWW!). You're not going to like what I have to say, I don't think. If your server has been compromised, you can't fix it by simply taking it offline and installing patches. Anything on the server could very well have been compromised. Ideally, you should wipe the disks, reinstall the OS and everything else, and restore your application files from a trusted backup. Otherwise, you can't be sure that other back doors haven't been set up on the box. During the reinstall process, you might want to take a look at the following resources, in addition to everything else that's been suggested: Securing Windows NT/2000 Servers for the Internet, Stefan Norberg, O'Reilly This is a very good explanation of securing IIS web servers, and contains good step-by-step instructions. Hardening Windows 2000 Guide, available as a PDF download: http://www.systemexperts.com/win2k/HardenWin2K.html Windows NT Security Guidelines, written by Trusted Systems for NSA, available as a download: http://www.trustedsystems.com/tss_nsa_guide.htm This doesn't have too much to do with web services specifically, but provides a clear description of basic use of ACLs, which is essential for securing your web server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS 5 and CF 4.5.1 sp2
I keep getting this error on my 2000 Professional and 2000 Advanced Server. Any help. The HTTP Filter DLL C:\CFUSION\BIN\ISCFFILT.DLL failed to load. The data is the error. You can either disregard this error (it's harmless), or remove the filter - it's not needed by CF, which uses a regular ISAPI extension. To remove the filter, you'll need to go into the registry: HKLM\System\CurrentControlSet\Services\W3SVC Somewhere within this key, I believe under Parameters\Script Map or something like that, there'll be a value with your ISCFFILT.DLL in it. Simply remove this value. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DevCon Europe? Asia? Anywhere Outside the U.S.?
Arent there in in europe ? -Original Message- From: GG Hamer [mailto:[EMAIL PROTECTED]] Sent: 30 April 2001 22:46 To: CF-Talk Subject: DevCon Europe? Asia? Anywhere Outside the U.S.? Can anyone identify for me major non-U.S. developer conferences? I know that in the U.S. there will be the Macromedia DevCon 2001 at Walt Disney World Florida October 21 - 24. Are there any similar non-U.S. events? For instance are there any major Java conferences outside of the U.S. that Macromedia/Allaire might have a presence at? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
have you tried outputting those variables to make sure they're what you expect (ie - not null)? Have you tried reading my post ? [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
woah...touchy.that'll teach you to offer help Dylan! Can you tell us exactly what datatypes all three fields are in the db. What happened when you ran the query directly in Access? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 15:50 To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? have you tried outputting those variables to make sure they're what you expect (ie - not null)? Have you tried reading my post ? [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, 'The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine.' Technically the critera you want to update doesn't exist any more there for no record therefore an Error. QED Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:43 AM To: CF-Talk Subject: Update in CFquery is failing, somone code check this ? I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS and I cant sport the error. The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
I'm sure this worked earlier
Hello Folks, Can any of you eagle eyed people spot why I am getting a ODBC Error Code = 37000 (Syntax error or access violation) error when I run this. I had it working earlier and managed ot output all the oldnews.headline into my database but, I added a few more fields to the sql and now it had buggered it all up. This is bugging me, any help will be very appreciated. Cheers Daz cfquery name=news datasource=newsadmin dbtype=ODBC select * from pressreleasetable !---where live = 1--- ORDER by pressreleasedate DESC /cfquery !---Setup an array with a structure --- cfset oldnews = ArrayNew(1) Cfoutput query=news cfset oldnews[news.currentrow] = StructNew() cfset oldnews[news.currentrow].headline = #pressreleaseheader# cfset oldnews[news.currentrow].subtitle = #prsub# cfset oldnews[news.currentrow].body = #pressreleasecontent# cfset oldnews[news.currentrow].date = #pressreleasedate# cfset oldnews[news.currentrow].expdate = #expdate# cfset oldnews[news.currentrow].country = #pressreleasecountryname# cfset oldnews[news.currentrow].live = #live# cfset oldnews[news.currentrow].author = #pressreleaseauthor# /cfoutput !---cf_objectdump object=#oldnews#--- !---loop throught the array and then insert into the database --- cfloop from=1 to=#ArrayLen(oldnews)# index=i cfquery name=newnews datasource=cosmos1 dbtype=ODBC insert into pressoffice (headline)!---,subtitle,body,date,expdate),country,live,author--- Values ('#oldnews[i].headline#') !---,'#oldnews[i].subtitle#','#oldnews[i].body#','#oldnews[i].date#','#oldn ews[i].expdate#'), '#oldnews[i].country#','#oldnews[i].live#','#oldnews[i].author#'--- /cfquery /cfloop Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fw: [cold_fusion] Why ColdFusion Is Still Relevant (IntenetWorld)
MessageFYI - from another list... Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Robert Baker To: [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 9:18 AM Subject: [cold_fusion] Why ColdFusion Is Still Relevant (IntenetWorld) Everyone, Received this email from InterntWorld (www.internetworld.com) Here is the online version: http://www.internetworld.com/news/archive/05012001a.jsp Enjoy! »»» Rob Baker ««« Webcentric Applications Developer Smith, Anderson, Blount, Dorsett, Mitchell, Jernigan, L.L.P. www.smithlaw.com 2500 First Union Capitol Center (PO Box 2611) Raleigh, North Carolina 27602-2611 v. 919-838-2010 f. 919-821-6800 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Update in CFquery is failing, somone code check this ?
Well, your post is not particularly clear. Have you tried running that exact query inside Microsoft Access? Assuming that note is a text field (character) and that userid is numeric and skill is numeric, this query should work just fine. However, if it doesn't work in Access directly it won't work in ColdFusion via CFQUERY. DC - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 10:49 Subject: RE: Update in CFquery is failing, somone code check this ? have you tried outputting those variables to make sure they're what you expect (ie - not null)? Have you tried reading my post ? [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
no need to get testy :) it's perplexing. i checked the reserved word list for access (i thought NOTE might be) but nothing is in the reserved word list that you're using. what about the code immediately before or after the CFQUERY? anything there that looks suspicious? if you could post more of the code (not just the query, but what's around it) from that file, maybe that will offer some clue. or if you want to send me the code off-list i'd be happy to look at it. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 7:50 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? have you tried outputting those variables to make sure they're what you expect (ie - not null)? Have you tried reading my post ? [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
I've also been caught on more than one occasion passing a userid as a number when it is, in fact, a string in the database. Just a thought. Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376 http://www.prairiesoftdev.com Amateurs practice until they get it right, Experts practice until they can't get it wrong. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 9:50 To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? have you tried outputting those variables to make sure they're what you expect (ie - not null)? Have you tried reading my post ? [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
Is note a reserved word in Access? Try [note] = 'dr'. Craig -Original Message- From: Jason Lees (National Express) [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:01 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, 'The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine.' Technically the critera you want to update doesn't exist any more there for no record therefore an Error. QED Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:43 AM To: CF-Talk Subject: Update in CFquery is failing, somone code check this ? I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS and I cant sport the error. The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
that may be, but i don't think that would throw a SYNTAX error. it just wouldn't update the field. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:01 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, 'The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine.' Technically the critera you want to update doesn't exist any more there for no record therefore an Error. QED Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:43 AM To: CF-Talk Subject: Update in CFquery is failing, somone code check this ? I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS and I cant sport the error. The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
heh no doubt. :) -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:00 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? woah...touchy.that'll teach you to offer help Dylan! Can you tell us exactly what datatypes all three fields are in the db. What happened when you ran the query directly in Access? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 15:50 To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? have you tried outputting those variables to make sure they're what you expect (ie - not null)? Have you tried reading my post ? [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Verity Indexing a Remote Server
Have you tried referring to the share as a drive like G:\Server\Path\To\My\Files where G is the drive letter assigned to the share. - Original Message - From: Bryan Batchelder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 8:11 AM Subject: Verity Indexing a Remote Server I am trying to create a verity collection that indexes a share on a remote server. (We have 2 front end clustered webservers, and a static data server - I am trying to index files on the static server, via a UNC path) I believe the systems are set up properly in regards to the user which the CF services are running as having proper permissions to the share. I can successfully create files on the remote server using CFFILE from the webservers using the same UNC path - so I would think that the verity indexer would be able to read those files. also of note is the fact that we currently use this file server to store our verity collections between servers - and that works fine. am I missing something? Here is the exact tag I use: cfindex action = refresh collection = somecollection key= \\Server\Path\To\My\Files type = path urlpath= ../images/mailings/ recurse= no Of course, when I change the key attribute to some local drive\directory (like D:\cf\is\ereet) it works just fine (and again, the collection datastructure itself is being stored on the static server) Also, when I try and use the CF Administrator to create the index, it gives me the same error. Am I forgetting something? Thanks in advance. Bryan Batchelder Web Application Developer ConnectWise, Inc. Phone: 813-935-7100 x 425 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
Create a query and use the SQL view The paperclip rather helpfuly says 'Syntax error in update statement' when I try and save update con_list set note = 'dr' where userid = 32715281 and skill =1; ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I'm sure this worked earlier
can you provide the datatypes of the fields? -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:04 AM To: CF-Talk Subject: I'm sure this worked earlier Hello Folks, Can any of you eagle eyed people spot why I am getting a ODBC Error Code = 37000 (Syntax error or access violation) error when I run this. I had it working earlier and managed ot output all the oldnews.headline into my database but, I added a few more fields to the sql and now it had buggered it all up. This is bugging me, any help will be very appreciated. Cheers Daz cfquery name=news datasource=newsadmin dbtype=ODBC select * from pressreleasetable !---where live = 1--- ORDER by pressreleasedate DESC /cfquery !---Setup an array with a structure --- cfset oldnews = ArrayNew(1) Cfoutput query=news cfset oldnews[news.currentrow] = StructNew() cfset oldnews[news.currentrow].headline = #pressreleaseheader# cfset oldnews[news.currentrow].subtitle = #prsub# cfset oldnews[news.currentrow].body = #pressreleasecontent# cfset oldnews[news.currentrow].date = #pressreleasedate# cfset oldnews[news.currentrow].expdate = #expdate# cfset oldnews[news.currentrow].country = #pressreleasecountryname# cfset oldnews[news.currentrow].live = #live# cfset oldnews[news.currentrow].author = #pressreleaseauthor# /cfoutput !---cf_objectdump object=#oldnews#--- !---loop throught the array and then insert into the database --- cfloop from=1 to=#ArrayLen(oldnews)# index=i cfquery name=newnews datasource=cosmos1 dbtype=ODBC insert into pressoffice (headline)!---,subtitle,body,date,expdate),country,live,author--- Values ('#oldnews[i].headline#') !---,'#oldnews[i].subtitle#','#oldnews[i].body#','#oldnews[i].date#','#oldn ews[i].expdate#'), '#oldnews[i].country#','#oldnews[i].live#','#oldnews[i].author#'--- /cfquery /cfloop Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
Can you tell us exactly what datatypes all three fields are in the db. note is 'Text', size 50. userid, skill and skill_level are 'Number', size 'long integer'. userid and skill form the primary key. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT (maybe?): IIS5 CF authentication prob
That is the one that works for me is to go to the advanced user rights and set permission to log on to the server locally. Are you using IIS challenge response or any additional authentication? Bryan - Original Message - From: Cold Fusion [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 12:39 PM Subject: OT (maybe?): IIS5 CF authentication prob I'm having one of 'those days'... I just can't work this one out. It's probably more of an IIS issue than CF though, me thinks, but I've been looking so much I just can't see it anymore... so it's list help time... I'm just in the process of setting up a new (replacement) server. It's running Win2K SP1 (i.e. IIS 5.0) and CF Pro 4.5.1 SP2. The CF service logs in as LocalSystem. As things stand, the server has no problems spitting out anonymous CFM or plain old HTML files to browsers (anonymous access). That's cool, but I actually also to set up authenticated (by W2K) logins on the server to certain CFM pages (actually sub-folders containing CF apps) too. However, if I remove anonymous access to the site definition in IIS manager, or if I remove privs for the IUSR_ account from the relevant site folder, whilst I can then authenticate OK from a browser to access HTML files, accessing CFM files always bounces the authentication, finally settling on a 403 (ACL on resource) error. Here's the kicker: if I add the relevant W2K user account being used to the local 'administrators' group on the server, it then lets me in and the CFM pages load just fine. I though this might be related to 'administrators' by default having 'full control' on the site folder, but providing those privs to the relevant user (or their group) directly, even all the way up/down/across/inside/all over the directory tree, has no apparent effect. I can't see what 'administrators' has permission to that others don't... I'm assuming user policy details ('log-on locally' etc) are OK because authenticating HTML works OK. CFUSION/BIN has 'read/execute' for everyone set... So: what on earth did I miss and/or screw up??! Anyone any suggestions where to look? I get the feeling it's probably something simple I've missed though... ;-) SB ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, Technically the critera you want to update doesn't exist any more there for no record therefore an Error. Shame that the error is 'syntax error', and not 'no records updated', which iirc wont be reported 'cuase its OK for an update to not update anything. Anyway, its still a bug, now fixed, so thanks for spotting it :-) Dont suppose you've secretly found out where the syntax error is ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC is EXTREMELY SLOW!
Hi all. I have a machine running one website that doesnÂ’t get that much traffic. It has 2 drives, with windows on the C: drive and the databases and coldfusion sites on the D: drive. The D: drive has about 1.5 GB free, but the C: only has about 300MB free, so I wonder if the low HD space is related. My problem is, I have access databases and Interbase databases, both of which have very small amount of records in them. They are used on this machine for development. But on ODBC these databases are extremely slow. It will take like 2000 ms to query a table that has NO records in it. I have one live site running, with minimal traffic, and it uses Access with OLEDB and runs large queries in 30 to 500 ms or lower. Plus at work, ODBC Access databases run on an equivalent machine just fine. ItÂ’s not just Access that is slow. Any ODBC database I create runs at a snails pace. Is there any reason why the ODBC stuff would crawl but OLEDB runs normally? Please reply to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Dreamweaver Site preferences/setting
I'm testing dreamweaver in a thin environment and my application settings are not being saved. I'm sure that this is because i'm on thin and it's on a test box. where does DW save the site settings? could i copy the file to my network dir and just stick it back into the DW dir when I want to use it? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I'm sure this worked earlier
Your insert is probably breaking a constraint in the table, or the Access datasource is open in design view (close Access, use 'fix' option in ODBC admin.). Probably :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Update in CFquery is failing, somone code check this ?
Well, your post is not particularly clear. Have you tried Sorry, sorry :-/ Been banging this all day, and I've tried the obvious things 8 times already :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql server 2000
Hi, I was wondering if someone could help me. I need to connect to SQL Server using OLE. I'm not sure exactly what needs to be done inside the administrator (if anything) and inside cfquery. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ Toronto ~ Newport Beach ~ Ottawa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: I'm sure this worked earlier
Check your last query. You have an extra ) where you list your values This '#oldnews[i].expdate#'), should be this '#oldnews[i].expdate#', cfquery name=newnews datasource=cosmos1 dbtype=ODBC insert into pressoffice (headline)!---,subtitle,body,date,expdate),country,live,author--- Values ('#oldnews[i].headline#') !---,'#oldnews[i].subtitle#','#oldnews[i].body#','#oldnews[i].date#', -- RIGHT HERE '#oldnews[i].expdate#'), -- '#oldnews[i].country#','#oldnews[i].live#','#oldnews[i].author#'--- /cfquery HTH, Art ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
it's perplexing. i checked the reserved word list for access (i thought NOTE might be) but nothing is in the reserved word list that you're using. :nods Thought of that too :-/ what about the code immediately before or after the CFQUERY? anything there that looks suspicious? Snipit here - you can see it picks up that were updating on line 1, and looks to see if we should update or insert, the problem query is marked '[here]'. The database has two lines for userid = #session.userid# (i.e. 32715281), neither with a note: userid skill skill_level note 327152811 2 327152812 2 ---snip top of file, just GUI stuff--- cfif IsDefined(form.level) cfquery name=update_ch datasource=ps_skills select * from con_list where userid = #session.userid# and skill=#form.skill# /cfquery cfif update_ch.recordcount eq 0 cfquery name=update datasource=ps_skills insert into con_list values (#session.userid#,#form.skill#,#form.level#,'#form.notes#') /cfquery cfelse cfquery name=update1 datasource=ps_skills update con_list set skill_level=#form.level# where userid = #session.userid# and skill=#form.skill# /cfquery cfquery name=update2 datasource=ps_skills!--- [here] --- update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery /cfif Updated OK. cflocation url=index.cfm /cfif ---never gets this far--- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity Indexing a Remote Server
Is that possible without someone being logged in to the server? I mean, UNC's should work. If they don't, then this particular site will be taken out of the cluster...its just not worth the work needed to make it compatible. I am curious though...is anyone out there doing a verity index on a remote server? I am assuming that what most people do is have CF running on the remote server, and have it verity indexing the content, and then mapping to that verity index on the front end boxes? --b Bryan Batchelder Web Application Developer ConnectWise, Inc. Phone: 813-935-7100 x 425 Email: [EMAIL PROTECTED] -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:14 AM To: CF-Talk Subject: Re: Verity Indexing a Remote Server Have you tried referring to the share as a drive like G:\Server\Path\To\My\Files where G is the drive letter assigned to the share. - Original Message - From: Bryan Batchelder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 8:11 AM Subject: Verity Indexing a Remote Server I am trying to create a verity collection that indexes a share on a remote server. (We have 2 front end clustered webservers, and a static data server - I am trying to index files on the static server, via a UNC path) I believe the systems are set up properly in regards to the user which the CF services are running as having proper permissions to the share. I can successfully create files on the remote server using CFFILE from the webservers using the same UNC path - so I would think that the verity indexer would be able to read those files. also of note is the fact that we currently use this file server to store our verity collections between servers - and that works fine. am I missing something? Here is the exact tag I use: cfindex action = refresh collection = somecollection key= \\Server\Path\To\My\Files type = path urlpath= ../images/mailings/ recurse= no Of course, when I change the key attribute to some local drive\directory (like D:\cf\is\ereet) it works just fine (and again, the collection datastructure itself is being stored on the static server) Also, when I try and use the CF Administrator to create the index, it gives me the same error. Am I forgetting something? Thanks in advance. Bryan Batchelder Web Application Developer ConnectWise, Inc. Phone: 813-935-7100 x 425 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ? FIXED
Is note a reserved word in Access? Try [note] = 'dr'. ** Genius ** You win... searches franticly around desk a poster of the current Dell server line. Mail me your address of list :-) Thanks to all the others, hope I didnt annoy you too much. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I'm sure this worked earlier
they are all text/memo apart from the date fields. The live fields are boolean field types. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:18 To: CF-Talk Subject: RE: I'm sure this worked earlier can you provide the datatypes of the fields? -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:04 AM To: CF-Talk Subject: I'm sure this worked earlier Hello Folks, Can any of you eagle eyed people spot why I am getting a ODBC Error Code = 37000 (Syntax error or access violation) error when I run this. I had it working earlier and managed ot output all the oldnews.headline into my database but, I added a few more fields to the sql and now it had buggered it all up. This is bugging me, any help will be very appreciated. Cheers Daz cfquery name=news datasource=newsadmin dbtype=ODBC select * from pressreleasetable !---where live = 1--- ORDER by pressreleasedate DESC /cfquery !---Setup an array with a structure --- cfset oldnews = ArrayNew(1) Cfoutput query=news cfset oldnews[news.currentrow] = StructNew() cfset oldnews[news.currentrow].headline = #pressreleaseheader# cfset oldnews[news.currentrow].subtitle = #prsub# cfset oldnews[news.currentrow].body = #pressreleasecontent# cfset oldnews[news.currentrow].date = #pressreleasedate# cfset oldnews[news.currentrow].expdate = #expdate# cfset oldnews[news.currentrow].country = #pressreleasecountryname# cfset oldnews[news.currentrow].live = #live# cfset oldnews[news.currentrow].author = #pressreleaseauthor# /cfoutput !---cf_objectdump object=#oldnews#--- !---loop throught the array and then insert into the database --- cfloop from=1 to=#ArrayLen(oldnews)# index=i cfquery name=newnews datasource=cosmos1 dbtype=ODBC insert into pressoffice (headline)!---,subtitle,body,date,expdate),country,live,author--- Values ('#oldnews[i].headline#') !---,'#oldnews[i].subtitle#','#oldnews[i].body#','#oldnews[i].date#','#oldn ews[i].expdate#'), '#oldnews[i].country#','#oldnews[i].live#','#oldnews[i].author#'--- /cfquery /cfloop Darren Adams Web Developer Marketing Department Systems Union Office: 01252 55 6220 Mobile: 07714 817 038 Email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MOD2 variation
In the past I have used this statement to vary the color of a table row to simulate the 'green bar effect'. tr bgcolor=#iif(qName.CurrentRow MOD 2, DE('ff'), DE('e8e8e8'))# Is there a way to modify this so that in the output of a query a br would be output every second row and a nbsp; otherwise? This ought to work: cfscriptwriteOutput(iif(qName.CurrentRow MOD 2, de(nbsp;), de(br)));/cfscript -Bruce ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Update in CFquery is failing, somone code check this ?
Maybe that's why he's now out of a job g Seriously, though - have you tried putting square brackets around the word note? Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 11:16 AM Subject: RE: Update in CFquery is failing, somone code check this ? Create a query and use the SQL view The paperclip rather helpfuly says 'Syntax error in update statement' when I try and save update con_list set note = 'dr' where userid = 32715281 and skill =1; ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: I'm sure this worked earlier
Darren, I have a few questions / comments. 1) Why do you convert the query, which is conceptually a structure of arrays into an array of structures? 2) Why don't you insert the records into the data base in one step? e.g. cfquery insert into pressoffice (headline,subtitle,body,date,expdate,country,live,author) select headline, subtitle, body,date,expdate,country,live,author from pressrelesetable where live =1 /cfquery 3) Try using SQL comments -- in your query instead of Cold Fusion comments. -- Josh Meekhof ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
i already checked. according to MS, it's not. here's a list of what are reserved: http://support.microsoft.com/support/kb/articles/Q109/3/12.asp -Original Message- From: Howarth, Craig (IBK-NY) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:10 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? Is note a reserved word in Access? Try [note] = 'dr'. Craig -Original Message- From: Jason Lees (National Express) [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:01 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, 'The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine.' Technically the critera you want to update doesn't exist any more there for no record therefore an Error. QED Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:43 AM To: CF-Talk Subject: Update in CFquery is failing, somone code check this ? I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS and I cant sport the error. The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I'm sure this worked earlier
It would also help if you can post the error message. -Bruce -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 10:18 AM To: CF-Talk Subject: RE: I'm sure this worked earlier can you provide the datatypes of the fields? -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:04 AM To: CF-Talk Subject: I'm sure this worked earlier Hello Folks, Can any of you eagle eyed people spot why I am getting a ODBC Error Code = 37000 (Syntax error or access violation) error when I run this. I had it working earlier and managed ot output all the oldnews.headline into my database but, I added a few more fields to the sql and now it had buggered it all up. This is bugging me, any help will be very appreciated. Cheers Daz ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I'm sure this worked earlier
Access hasnt been open for about 10 mins. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:25 To: CF-Talk Subject: RE: I'm sure this worked earlier Your insert is probably breaking a constraint in the table, or the Access datasource is open in design view (close Access, use 'fix' option in ODBC admin.). Probably :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
Cant see anything wrong with the syntax, have you tried removing the spaces before and after all the ='s in the query string,shouldn't make a difference but worth trying. is the DSN correct? Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 4:22 PM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, Technically the critera you want to update doesn't exist any more there for no record therefore an Error. Shame that the error is 'syntax error', and not 'no records updated', which iirc wont be reported 'cuase its OK for an update to not update anything. Anyway, its still a bug, now fixed, so thanks for spotting it :-) Dont suppose you've secretly found out where the syntax error is ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
you have skill and skill_level. my guess is *you* mixed them up. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:22 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, Technically the critera you want to update doesn't exist any more there for no record therefore an Error. Shame that the error is 'syntax error', and not 'no records updated', which iirc wont be reported 'cuase its OK for an update to not update anything. Anyway, its still a bug, now fixed, so thanks for spotting it :-) Dont suppose you've secretly found out where the syntax error is ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [cold_fusion] Why ColdFusion Is Still Relevant (IntenetWorld )
Received this email from InterntWorld (www.internetworld.com) Here is the online version: http://www.internetworld.com/news/archive/05012001a.jsp Enjoy! If Macromedia hadn't rescinded the ColdFusion Server Hosting license idea, I'd have had difficulty believing this: Jeremy Allaire, who has stayed on as chief technology officer of Macromedia, says that rather than trying to compete with those players over who has the strongest distributed object transaction system, he prefers to focus on the mass enterprise of developers who don't have those extreme high-end requirements. -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql server 2000
The administrator setup is similar to the setup for an ODBC datasource; the main difference is you must type in SQLOLEDB in the provider field...other than that, setting your server database names as well as username and password are the same. The datasource name used in cfquery is whatever you assign it in administrator, much the same way as an ODBC datasource. Matt -Original Message- From: Jay Brushett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 9:04 AM To: CF-Talk Subject: sql server 2000 Hi, I was wondering if someone could help me. I need to connect to SQL Server using OLE. I'm not sure exactly what needs to be done inside the administrator (if anything) and inside cfquery. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ Toronto ~ Newport Beach ~ Ottawa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I'm sure this worked earlier
Yes you are correct but it is commented out so surely this would not make a difference ? the code is commented out so that it just deals with the headline. -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:32 To: CF-Talk Subject: Re: I'm sure this worked earlier Check your last query. You have an extra ) where you list your values This '#oldnews[i].expdate#'), should be this '#oldnews[i].expdate#', cfquery name=newnews datasource=cosmos1 dbtype=ODBC insert into pressoffice (headline)!---,subtitle,body,date,expdate),country,live,author--- Values ('#oldnews[i].headline#') !---,'#oldnews[i].subtitle#','#oldnews[i].body#','#oldnews[i].date#', -- RIGHT HERE '#oldnews[i].expdate#'), -- '#oldnews[i].country#','#oldnews[i].live#','#oldnews[i].author#'--- /cfquery HTH, Art ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql server 2000
** Macromedia Representative ** Here are a couple of Knowledge Base articles to help you. http://www.allaire.com/Support/KnowledgeBase/SearchForm.cfm then select article ID's 14709, 14632. Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.macromedia.com -Original Message- From: Jay Brushett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 6:04 AM To: CF-Talk Subject: sql server 2000 Hi, I was wondering if someone could help me. I need to connect to SQL Server using OLE. I'm not sure exactly what needs to be done inside the administrator (if anything) and inside cfquery. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ Toronto ~ Newport Beach ~ Ottawa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ? FIXED
someone better tell MS to update their list of reserved words for access. ;) it wasn't in the list. maybe that's new to access2000 (if that's what you're using). -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:46 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? FIXED Is note a reserved word in Access? Try [note] = 'dr'. ** Genius ** You win... searches franticly around desk a poster of the current Dell server line. Mail me your address of list :-) Thanks to all the others, hope I didnt annoy you too much. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Update in CFquery is failing, somone code check this ?
I am not sure if it is the way the mail wrapped the text, but is there a carriage return after skill = ? If so, then the query may be trying to pass a carriage return with the #form.skill# (I just ran into this a couple of days ago) Tim P. - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 6:43 AM Subject: Update in CFquery is failing, somone code check this ? I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS and I cant sport the error. The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfdirectory delete
When I try to delete or rename a folder with cfdirectory it sometimes gives me an error message saying that the folder access is denied. Is there any work-around to this problem? thanks for any help. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
question using IIf
I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it for their changing table row background colors though so now i'm wondering if i've been told something in error. can anyone shed any light on this? thanks in advance. david tr bgcolor=#iif(qName.CurrentRow MOD 2, DE('ff'), DE('e8e8e8'))# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
i sent this email at 8:56am this morning and got it at 9:55am from the list. zoiks! -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:56 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? i already checked. according to MS, it's not. here's a list of what are reserved: http://support.microsoft.com/support/kb/articles/Q109/3/12.asp -Original Message- From: Howarth, Craig (IBK-NY) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:10 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? Is note a reserved word in Access? Try [note] = 'dr'. Craig -Original Message- From: Jason Lees (National Express) [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:01 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, 'The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine.' Technically the critera you want to update doesn't exist any more there for no record therefore an Error. QED Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:43 AM To: CF-Talk Subject: Update in CFquery is failing, somone code check this ? I have: cfquery name=update2 datasource=ps_skills update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# /cfquery And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = update con_list set note = 'dr' where userid = 32715281 and skill = 1 Data Source = PS_SKILLS and I cant sport the error. The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Studio - File types
*** Team Nobody *** In CF Studio's Extended Find dialog, if you set Find where to In folder, you can restrict the search to certain file types. For example, one group of file types is {*.htm;*.html;*.cfm;*.cfml}. I'd like to create my own group of file types. Anyone know how? (I know that I can use *.* to search all files.) Thanks. -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: I'm sure this worked earlier
On 5/1/01, Darren Adams penned: Hello Folks, Can any of you eagle eyed people spot why I am getting a ODBC Error Code = 37000 (Syntax error or access violation) error when I run this. I had it working earlier and managed ot output all the oldnews.headline into my database but, I added a few more fields to the sql and now it had buggered it all up. This is bugging me, any help will be very appreciated. I see you have all the other fields commented out. Are you sure they are all set to accept nulls and set as not required? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: question using IIf
* Team Allaire * IIF is way slower than the equivalent CFIF. This does the same thing and is faster. tr bgcolor=CFIF qName.CurrentRow MOD 2ffCFELSEe8e8e8/CFIF I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it for their changing table row background colors though so now i'm wondering if i've been told something in error. can anyone shed any light on this? thanks in advance. david tr bgcolor=#iif(qName.CurrentRow MOD 2, DE('ff'), DE('e8e8e8'))# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
my guess - now that we all know the answer - is i'm wrong :). darn list speed :). -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 9:04 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? you have skill and skill_level. my guess is *you* mixed them up. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 8:22 AM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, Technically the critera you want to update doesn't exist any more there for no record therefore an Error. Shame that the error is 'syntax error', and not 'no records updated', which iirc wont be reported 'cuase its OK for an update to not update anything. Anyway, its still a bug, now fixed, so thanks for spotting it :-) Dont suppose you've secretly found out where the syntax error is ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Dreamweaver Site preferences/setting
Site settings are stored in the Registry. Look in HKEY_CURRENT_USER\\Software\\Macromedia\\Dreamweaver 4\\Sites\\ tom www.basic-ultradev.com [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm testing dreamweaver in a thin environment and my application settings are not being saved. I'm sure that this is because i'm on thin and it's on a test box. where does DW save the site settings? could i copy the file to my network dir and just stick it back into the DW dir when I want to use it? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Microsoft Word Summary Data
Does anyone have a tag that will pull in the summary data available from a MS Word file ? If not a tag, then if any has done this some other way. Thanks. Bill Lundin WeBS Group Factory Mutual Insurance Company 401-275-3000 x1380 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql server 2000
Thanks to all who responded. I found the answer in the knowledge base articles. Jay At 12:31 PM 5/1/2001 -0400, you wrote: ** Macromedia Representative ** Here are a couple of Knowledge Base articles to help you. http://www.allaire.com/Support/KnowledgeBase/SearchForm.cfm then select article ID's 14709, 14632. Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.macromedia.com -Original Message- From: Jay Brushett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 6:04 AM To: CF-Talk Subject: sql server 2000 Hi, I was wondering if someone could help me. I need to connect to SQL Server using OLE. I'm not sure exactly what needs to be done inside the administrator (if anything) and inside cfquery. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ Toronto ~ Newport Beach ~ Ottawa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: question using IIf
I think #IIF()# just takes longer to evaluate than Cfif or the even faster cfswitch... At leasts that what I have gathered from others experience and from classes. HTH Dan -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 12:55 PM To: CF-Talk Subject: question using IIf I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it for their changing table row background colors though so now i'm wondering if i've been told something in error. can anyone shed any light on this? thanks in advance. david tr bgcolor=#iif(qName.CurrentRow MOD 2, DE('ff'), DE('e8e8e8'))# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
JOIN queries from two datasources
Sorry if this has been asked before Can I join two queries from two different datasources (SQL 2000)? I need to relate the username/userID from source 1 to userID from source 2. (If it's too difficult, I'll just copy the username into source 2). TIA! D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: question using IIf
I recently picked up a copy of Ben Forta's Certified CF Study Guide. One of the last chapters is about speed and optimization, and it states that IIF(), DE() and Evaluate() are all very slow functions, and while they have their time and place, can and perhaps should often be avoided (Ben, please forgive me if I'm misquoting you, I don't have the book in front of me!). Evan -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 12:55 PM To: CF-Talk Subject: question using IIf I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it for their changing table row background colors though so now i'm wondering if i've been told something in error. can anyone shed any light on this? thanks in advance. david tr bgcolor=#iif(qName.CurrentRow MOD 2, DE('ff'), DE('e8e8e8'))# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio - File types
You can type the file type directly into the file types drop-down. Select an existing file type, highlight it, then type in the file type you want. You can then perform a search on that file type, and the next time you do an Extended Find, that file type will display in your drop-down list. -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 1:01 PM To: CF-Talk Subject: Studio - File types *** Team Nobody *** In CF Studio's Extended Find dialog, if you set Find where to In folder, you can restrict the search to certain file types. For example, one group of file types is {*.htm;*.html;*.cfm;*.cfml}. I'd like to create my own group of file types. Anyone know how? (I know that I can use *.* to search all files.) Thanks. -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: question using IIf
Latest CFDJ states that iif takes 4 times as long to execute as cfifcfelse/cfif. The provide a snippet of code to test. - Original Message - From: David Baskin [EMAIL PROTECTED] I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it for their changing table row background colors though so now i'm wondering if i've been told something in error. can anyone shed any light on this? thanks in advance. david tr bgcolor=#iif(qName.CurrentRow MOD 2, DE('ff'), DE('e8e8e8'))# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Talk-list V1 #306
Any idea how you can turn a certain area of a webpage into a viewing pdf area? I want a certain area on my webpage to open up to a pdf file, not an entirely brand new window (or take up the current one) (and not necessarily use frames either...which I guess could be a cfinclude) Mark Smeets/stranger0/ICQ #1062196 Mr. West, not every situation requires your patented approach of shoot first, shoot later, shoot some more and then when everybody's dead try to ask a question or two - Wild Wild West A Stranger's Domain (Redesigned and New) http://24.113.34.178/stranger Official Splitting Adam Homepage http://www.splittingadam.com/ Over the Wall Productions and Web Designs http://www.solarcourt.com/ _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: More locking confusion...
If someone does find the link for the patch could you please post it here. Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 7:15 AM To: CF-Talk Subject: RE: More locking confusion... The hotfix download page says the problem exists in v4.51 SP2 but then goes on to say This fix is only available to CF Server Enterprise customers. Does this mean that the problem is only with the Enterprise version? Or are they only providing a fix for Enterprise customers leaving Pro customers vulnerable? There's a separate patch for Pro. Unfortunately, I don't know where on the Allaire site it can be found. You might have to contact Allaire tech support. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio - File types
You can do it with a simple registry hack. 1) In regedit, open the key HKCU/Software/Allaire/Studio45/SavedSettings/ExtendedFindFolder. 2) Add a new string value Item10. Set the value to your new extension. if more than one, use commas to separate (ie: *.abc,*.def). I tried it on mine (CFS 4.5.2/WinNT 4) and it worked just fine: it found a .abc page containing the string body in my root document folder. Of course this folder contains many html files. You may need to restart studio before find will work, although the list of extensions may show up immediately. -Bruce -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 12:01 PM To: CF-Talk Subject: Studio - File types *** Team Nobody *** In CF Studio's Extended Find dialog, if you set Find where to In folder, you can restrict the search to certain file types. For example, one group of file types is {*.htm;*.html;*.cfm;*.cfml}. I'd like to create my own group of file types. Anyone know how? (I know that I can use *.* to search all files.) Thanks. -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio - File types
If I understand correctly you want a new option in that drop down of file types. All you have to do is type in that drop down the type you want to search and it will remember that type from then on and it will be in the drop down list. Does that help? J. John Wilker Web Applications Consultant Allaire Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Lessons learned from movies: 5. It does not matter if you are heavily outnumbered in a fight involving martial arts, your enemies will wait patiently to attack you one by one by dancing around in a threatening manner until you have knocked out their predecessors. -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 10:01 AM To: CF-Talk Subject: Studio - File types *** Team Nobody *** In CF Studio's Extended Find dialog, if you set Find where to In folder, you can restrict the search to certain file types. For example, one group of file types is {*.htm;*.html;*.cfm;*.cfml}. I'd like to create my own group of file types. Anyone know how? (I know that I can use *.* to search all files.) Thanks. -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: question using IIf
I can attest to that statement. We had a custom tag that used those three functions HEAVILY - iif, de, and evaluate. It was very very very very slow. Unfortunately for us, it is the core of our application - so it was rewritten as a CFX, then a COM component, and not it is a hybrid COM/XML thing. So, um, yeah, that stuff is slow - beware. --b Bryan Batchelder Web Application Developer ConnectWise, Inc. Phone: 813-935-7100 x 425 Email: [EMAIL PROTECTED] -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 1:56 PM To: CF-Talk Subject: RE: question using IIf I recently picked up a copy of Ben Forta's Certified CF Study Guide. One of the last chapters is about speed and optimization, and it states that IIF(), DE() and Evaluate() are all very slow functions, and while they have their time and place, can and perhaps should often be avoided (Ben, please forgive me if I'm misquoting you, I don't have the book in front of me!). Evan -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 12:55 PM To: CF-Talk Subject: question using IIf I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it for their changing table row background colors though so now i'm wondering if i've been told something in error. can anyone shed any light on this? thanks in advance. david tr bgcolor=#iif(qName.CurrentRow MOD 2, DE('ff'), DE('e8e8e8'))# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists