RE: Amazon Tags
What code do you use to then display these HTML snippets? I'd assume you loop through the files in your /books/ directory and CFINCLUDE them? Curious... -- looks like that can be turned into a convenient custom tag. -Dave -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 9:55 PM To: [EMAIL PROTECTED] Subject: Re: Amazon Tags glad to help. Note: cfset filepath="C:\www\test\www\capitalidea\content\books" the path to save the html snippet created by the custom tag. affid. the amazon associate id from ... amazon Book = AIBN code of the book. Example: http://www.capitalidea.com/amazon.cfm == myFavouriteBooks.cfm === cf__get_amazon affid="capitalidea0d" Book="0439139597" === You get the ISBN number from the amazon site directly Example: Hardcover - 752 pages (July 8, 2000) Scholastic/Arthur A. Levine; ISBN: 0439139597 == _get_amazon.cfm cfhttp method="get" url="http://www.amazon.com/exec/obidos/ASIN/#attributes.book#/icigroup/capit alidea0d" resolveurl="yes" cfset filepath="C:\www\test\www\capitalidea\content\books" cfset content = cfhttp.filecontent !-- News Item -- cfset startpos = FindNoCase("/exec/obidos/handle-buy-box=", Content)-50 cfset startpos = FindNoCase("form", Content, startpos) cfset endpos = FindNoCase("/form", Content,startpos)+7 cfset Content = Trim(Mid(Content, startpos, endpos - startpos)) CFSET Content = replacenocase(Content,"/g/detail/addtocart","http://www.amazon.com/g/detail/ addtocart","ALL") CFSET Content = replacenocase(Content,"/g/gift-services/buttons/addtoWL","http://www.amazon. com/g/gift-services/buttons/addtoWL","ALL") CFSET Content = replacenocase(Content,"/g/detail/buybox/add-to-shopping-cart-blue.gif","http ://www.amazon.com/g/detail/buybox/add-to-shopping-cart-blue.gif","ALL") CFSET Content = replacenocase(Content,"/g/gift-services/buttons/wl_white.gif","http://www.am azon.com/g/gift-services/buttons/wl_white.gif","ALL") CFFILE ACTION="Write" FILE="#filepath#\#attributes.book#.html" OUTPUT="#content#" === From: "Joseph J. Sanger, M.D." [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Amazon Tags Date: Tue, 11 Jul 2000 18:30:22 -0400 Eric, I am VERY intrigued by this code ... could you give me a pointer or two on how to use it? For example, where can I get these two parameters in order to grab info on a book? It's not obvious to me from crusing Amazon's site. Thanks very much in advance. cfparam name="attributes.book" default="???" cfparam name="attributes.affid" default="" cfhttp method="get" url="http://www.amazon.com/exec/obidos/ASIN/#attributes.book#/icigrou p/#attributes.affid#" resolveurl="yes" cfset filepath="C:\www\content\books" cfset content = cfhttp.filecontent cfset startpos = FindNoCase("/exec/obidos/handle-buy-box=", Content)-50 cfset startpos = FindNoCase("form", Content, startpos) cfset endpos = FindNoCase("/form", Content,startpos)+7 cfset Content = Trim(Mid(Content, startpos, endpos - startpos)) CFSET Content = replacenocase(Content,"/g/detail/addtocart","http://www.amazon.com/g/ detail/addtocart","ALL") CFSET Content = replacenocase(Content,"/g/gift-services/buttons/addtoWL","http://www. amazon.com/g/gift-services/buttons/addtoWL","ALL") CFFILE ACTION="Write" FILE="#filepath#\#attributes.book#.html" OUTPUT="#content#" From: Stuart Duncan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Amazon Tags Date: Wed, 21 Jun 2000 10:27:13 -0700 Hey all, I've come across a few interesting tags for searching through Amazon's books and such but what I really need is something which allows me to actually select individual books and display those on the site. I was thinking, something where I could just enter the product id form Amazon, and the tag would go and fetch all the information from them on that book. Has anyone come up with an easy way to do this, or do you know of any custom tags that does this? Any help on this would be greatly appreciated. Stuart Duncan. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF4.5.1 and Security Sandbox
Did we lose the security sandbox in CF4.5.1? I am using 4.5.1 PRO. I suppose I just make a security context for RDS and granularly apply access rules? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Good Cold fusion osting in UK?
Remi, I would suggest that you visit http://www.cfug.co.uk and go to the links section. Whilst you're there - sign up for the mailing list - as this question pops up quite often on there. -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Capolinea [mailto:[EMAIL PROTECTED]] Sent: 12 July 2000 06:28 To: Cold FusionList Subject: Good Cold fusion osting in UK? This is a multi-part message in MIME format. --=_NextPart_000_000F_01BFEBD2.C1DE63E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I'am looking for a good hosting service in UK with Cold Fusion 401: SQL=20 Server, CFX Tag... Does anybody know a good hosting service just like Intermedia (american=20 hosting service) in the UK or Ireland? Regards, Remi van der Deure --=_NextPart_000_000F_01BFEBD2.C1DE63E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVHi,BRBRI'am looking for a good hosting service in UK with Cold = Fusion=20 401: SQL BRServer, CFX Tag...BRDoes anybody know a good hosting = service just=20 like Intermedia (american BRhosting service) in the UK=20 orBRIreland?BRBRRegards,BRRemi van der = DeureBR/DIV/BODY/HTML --=_NextPart_000_000F_01BFEBD2.C1DE63E0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Odd Question
I have an application.cfm and a form on a page. Now, if they fill in the form, they then have a CustomerID variable defined... in my application.cfm I have the following line: CFSET APPLICATION.ADDTOKEN = "cfid=#client.cfid#cftoken=#client.cftoken#" Now, how could I put the customerID to the end of the addtoken if and only if it exists? So it isn't there until they fill out the form... then on every page it is there...? How would I do this? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Cold Fusion Studio Vs Dreamweaver Ultradev
Many many CFSCRIPTS in the the CFML code... I think that the purpose of this is to be able to switch from asp or Jsp to CFML for example but the code looks really strange to me. At 19:06 11/07/00 -0400, vous avez écrit: Hello All: I'm Currently evaluating ultradev for asp and cold fusion applications, anybody have any comments on ultradev I would appreciate any suggestions, comments, gripes ect.. thanks in adv. Dana E. Johnson Sr. Web Developer CIT VTF/Technology Financing Services [EMAIL PROTECTED] (904) 620-7458 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Odd Question
Chris, how about: CFSET APPLICATION.ADDTOKEN = "cfid=#client.cfid#cftoken=#client.cftoken#" CFIF IsDefined("customerID") CFSET APPLICATION.ADDTOKEN = APPLICATION.ADDTOKEN "customerID=" customerID /CFIF Modify to include whatever scope customerID would be in (client, form, cookie, URL, etc.). HTH, -Max At 7/12/2000 05:03 AM -0400, Chris Farrugia wrote: I have an application.cfm and a form on a page. Now, if they fill in the form, they then have a CustomerID variable defined... in my application.cfm I have the following line: CFSET APPLICATION.ADDTOKEN = "cfid=#client.cfid#cftoken=#client.cftoken#" Now, how could I put the customerID to the end of the addtoken if and only if it exists? So it isn't there until they fill out the form... then on every page it is there...? How would I do this? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Odd Question
On 7/12/00, Chris Farrugia penned: I have an application.cfm and a form on a page. Now, if they fill in the form, they then have a CustomerID variable defined... in my application.cfm I have the following line: CFSET APPLICATION.ADDTOKEN = "cfid=#client.cfid#cftoken=#client.cftoken#" Now, how could I put the customerID to the end of the addtoken if and only if it exists? So it isn't there until they fill out the form... then on every page it is there...? How would I do this? If you are passing the cfid and cftoken as a query string, which it appears you are looking at the syntax, just wrap the cfset tag in a cfif not isdefined('url.cfid') tag. Or,you could put an action field in the form. input type=hidden name=action value=writetoken Then wrap it in a cfif action is "writetoken" tag. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: roots
Thanks, Dave 1. Just wondering if there is some variable defined which stores local root of the running application: C:\Inetpub\wwwroot\ for example. None of which I'm aware, although it's pretty easy to figure out where this is, and you can just set this in your Application.cfm file. This is exactly what I've done: set this in Application.cfm, but the problem is that my development server is W2K and production is Linux. That's why I want this root to be automatically detected. 2. Another thing I can't understand is why the / sign does not address the web root folder of the application. Why if I call the module with template="/some.cfm" the / sign still addresses current directory? Where's the logic? When you begin a template path with "/" in CF, CF looks for the mapping in the list that you can set in CF Administrator under the Mappings link. You can only map the root slash once, so even if you have multiple virtual servers, you can only have one resolution for "/". This of course only applies to CFML tags which use a TEMPLATE attribute. Actually, I've never used these mappings, I'll try, thanks. I'm a little confused by your example, though; it seems to suggest that something else is going on. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
mySQL, win98 Coldfusion Admin
Due to a strange quirk in the office setup, a colleague and I are testing stuff over a multi-OS setup. He is on Linux, I am on win98, using PWS (eech.) and CF PRO single user. It'll all get migrated to the serious kit later on in the dev cycle, but for now, I just want to be able to connect to his MySQL DBs and muck around. Following the instructions from mySQL.com, I have installed MyODBC and setting up a user DSN under windows ODBC control panel is a breeze, but CF Admin will not display the MySQL driver in its ODBC panel, or in any other DB driver pages. Has anyone used CF under windows to connect to a MySQL DB under Linux? If so, what can I do? -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: mySQL, win98 Coldfusion Admin
doh. eejit. don't worry - done it. :) the DSN had to be created in win ODBC control panel first - then the username and password setup in CF administrator. All verified after that. -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 12 July 2000 11:50 To: [EMAIL PROTECTED] Subject: mySQL, win98 Coldfusion Admin Due to a strange quirk in the office setup, a colleague and I are testing stuff over a multi-OS setup. He is on Linux, I am on win98, using PWS (eech.) and CF PRO single user. It'll all get migrated to the serious kit later on in the dev cycle, but for now, I just want to be able to connect to his MySQL DBs and muck around. Following the instructions from mySQL.com, I have installed MyODBC and setting up a user DSN under windows ODBC control panel is a breeze, but CF Admin will not display the MySQL driver in its ODBC panel, or in any other DB driver pages. Has anyone used CF under windows to connect to a MySQL DB under Linux? If so, what can I do? -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What are you using instead of IDENTITY?
Yes, this is true... ...But, here again use of Identity solves a problem: What if you used FN LN and Street address as primary key? Then, You have two different AlGores living at the same address! You would somehow have uniquify these two different records' primary keys.. Enter Identity, problem solved... Now, what do I do with that extra AlGore? The other main problem about using "variable" fields as primary keys is that they COULD conceivably change, which means that whenever you wish to do an update, you have to pass the current values to the next form, and do the update from there - then the next presentation must have the NEW values for these fields for the next post Personally, I wouldn't want to see a world with 2 Al Gore's, so duplicate keys in that case would cause all sorts of nightmares (in all senses g) I'm a great believer in IDENTITY fields as it makes Normalised relationships really easy to track - can you imagine handling a normalised relationship table without an identity? That'd be real fun (and space wasting) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What are you using instead of IDENTITY...Part II
Is it just me, or does Joe seem to avoid the actual questions that Tom has asked?? Or have the questions been truncated in some way? Why is the city example a bad one? It's something that every address that is stored has, and can potentially contain many duplications. What is the relevance of the SAN? The majority of addresses won't have anything to do with the book trade?! Where Joe does mention putting city, state and zip into seperate tables, he doesn't explain what he uses to reference between tables? If he doesn't use an Identity column, does he just use the city, state or zip as the key? Doesn't this cause over-bloated indexes therefore affecting performance and possibly fragmented indexes? I'm not familiar with Joe Celko, or his work, but from the messages that have been posted I still haven't seen any definitive reason to not use Identity columns, and in my experience, as Tom mentioned in his email to Joe, most developers I have also ever come across have used Identity columns. I have about 8 years experience of database design, and building systems, and I have never come across anyone who has had serious problems with Identity columns. Maybe that is purely luck. There have been lots of great reasons posted for using Identity Columns, but not many for not using them and I guess at the end of the day, do what works for you, but be aware of the potential pitfalls, and develop accordingly. In my personal opinion, and from my experience to date, I will continue to use Identity columns, and I will continue to recommend them. From: Tom Nunamaker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 12 Jul 2000 13:47:36 +0200 To: [EMAIL PROTECTED] Subject: What are you using instead of IDENTITY...Part II Continuing the dialog with Joe Celko, here's more fuel to the fire. New questions raised by Joe's latest email: * Has anyone looked at ORM? * I personally love ERwin. What better alternative is there? * The next step is to ask Joe Celko if he ever recommends a surrogate key. Tom Nunamaker [EMAIL PROTECTED] = If I have a table with repeating information, suppose a city field in an employee table for example, to normalize it you would break the city into a separate table. If I used the city name as the primary key for this "city" table, then it wouldn't accomplish anything to put it in it's own table. That is a bad example. Each city in a Personnel table (remember use a plural or collective noun for table names) is probably going to be part of a different address -- mailing address, his/her doctor's address or whatever. Try a Personnel table with columns called kid1, kid2, and kid3 for his dependents. Clearly having a Dependents table is much better design -- it beats the heck out of requiring everyone to have three kids or to kill one if they have over-breed. I could create an INTEGER field in this city table and reference the integer in the employee table. That would certainly take up less space overall. Are you saying it's better to NOT to do something like this? Instead, just put the repeating city name in the employee table and forget the city table? I would use the SAN (Standard Address Number) if I were in the book trade. It is a number for all the bookstores and publishers in the US. This is because the set of addresses can be treated like an entity in that model. I am saying look at your model. If Addresses are a serious part of the business model and appear in multiple places, then I would also have a table for (zipcode, city, state) and assemble the addresses from this and the street address line. ZIP codes get changed more than people think. If the addresses are not reused much, then put them with the table to which they belong. What you save in space with a separate address code, you will lose in doing JOINs. I've 'faked it' using IDENTITY fields but I'm willing to use a better approach if I can. How do you handle situations like this? I see "identifier" fields in the book "Data Modeling with ERwin". I know LOTS of developers using it. I know a lot of developers who do it, too. I bill their employers $1500 to $2000 per day to fix that kind of code. Oh, ERwin is a bad tool. It has planar graph problems, cannot show constraints, returns only one schema, etc. You might want to look at ORM modeling methods. --CELKO-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit
Re: cfif problem
Janey, This is a response to the CF-Talk question you posted There is a couple of things I notice about your code. First, is that I do not see any /CFIF statements in that code. That may be part of the problem. Second, it seems like you are doing a lot of extra coding in that statement. Maybe try to rewrite it something like this: CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer1)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer1#', #ans_pol_id#) /CFIF /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer2)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer2#', #ans_pol_id#) /CFIF /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer3)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer3#', #ans_pol_id#) /CFIF /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer4)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer4#', #ans_pol_id#) /CFIF /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer5)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer5#', #ans_pol_id#) /CFIF /CFQUERY If you do not want to write the code in that method, and wish to stay with your original formatting, try this (only answer1 is included): CFIF #trim(form.ans_answer1)# IS "" CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) VALUES ('¬', #ans_pol_id#) /CFQUERY CFELSEIF #trim(form.ans_answer1)# IS NOT "" CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) VALUES ('#form.ans_Answer1#', #ans_pol_id#) /CFQUERY ... Hope this helps! Chris Ivey MTS Systems Engineer GTE Data Services: Temple Terrace, Florida TSS Distributed - WAN Tools Group Office: (813) 978-4844 Pager: (813) 303-1177 AIM: IveyAtGTEDS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Cookies
Thanks Dave... That's definitely more of an answer I was expecting. I appreciate your help at least. I was looking for some more specific discussions on the uses of cfapplication and session management type things (I've done about 10 or so projects so far to make dynamic web pages and have had yet to even look at using cfapplication). This is the first time that I have needed to do something like this without just password protecting an entire directory and wanted not to do that this way because then I wouldn't have to get our IS department to set up quite a few user names and passwords. This is also the first project that I have worked on where there would be more than one person using the update/add forms to manipulate the data in the database. Anyone else have any book suggestions? I've got Forta's Cold Fusion Web Application Construction Kit, but it didn't cover the topics as in-depth as I had hoped. Allaire training for me is unfortunately not an option (i.e. my price limit for learning is about $40 or less) because any training would come out of my pocket, and I already have some college bills of my own to pay. Thanks! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Queries to Oracle Slow from CFAS (tds)
have you set the datasource to maintain connections? oracle is slow at starting up a new connection, and you will see that overhead with every query if you don't use "maintain connections". -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 6:39 PM To: cf-talk Subject: Queries to Oracle Slow from CFAS (tds) When I run a query from an SQLPLUS Session, the query runs lighting fast. But, when I run the query via a CF Template and display the results to a browser it is very slow for only 100 records. I'm use CF 4.5.1 with Windows 2000 and the CF Native Drivers. I've stripped out everything from the CF Template except just the necessary stuff like cfquery and cfoutput I have debugging turned on and time specified in the "Queries Section" is like 134233 milliseconds (134.233 Secons). Every once in a while I get a response time like 5432 milliseconds (5.4 Seconds) Has anyone experienced this as well. -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL - One or two queries?
try OUTER: cfquery name="info" datasource="myDSN" SELECT skiareas.*, skiareanews.news FROM skiareas LEFT OUTER JOIN skiareanews ON skiareas.areacode = skiareanews.areacode WHERE skiareas.areacode = 'co01' AND skiareanews.season = 2000 /cfquery -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 5:59 PM To: cf-talk Subject: OT: SQL - One or two queries? I've got a situation where I'm not sure if it's better to pull data using a single SQL statement, or use two. The database relationship is this: One to Many, where I've got a table of ski areas and a table of 'new for season' data where I have new features for a given area in successive seasons, 1998, 1999, 2000, etc., one record per ski area/season. So I want to pull up information about the area, plus the 'news' for the current ski season. Following the advise of using as few queries as possible, I tried to construct an outer join to pull a single record with the needed data. The outer join is necessary, since there may be no news for a given area in a given season. cfquery name="info" datasource="myDSN" SELECT skiareas.*, skiareanews.news FROM skiareas LEFT JOIN skiareanews ON skiareas.areacode = skiareanews.areacode WHERE skiareas.areacode = 'co01' AND skiareanews.season = 2000 /cfquery But this returns zero records when there are no news records for the current season. I suspect the problem may be in the WHERE clause, but I don't know how to formulate it correctly. By removing the 'AND skiareanews.season = 2000' part, I get results, but of course it sometimes -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What are you using instead of IDENTITY...Part II
At 7/12/00 10:23 PM, you wrote: Is it just me, or does Joe seem to avoid the actual questions that Tom has asked?? Or have the questions been truncated in some way? Nothing was truncated. I just copied and pasted the email Joe Celko sent to me. To be honest, Joe had me doubting my database modeling technique. I'm still open to better ways. Perhaps ORM is better. I am just discovering it now. So far, it seems very similar to the ER diagrams I can make with ERwin. Little apparent benefits so far. I had the same feeling that Joe was being a good politician and avoiding my question. I was going to ask his thinking about surrogate keys, but I'm happy with the way I do things now (WITH surrogate keys). At the least, Joe's comments stirred up quite a good discussion. I look forward to more of the same in the future here! Tom Nunamaker [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Seeking Text Rollover
Date: Tue, 11 Jul 2000 10:52:09 -0700 From: "Richard Colman" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Subject: Seeking Text Rollover Message-ID: [EMAIL PROTECTED] (A little off topic, but, this may be a common need and worth repeating.) Seeking JavaScript, DHTML, CF, etc. script/solution that will provide a simple "change-in-color" text rollover (without the need for images) in both IE AND NETSCAPE browsers. Have been looking in the obvious places, but have not found anything. Does anyone know of a source? Richard Colman Richard, You may want to try something like this. It is a javascript we implemented on our site: html head titleWhatever you want here/title STYLE .Fancy {color : Cyan;link : Cyan;} .start {color : silver;link : silver; visited : silver;} /STYLE SCRIPT LANGUAGE=JAVASCRIPT function highlightButton(s) { if ("INPUT"==event.srcElement.tagName) event.srcElement.className=s } /SCRIPT /head HTML tr tdstrongfont size="+1" color="#00ff00"Category 1font/strong/td tdstrongfont size="+1" color="#00ff00"Category 2font/strong/td /tr tr tdstrongA onmouseover = "this.className = 'Fancy'" onmouseout = "this.className='start'" class=start HREF="Category1.cfm"Category 1 Data/strong/A/td tdstrongA onmouseover = "this.className = 'Fancy'" onmouseout = "this.className='start'" class=start HREF="Category2.cfm"Category 2 Data/strong/A/td /tr HTML Hope this works for you! Chris Ivey MTS Systems Engineer GTE Data Services: Temple Terrace, Florida TSS Distributed - WAN Tools Group Office: (813) 978-4844 Pager: (813) 303-1177 AIM: IveyAtGTEDS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Problems with CFMAIL and CF4.5.1 and HTML Formatting!
We have been using CFMAIL to send HTML formatted e-mails to our customers on a weekly basis. We were using CF4.0.1 without difficulty. We just recently upgraded to CF4.5.1 and now some users are complaining that the e-mails are displaying just the raw HTML not the formatted HTML message. It still works fine with Outlook but Groupwise and Lotus Notes users (that were working before) are having difficulty. Here's the code for the CFMAIL tag. Do I need to do anything differently with CF4.5.1? cfmail query="HTMLList" to="#email#" from="[EMAIL PROTECTED]" subject="INPUT's Weekly E-Letter" type="HTML"#HTMLVersion#/cfmail Thanks Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Netscape Problem with CFGRID
I am having a problem with a CFGRID displaying in Netscape. The same CFGRID shows up just fine in Internet Explorer. The problem seems to have something to do with the number of records that are being displayed. The table in question returns 25,000 records. I think I read somewhere that you can just retrieve X number of records at a time, and allow the next group of records to display at the request of the user. This would be a good idea regardless of the Netscape problem, but I am curious as to the reason why it does not display. If I request a smaller subset of the data, it does display, so I do not think that the problem is syntax related, but rather a resource problem with Netscape. Any idea? Tim Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
uniqueidentifier in SQL and ColdFusion
What problems do people get when using uniqueidentifier as there primey key in MS SQL and Cold Fusion ? Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: (OT) Feel like a dumbass
I'm not gonna post an air cargo or Alyssa Milano question here. Well...at least THOSE are questions we could answer: 1.) 5000 pounds, give or take. 2.) Yes, but never on-camera. Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF4.5.1 and Security Sandbox
Did we lose the security sandbox in CF4.5.1? I am using 4.5.1 PRO. I suppose I just make a security context for RDS and granularly apply access rules? You'll need CF 4.5.1 Enterprise to get Advanced Security. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFEXECUTE Problems
mm... nope, still not working for me. In addition to your example, I've also tried running it from a cmd.exe shell - i.e.: cfexecute name="c:\winnt\system32\cmd.exe" arguments="net user testme testme /add" /cfexecute ... still no dice. I couldn't get it to work that way, either. Is your CF service running as localsystem? Yes, it is. I tested this on my development machine, running Win2K and CF 4.5.1. I'm using the standard security configuration (essentially, no security); this might be your problem, if you've modified your user rights and security configuration in one way or another. If you're trying to manipulate users, rights, etc. you might want to take a look at ADSI, which you can use through COM. CFOBJECT isn't really good at doing this, but it's pretty easy to write wrapper objects, and call those objects to do your ADSI tasks. I've used Windows Script Components for this. On a tangent, can anyone recommend an FTP server that would integrate well with CF automation? The ultimate goal here is to automate the creation of user accounts and access rights. Currently, I'm trying to add the user to an NT domain (duh) and then I'm assigning server permissions at the file level using xcacls.exe (this works just dandy using CFEXECUTE). I've had few problems using IIS's web server for this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Amazon Tags
whoops. yeah. cfinclude template="relativepath/isbn.html" From: "Dave Notik" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Amazon Tags Date: Tue, 11 Jul 2000 23:12:46 -0700 What code do you use to then display these HTML snippets? I'd assume you loop through the files in your /books/ directory and CFINCLUDE them? Curious... -- looks like that can be turned into a convenient custom tag. -Dave -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 9:55 PM To: [EMAIL PROTECTED] Subject: Re: Amazon Tags glad to help. Note: cfset filepath="C:\www\test\www\capitalidea\content\books" the path to save the html snippet created by the custom tag. affid. the amazon associate id from ... amazon Book = AIBN code of the book. Example: http://www.capitalidea.com/amazon.cfm == myFavouriteBooks.cfm === cf__get_amazon affid="capitalidea0d" Book="0439139597" === You get the ISBN number from the amazon site directly Example: Hardcover - 752 pages (July 8, 2000) Scholastic/Arthur A. Levine; ISBN: 0439139597 == _get_amazon.cfm cfhttp method="get" url="http://www.amazon.com/exec/obidos/ASIN/#attributes.book#/icigroup/capit alidea0d" resolveurl="yes" cfset filepath="C:\www\test\www\capitalidea\content\books" cfset content = cfhttp.filecontent !-- News Item -- cfset startpos = FindNoCase("/exec/obidos/handle-buy-box=", Content)-50 cfset startpos = FindNoCase("form", Content, startpos) cfset endpos = FindNoCase("/form", Content,startpos)+7 cfset Content = Trim(Mid(Content, startpos, endpos - startpos)) CFSET Content = replacenocase(Content,"/g/detail/addtocart","http://www.amazon.com/g/detail/ addtocart","ALL") CFSET Content = replacenocase(Content,"/g/gift-services/buttons/addtoWL","http://www.amazon. com/g/gift-services/buttons/addtoWL","ALL") CFSET Content = replacenocase(Content,"/g/detail/buybox/add-to-shopping-cart-blue.gif","http ://www.amazon.com/g/detail/buybox/add-to-shopping-cart-blue.gif","ALL") CFSET Content = replacenocase(Content,"/g/gift-services/buttons/wl_white.gif","http://www.am azon.com/g/gift-services/buttons/wl_white.gif","ALL") CFFILE ACTION="Write" FILE="#filepath#\#attributes.book#.html" OUTPUT="#content#" === From: "Joseph J. Sanger, M.D." [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Amazon Tags Date: Tue, 11 Jul 2000 18:30:22 -0400 Eric, I am VERY intrigued by this code ... could you give me a pointer or two on how to use it? For example, where can I get these two parameters in order to grab info on a book? It's not obvious to me from crusing Amazon's site. Thanks very much in advance. cfparam name="attributes.book" default="???" cfparam name="attributes.affid" default="" cfhttp method="get" url="http://www.amazon.com/exec/obidos/ASIN/#attributes.book#/icigrou p/#attributes.affid#" resolveurl="yes" cfset filepath="C:\www\content\books" cfset content = cfhttp.filecontent cfset startpos = FindNoCase("/exec/obidos/handle-buy-box=", Content)-50 cfset startpos = FindNoCase("form", Content, startpos) cfset endpos = FindNoCase("/form", Content,startpos)+7 cfset Content = Trim(Mid(Content, startpos, endpos - startpos)) CFSET Content = replacenocase(Content,"/g/detail/addtocart","http://www.amazon.com/g/ detail/addtocart","ALL") CFSET Content = replacenocase(Content,"/g/gift-services/buttons/addtoWL","http://www. amazon.com/g/gift-services/buttons/addtoWL","ALL") CFFILE ACTION="Write" FILE="#filepath#\#attributes.book#.html" OUTPUT="#content#" From: Stuart Duncan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Amazon Tags Date: Wed, 21 Jun 2000 10:27:13 -0700 Hey all, I've come across a few interesting tags for searching through Amazon's books and such but what I really need is something which allows me to actually select individual books and display those on the site. I was thinking, something where I could just enter the product id form Amazon, and the tag would go and fetch all the information from them on that book. Has anyone come up with an easy way to do this, or do you know of any custom tags that does this? Any help on this would be greatly appreciated. Stuart Duncan. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com --- ---
RE: CFEXECUTE Problems
Correct me if I'm wrong, but isn't TIMEOUT=X required? I believe the docs forget to mention it, but that could be your problem. mm... nope, still not working for me. In addition to your example, I've also tried running it from a cmd.exe shell - i.e.: cfexecute name="c:\winnt\system32\cmd.exe" arguments="net user testme testme /add" /cfexecute ... still no dice. I couldn't get it to work that way, either. Is your CF service running as localsystem? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cfif problem
thanks a lot for your help, got that probelm sorted now From: "Chris Ivey" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: cfif problem Date: Wed, 12 Jul 2000 8:39:03 -0400 Janey, This is a response to the CF-Talk question you posted There is a couple of things I notice about your code. First, is that I do not see any /CFIF statements in that code. That may be part of the problem. Second, it seems like you are doing a lot of extra coding in that statement. Maybe try to rewrite it something like this: CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer1)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer1#', #ans_pol_id#) /CFIF /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer2)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer2#', #ans_pol_id#) /CFIF /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer3)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer3#', #ans_pol_id#) /CFIF /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer4)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer4#', #ans_pol_id#) /CFIF /CFQUERY CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) CFIF #trim(form.ans_answer5)# IS "" VALUES ('¬', #ans_pol_id#) CFELSE VALUES ('#form.ans_Answer5#', #ans_pol_id#) /CFIF /CFQUERY If you do not want to write the code in that method, and wish to stay with your original formatting, try this (only answer1 is included): CFIF #trim(form.ans_answer1)# IS "" CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) VALUES ('¬', #ans_pol_id#) /CFQUERY CFELSEIF #trim(form.ans_answer1)# IS NOT "" CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer" INSERT INTO ans_answer (ans_ans, ans_pol_id) VALUES ('#form.ans_Answer1#', #ans_pol_id#) /CFQUERY ... Hope this helps! Chris Ivey MTS Systems Engineer GTE Data Services: Temple Terrace, Florida TSS Distributed - WAN Tools Group Office: (813) 978-4844 Pager: (813) 303-1177 AIM: IveyAtGTEDS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What are you using instead of IDENTITY...Part II
At 10:23 PM +1000 7/12/2000, Nick Slay wrote: Is it just me, or does Joe seem to avoid the actual questions that Tom has asked?? Or have the questions been truncated in some way? Hard to tell... he may just be trying to support a "general" opinion/statement/position with a "specific" example. It would be interesting to ask: "If identity were added to the standard, would this change your opinion?" Why is the city example a bad one? It's something that every address that is stored has, and can potentially contain many duplications. It is a good, real-world, example, IMO. What is the relevance of the SAN? The majority of addresses won't have anything to do with the book trade?! Where Joe does mention putting city, state and zip into seperate tables, he doesn't explain what he uses to reference between tables? If he doesn't use an Identity column, does he just use the city, state or zip as the key? Doesn't this cause over-bloated indexes therefore affecting performance and possibly fragmented indexes? One thing you gain, regardless of key, is the domain constraint... the employee's city must exist within the existing set of cities. You also avoid data anomalies: San Francisco SanFrancisco San Francisco To take this to another level (extreme) you could normalize repeating occurrences of repeated words in the cities table to avoid: Des Baines Des Plaines Des Moines . . . Fort Apache Fort Huachuca Fort Smith . . . San Diego San Francisco San Jose Normalization rules suggest that you only store "Des", "Fort" and "San" once. Now, most (including myself) would agree that taking normalization to this level is impractical for most situations. (An exception might be a database of Atlas cities, or a dictionary) The whole point is that you should not blindly follow "rules" or "theory" just because they exist... rather, use those which apply/benefit your particular situation. However, I do like to employ Domain tables/constraints where practical to: simplify input (Select rather than type) avoid data anomalies improve access efficiency to data and, yes, sometimes for normalization I'm not familiar with Joe Celko, or his work, but from the messages that have been posted I still haven't seen any definitive reason to not use Identity columns, and in my experience, as Tom mentioned in his email to Joe, most developers I have also ever come across have used Identity columns. I have about 8 years experience of database design, and building systems, and I have never come across anyone who has had serious problems with Identity columns. Maybe that is purely luck. I agree with Celko that using Identity makes your data/programs non-portable. But this is a situation where, I tradeoff theory for practicality. I can knowingly violate the "rules" and greatly simplify programming and increase db performance. Should I, later, need to convert to another system, I have a single, non-standard issue to resolve... not multiple, theoretically-pure but impractical, implementations. One thing I like about Identity (and it probably drives the purists crazy) is the fact that it is an arbitrary pointer to the data. As such it more closely resembles the underlying structure and programming of the data store, access method and the db system. It, therefore is a reasonable assumption, that use of identity will yield efficiencies at all levels. There have been lots of great reasons posted for using Identity Columns, but not many for not using them and I guess at the end of the day, do what works for you, but be aware of the potential pitfalls, and develop accordingly. In my personal opinion, and from my experience to date, I will continue to use Identity columns, and I will continue to recommend them. I agree (although I did experience problems with SQL Server 6.5). One final comment on standard vs non-standard... It was not too long ago that there were only hierarchical and flat-file databases... ...RDBMS were non-standard and non-portable! Dick From: Tom Nunamaker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 12 Jul 2000 13:47:36 +0200 To: [EMAIL PROTECTED] Subject: What are you using instead of IDENTITY...Part II Continuing the dialog with Joe Celko, here's more fuel to the fire. New questions raised by Joe's latest email: * Has anyone looked at ORM? * I personally love ERwin. What better alternative is there? * The next step is to ask Joe Celko if he ever recommends a surrogate key. Tom Nunamaker [EMAIL PROTECTED] = If I have a table with repeating information, suppose a city field in an employee table for example, to normalize it you would break the city into a separate table. If I used the city name as the primary key for this "city" table, then it wouldn't accomplish anything to put
RE: CFEXECUTE Problems
Correct me if I'm wrong, but isn't TIMEOUT=X required? I believe the docs forget to mention it, but that could be your problem. It worked fine without it for me. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
QuestionII:RE:_Welcome_to_Microsoft®_Windows_NT®_4.0_Option_Pack_
I don't know how to set the settings of the requested server (to which I have access). How do I prevent it from displaying the default page and going to the desired page? I tried to go into internet options and changing the first page being displayed but it did not help. Appreciate greatly. A.B. --- Steve Bernard [EMAIL PROTECTED] wrote: One of two things has to happen, either you need to explicitely state the file that you want to retrieve, http://www.someurl.com/requestedpage.html, or the administrator of the requested server needs to change the default page for the server in question. Steve -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQLOLEDB Provider and 4.51
Is anyone running the SQLOLEDB provider from 4.51? Is it_fully_supported now? I want to move from ODBC, but when I did that in 4.01 I found a few unsupported statements and had to move back to ODBC. What unsupported statements did you find? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Encrypt Url
How do I encrypt urls, where do i get info on encrypt urls, just want info on encrypt url Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
It is truly a sad state of affairs isn't it? This sort of thing has been happening on a regular basis since Allaire first started hosting a website. All three of their main components, Corporate, Forums, and Beta sites, have gone down or produced errors that really make them look bad. The two general types that I have seen the most, and that speak volumes about their infrastructure/administration in my opinion, are related to performance/load and database management. Ironically enough, these are two of tenants of the Allaire Performance Tuning class, optimizing your code and your database. Another problem that this exposes is Allaire's attention to detail and security. You can learn a lot about a system by getting such error messages. It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT 3) Web root is on D:, seperate from the system root 4) Exact path to the customtags directory 5) Template name 6) Exact line of offending code 7) 'CustomTagsV65' may indicate that they have multiple versions in one tree. This may provide further opportunity if the system is breached. 8) Allaire doesn't monitor it's servers effectively 9) Allaire doesn't seem to take it's web presence seriously enough even though the product it sells is made for developing high-end, robust, data-driven, web sites (enought buzz words there?). All this provides is information, not vulnerabilities, but, it is a definite start in profiling the system, and all without having to send a single suspicious packet their way. Anyone who has spent time profiling systems will understand this. So if Allaire is this shoddy in protecting/maintaining their corporate site what's going on with the areas of the site that manage customer information? Steve p.s. I don't have anything against Allaire, I'm just calling it like I see it. -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] I think it would be really cool if you went to Allaire's website, searched for something and didn't get this: Error Diagnostic Information Error occurred in tag CFSEARCH Collection failed to open: AllaireWeb6SiteSearch The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in the template file D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESE ARCH.CFM. Date/Time: 07/11/00 22:55:58 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 63.203.119.82 HTTP Referer: http://www.allaire.com/search/index.cfm How do these guys expect to have people buy into this language when thier own site is constantly breaking? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: QuestionII:RE:_Welcome_to_Microsoft®_Windows_NT®_4.0_Option_Pack_
I don't know how to set the settings of the requested server (to which I have access). How do I prevent it from displaying the default page and going to the desired page? You can do this from the Internet Service Manager. Right-click on the virtual server in question, select Properties, go to the Documents tab, and enter the name of the document you want to use as a default. Then, sit down and spend about half an hour or so wandering through the Internet Service Manager. There's lots of stuff in there which is good to know, and if you're going to use IIS, you'll have to learn it sooner or later. This will be a good start. You might also want to get a book about IIS; it's a complex enough application that it warrants a bit of research time. I'd recommend the IIS Resource Kit, at least. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
why is this happening?
Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF And Outlook Address Book
Does anyone on the list know of a tag that will allow me to use the Microsoft Outlook address book in my applications? I want end users to be able to search the address book for names and phone numbers, more than for the email addresses. Can I pull what amounts to a phone directory out of the Outlook address book? Tim Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: QuestionII:RE:_Welcome_to_Microsoft®_Windows_NT®_4.0_Option_Pack_
You have to use the Internet Services Manger and select the site you are working on and add your page to the default page selections and remove the others. - Original Message - From: "aslam bajaria" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 12, 2000 9:57 AM Subject: QuestionII:RE:_Welcome_to_Microsoft®_Windows_NT®_4.0_Option_Pack_ I don't know how to set the settings of the requested server (to which I have access). How do I prevent it from displaying the default page and going to the desired page? I tried to go into internet options and changing the first page being displayed but it did not help. Appreciate greatly. A.B. --- Steve Bernard [EMAIL PROTECTED] wrote: One of two things has to happen, either you need to explicitely state the file that you want to retrieve, http://www.someurl.com/requestedpage.html, or the administrator of the requested server needs to change the default page for the server in question. Steve -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Thumbnail tags
I'd use Jukka Manner's updated CFX_Image tag instead of the old CFX_GifGD tag. It has support for progressive jpegs as far as I can tell, it also has much more features. - Original Message - From: "Seth Petry-Johnson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 11, 2000 8:30 PM Subject: Re: Thumbnail tags I've been using cf_gifgd from the tag gallery works good for me, but progressive jpg's will break it. If anyone has any better solutions I'd like to know also. I too have been stuck with cfx_gifgd and its problems with progressive JPEGs. I've looked, but haven't found anything that is a good replacement. If anyone knows of a good alternative, I too would be very interested. However, I do know how to test for progressive JPEGs before resizing them. The problem is that when CFX_GIFGD is called to resize a progressive JPEG it causes the entire CF service to crash and restart, which is obviously a bad thing. I don't know enough about JPEGs (or the CFX code) to know why this is. To ensure that this won't happen, use CFX_GIFGD to read the file before you resize it. The READ action returns a series of variables about the image, one of which is the file type. If the image is a progressive JPEG the type variable will contain an empty string. Just wrap the resize action in a CFIF that checks the length of the type variable. For example: !--- check the file type --- CFX_GIFGD ACTION="read" FILE="#yourFile#" CFIF NOT Len(Trim(Variables.IMG_TYPE)) !--- progressive JPEG! put some sort of error message here --- CFELSE !--- image can be safely resized --- CFX_GIFGD ACTION="resize" blah blah /CFIF Just a little workaround I discovered. Hope it helps. Regards, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEC13.BA40F1D0 Content-Type: text/plain Or they have deliberately misinformed you in the error message :-) Not that the error is deliberate...but the information it is giving you could be deliberately wrong. I have done this in past systems I have worked on.and set up most of my UNIX boxes to give wrong profiling information (including information in errors). Just a thought. Its fun watching people try linux exploits on a solaris box...or vice versa - or making a linux box look like an NT box. Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:03 AM To: [EMAIL PROTECTED] Subject: RE: You know what would be really cool? It is truly a sad state of affairs isn't it? This sort of thing has been happening on a regular basis since Allaire first started hosting a website. All three of their main components, Corporate, Forums, and Beta sites, have gone down or produced errors that really make them look bad. The two general types that I have seen the most, and that speak volumes about their infrastructure/administration in my opinion, are related to performance/load and database management. Ironically enough, these are two of tenants of the Allaire Performance Tuning class, optimizing your code and your database. Another problem that this exposes is Allaire's attention to detail and security. You can learn a lot about a system by getting such error messages. It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT 3) Web root is on D:, seperate from the system root 4) Exact path to the customtags directory 5) Template name 6) Exact line of offending code 7) 'CustomTagsV65' may indicate that they have multiple versions in one tree. This may provide further opportunity if the system is breached. 8) Allaire doesn't monitor it's servers effectively 9) Allaire doesn't seem to take it's web presence seriously enough even though the product it sells is made for developing high-end, robust, data-driven, web sites (enought buzz words there?). All this provides is information, not vulnerabilities, but, it is a definite start in profiling the system, and all without having to send a single suspicious packet their way. Anyone who has spent time profiling systems will understand this. So if Allaire is this shoddy in protecting/maintaining their corporate site what's going on with the areas of the site that manage customer information? Steve p.s. I don't have anything against Allaire, I'm just calling it like I see it. -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] I think it would be really cool if you went to Allaire's website, searched for something and didn't get this: Error Diagnostic Information Error occurred in tag CFSEARCH Collection failed to open: AllaireWeb6SiteSearch The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in the template file D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESE ARCH.CFM. Date/Time: 07/11/00 22:55:58 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 63.203.119.82 HTTP Referer: http://www.allaire.com/search/index.cfm How do these guys expect to have people buy into this language when thier own site is constantly breaking? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BFEC13.BA40F1D0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: You know what would be really cool?/TITLE /HEAD BODY PFONT SIZE=3D2Or they have deliberately misinformed you in the = error message :-)nbsp; Not that the error is deliberate...but the = information it is giving you could be deliberately wrong./FONT/P PFONT SIZE=3D2I have done this in past systems I have worked = on.and set up most of my UNIX boxes to give wrong profiling = information (including information in
RE: What are you using instead of IDENTITY...Part II
All, What Joe is saying is very simple. - Primary Keys must be made from data elements within the row. Using a number generator to assign an integer value as a key is acceptable. - Since IDENTITY is not a real data element (it's an internal row pointer), it is NOT an appropriate key candidate. And he is ENTIRELY correct. The true test of a key, is to think of a situation where you are asked to extract a subset of data (ie. set of master with all related details) into a new database with an identical structure. The test is met if you are able to perform the transition and maintain all relationships. On this score IDENTITY fails. Sean -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: QuestionII:RE:_Welcome_to_Microsoft®_Windows_NT®_4.0_Option_Pack_
No problem ... *** Open up the IIS Manager (MMC) Right click on the applicable host/virtual host, select 'Properties' Select the Documents tab Make sure that the 'Default document' checkbox is checked Do ONE of the following ... 1) Delete all document names and insert the one you want 2) Rename your default document to whatever the top name is 3) Insert the name you want and make sure it is the first name in the list Click the 'Apply' or 'OK' button Open web browser and verify *** Let me know if you have further problems, Steve -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 10:58 AM To: [EMAIL PROTECTED] Subject: QuestionII:RE:_Welcome_to_Microsoft®_Windows_NT®_4.0_Option_Pack_ I don't know how to set the settings of the requested server (to which I have access). How do I prevent it from displaying the default page and going to the desired page? I tried to go into internet options and changing the first page being displayed but it did not help. Appreciate greatly. A.B. --- Steve Bernard [EMAIL PROTECTED] wrote: One of two things has to happen, either you need to explicitely state the file that you want to retrieve, http://www.someurl.com/requestedpage.html, or the administrator of the requested server needs to change the default page for the server in question. Steve -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
Heh their site search was failing to create sessions yesterday.. But I can understand. Allaire is moving their entire company to a new building so lets cut thema lil slack ehh, I know the two are not really related.. but moving servers and stuff and keeping any kind of web presence is cool. :) Jeremy -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:03 AM To: [EMAIL PROTECTED] Subject: RE: You know what would be really cool? It is truly a sad state of affairs isn't it? This sort of thing has been happening on a regular basis since Allaire first started hosting a website. All three of their main components, Corporate, Forums, and Beta sites, have gone down or produced errors that really make them look bad. The two general types that I have seen the most, and that speak volumes about their infrastructure/administration in my opinion, are related to performance/load and database management. Ironically enough, these are two of tenants of the Allaire Performance Tuning class, optimizing your code and your database. Another problem that this exposes is Allaire's attention to detail and security. You can learn a lot about a system by getting such error messages. It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT 3) Web root is on D:, seperate from the system root 4) Exact path to the customtags directory 5) Template name 6) Exact line of offending code 7) 'CustomTagsV65' may indicate that they have multiple versions in one tree. This may provide further opportunity if the system is breached. 8) Allaire doesn't monitor it's servers effectively 9) Allaire doesn't seem to take it's web presence seriously enough even though the product it sells is made for developing high-end, robust, data-driven, web sites (enought buzz words there?). All this provides is information, not vulnerabilities, but, it is a definite start in profiling the system, and all without having to send a single suspicious packet their way. Anyone who has spent time profiling systems will understand this. So if Allaire is this shoddy in protecting/maintaining their corporate site what's going on with the areas of the site that manage customer information? Steve p.s. I don't have anything against Allaire, I'm just calling it like I see it. -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] I think it would be really cool if you went to Allaire's website, searched for something and didn't get this: Error Diagnostic Information Error occurred in tag CFSEARCH Collection failed to open: AllaireWeb6SiteSearch The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in the template file D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESE ARCH.CFM. Date/Time: 07/11/00 22:55:58 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 63.203.119.82 HTTP Referer: http://www.allaire.com/search/index.cfm How do these guys expect to have people buy into this language when thier own site is constantly breaking? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Form.Fieldnames Missing
That's what we're running as well. --K Katrina Chapman Consultant Ameriquest Mortgage "Dave Watts" [EMAIL PROTECTED] 07/11/00 08:37 PM Please respond to cf-talk To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject:RE: Form.Fieldnames Missing Is there a reason why the form.fieldnames field would not be passed in a form? I vaguely seem to recall that in some versions of CF prior to 4.5.x, if the ENCTYPE attribute of the form is set to "multipart/form-data", which is what you'd use for file uploads, FORM.FIELDNAMES wouldn't appear. Unfortunately, I can't test that theory, since I'm running 4.5.1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Quite simple, co
Quite simple, count the amount of Fields, and the amount of values, and they aren't consistent you have 11 fields and 12 values, re-tool and try again! Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] [EMAIL PROTECTED] 07/12 8:05 AM Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Please help! CFFTP and empty file.
This is a multi-part message in MIME format. --=_NextPart_000_0026_01BFEBF4.5DFA5E20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am using CFFTP to send files from one CF server to another CF server. = The files get sent okay, but they contain no data. They are all zero = bytes. Any ideas? Please help! =20 Thanks --=_NextPart_000_0026_01BFEBF4.5DFA5E20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hello,/FONT/DIV DIVFONT face=3DArial size=3D2I am using CFFTP to send files from one = CF server=20 to another CF server.nbsp; The files get sent okay, but they contain no = data.nbsp; They are all zero bytes.nbsp; Any ideas? Please help!nbsp; = /FONT/DIV DIVFONT face=3DArial size=3D2Thanks/FONT/DIV/BODY/HTML --=_NextPart_000_0026_01BFEBF4.5DFA5E20-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: why is this happening?
At 11:05 12/07/00 -0400 Douglas Jordon said Could be the ; at the end of '#TIMEx#') Gordon Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_t alk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: why is this happening?
Doug, Could one of you values have a comma in it? That might make the database think it has more values than you intend. -- Tim Dempsey -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:06 AM To: Cold Fusion List Subject: why is this happening? Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Form.Fieldnames Missing
I can recreate the error if the only form elements that are named are checkboxes and radio buttons, and none of them have been checked or selected. At that point form.fieldnames is not defined in the action page. Any chance your form only has checkboxes and radio buttons? Dan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 8:37 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Form.Fieldnames Missing Is there a reason why the form.fieldnames field would not be passed in a form? I vaguely seem to recall that in some versions of CF prior to 4.5.x, if the ENCTYPE attribute of the form is set to "multipart/form-data", which is what you'd use for file uploads, FORM.FIELDNAMES wouldn't appear. Unfortunately, I can't test that theory, since I'm running 4.5.1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Thumbnail tags
you can use the CF_GifGD and when you encounter a progressive JPEG use CGX_Image and CFX_ImageInfo to handle the resize.. I haven't used CF_GifGD but I plan on using it with this combination.. Brian Silvers [EMAIL PROTECTED] X-Net Web Systems Senior Developer ColdFusion, SQL, PHP, Perl, Dynamic Content Database Integration, Flash, and more! - Original Message - From: "ColdFusionKid" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 12, 2000 10:10 AM Subject: Re: Thumbnail tags I'd use Jukka Manner's updated CFX_Image tag instead of the old CFX_GifGD tag. It has support for progressive jpegs as far as I can tell, it also has much more features. - Original Message - From: "Seth Petry-Johnson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 11, 2000 8:30 PM Subject: Re: Thumbnail tags I've been using cf_gifgd from the tag gallery works good for me, but progressive jpg's will break it. If anyone has any better solutions I'd like to know also. I too have been stuck with cfx_gifgd and its problems with progressive JPEGs. I've looked, but haven't found anything that is a good replacement. If anyone knows of a good alternative, I too would be very interested. However, I do know how to test for progressive JPEGs before resizing them. The problem is that when CFX_GIFGD is called to resize a progressive JPEG it causes the entire CF service to crash and restart, which is obviously a bad thing. I don't know enough about JPEGs (or the CFX code) to know why this is. To ensure that this won't happen, use CFX_GIFGD to read the file before you resize it. The READ action returns a series of variables about the image, one of which is the file type. If the image is a progressive JPEG the type variable will contain an empty string. Just wrap the resize action in a CFIF that checks the length of the type variable. For example: !--- check the file type --- CFX_GIFGD ACTION="read" FILE="#yourFile#" CFIF NOT Len(Trim(Variables.IMG_TYPE)) !--- progressive JPEG! put some sort of error message here --- CFELSE !--- image can be safely resized --- CFX_GIFGD ACTION="resize" blah blah /CFIF Just a little workaround I discovered. Hope it helps. Regards, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
I see! What a great idea. All of the tech staff and admins would have their Allaire Secret Decoder Rings(tm), available in Personal or Enterprise versions. Error says ODBC error? A quick flick of the dial and it's actually a syntax error! Zounds! a misplaced sign. The future is so bright, I need shades! Greg Creedon On Wed, 12 Jul 2000, Bryan Batchelder wrote: This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEC13.BA40F1D0 Content-Type: text/plain Or they have deliberately misinformed you in the error message :-) Not that the error is deliberate...but the information it is giving you could be deliberately wrong. I have done this in past systems I have worked on.and set up most of my UNIX boxes to give wrong profiling information (including information in errors). Just a thought. Its fun watching people try linux exploits on a solaris box...or vice versa - or making a linux box look like an NT box. Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:03 AM To: [EMAIL PROTECTED] Subject: RE: You know what would be really cool? It is truly a sad state of affairs isn't it? This sort of thing has been happening on a regular basis since Allaire first started hosting a website. All three of their main components, Corporate, Forums, and Beta sites, have gone down or produced errors that really make them look bad. The two general types that I have seen the most, and that speak volumes about their infrastructure/administration in my opinion, are related to performance/load and database management. Ironically enough, these are two of tenants of the Allaire Performance Tuning class, optimizing your code and your database. Another problem that this exposes is Allaire's attention to detail and security. You can learn a lot about a system by getting such error messages. It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT 3) Web root is on D:, seperate from the system root 4) Exact path to the customtags directory 5) Template name 6) Exact line of offending code 7) 'CustomTagsV65' may indicate that they have multiple versions in one tree. This may provide further opportunity if the system is breached. 8) Allaire doesn't monitor it's servers effectively 9) Allaire doesn't seem to take it's web presence seriously enough even though the product it sells is made for developing high-end, robust, data-driven, web sites (enought buzz words there?). All this provides is information, not vulnerabilities, but, it is a definite start in profiling the system, and all without having to send a single suspicious packet their way. Anyone who has spent time profiling systems will understand this. So if Allaire is this shoddy in protecting/maintaining their corporate site what's going on with the areas of the site that manage customer information? Steve p.s. I don't have anything against Allaire, I'm just calling it like I see it. -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] I think it would be really cool if you went to Allaire's website, searched for something and didn't get this: Error Diagnostic Information Error occurred in tag CFSEARCH Collection failed to open: AllaireWeb6SiteSearch The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in the template file D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESE ARCH.CFM. Date/Time: 07/11/00 22:55:58 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 63.203.119.82 HTTP Referer: http://www.allaire.com/search/index.cfm How do these guys expect to have people buy into this language when thier own site is constantly breaking? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BFEC13.BA40F1D0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii" META NAME=3D"Generator"
Errors when using CFHTTP / WDDX on 4.5
Hi, Since I've upgraded to 4.5, using cfhttp with any xml or text templates is not working. We now get an error that states that the ascii file that we are attempting to display is invalid. To work with the data read from cfhttp, we need to dump the content to a file, then read it back in. Is anyone aware of another workaround for this? Thanks - Geoff B -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Queries to Oracle Slow from CFAS (tds)
We also removed a large delay by making sure the local tnsnames.ora file has all the information needed to reach the database. Our DBAs originally set up the tnsnames.ora to point at the "source" on another server. With a little pushing and shoving we were able to get them to publish the "source" tnsnames.ora out to the web servers. For some reason this was about a four second lag problem the first hit to the database on each page, even with maintain connections set, but now it is gone! Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 5:57 AM To: [EMAIL PROTECTED] Subject: RE: Queries to Oracle Slow from CFAS (tds) have you set the datasource to maintain connections? oracle is slow at starting up a new connection, and you will see that overhead with every query if you don't use "maintain connections". -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 6:39 PM To: cf-talk Subject: Queries to Oracle Slow from CFAS (tds) When I run a query from an SQLPLUS Session, the query runs lighting fast. But, when I run the query via a CF Template and display the results to a browser it is very slow for only 100 records. I'm use CF 4.5.1 with Windows 2000 and the CF Native Drivers. I've stripped out everything from the CF Template except just the necessary stuff like cfquery and cfoutput I have debugging turned on and time specified in the "Queries Section" is like 134233 milliseconds (134.233 Secons). Every once in a while I get a response time like 5432 milliseconds (5.4 Seconds) Has anyone experienced this as well. -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
pass variables
i have a problem passing variables to an edit page, it passes the field pol_question fine but for the answer fields my loop is incorrect, it just reproduces the answers 5 times each. each answer is the ans_answer table is related to the pol_question through the pol_id, any help would be appreciated, html head titleUpdate Poll/title /head body bgcolor="#CC" link="#996633" vlink="#CC9966" alink="#CC9966" !--- CFIF ISDEFINED("#url.Pol_id#") No Pol_id Passed! /CFIF --- CFQUERY NAME="GetPollDetails" DATASOURCE="quickpoll" SELECT pol_ID, pol_Question, pol_Category, pol_Status FROM pol_Poll WHERE pol_ID = #URL.PollID# /CFQUERY CFQUERY NAME="GetAnswers" DATASOURCE="quickpoll" SELECT ans_ID,ans_Ans FROM ans_Answer A WHERE ans_pol_ID = #url.PollID# /CFQUERY !-- Display HTML FORM Here with values filled -- cfoutput query="getpolldetails" form method="POST" action="PollUpdate.cfm" !--- textarea rows="5" name="MainText" cols="45" --- pnbsp;/ppPoll: input type="Text" textarea rows="5" cols="45" name="pol_question" size=40 value="#pol_question#" !--- INPUT NAME="question" SIZE=10 VALUE="#pol_question#" --- !--- input type="hidden" name="pol_ID" value="#url.pol_id#" ---/p/cfoutput CFSET Ans1="" CFSET Ans2="" CFSET Ans3="" CFSET Ans4="" CFSET Ans5="" !--- get first record --- CFLOOP QUERY="GetAnswers" CFSET Ans1=#ans_Ans# input type="hidden" name="ans_id1" value="#ans_id#" /CFLOOP !--- get second record etc the cfloop may not work as coded! --- CFLOOP QUERY="GetAnswers" CFSET Ans2=#ans_Ans# input type="hidden" name="ans_id2" value="#ans_id#" /CFLOOP CFLOOP QUERY="GetAnswers" CFSET Ans3=#ans_Ans# input type="hidden" name="ans_id3" value="#ans_id#" /CFLOOP CFLOOP QUERY="GetAnswers" CFSET Ans4=#ans_Ans# input type="hidden" name="ans_id4" value="#ans_id#" /CFLOOP CFLOOP QUERY="GetAnswers" CFSET Ans5=#ans_Ans# input type="hidden" name="ans_id5" value="#ans_id#" /CFLOOP cfoutput query="getanswers" pAnswer1: input type="text" name="answer1" size="45" value="#Ans1#" br Answer2: input type="text" name="answer2" size="45" value="#Ans2#" br Answer3: input type="text" name="answer3" size="45" value="#Ans3#" br Answer4: input type="text" name="answer4" size="45" value="#Ans4#" br Answer5: input type="text" name="answer5" size="45" value="#Ans5#" br /p/cfoutput pStatus: select name="status" size="1" option value="All"All/option option value="New"New/option option value="Active"Active/option option value="Archive"Archive/option option value="Hide"Hide/option /select Category: select name="category" size="1" option value="All"All/option option value="sports"sports/option option value="current affairs"current affairs/option option value="general"General/option /select !--- Above need code to select the correct value should create function or just use IFS Poll Type: --- INPUT name=polltype type=radio value=Y Yes/No INPUT name=polltype type=radio value=M Multiple Choice /p p input type="submit" value="Update Poll" name="submit"/form /p /body /html Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Quite simple, co
Quite simple, count the amount of Fields, and the amount of values, and they aren't consistent you have 11 fields and 12 values, re-tool and try again! What was throwing me is that the data he had *right* was still being saved. I've been fortunate(?) to work with native drivers instead of ODBC, and this (or any other failure) would simply have discarded the whole query and inserted nothing - is this 'partial insert' a common behavior of ODBC drivers? Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Studio: Any way to have File Open folder follow current file?
I use UltraEdit as my standard text editor and it has an option that allows you to "Use Active File Directory on File Open". This is very convenient. Is this possible in CF Studio? I can't find such an option. For example, I start CFStudio and do "File Open" and get a file from D:\Test. Then I open a file from the "Recent Files" list that is from directory C:\ABC\HTMLFiles. Now if I click "File Open" again, it goes back to D:\Test instead of the directory of the currently open file (C:\ABC\HTMLFiles). It is kind of a pain to have to scroll all the way across disks and directories like this. Most often when I do a "File Open", I will want a file from the same directory as the currently open file. Under "Settings" in CFStudio the only choices I seem to have are in "Startup". I can have "File Open" start in either (1) folder last opened in Resource Tab; (2) folder last opened in File Open dialog; (3) hard coded folder. I'm hoping there is a way to configure it so the File Open Dialog follows the currently active file. Don't see it anywhere but thought I would ask just in case I'm missing something. Paul Sinclair -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
problem with primary key
Hi, haveing a crisis here. Everything was working fine earlier, now all of a sudden when I try to do an update on my membership page I get the following error. SQL operation updated no rows. The SQL operation affected no rows.Either the Key value has changed or the row has been deleted. The primary key is id, and I can't figure out why it suddenly would stop working. The database and the program look fine. Any ideas what might be going on? Gregg -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Final Checkout coming back from Secure Server
Okay so the user uses a shoppingcart and checks out through a secure server. Now that the transaction has gone through I want to display our usual header and a little notificaiton if the transaction worked out okay or what the complications are. You can't use a cfinclude with a physical path which sucks because when we come back from the 3rd party credit verification site the direct path of everything is lost. I tried sticking a base ref="urlpath" in there, and it kinda works for IE (it displays header but puts up notice saying not everythign is secure), but Netscape just doesn't show the images because they're not secure. Now i can make it work with keeping the images secure but then all my links take the user back through the site entirely using secure server. I was thinkign of trying to make a seperate file to display these various headers and using a cflocation, or remaking the header files specifically for the final checkout. Before I do that I thought i'd see if anyone knows of a fancy little coldfusion tag already made to handle this. Thanks, Matt Carney -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How to Count? or Record Count?
Ok this is going to sound a bit odd since i am not sure how to word it. i have my little query: [in my admin page for viewing who has signed up for the class] [[from dataview01.cfm]] cfquery name="rsSignedUP" datasource="practice" SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName, tbl_Employee.FirstName, tbl_Employee.Email, tbl_Class.ClassID, tbl_Class.ClassName, tbl_Class.ClassDate, tbl_SignUp.SignUpID, tbl_SignUp.SU_DateOfferdID, tbl_SignUp.SU_EmployeeID, tbl_SignUp.Completed, tbl_SignUp.CreateDate FROM tbl_Employee, tbl_Class, tbl_SignUp WHERE EmployeeID = SU_EmployeeID AND ClassID = SU_DateOfferdID AND ClassName = 'Human Resource Mgmt' ORDER BY #DefOrder# /cfquery Which is grabbing a list of employees which could have signed up for 1 class, given on 2 differnt dates. My problem is, that the class size needs to be limited to 25 people. This is stated on my main form. it also shows how many people are currently singed up for class 01 class 02. [[from signup01.cfm]] cfquery name="rsDate01" datasource="practice" SELECT SignUpID, SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 1 /cfquery cfquery name="rsDate02" datasource="practice" SELECT SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 2 /cfquery [[the display]] A limit of 25 spaces are available per class per day. You will be notified if you are selected for the class time. . cfoutput#rsDate01_total#/cfoutput people have signed up so far for cfoutput# LSDateFormat(rsDisplayDate01.ClassDate, ', DD, ') #/cfoutput.br bcfoutput#rsDate02_total#/cfoutputnbsp/b people for cfoutput# LSDateFormat(rsDisplayDate02.ClassDate, ', DD, ') #/cfoutput So, on the form i show how many have signed up. But on the admin page, i cant figure out how to show who has signed up in sequential order. Because on one admin page i have 2 seperate date/times they could sign up. Its not really abig deal. i would just like to know how to get the number of the last insert Total + 1 as the number that realates to the student who signed up.?? I know i should have used a sepereate table for each Class/time. mabey i will redo it from the ground up. But since it is 10 different classes with 2 times each, spread out over the next year. I wanted to be able to track Student/employees progress through this "Practice Manegment" class. lol no one will read this! Thanks if you do! -paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF And Outlook Address Book
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEC1C.4F698F10 Content-Type: text/plain; charset="iso-8859-1" I have written a COM object that talks to exchange using CDO. It syncs activities defined in our SQL server and Outlook/Exchange. We are calling the object in our web app using CFOBJECT whenever an activity is created or modifiedand it is called in a 'sync everything' mode from a web pagewhich is actually ASP based - kinda cool. You could use VBScript to do the same thing on the client side. Go one step further and use an HTA and you don't have all the security issues. I would suggest looking at msdn.microsoft.com and looking up CDO. The future only gets brighter as microsoft releases the new ways of accessing Exchange with Exchange 2000. --b Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:34 AM To: [EMAIL PROTECTED] Subject: RE: CF And Outlook Address Book Are you using Exchange Server and connecting with Outlook? You could Export your data from Exchange or Outlook (install the Export tools) and import into a database. That is how we did it, but data is static and needs to be dumped often. Was a quick fix. There may be a COM or DCOM way to tackle it. Anyone have any ideas? -Gary McNeel -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 10:08 AM To: [EMAIL PROTECTED] Subject: CF And Outlook Address Book Does anyone on the list know of a tag that will allow me to use the Microsoft Outlook address book in my applications? I want end users to be able to search the address book for names and phone numbers, more than for the email addresses. Can I pull what amounts to a phone directory out of the Outlook address book? Tim Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BFEC1C.4F698F10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: CF And Outlook Address Book/TITLE /HEAD BODY PFONT SIZE=3D2I have written a COM object that talks to exchange = using CDO.nbsp; It syncs activities defined in our SQL server and = Outlook/Exchange.nbsp; We are calling the object in our web app using = CFOBJECT whenever an activity is created or modifiedand it is = called in a 'sync everything' mode from a web pagewhich is actually = ASP based - kinda cool./FONT/P PFONT SIZE=3D2You could use VBScript to do the same thing on the = client side.nbsp; Go one step further and use an HTA and you don't = have all the security issues./FONT/P PFONT SIZE=3D2I would suggest looking at msdn.microsoft.com and = looking up CDO./FONT /P PFONT SIZE=3D2The future only gets brighter as microsoft releases = the new ways of accessing Exchange with Exchange 2000./FONT /P PFONT SIZE=3D2--b/FONT /P PFONT SIZE=3D2/FONT BRFONT SIZE=3D2Bryan D. = Batcheldernbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Work: = 813-935-7100/FONT BRFONT SIZE=3D2Palm/Internet Developernbsp;nbsp; Home: = 727-547-1322/FONT BRFONT SIZE=3D2/FONT BRFONT SIZE=3D2ConnectWise, Inc. (www.ConnectWise.com)/FONT BRFONT SIZE=3D22803 West Busch Blvd, Suite 204/FONT BRFONT SIZE=3D2Tampa, FL 33618/FONT BRFONT SIZE=3D2/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Gary McNeel, Jr. [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=3D2Sent: Wednesday, July 12, 2000 11:34 AM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT
Re: Quite simple, co
Gregory Harris: Quite simple, count the amount of Fields, and the amount of values, and they aren't consistent you have 11 fields and 12 values, re-tool and try again! Nope 12 and 12. You should try looking at the full sql that gets passed, check it for quotes etc What DB are you using??? ~Justin [EMAIL PROTECTED] 07/12 8:05 AM Why would this query: cfquery datasource="datasourcename" insert into emails( SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#' ); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Please help! CFFTP and empty file.
|Hello, |I am using CFFTP to send files from one CF server to another |CF server. = |The files get sent okay, but they contain no data. They are all zero = |bytes. Hi Jeff, What kind of name contention scheme are you using? Regards, Anthony Geoghegan. Lead Developer, IFTN www.wow.ie mailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Cold Fusion Studio Vs Dreamweaver Ultradev
alot of cgi stuff too. i have been using it for a few days now. i like that you can through up a decently designed page that pulls data in, in a few minute preview it right there. What i dont like is its reformating of my code, from cf. ud, seems not to understand some very basic list functions. but its pretty neat to slash out a few pages quickly. wont replace studio any time soon. -paul -Original Message- From: Francis NART [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 5:18 AM To: [EMAIL PROTECTED] Subject: Re: Cold Fusion Studio Vs Dreamweaver Ultradev Many many CFSCRIPTS in the the CFML code... I think that the purpose of this is to be able to switch from asp or Jsp to CFML for example but the code looks really strange to me. At 19:06 11/07/00 -0400, vous avez écrit: Hello All: I'm Currently evaluating ultradev for asp and cold fusion applications, anybody have any comments on ultradev I would appreciate any suggestions, comments, gripes ect.. thanks in adv. Dana E. Johnson Sr. Web Developer CIT VTF/Technology Financing Services [EMAIL PROTECTED] (904) 620-7458 - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: why is this happening?
That's interesting, because I had narrowed the fields down to one: the body field which of course contains commas(the data is email). How do I get around this? It's an Access database memo field. DJ "Dempsey, Timothy F." wrote: Doug, Could one of you values have a comma in it? That might make the database think it has more values than you intend. -- Tim Dempsey -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:06 AM To: Cold Fusion List Subject: why is this happening? Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Odd Question
Should your addtoken var be in the Application scope? That will assign the same CFID and CFTOKEN to all users... CF automatically creates Client.URLToken and Session.URLToken, similar to your assignment below, so you don't need to do that manually. You could try something like this: CFSET Session.Mytoken="#Session.URLToken#" CFIF IsDefined("Form.CustomerID") CFSET Session.Mytoken="#Session.URLToken##Form.CustomerID#" /CFIF Gene Kraybill --- "Chris Farrugia" [EMAIL PROTECTED]: I have an application.cfm and a form on a page. Now, if they fill in the form, they then have a CustomerID variable defined... in my application.cfm I have the following line: CFSET APPLICATION.ADDTOKEN = "cfid=#client.cfid#cftoken=#client.cftoken#" Now, how could I put the customerID to the end of the addtoken if and only if it exists? So it isn't there until they fill out the form... then on every page it is there...? How would I do this? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT This can be found out through other means though - they're actually running IIS4... therefore NT4 From this info you could run attack attempts to check vunerabilities, but that'd be illegal BTW, if you want to check what someone is running, I find this site very useful http://www.netcraft.com/whats Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Thumbnail tags
Dumb question, what are progressive jpegs? Bob Jpegs born after May 15, 1987... sorry. could not resist -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What are you using instead of IDENTITY...Part II
The true test of a key, is to think of a situation where you are asked to extract a subset of data (ie. set of master with all related details) into a new database with an identical structure. The test is met if you are able to perform the transition and maintain all relationships. On this score IDENTITY fails. Not to argue just for the sake of arguing, but yesterday I just moved most of the data in one database to another with a slightly different structure (including a slightly different degree of normalization). The tables in the previous database all contained IDENTITY fields with a couple minor exceptions. Although I understand the theory behind the arguments against IDENTITY fields, I maintain that real world applications do not support the theory in most situations. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: why is this happening
Ok first order of the day: Get Novell Groupwise off my computer, the email program on it IMHO sucks, attempting to type the body of my message in the subject, not very intuitive...and people wonder why MS Outlook dominates the market *sigh* Anyways, a partial insert is impossible the query would have simply aborted on this error message, this was just simploy a typo that stopped the query in its tracks. Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] [EMAIL PROTECTED] 07/12 9:06 AM Quite simple, count the amount of Fields, and the amount of values, and they aren't consistent you have 11 fields and 12 values, re-tool and try again! What was throwing me is that the data he had *right* was still being saved. I've been fortunate(?) to work with native drivers instead of ODBC, and this (or any other failure) would simply have discarded the whole query and inserted nothing - is this 'partial insert' a common behavior of ODBC drivers? Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFLOCK and server variables
Ok, I've seen that (in 4.01) I should use #application.applicationname# for the CFLOCK "name" when locking application variables; what do I use for locking server variables? --- Martin Herbener [EMAIL PROTECTED] Kentucky Department of Education -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: why is this happening?
Why partial data would be saved to the table is beyond me though. Maybe you weren't running things in a transaction and there was no rollback? Another query doing an insert? Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] [EMAIL PROTECTED] 07/12 8:05 AM Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Thumbnail tags
A progressive JPEG will display in the web browser in several passes, with more detail reveal with each pass. Programs like Photoshop allow you to specify the number of scans for the JPEG image you are creating. Sincerely, Shane Witbeck Webmaster -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:51 AM To: '[EMAIL PROTECTED]' Subject: RE: Thumbnail tags Dumb question, what are progressive jpegs? Bob -Original Message- From: ColdFusionKid [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:11 AM To: [EMAIL PROTECTED] Subject: Re: Thumbnail tags I'd use Jukka Manner's updated CFX_Image tag instead of the old CFX_GifGD tag. It has support for progressive jpegs as far as I can tell, it also has much more features. - Original Message - From: "Seth Petry-Johnson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 11, 2000 8:30 PM Subject: Re: Thumbnail tags I've been using cf_gifgd from the tag gallery works good for me, but progressive jpg's will break it. If anyone has any better solutions I'd like to know also. I too have been stuck with cfx_gifgd and its problems with progressive JPEGs. I've looked, but haven't found anything that is a good replacement. If anyone knows of a good alternative, I too would be very interested. However, I do know how to test for progressive JPEGs before resizing them. The problem is that when CFX_GIFGD is called to resize a progressive JPEG it causes the entire CF service to crash and restart, which is obviously a bad thing. I don't know enough about JPEGs (or the CFX code) to know why this is. To ensure that this won't happen, use CFX_GIFGD to read the file before you resize it. The READ action returns a series of variables about the image, one of which is the file type. If the image is a progressive JPEG the type variable will contain an empty string. Just wrap the resize action in a CFIF that checks the length of the type variable. For example: !--- check the file type --- CFX_GIFGD ACTION="read" FILE="#yourFile#" CFIF NOT Len(Trim(Variables.IMG_TYPE)) !--- progressive JPEG! put some sort of error message here --- CFELSE !--- image can be safely resized --- CFX_GIFGD ACTION="resize" blah blah /CFIF Just a little workaround I discovered. Hope it helps. Regards, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
searches failing...help.
Hi, Ive got myself a tiny problem...which should be a snap for you folks that are more skilled than myself right now... CFQUERY Name="knowledge" DataSource="ccmast" select id, entered_date, synopsis, knowledge from nxsknow where knowledge = '#search_string#' order by entered_date desc /CFQUERY this query will fail each and every time with the following error. [microsoft][ODBC SQL Server Driver][SQL Server]TEXT and IMAGE datatypes may not be used in the WHERE or HAVING clause, except with the LIKE predicate and the IS NULL predicate. HOWEVER when I change the WHERE statement to the following... where knowledge LIKE '#search_string#' I get no results. It doesn't matter what I enter as a variable. I should get something backshouldn't I ? The somewhat annoying part about this is if I change the where statement to the following where id = '#search_string#' and id is equal to some number...this query works...and pulls up a single record...or if I change the where statement to where synopsis = '#search_string#' and synopsis is equal to "site". It returns nothingit should return something because half the entries in this table half the word "site" in the field synopsis. And before you think that there's nothing in the table...there is plenty of data. What's up with this query...why is this happening ? Any clues ? Miles. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Form.Fieldnames Missing
While the form isn't only checkboxes or radio buttons this helps. Thanks, --Kat Katrina Chapman Consultant Ameriquest Mortgage Dan Haley [EMAIL PROTECTED] 07/12/00 08:51 AM Please respond to cf-talk To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] cc: Subject:RE: Form.Fieldnames Missing I can recreate the error if the only form elements that are named are checkboxes and radio buttons, and none of them have been checked or selected. At that point form.fieldnames is not defined in the action page. Any chance your form only has checkboxes and radio buttons? Dan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 8:37 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Form.Fieldnames Missing Is there a reason why the form.fieldnames field would not be passed in a form? I vaguely seem to recall that in some versions of CF prior to 4.5.x, if the ENCTYPE attribute of the form is set to "multipart/form-data", which is what you'd use for file uploads, FORM.FIELDNAMES wouldn't appear. Unfortunately, I can't test that theory, since I'm running 4.5.1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
Actually it's The future's so bright, I gotta wear shades! Just an FYI. --K Katrina Chapman Consultant Ameriquest Mortgage Greg Creedon [EMAIL PROTECTED] 07/12/00 08:54 AM Please respond to cf-talk To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] cc: Subject:RE: You know what would be really cool? I see! What a great idea. All of the tech staff and admins would have their Allaire Secret Decoder Rings(tm), available in Personal or Enterprise versions. Error says ODBC error? A quick flick of the dial and it's actually a syntax error! Zounds! a misplaced sign. The future is so bright, I need shades! Greg Creedon On Wed, 12 Jul 2000, Bryan Batchelder wrote: This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEC13.BA40F1D0 Content-Type: text/plain Or they have deliberately misinformed you in the error message :-) Not that the error is deliberate...but the information it is giving you could be deliberately wrong. I have done this in past systems I have worked on.and set up most of my UNIX boxes to give wrong profiling information (including information in errors). Just a thought. Its fun watching people try linux exploits on a solaris box...or vice versa - or making a linux box look like an NT box. Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:03 AM To: [EMAIL PROTECTED] Subject: RE: You know what would be really cool? It is truly a sad state of affairs isn't it? This sort of thing has been happening on a regular basis since Allaire first started hosting a website. All three of their main components, Corporate, Forums, and Beta sites, have gone down or produced errors that really make them look bad. The two general types that I have seen the most, and that speak volumes about their infrastructure/administration in my opinion, are related to performance/load and database management. Ironically enough, these are two of tenants of the Allaire Performance Tuning class, optimizing your code and your database. Another problem that this exposes is Allaire's attention to detail and security. You can learn a lot about a system by getting such error messages. It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT 3) Web root is on D:, seperate from the system root 4) Exact path to the customtags directory 5) Template name 6) Exact line of offending code 7) 'CustomTagsV65' may indicate that they have multiple versions in one tree. This may provide further opportunity if the system is breached. 8) Allaire doesn't monitor it's servers effectively 9) Allaire doesn't seem to take it's web presence seriously enough even though the product it sells is made for developing high-end, robust, data-driven, web sites (enought buzz words there?). All this provides is information, not vulnerabilities, but, it is a definite start in profiling the system, and all without having to send a single suspicious packet their way. Anyone who has spent time profiling systems will understand this. So if Allaire is this shoddy in protecting/maintaining their corporate site what's going on with the areas of the site that manage customer information? Steve p.s. I don't have anything against Allaire, I'm just calling it like I see it. -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] I think it would be really cool if you went to Allaire's website, searched for something and didn't get this: Error Diagnostic Information Error occurred in tag CFSEARCH Collection failed to open: AllaireWeb6SiteSearch The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in the template file D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESE ARCH.CFM. Date/Time: 07/11/00 22:55:58 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 63.203.119.82 HTTP Referer: http://www.allaire.com/search/index.cfm How do these guys expect to have people buy into this language when thier own site is constantly breaking? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit
RE: problem with primary key
Try running the SQL statement directly in the database to see what happens. -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: gregg Kachel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 9:07 AM To: [EMAIL PROTECTED] Subject: problem with primary key Hi, haveing a crisis here. Everything was working fine earlier, now all of a sudden when I try to do an update on my membership page I get the following error. SQL operation updated no rows. The SQL operation affected no rows.Either the Key value has changed or the row has been deleted. The primary key is id, and I can't figure out why it suddenly would stop working. The database and the program look fine. Any ideas what might be going on? Gregg -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFContent Problem.........
When I try to use CFContent to serve up an install program from an FTP directory through a web browser. If I just give an anchor to the URL, it works fine. However, the project manager wants the option of starting the file download via HTTP when the user goes to a particular page. The file is in a folder accessible to the webserver, the user IUSR_MACHINENAME (changed for security) has read access to the folder, and the server set up to allow CFCONTENT. However, when I try to access the file, I get "An error occurred while attempting to open the file. ... Windows NT error number 5" in the error message. It is only visible when I look at the RAW HTTP results. When it is opened in the web browser, this error isn't visible. I tried to do a NET HELPMSG ERRORNUMBER 5 in the command prompt, but the results were absolutely useless. If anyone can help, I would be appreciative. Russel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How to Count? or Record Count?
I could be totally wrong here but I'm assuming that tbl_SignUp.CreateDate is the time that they signed up. Am I right? If I am you could just do this cfquery name="rsSignedUP" datasource="practice" SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName, tbl_Employee.FirstName, tbl_Employee.Email, tbl_Class.ClassID, tbl_Class.ClassName, tbl_Class.ClassDate, tbl_SignUp.SignUpID, tbl_SignUp.SU_DateOfferdID, tbl_SignUp.SU_EmployeeID, tbl_SignUp.Completed, tbl_SignUp.CreateDate FROM tbl_Employee, tbl_Class, tbl_SignUp WHERE EmployeeID = SU_EmployeeID AND ClassID = SU_DateOfferdID AND ClassName = 'Human Resource Mgmt' ORDER BY tbl_Class.ClassDate, tbl_SignUp.CreateDate, #DefOrder# /cfquery This sort order would put the classes together, then put them in order by who signed up when, then whatever #DefOrder# is. Is that what you wanted? --K Katrina Chapman Consultant Ameriquest Mortgage Paul Ihrig [EMAIL PROTECTED] 07/12/00 09:13 AM Please respond to cf-talk To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] cc: Subject:How to Count? or Record Count? Ok this is going to sound a bit odd since i am not sure how to word it. i have my little query: [in my admin page for viewing who has signed up for the class] [[from dataview01.cfm]] cfquery name="rsSignedUP" datasource="practice" SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName, tbl_Employee.FirstName, tbl_Employee.Email, tbl_Class.ClassID, tbl_Class.ClassName, tbl_Class.ClassDate, tbl_SignUp.SignUpID, tbl_SignUp.SU_DateOfferdID, tbl_SignUp.SU_EmployeeID, tbl_SignUp.Completed, tbl_SignUp.CreateDate FROM tbl_Employee, tbl_Class, tbl_SignUp WHERE EmployeeID = SU_EmployeeID AND ClassID = SU_DateOfferdID AND ClassName = 'Human Resource Mgmt' ORDER BY #DefOrder# /cfquery Which is grabbing a list of employees which could have signed up for 1 class, given on 2 differnt dates. My problem is, that the class size needs to be limited to 25 people. This is stated on my main form. it also shows how many people are currently singed up for class 01 class 02. [[from signup01.cfm]] cfquery name="rsDate01" datasource="practice" SELECT SignUpID, SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 1 /cfquery cfquery name="rsDate02" datasource="practice" SELECT SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 2 /cfquery [[the display]] A limit of 25 spaces are available per class per day. You will be notified if you are selected for the class time. . cfoutput#rsDate01_total#/cfoutput people have signed up so far for cfoutput# LSDateFormat(rsDisplayDate01.ClassDate, ', DD, ') #/cfoutput.br bcfoutput#rsDate02_total#/cfoutputnbsp/b people for cfoutput# LSDateFormat(rsDisplayDate02.ClassDate, ', DD, ') #/cfoutput So, on the form i show how many have signed up. But on the admin page, i cant figure out how to show who has signed up in sequential order. Because on one admin page i have 2 seperate date/times they could sign up. Its not really abig deal. i would just like to know how to get the number of the last insert Total + 1 as the number that realates to the student who signed up.?? I know i should have used a sepereate table for each Class/time. mabey i will redo it from the ground up. But since it is 10 different classes with 2 times each, spread out over the next year. I wanted to be able to track Student/employees progress through this "Practice Manegment" class. lol no one will read this! Thanks if you do! -paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: pass variables
"janey smith" [EMAIL PROTECTED] i have a problem passing variables to an edit page, it passes the field pol_question fine but for the answer fields my loop is incorrect, it just reproduces the answers 5 times each. each answer is the ans_answer table is related to the pol_question through the pol_id, any help would be appreciated. Try consolidating your code, combining the hidden vars and the input fields into a single loop. You were getting 5 answers for each loop because loops do what they are supposed to do: they loop through an entire query set. I didn't take the time to fully decipher the page you're trying to build, but you ought to be able to build it with only one or two loops and a few lines of code. Something along these lines: CFLOOP QUERY="GetAnswers" input type="hidden" name="ans_id#GetAnswers.CurrentRow#" value="#GetAnswers.ans_id#" pAnswer #GetAnswers.CurrentRow#: input type="text" name="answer#GetAnswers.CurrentRow#" size="45" value="#GetAnswers.ans_Ans#" /CFLOOP Gene Kraybill LPW Associates Mansfield, PA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Thumbnail tags
Dumb question, what are progressive jpegs? In their own way, they're like interlaced GIFs The idea being that you get the "impression" of the image before the quality is loaded, so that you can see "roughly" what the image is before it loads fully Useful for absolutely HAUGE images, but pointless for those of less than 10Kb Hope this explains Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Writing Fixed Width TXT Files
A few months back there was a thread on writing out a fixed width txt file, I cannot seem to locate the emails. There were a few slick methods of doing this I believe. Does anyone have that email or can comment on ways of doing this. thanks,Adrian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Quite simple, co
Second thing for this morning: Switch back to caffeinated coffee (been trying to stay away from it) Run the query with debug enabled, and try and see the Query as it executes, this will give you information about the query and you can check for better syntax. Show me the results with debug enabled if you're stuck afterwards. Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] [EMAIL PROTECTED] 07/12 9:20 AM Gregory Harris: Quite simple, count the amount of Fields, and the amount of values, and they aren't consistent you have 11 fields and 12 values, re-tool and try again! Nope 12 and 12. You should try looking at the full sql that gets passed, check it for quotes etc What DB are you using??? ~Justin [EMAIL PROTECTED] 07/12 8:05 AM Why would this query: cfquery datasource="datasourcename" insert into emails( SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#' ); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Form.Fieldnames Missing
Is there a reason why the form.fieldnames field would not be passed in a form? ... I vaguely seem to recall that in some versions of CF prior to 4.5.x, if the ENCTYPE attribute of the form is set to "multipart/form-data", which is what you'd use for file uploads, FORM.FIELDNAMES wouldn't appear. Unfortunately, I can't test that theory, since I'm running 4.5.1. ... That's what we're running as well. Well then, I'm officially out of ideas. Is it possible that you're using some wacky browser, like any Mac browser? They've caused interesting problems in the past with difficulties in properly posting form data. Typically, when I run into some anomaly like this, I might try looking at the raw data being received by the server. You can use the Netcat utility to do this; it should take about five minutes to see what data you're getting, and compare it against what you should be getting. You can get Netcat at http://www.l0pht.com/~weld/. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEC29.DA889A70 Content-Type: text/plain; charset="iso-8859-1" Well, I wasn't suggesting thatthough it might be cool ;-) I just meant they may (or should) put fake data in the message elsewhere. Not the specific message 'Syntax Error on line: 'but maybe switch out the path and some other info. Maybe even server specific data. I know its far fetched.but you can't assume everything is true. They may be running their site on CF Linux! Yeah right. --b Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Greg Creedon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:55 AM To: '[EMAIL PROTECTED]' Subject: RE: You know what would be really cool? I see! What a great idea. All of the tech staff and admins would have their Allaire Secret Decoder Rings(tm), available in Personal or Enterprise versions. Error says ODBC error? A quick flick of the dial and it's actually a syntax error! Zounds! a misplaced sign. The future is so bright, I need shades! Greg Creedon On Wed, 12 Jul 2000, Bryan Batchelder wrote: This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEC13.BA40F1D0 Content-Type: text/plain Or they have deliberately misinformed you in the error message :-) Not that the error is deliberate...but the information it is giving you could be deliberately wrong. I have done this in past systems I have worked on.and set up most of my UNIX boxes to give wrong profiling information (including information in errors). Just a thought. Its fun watching people try linux exploits on a solaris box...or vice versa - or making a linux box look like an NT box. Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:03 AM To: [EMAIL PROTECTED] Subject: RE: You know what would be really cool? It is truly a sad state of affairs isn't it? This sort of thing has been happening on a regular basis since Allaire first started hosting a website. All three of their main components, Corporate, Forums, and Beta sites, have gone down or produced errors that really make them look bad. The two general types that I have seen the most, and that speak volumes about their infrastructure/administration in my opinion, are related to performance/load and database management. Ironically enough, these are two of tenants of the Allaire Performance Tuning class, optimizing your code and your database. Another problem that this exposes is Allaire's attention to detail and security. You can learn a lot about a system by getting such error messages. It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT 3) Web root is on D:, seperate from the system root 4) Exact path to the customtags directory 5) Template name 6) Exact line of offending code 7) 'CustomTagsV65' may indicate that they have multiple versions in one tree. This may provide further opportunity if the system is breached. 8) Allaire doesn't monitor it's servers effectively 9) Allaire doesn't seem to take it's web presence seriously enough even though the product it sells is made for developing high-end, robust, data-driven, web sites (enought buzz words there?). All this provides is information, not vulnerabilities, but, it is a definite start in profiling the system, and all without having to send a single suspicious packet their way. Anyone who has spent time profiling systems will understand this. So if Allaire is this shoddy in protecting/maintaining their corporate site what's going on with the areas of the site that manage customer information? Steve p.s. I don't have anything against Allaire, I'm just calling it like I see it. -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] I think it would be really cool if you went to Allaire's website, searched for something and didn't get this: Error Diagnostic Information Error occurred in tag CFSEARCH Collection failed to open: AllaireWeb6SiteSearch The error occurred while
Re: why is this happening?
It shouldn't matter what kind of field it is in the database. You need to escape your comma's. Try this. cfset message_body = Replace(query.BODY, ",", "Chr(44)", "ALL") cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#message_body#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery Then when you output it you do the opposite. --K Katrina Chapman Consultant Ameriquest Mortgage Douglas Jordon [EMAIL PROTECTED] 07/12/00 09:49 AM Please respond to cf-talk To: [EMAIL PROTECTED] cc: Subject:Re: why is this happening? That's interesting, because I had narrowed the fields down to one: the body field which of course contains commas(the data is email). How do I get around this? It's an Access database memo field. DJ "Dempsey, Timothy F." wrote: Doug, Could one of you values have a comma in it? That might make the database think it has more values than you intend. -- Tim Dempsey -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:06 AM To: Cold Fusion List Subject: why is this happening? Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: pass variables
i have a problem passing variables to an edit page, it passes the field pol_question fine but for the answer fields my loop is incorrect, it just reproduces the answers 5 times each. each answer is the ans_answer table is related to the pol_question through the pol_id, any help would be appreciated It appears that your query loops are resetting the value of 'ans_Ans' 'ans_ID' each through each iteration; therefore the value for each will end up set to the last value in the query each time. You might try using an index loop instead of a query loop, like so: !--- start replacement loop code --- cfLoop from="1" to="#GetPollDetails.recordCount#" index="i" !--- create a name for the current ans (i.e. 'Ans1') based on loop index --- cfSet currAns = 'Ans' i !--- assign current ans a value from matching query index --- cfSet '#currAns#' = getPollDetails.ans_Ans[i] !--- create a name for hidden form tag based on loop index --- cfSet currAnsID = 'ans_id' i input type="hidden" name="#currAnsID#" value="#getPollDetails.ans_id[i]#" /cfLoop !--- end replacement loop code --- This will replace all 5 of the loops in your current setup. A possible side benefit of this is that it'll create the variables for every row in the current query; of course, this might not be what you want, if your query is actually selecting a couple hundred rows... The rest of your output should remain the same. HTH Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What are you using instead of IDENTITY...Part II
- Primary Keys must be made from data elements within the row. Using a number generator to assign an integer value as a key is acceptable. - Since IDENTITY is not a real data element (it's an internal row pointer), it is NOT an appropriate key candidate. I must be missing something here. If you use a number generator to assign an integer value as a key, how is that different from an identity column, which is nothing more than an integer column which is generated using the number generator provided by the database itself? Isn't it still an arbitrary, surrogate value with no relation to the data it represents? There's nothing special about an identity column, except that the database figures out what the next value should be when a new record is inserted. It's simply a surrogate key rather than a natural key, but it's in the data, not separate from the data, when we use it. The true test of a key, is to think of a situation where you are asked to extract a subset of data (ie. set of master with all related details) into a new database with an identical structure. The test is met if you are able to perform the transition and maintain all relationships. On this score IDENTITY fails. I disagree. If I export some rows from a table, and matching rows from dependent tables, then put those rows in a new database, the key may no longer by defined by the system as an identity column, but it'll still be in the data as an integer column. As long as I extract complete rows, I'll extract the key, whether the key is natural or a surrogate key. I can assert this is true because I do it all the time. Again, there's no magic around identity columns; they're just integer columns. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEC2B.CCE3AED0 Content-Type: text/plain; charset="iso-8859-1" You could just as easily telnet to port 80 and type 'get' and get the same info. c:\telnet www.allaire.com 80 get HTTP/1.1 400 Bad Request Server: Microsoft-IIS/4.0 Date: Wed, 12 Jul 2000 18:07:05 GMT Content-Type: text/html Content-Length: 87 htmlheadtitleError/title/headbodyThe parameter is incorrect. /body /html Connection to host lost. But alas, this info can be changed tooat least under UNIX. --b Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 12:28 PM To: [EMAIL PROTECTED] Subject: RE: You know what would be really cool? It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT This can be found out through other means though - they're actually running IIS4... therefore NT4 From this info you could run attack attempts to check vunerabilities, but that'd be illegal BTW, if you want to check what someone is running, I find this site very useful http://www.netcraft.com/whats Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BFEC2B.CCE3AED0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: You know what would be really cool?/TITLE /HEAD BODY PFONT SIZE=3D2You could just as easily telnet to port 80 and type = 'get' and get the same info./FONT /P PFONT SIZE=3D2c:\gt;telnet www.allaire.com 80/FONT BRFONT SIZE=3D2get/FONT /P PFONT SIZE=3D2HTTP/1.1 400 Bad Request/FONT BRFONT SIZE=3D2Server: Microsoft-IIS/4.0/FONT BRFONT SIZE=3D2Date: Wed, 12 Jul 2000 18:07:05 GMT/FONT BRFONT SIZE=3D2Content-Type: text/html/FONT BRFONT SIZE=3D2Content-Length: 87/FONT /P PFONT = SIZE=3D2lt;htmlgt;lt;headgt;lt;titlegt;Errorlt;/titlegt;lt;/he= adgt;lt;bodygt;The parameter is incorrect. lt;/bodygt;/FONT BRFONT SIZE=3D2lt;/htmlgt;/FONT /P PFONT SIZE=3D2Connection to host lost./FONT /P PFONT SIZE=3D2But alas, this info can be changed tooat least = under UNIX./FONT /P PFONT SIZE=3D2--b/FONT /P PFONT SIZE=3D2/FONT BRFONT SIZE=3D2Bryan D. = Batcheldernbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Work: = 813-935-7100/FONT BRFONT SIZE=3D2Palm/Internet Developernbsp;nbsp; Home: = 727-547-1322/FONT BRFONT SIZE=3D2/FONT BRFONT SIZE=3D2ConnectWise, Inc. (www.ConnectWise.com)/FONT BRFONT SIZE=3D22803 West Busch Blvd, Suite 204/FONT BRFONT SIZE=3D2Tampa, FL 33618/FONT BRFONT SIZE=3D2/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Philip Arnold - ASP [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT= BRFONT SIZE=3D2Sent: Wednesday, July 12, 2000 12:28 PM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Subject: RE: You know what would be really = cool?/FONT /P BR PFONT SIZE=3D2gt; It may seem innocent enough but from this error = message you know:/FONT BRFONT SIZE=3D2gt;/FONT BRFONT SIZE=3D2gt; 1) Using IIS/FONT BRFONT SIZE=3D2gt; 2) .. therefore, using NT/FONT /P PFONT SIZE=3D2This can be found out through other means though - = they're actually running/FONT BRFONT SIZE=3D2IIS4... therefore NT4/FONT /P PFONT SIZE=3D2From this info you could run attack attempts to check = vunerabilities, but/FONT BRFONT SIZE=3D2that'd be illegal/FONT /P PFONT SIZE=3D2BTW, if you want to check what someone is running, I = find this site very/FONT BRFONT SIZE=3D2useful/FONT BRFONT SIZE=3D2A
RE: Studio: Any way to have File Open folder follow current file?
I use UltraEdit as my standard text editor and it has an option that allows you to "Use Active File Directory on File Open". This is very convenient. Is this possible in CF Studio? I can't find such an option. Why don't you just use the "Files" tab on the Resource window? The File/Open allows you to grab files that AREN'T in the current folder Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: pass variables
i have a problem passing variables to an edit page, it passes the field pol_question fine but for the answer fields my loop is incorrect, it just reproduces the answers 5 times each. each answer is the ans_answer table is related to the pol_question through the pol_id, any help would be appreciated, cf_snip CFSET Ans1="" CFSET Ans2="" CFSET Ans3="" CFSET Ans4="" CFSET Ans5="" !--- get first record --- CFLOOP QUERY="GetAnswers" CFSET Ans1=#ans_Ans# input type="hidden" name="ans_id1" value="#ans_id#" /CFLOOP !--- get second record etc the cfloop may not work as coded! --- CFLOOP QUERY="GetAnswers" CFSET Ans2=#ans_Ans# input type="hidden" name="ans_id2" value="#ans_id#" /CFLOOP CFLOOP QUERY="GetAnswers" CFSET Ans3=#ans_Ans# input type="hidden" name="ans_id3" value="#ans_id#" /CFLOOP CFLOOP QUERY="GetAnswers" CFSET Ans4=#ans_Ans# input type="hidden" name="ans_id4" value="#ans_id#" /CFLOOP CFLOOP QUERY="GetAnswers" CFSET Ans5=#ans_Ans# input type="hidden" name="ans_id5" value="#ans_id#" /CFLOOP Erm, you've ASKED it to reproduce the answers multiple times You should try something like this: CFLOOP QUERY="GetAnswers" input type="hidden" name="ans_id#CurrentRow#" value="#ans_id#" /CFLOOP That'll pass through as many "Ans_IDn" as you need, and not fix it to 5 HTH Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Express and SQL 7
I know CF Express does not support SQL Server, and if you set up a SQL 7 data source in CF Administrator, it fails to connect. So, I'm wondering if anyone has figured out a way to use a SQL 7 DB w/ CF Express. Can you just put all the necessary attributes in the CFQUERY tag to override the data source settings in CF Administrator? Or, what about OLE-DB? Can you access the SQL 7 DB through an OLE-DB provider? I haven't had time to test this, so if you've tried to make a SQL 7 DB work w/ CF Express, you're feedback would be greatly appreciated. If all of your databases are SQL 7, but not all your servers need a full-blown CF Server, it sure would be nice to install CF Express on the ones that don't need Professional/Enterprise. Thanks in advance, Byron Stuart Lead Application Developer Data Critical Corp. http://www.unwireddr.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Any free verity search engines????
Anyone have a search engine they did to index a website. Open source must be a must so I can plug my look in feel into it. Got to get a search out ASAP and was hoping to not have to code it because of time constraints. Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFEXECUTE Problems
Dave and all, I've gotten several helpful replies now but I'm still a little worried here. Its starting to sound like this isn't a very good approach to my goal. I've added some comments and thoughts inline below: Is your CF service running as localsystem? Yes, it is. I tested this on my development machine, running Win2K and CF 4.5.1. I'm using the standard security configuration (essentially, no security); this might be your problem, if you've modified your user rights and security configuration in one way or another. I've attempted testing this on several similar configurations, both my development and staging servers and am not getting successful results. I've tried including a timeout here as well with no luck. My development and staging machines are both running 4.5.1 and NT 4 SP5 (maybe 4.0 is the problem). If I add an outputfile param on the tag, the 'user /add' command produces no result (empty text file). If I issue a 'user' command, it produces an enumeration list in the file, but also the ambigous 'one or more errors' message. If I issue a different command like 'view', it enumerates all the machines on the domain and reports 'operation completed successfully'. If you're trying to manipulate users, rights, etc. you might want to take a look at ADSI, which you can use through COM. CFOBJECT isn't really good at doing this, but it's pretty easy to write wrapper objects, and call those objects to do your ADSI tasks. I've used Windows Script Components for this. Justing MacCarthy also suggested this route but this is turning into more complexity than I have time or resources for right now. I was also provided a good link to Lewis Sellers usermanager suite which appears to contain a bunch of CFX's that will do exactly what I need. On a tangent, can anyone recommend an FTP server that would integrate well with CF automation? The ultimate goal here is to automate the creation of user accounts and access rights. Currently, I'm trying to add the user to an NT domain (duh) and then I'm assigning server permissions at the file level using xcacls.exe (this works just dandy using CFEXECUTE). I've had few problems using IIS's web server for this. Could you elaborate on this a little for me? Thanks, Ryan Ryan Hill, MCSE Director of Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
saving queries
Hi i know there is a way to do this, i just dont know the syntax. i would like to save a query result into a variable cfset var = query.resultset can anyone help me with the proper way to do this?? Thanx -Eli- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: pass variables
when you loop through the query, you only need to do it once - thats why its a called a loop...so instead of all those CFLOOPs and the cfoutput query="getanswers", try: !--- set a counter to use in the names of the variables --- CFSET variables.count = 0 CFOUTPUT QUERY="GetAnswers" !--- increase the counter for each iteration of the loop --- CFSET variables.count = variables.count+1 !--- now use variables.count to name your form fields --- Answer#variables.count#: INPUT TYPE="text" NAME="answer#variables.count#" SIZE="45" VALUE="#GetAnswers.ans_Ans#" INPUT TYPE="hidden" NAME="ans_id#variables.count#" VALUE="#GetAnswers.ans_id#" BR /CFOUTPUT Bert Dawson -Original Message- From: janey smith [mailto:[EMAIL PROTECTED]] Sent: 12 July 2000 17:01 To: [EMAIL PROTECTED] Subject: pass variables i have a problem passing variables to an edit page, it passes the field pol_question fine but for the answer fields my loop is incorrect, it just reproduces the answers 5 times each. each answer is the ans_answer table is related to the pol_question through the pol_id, any help would be appreciated, html head titleUpdate Poll/title /head body bgcolor="#CC" link="#996633" vlink="#CC9966" alink="#CC9966" !--- CFIF ISDEFINED("#url.Pol_id#") No Pol_id Passed! /CFIF --- CFQUERY NAME="GetPollDetails" DATASOURCE="quickpoll" SELECT pol_ID, pol_Question, pol_Category, pol_Status FROM pol_Poll WHERE pol_ID = #URL.PollID# /CFQUERY CFQUERY NAME="GetAnswers" DATASOURCE="quickpoll" SELECT ans_ID,ans_Ans FROM ans_Answer A WHERE ans_pol_ID = #url.PollID# /CFQUERY !-- Display HTML FORM Here with values filled -- cfoutput query="getpolldetails" form method="POST" action="PollUpdate.cfm" !--- textarea rows="5" name="MainText" cols="45" --- pnbsp;/ppPoll: input type="Text" textarea rows="5" cols="45" name="pol_question" size=40 value="#pol_question#" !--- INPUT NAME="question" SIZE=10 VALUE="#pol_question#" --- !--- input type="hidden" name="pol_ID" value="#url.pol_id#" ---/p/cfoutput CFSET Ans1="" CFSET Ans2="" CFSET Ans3="" CFSET Ans4="" CFSET Ans5="" !--- get first record --- CFLOOP QUERY="GetAnswers" CFSET Ans1=#ans_Ans# input type="hidden" name="ans_id1" value="#ans_id#" /CFLOOP !--- get second record etc the cfloop may not work as coded! --- CFLOOP QUERY="GetAnswers" CFSET Ans2=#ans_Ans# input type="hidden" name="ans_id2" value="#ans_id#" /CFLOOP CFLOOP QUERY="GetAnswers" CFSET Ans3=#ans_Ans# input type="hidden" name="ans_id3" value="#ans_id#" /CFLOOP CFLOOP QUERY="GetAnswers" CFSET Ans4=#ans_Ans# input type="hidden" name="ans_id4" value="#ans_id#" /CFLOOP CFLOOP QUERY="GetAnswers" CFSET Ans5=#ans_Ans# input type="hidden" name="ans_id5" value="#ans_id#" /CFLOOP cfoutput query="getanswers" pAnswer1: input type="text" name="answer1" size="45" value="#Ans1#" br Answer2: input type="text" name="answer2" size="45" value="#Ans2#" br Answer3: input type="text" name="answer3" size="45" value="#Ans3#" br Answer4: input type="text" name="answer4" size="45" value="#Ans4#" br Answer5: input type="text" name="answer5" size="45" value="#Ans5#" br /p/cfoutput pStatus: select name="status" size="1" option value="All"All/option option value="New"New/option option value="Active"Active/option option value="Archive"Archive/option option value="Hide"Hide/option /select Category: select name="category" size="1" option value="All"All/option option value="sports"sports/option option value="current affairs"current affairs/option option value="general"General/option /select !--- Above need code to select the correct value should create function or just use IFS Poll Type: --- INPUT name=polltype type=radio value=Y Yes/No INPUT name=polltype type=radio value=M Multiple Choice /p p input type="submit" value="Update Poll" name="submit"/form /p /body /html __ __ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to Count? or Record Count?
Ok. I am able to get one class id inserted besed on the record count. My problem now is at the bottom of this page. it needs to be conditional on wether the insert is for date/time 01 or date/time 02. But how is my form suposed to know what date has been selected befor the actual submit button is hit? i need a CFIF ClassID = 1 input type="hidden" name="SU_Number1" value="cfoutput#rsDate01_total# + 1/cfoutput" CFELSE input type="hidden" name="SU_Number2" value="cfoutput#rsDate02_total# + 1/cfoutput" /CFIF /CFIF any help would be awsome! thanks -paul !--- CODE BELOW --- cfquery name="rsClass" datasource="practice" SELECT ClassID, ClassName, ClassTeacher, ClassEmail, ClassDescription, ClassRoom, ClassStartTime, ClassEndTime, ClassDate FROM tbl_Class WHERE ClassID = 1 OR ClassID = 2 /cfquery cfquery name="rsDate01" datasource="practice" SELECT SignUpID, SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 1 /cfquery cfquery name="rsDate02" datasource="practice" SELECT SU_DateOfferdID FROM tbl_SignUp WHERE SU_DateOfferdID = 2 /cfquery select name="slctDate" cfloop query="rsClass" option value="cfoutput#rsClass.ClassID#/cfoutput" selectedcfoutput # LSDateFormat(rsClass.ClassDate, ', DD, ') # /cfoutput/option /cfloop /select td width="123" font face="Arial, Helvetica, sans-serif" input type="hidden" name="SU_Number1" value="cfoutput#rsDate01_total# + 1/cfoutput" input type="hidden" name="SU_Number2" value="cfoutput#rsDate02_total# + 1/cfoutput" /font/td -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Quite simple, co
My count shows 12 and 12. Here it is again, illustrated: cfquery datasource="datasourcename" insert into emails( 1 SUBJECT, 2 FROMX, 3 TO, 4 DATEX, 5 BODY, 6 ATTACHMENTS, 7 CC, 8 MESSAGENUMBER, 9 ATTACHMENTFILES, 10 REPLYTO, 11 HEADER, 12 TIMEx) values ( 1 '#query.SUBJECT#', 2 '#FROMX#', 3 '#query.TO#', 4 #DATEy#, 5 '#query.BODY#', 6 '#ATTACHMENTSX#', 7 '#query.CC#', 8 '#query.MESSAGENUMBER#', 9 '#ATTACHMENTFILESX#', 10 '#query.REPLYTO#', 11 '#query.HEADER#', 12 '#TIMEx#'); Brandon Whitaker wrote: Quite simple, count the amount of Fields, and the amount of values, and they aren't consistent you have 11 fields and 12 values, re-tool and try again! What was throwing me is that the data he had *right* was still being saved. I've been fortunate(?) to work with native drivers instead of ODBC, and this (or any other failure) would simply have discarded the whole query and inserted nothing - is this 'partial insert' a common behavior of ODBC drivers? Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
As I said, this information is given to you without having to do any work. It is rather trivial to profile the outside interfaces of a server but, when a company makes itself stick out by having things like this happen on a regular and long term basis it can make that company more susceptible to intrusion. If nothing else it makes them look bad. It's a legitimate concern when a company doesn't use their own product to set a positive and impressive example. But then, Allaire has historically put security on the back burner in their products. I remember when Allaire first introduced the web based administrator in CF, 2.0 or 3.0, without requiring any authentication or authorization at all. You could go to any CF-based site and shut it down, 'click'. Their response was along the lines of, "but, but ... that's just not fair." As a matter of fact, I met and talked to Jeremy Allaire during this period and questioned him on this matter and he told me flat out that during the development cycle security was definitely put on a back burner to features and time schedule. This business philosophy continues as evidenced by the security holes in 4.x. Microsoft endures unending criticism for its philosophy of features before security, and Sun has been blasted for various holes in the JRE and Sandbox architectures. Where's the outcry to Allaire? People want to use CF to create Internet environments that form the foundation of e-commerce but, don't seem overly concerned about the security of the product until AFTER someone exploits it. I say "hats off" to RFP, Matt Chapman, and the others who have exposed weaknesses in Allaire's products. At least they take the time to look. Steve -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 12:28 PM To: [EMAIL PROTECTED] Subject: RE: You know what would be really cool? It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT This can be found out through other means though - they're actually running IIS4... therefore NT4 From this info you could run attack attempts to check vunerabilities, but that'd be illegal BTW, if you want to check what someone is running, I find this site very useful http://www.netcraft.com/whats Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Find a date from a given date
How can I find the date 180 days from a give date? For example, if I am given the date 05/16/00, I want to return the date of 11/16/00. I have tried using DateDiff for a while, but I do not think it will work. checkdate = 05/16/00 #evaluate(180 + DateDiff("d",now(),checkdate.odr_date))# gives me the answer of 123, but I would like the date. Try variation of, but no luck. Thanks in advance. Jacob -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You know what would be really cool?
Deliberate obfuscation of environment information is a legitimate security technique but, I have never seen this used on debug information. If nothing else, you severely hamper your developers ability to fix problem quickly and effectively. The type of information in this error message combined with the fact that their sites have been throwing errors since inception lead me to believe that obfuscation is not being used here. Also, I've talked with their web team before regarding various issues and the problem always ends up being related to the error message that is thrown. Steve -Original Message- From: Greg Creedon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:55 AM To: '[EMAIL PROTECTED]' Subject: RE: You know what would be really cool? I see! What a great idea. All of the tech staff and admins would have their Allaire Secret Decoder Rings(tm), available in Personal or Enterprise versions. Error says ODBC error? A quick flick of the dial and it's actually a syntax error! Zounds! a misplaced sign. The future is so bright, I need shades! Greg Creedon On Wed, 12 Jul 2000, Bryan Batchelder wrote: This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEC13.BA40F1D0 Content-Type: text/plain Or they have deliberately misinformed you in the error message :-) Not that the error is deliberate...but the information it is giving you could be deliberately wrong. I have done this in past systems I have worked on.and set up most of my UNIX boxes to give wrong profiling information (including information in errors). Just a thought. Its fun watching people try linux exploits on a solaris box...or vice versa - or making a linux box look like an NT box. Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:03 AM To: [EMAIL PROTECTED] Subject: RE: You know what would be really cool? It is truly a sad state of affairs isn't it? This sort of thing has been happening on a regular basis since Allaire first started hosting a website. All three of their main components, Corporate, Forums, and Beta sites, have gone down or produced errors that really make them look bad. The two general types that I have seen the most, and that speak volumes about their infrastructure/administration in my opinion, are related to performance/load and database management. Ironically enough, these are two of tenants of the Allaire Performance Tuning class, optimizing your code and your database. Another problem that this exposes is Allaire's attention to detail and security. You can learn a lot about a system by getting such error messages. It may seem innocent enough but from this error message you know: 1) Using IIS 2) .. therefore, using NT 3) Web root is on D:, seperate from the system root 4) Exact path to the customtags directory 5) Template name 6) Exact line of offending code 7) 'CustomTagsV65' may indicate that they have multiple versions in one tree. This may provide further opportunity if the system is breached. 8) Allaire doesn't monitor it's servers effectively 9) Allaire doesn't seem to take it's web presence seriously enough even though the product it sells is made for developing high-end, robust, data-driven, web sites (enought buzz words there?). All this provides is information, not vulnerabilities, but, it is a definite start in profiling the system, and all without having to send a single suspicious packet their way. Anyone who has spent time profiling systems will understand this. So if Allaire is this shoddy in protecting/maintaining their corporate site what's going on with the areas of the site that manage customer information? Steve p.s. I don't have anything against Allaire, I'm just calling it like I see it. -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] I think it would be really cool if you went to Allaire's website, searched for something and didn't get this: Error Diagnostic Information Error occurred in tag CFSEARCH Collection failed to open: AllaireWeb6SiteSearch The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in the template file D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESE ARCH.CFM. Date/Time: 07/11/00 22:55:58 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 63.203.119.82 HTTP
Re: Quite simple, co
Thanks. Memo field in an Access database. DJ "Justin v0.9 MacCarthy" wrote: Gregory Harris: Quite simple, count the amount of Fields, and the amount of values, and they aren't consistent you have 11 fields and 12 values, re-tool and try again! Nope 12 and 12. You should try looking at the full sql that gets passed, check it for quotes etc What DB are you using??? ~Justin [EMAIL PROTECTED] 07/12 8:05 AM Why would this query: cfquery datasource="datasourcename" insert into emails( SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#' ); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.