Re: SQL Server 2k - query from URL
Sounds very insecure to me. I could see a use for backend xml type stuff, but one would have to be super lazy. I think this would be more for the dba's who are not familiar with CF or it's like. jon - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 2:48 AM Subject: OT: SQL Server 2k - query from URL I just read an article in the December 2000 issue of WebTechniques, "Plug in to SQL Server 2k," that says you can make a database query from a URL. "One of the cool features of SQL Server 2000 is that you can query the database through a web connection. That is, you can create an association within your web server that allows you to interact with SQL Servers. Start by making a new virtual directory within your web server and associate that directory with the physical database. You can do this by using the IIS Virtual Directory Manager for SQL, or programatically using the SQL Server Object Model. Once you've created the associations, you can pass a SQL query directly in a URL and retrieve data through a web connection. For example, I can use the following URL to retrieve all records from the invoice table: www.beyondhtml.com/db?sql=SELECT+*+FROM+invoice You can enter this URL in the location bar, but you're more likely to enter the query in a form and have the form's action page construct the URL and redirect to it. The article goes on to discuss how you can retrieve the results as XML data. You can also execute stored procedures this way. I don't use SQL Server, but this sounds interesting. -David YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
OT: Blocking s.o. from utilize open SMTP-Ports ( was Blocking IPs )
Speaking of blocking. Does s.o. know of a blocking SW which blocks one IP (or several IPs) to prevent that s.o. uses the open SMTP-Mail-Server ? My Mail-server doesn't provide this feature or only on a domain-basis. But I want to use it for a static server IP. Uwe - Original Message - From: "Mike Sullivan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Montag, 6. November 2000 23:54 Subject: RE: Blocking IPs -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Juan, You could block an intruder at your web server with the facilities of the httpd software, the server's tcp/ip features, you can also do it from CF (but you would have to wait for the intruder to request a Cf template... maybe you don't want to wait that long!). There are a lot of inetd sorts of security that depend on the platform you are using. The best (fastest, most robust and a goodie that is designed for it) would be at your firewall/router. You will shortly find that you need to see your site in the context of a greater security policy. Balance that with why you have a web site and what you keep there }:/. Formulate a real security policy and put it to work. Is your abuser always from the same IP address? Then report it to the upstream ISP and help protect the field. OTOH, a dial up account is easy to setup and abusive nut cases are very fond of them as it costs them nothing. Do you want to catch this black hat in the act? Put up a honey pot and attract all kinds of critters. But really, think about what you do with your server and get a working policy, firewall, router, etc. Get some books, investigate a DMZ, encryption etc. Visit CERT, Security Focus, l0pth and others. Enjoy, but remember, your not in Kansas any more. Mike - -Original Message- From: Juan Andres Alvarez Valenzuela [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 8:30 AM To: CF-Talk Subject: Blocking IPs Hello everyone, Someone has experience in blocking the access to some IP number in CF ? We have a potential information robber and we are trying to block him. ideas? ~Juandres - -- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com iQA/AwUBOgc2K3YFmKomMlANEQJTLQCeJuiwku1xHTP+c3vCtLOaa72ZUnMAn1Y0 3QkmOUPy9j9RmrwsCSdAMzTS =Qopx -END PGP SIGNATURE- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: [Cached Queries]
On 11/11/00, pan penned: As a final test to see if reformatted sql affects caching I repeated A B with the difference that afetr a restart I excluded the reformatted sql call from the template but included it within B. Result is that Bud is absolutely right. My mistake was that I have a machine that almost never needs a restart. :) Another thing that I noticed and surprised me. When setting up the queries, I ran them once, then of course even the different on was cached. So I changed the name of the query to run it fresh but they all came back cached again. So, to run them fresh, I had to add product_name to the select statement. Seems that the name of the query doesn't matter. Just the structure/datasource combination. -- 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Blocking s.o. from utilize open SMTP-Ports ( was Blocking IPs )
BlackIce should suffice, it will actually warn you and log smtp relay attempts. At which point you can block the ip. jon - Original Message - From: "CF-Talk" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 4:43 AM Subject: OT: Blocking s.o. from utilize open SMTP-Ports ( was Blocking IPs ) Speaking of blocking. Does s.o. know of a blocking SW which blocks one IP (or several IPs) to prevent that s.o. uses the open SMTP-Mail-Server ? My Mail-server doesn't provide this feature or only on a domain-basis. But I want to use it for a static server IP. Uwe - Original Message - From: "Mike Sullivan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Montag, 6. November 2000 23:54 Subject: RE: Blocking IPs -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Juan, You could block an intruder at your web server with the facilities of the httpd software, the server's tcp/ip features, you can also do it from CF (but you would have to wait for the intruder to request a Cf template... maybe you don't want to wait that long!). There are a lot of inetd sorts of security that depend on the platform you are using. The best (fastest, most robust and a goodie that is designed for it) would be at your firewall/router. You will shortly find that you need to see your site in the context of a greater security policy. Balance that with why you have a web site and what you keep there }:/. Formulate a real security policy and put it to work. Is your abuser always from the same IP address? Then report it to the upstream ISP and help protect the field. OTOH, a dial up account is easy to setup and abusive nut cases are very fond of them as it costs them nothing. Do you want to catch this black hat in the act? Put up a honey pot and attract all kinds of critters. But really, think about what you do with your server and get a working policy, firewall, router, etc. Get some books, investigate a DMZ, encryption etc. Visit CERT, Security Focus, l0pth and others. Enjoy, but remember, your not in Kansas any more. Mike - -Original Message- From: Juan Andres Alvarez Valenzuela [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 8:30 AM To: CF-Talk Subject: Blocking IPs Hello everyone, Someone has experience in blocking the access to some IP number in CF ? We have a potential information robber and we are trying to block him. ideas? ~Juandres - -- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com iQA/AwUBOgc2K3YFmKomMlANEQJTLQCeJuiwku1xHTP+c3vCtLOaa72ZUnMAn1Y0 3QkmOUPy9j9RmrwsCSdAMzTS =Qopx -END PGP SIGNATURE- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
PCodeDocumentNodeImp::validateSelf
What is that? It's giving me an error message on a custom tag (regular cf_ tag not a C++) on one site and not others and it never has before. PCodeDocumentNodeImp::validateSelf Nothing like an error message in English! Cripes! -- 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: RDS and NT holding a lock on a file
If anyone has *any* info on how to eliminate this error message, please let me know. I just can't t-t-t-take it any more *sob* *sob* -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 08 November 2000 16:22 To: CF-Talk Subject: RDS and NT holding a lock on a file There was a thread a while ago about NT (I think) holding a -- It's actually an IIS thing, as someone mentioned -- lock on a file for 60 seconds. I'm finding if request a .cfm file in a browser and then try and open the same file via RDS in Studio, Studio throws this error: Error attempting to read data from file F:/pathtofile/file.cfm P Error = There was a sharing violation. If you click OK, after about a minute you can open the file and edit away. We're not having this problem with other servers and our network admin has just turned off "Keep Alives" on the server in question but no dice. Any suggestions? This is driving me mad (you want a file? wait a minute, then you can have it ;-). -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
country by IP?
Is there a tag or anyway for CF to figure out the country origin of an IP address? My stat server does it just fine, and so I know it can be done! Thanks for any pointers. Eric J Hoffman, MAIP Director of Internet Development Small Dog Design Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: [Cached Queries]
They are cached by name, search parameters, and also by the query structure itself. So SELECT product_name FROM products and SELECT product_name FROM products would be read as 2 separate queries because the structure is different, even if they are named the same. Oh I see - didn't realise that. Where it will also help, in addition to static queries, is if you have a query that returns many items and you are doing next'n records. Every time the user clicks to show the next startrow/maxrows, the database will not be hit again and it will speed things up considerably. Excellent. I basically have 2 queries that both return large amounts of records - the first being as you describe above - however the second is an interesting dilema. I have a table called Locations, with "County" and "Town." Using the cool TwoSelectsRelated tag, I'm populating both boxes (users choose a county - and then a town). However with a current town list of over 1600, and due to the fact that TwoSelectsRelated loads both columns of the table in their entirity, this takes *ages* to download. Using TwoSelectsRelated is by far the nicest option available - but unfortunately I might have to change. Hopefully caching the query will speed things up a little anyhow.. Cheers, Will Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: [Cached Queries]
On 11/12/00, W Luke penned: Excellent. I basically have 2 queries that both return large amounts of records - the first being as you describe above - however the second is an interesting dilema. I have a table called Locations, with "County" and "Town." Using the cool TwoSelectsRelated tag, I'm populating both boxes (users choose a county - and then a town). However with a current town list of over 1600, and due to the fact that TwoSelectsRelated loads both columns of the table in their entirity, this takes *ages* to download. Using TwoSelectsRelated is by far the nicest option available - but unfortunately I might have to change. Hopefully caching the query will speed things up a little anyhow. I tried using it in my shopping cart also for countries and states/territories. It was dreadfully slow, because of the huge amount of javascript code that had to be loaded, and didn't work at times probably due to the same thing. I ended up just going to an extra screen to choose the state based on the country. An extra click, but still much quicker. -- 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: [Cached Queries]
I tried using it in my shopping cart also for countries and states/territories. It was dreadfully slow, because of the huge amount of javascript code that had to be loaded, and didn't work at times probably due to the same thing. I ended up just going to an extra screen to choose the state based on the country. An extra click, but still much quicker. Yup this is what I've done for some of the site - as you say, an extra click, but much much quicker. Will -- Coming soon: http://www.LocalBounty.com Local Classified Advertising for the UK Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: RDS and NT holding a lock on a file
I have the same problem on occasion, sometimes if I have the file open in my browser at the same time - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 10:03 AM Subject: RE: RDS and NT holding a lock on a file If anyone has *any* info on how to eliminate this error message, please let me know. I just can't t-t-t-take it any more *sob* *sob* -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 08 November 2000 16:22 To: CF-Talk Subject: RDS and NT holding a lock on a file There was a thread a while ago about NT (I think) holding a -- It's actually an IIS thing, as someone mentioned -- lock on a file for 60 seconds. I'm finding if request a .cfm file in a browser and then try and open the same file via RDS in Studio, Studio throws this error: Error attempting to read data from file F:/pathtofile/file.cfm P Error = There was a sharing violation. If you click OK, after about a minute you can open the file and edit away. We're not having this problem with other servers and our network admin has just turned off "Keep Alives" on the server in question but no dice. Any suggestions? This is driving me mad (you want a file? wait a minute, then you can have it ;-). -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Mixing ASP and CF on a server
--=_1193947==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed I missed the reply to this question and have the same problem. Can CF and ASP run simultaneously on the same server. If so, what are the disadvantages? Harry At 11:21 AM 11/7/00, you wrote: Our company just purchased a small application that they want integrated into our exisiting CF driven site. The software runs on ASP and SQL. Obviously to do this properly, we would have to have ASP and CF running on the same server, (we only have one...) and either have a page with some CF for our headers and then the rest ASP, or we would have to have a page that is ASP and static headers/footers. Either way, CF and ASP would have to be active on the server at the same time. Ive heard rumors that this is a "Really Bad Idea." Has anyone had experience trying to set somthing like this up? Thanks, Jacob Ezzell Web Developer Healthwell.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Harry MillerDirector Service Bureau i:FAO of North America http://www.quixdata.com 2000 Crow Canyon Pl, #185 http://www.ifao.net San Ramon, CA 94583 Ph: 925-244-6622 Ext. 236 E-Mail: [EMAIL PROTECTED] Fax: 925-244-1095 __ __ Harry MillerDirector Service Bureau i:FAO of North America http://www.quixdata.com 2000 Crow Canyon Pl, #185 http://www.ifao.net San Ramon, CA 94583 Ph: 925-244-6622 Ext. 236 E-Mail: [EMAIL PROTECTED] Fax: 925-244-1095 __ --=_1193947==_.ALT Content-Type: text/html; charset="us-ascii" html blockquote type=cite class=cite citeI missed the reply to this question and have the same problem.nbsp; Can CF and ASP run simultaneously on the same server.nbsp; If so, what are the disadvantages?br br Harrybr br At 11:21 AM 11/7/00, you wrote:br blockquote type=cite class=cite citeOur company just purchased a small application that they want integratedbr into our exisiting CF driven site.nbsp; The software runs on ASP and SQL.br Obviously to do this properly, we would have to have ASP and CF running onbr the same server, (we only have one...) and either have a page with some CFbr for our headers and then the rest ASP, or we would have to have a page thatbr is ASP and static headers/footers.nbsp; Either way, CF and ASP would have to bebr active on the server at the same time.nbsp; Ive heard rumors that this is abr quot;Really Bad Idea.quot;nbsp; Has anyone had experience trying to set somthing likebr this up?br br Thanks,br br Jacob Ezzellbr Web Developerbr Healthwell.combr br br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion.com//abr Unsubscribe: a href="http://www.houseoffusion.com/index.cfm?sidebar=lists" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=lists/a or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] /blockquotebr __br Harry Millerx-tabnbsp;nbsp;nbsp;nbsp;/x-tabx-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabx-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabx-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabDirector Service Bureaubr i:FAO of North Americax-tabnbsp;nbsp;/x-tabx-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabx-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-taba href="http://www.quixdata.com/" eudora="autourl"font color="#FF"uhttp://www.quixdata.com/a/u/font br 2000 Crow Canyon Pl, #185x-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabx-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-taba href="http://www.ifao.net/" eudora="autourl"http://www.ifao.net/a br San Ramon, CA 94583x-tabnbsp;nbsp;nbsp;nbsp;nbsp;/x-tabx-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabx-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabPh:nbsp; 925-244-6622 Ext. 236 br E-Mail: [EMAIL PROTECTED]x-tabnbsp;/x-tabx-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabFax: 925-244-1095br __/blockquote x-sigsepp/x-sigsep __br Harry
Re: Mixing ASP and CF on a server
- Original Message - From: "Harry Miller" [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 5:38 PM I missed the reply to this question and have the same problem. Can CF and ASP run simultaneously on the same server. If so, what are the disadvantages? Yes they can - but I would question the advisability of it. Not so long back I had a set of services running on a server - 95% of which was CF, and 5% ASP - a legacy application. That ASP application - which was efficiently written in VBScript - caused numerous problems with resource usage, and frequently crashed_all_IIS services. The CF apps behaved impeccably. If you must run ASP - I suggest you give it it's own server. Adrian Cooper. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CFMAIL Problems
I have an application that uses CFMAIL that worked perfectly with ColdFusion Server v4.0.1.0. I recently upgraded my server to v4.5.1 with SP1. Now 10 to15% of the emails are moved to the "UNDELIVR" folder and the mail.log shows the following message: SMTP server replied "Communication failure with mail server. I developed a routine to move the files back to the "SPOOL" folder so that they could be resent. The log file shows that all files are ultimately sent, but 1 or 2 emails out of 6 is lost and are never received. Has anyone run into this problem and come up with a solution? Gary Groomer Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CFMAIL Problems
Are you specifying the SERVER attribute? - Original Message - From: "Gary Groomer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 11:43 AM Subject: CFMAIL Problems I have an application that uses CFMAIL that worked perfectly with ColdFusion Server v4.0.1.0. I recently upgraded my server to v4.5.1 with SP1. Now 10 to15% of the emails are moved to the "UNDELIVR" folder and the mail.log shows the following message: SMTP server replied "Communication failure with mail server. I developed a routine to move the files back to the "SPOOL" folder so that they could be resent. The log file shows that all files are ultimately sent, but 1 or 2 emails out of 6 is lost and are never received. Has anyone run into this problem and come up with a solution? Gary Groomer -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CFMAIL Problems
Yes! - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 12:01 AM Subject: Re: CFMAIL Problems Are you specifying the SERVER attribute? - Original Message - From: "Gary Groomer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 11:43 AM Subject: CFMAIL Problems I have an application that uses CFMAIL that worked perfectly with ColdFusion Server v4.0.1.0. I recently upgraded my server to v4.5.1 with SP1. Now 10 to15% of the emails are moved to the "UNDELIVR" folder and the mail.log shows the following message: SMTP server replied "Communication failure with mail server. I developed a routine to move the files back to the "SPOOL" folder so that they could be resent. The log file shows that all files are ultimately sent, but 1 or 2 emails out of 6 is lost and are never received. Has anyone run into this problem and come up with a solution? Gary Groomer -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: jr CF
My advice: Setup a web site which demostrates your skills. If you can demonstrate that you are knowledgeable about EVERY CF tag in the book, I'm sure you'll get a job. ---mark -- 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: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 12, 2000 11:28 AM To: CF-Jobs Subject: Re: jr CF Things I would recommend: Take the Allaire courses. The beginner one and the advanced one on Cold Fusion. Even if you pay for it out of your own pocket. They aren't substitute for real-world experience, but will probably look better on a resume than "I self-taught myself at home for the past 6 months." Become active in the local CFUG, or try to start one if there isn't one. Go to meetings, and if you can, get involved in the web site (which will most likely use Cold Fusion). Although, recruiting at meetings is generally frowned upon by the CFUG managers, I have been to meetings that do a 'business card swap' at the end of the meeting. You may even be able to do this sort of work telecommuting for a CFUG if there isn't one local. Look up local non-profit or volunteer run organizations. Can you get involved with their web site, will ColdFusion help. I just don't think it's right for a company to pay someone nothing, (that includes internships) for work. I wouldn't expect an intern or a jr developer to receive the compensation someone w/ 4+ years experience would, either. Ellen Swartz wrote: Very interesting thread. I am not alone and it does not make me feel any better. I have been struggling for the last 6 months between getting several part-time jobs to make some $ and finding an entry level CF position or internship. I got about 10 interviews with local companies that all ended the same way. "Sorry, you don't have enough experience. Go home, work hard and contact us again when you are ready." Let's face it. What company is going to hire an accountant with no experience and barely any knowledge? If CF was tought in college we would not be were we are now. We still would not have the real life experience but we would have a lot more knowledge and consequently a lot more chances to find an entry level CF job. I got to a point where I was wondering if I should pay a company to hire me and give me some real life experience. I would work for freee if I was given the opportunity (only on-site with a local company). It's either that (and I agree I would be taken advantage of) or spent another year strugging learning in 6 months at home what I would probably learn in a month working full time. Why don't we start something. CF guru could teach one or twice a week and be paid for it. Example: I live in Fort Lauderdale, FL. If an experience CF could give a class to 10 CF beginners at least once a week and get paid by us (how much would have to be determined) maybe we would learn faster and smarter. -- Jeff Houser AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- DotComIt, LLC Computer Consultant specializing in database driven web data Lotus Notes/Domino, Cold Fusion -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com http://www.mp3.com/FarCryFly -- Does Everyone Think I'm a Cynical? -- To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _jobs or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: profiles.
If you cannot use cookies, then you have to maintain state by passing some sort of key between all URL calls and form fields which looks up the current user's "profile" in a database. This works fine, but it will slow down the system a little bit. Imagine having to call the database upon every page load - that may not seem like a big deal, but put a hundred people on it, and you'll notice. -- 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: miles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 07, 2000 9:24 PM To: CF-Talk Subject: profiles. Hi, I have an interesting intellectual problem that I need to solvenot immediately, but sometime in the next three months. I am about to roll out a new website for a client and to be honest (the client is aware of this) that its a kluudge at best...but it worksthey are happy...Im happy. Everyone is happy. PROBLEM! Everyone is NOT happy...me being the one that is not happy. The problem is that the site IS a kluudge. The reason its a kluudge is best left to history. However in rethinking the site, I have come up with a solution that will not only make the site more operable, but easier to maintain in the long run and that much easier to develop for in the future. What I am wanting to do is modulerize EVERYTHING... and its not right now. And one of those modules is a user module...this module will keep all types of user data, it will save different user queries (prepackaged ones of course for external users of the site, internal users get to create their own dynamic queries), last time they logged in, what their page is supposed to look like, who their internal advocates are (this is a support website so we assign them a support advocate that works with them directly through the life of their support contract) and who their sales reps are/wereetc. stuff like that. My question is this... I view this kind of data as user "profile" data stuff that will essentially never change except for a few times after the end user logs in. They may change what queries they'd like to see, but the rest of the data isn't going to change. What I was thinking was to store this user profile data in a tablethen when the end user logs in...this "state" or profile data is pulled up and then acted upon. Is there a better way to store this data somewhere... and cookies are NOT an option here. Sincerely, Miles. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
how do you create new DB tables and Columns with CF
say I had a access database with one table in it, and I wanted to dynamiclly create new tables within that DB based on user input. and once the new tables are created how can I create the columns in that table based on user input? Is this even possible? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: PCodeDocumentNodeImp::validateSelf
Looks like Perl OO - Original Message - From: "Bud" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 12:50 AM Subject: PCodeDocumentNodeImp::validateSelf What is that? It's giving me an error message on a custom tag (regular cf_ tag not a C++) on one site and not others and it never has before. PCodeDocumentNodeImp::validateSelf Nothing like an error message in English! Cripes! -- 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: how do you create new DB tables and Columns with CF
Jesse within a cfquery tag use: CREATE TABLE. or ALTER TABLE The proper syntax for these SQL commands can be found in any SQL reference At 4:22 PM -0500 11/12/00, Jesse wrote: say I had a access database with one table in it, and I wanted to dynamiclly create new tables within that DB based on user input. and once the new tables are created how can I create the columns in that table based on user input? Is this even possible? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Mixing ASP and CF on a server
Adrian My host service provides this. I have written several CF programs which work in conjunction with ASP programs. For example a general-purpose CF utility that passes SQL statements to an ASP program. The ASP Program executes the SQL statements and returns the results The reason for this is that because of a bug, cfquery does not return the: SELECT * results in the order the columns were defined when the tables was created. HTH Dick At 5:47 PM + 11/12/00, Adrian Cooper wrote: - Original Message - From: "Harry Miller" [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 5:38 PM I missed the reply to this question and have the same problem. Can CF and ASP run simultaneously on the same server. If so, what are the disadvantages? Yes they can - but I would question the advisability of it. Not so long back I had a set of services running on a server - 95% of which was CF, and 5% ASP - a legacy application. That ASP application - which was efficiently written in VBScript - caused numerous problems with resource usage, and frequently crashed_all_IIS services. The CF apps behaved impeccably. If you must run ASP - I suggest you give it it's own server. Adrian Cooper. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: how do you create new DB tables and Columns with CF
Check this site: http://www.w3schools.com/sql/ I found it has really easy to follow SQL tutorials. At 03:03 PM 11/12/00 -0700, you wrote: Jesse within a cfquery tag use: CREATE TABLE. or ALTER TABLE The proper syntax for these SQL commands can be found in any SQL reference At 4:22 PM -0500 11/12/00, Jesse wrote: say I had a access database with one table in it, and I wanted to dynamiclly create new tables within that DB based on user input. and once the new tables are created how can I create the columns in that table based on user input? Is this even possible? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -=-=- SBG-Priority: 4 (Low) http://www.internz.com/SpamBeGone/ -- Michael She I m a g i n e C o m m u n i c a t i o n s Company E-mail: [EMAIL PROTECTED] Personal E-mail: [EMAIL PROTECTED] ICQ UIN: #243466 Personal Homepage: http://www.michaelshe.com (Under Construction) Imagine Communications: http://www.imagineer.net PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: fusebox
Wow Jon! I don't want to be unkind, but if this message says what I think it does, it's one of the most wrong-headed things I've ever read. You are basically arguing that it's MY fault if I don't do things the way that YOU do them, because if you ever have to work on my code, you won't be familiar with it's structure; and that MY methodology is therefore somehow flawed. In short, your are arguging against ANY methodology, except the one you already happen to use. Look, if you want to AVOID this kind of inconvenience when shifting from your methodology to another one, then wouldn't it be a good idea to adopt a methodology that is actually being used by a large number of people? That way you MINIMIZE your potential confusion. You have to wonder about the kind of developer who does not "care to learn Fusebox", when FuseBox is given so much praise by so many. I header about it. I made the time, took a good look, and now I do things better because of it. When you (or ANYONE else) tell me about the even better way that you use, then I'll make the time and learn about that too, then I'll do things even better. Anyway, maybe you were kidding about your WHOLE message. (and no, I don't get your point at all, sorry;-]) Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] True on all of the above...but ... trying to do things in roughly the same way, resulting in a consistency of code that benefits EVERYONE, and agreeing to help improve the way we are all doing things. Everyone except those who dont have time to learn or care to learn Fusebox. When the day comes that someone dumps a site on me that was coded in Fusebox, and this is my main beef with the whole deal. It's going to take me LONGER to learn Fusebox and then go about adding the lastest widget! I know it's going to happen someday..and I am going to be royally cheesed off at you personally Lee when that day comes! just kidding man...but you get my point? IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: jr CF
I'd have to disagree. The type of employment you would want wouldn't be a varying type... Since you're starting out focus on quality not quantity. Otherwise you'll get a position you can't hand;e... You should focus on taking a basic skillset and setting it a fire... Then look at broading that strong skillset... My 2 cents.. - Original Message - From: Warrick, Mark [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 1:23 PM Subject: RE: jr CF My advice: Setup a web site which demostrates your skills. If you can demonstrate that you are knowledgeable about EVERY CF tag in the book, I'm sure you'll get a job. ---mark -- 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: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 12, 2000 11:28 AM To: CF-Jobs Subject: Re: jr CF Things I would recommend: Take the Allaire courses. The beginner one and the advanced one on Cold Fusion. Even if you pay for it out of your own pocket. They aren't substitute for real-world experience, but will probably look better on a resume than "I self-taught myself at home for the past 6 months." Become active in the local CFUG, or try to start one if there isn't one. Go to meetings, and if you can, get involved in the web site (which will most likely use Cold Fusion). Although, recruiting at meetings is generally frowned upon by the CFUG managers, I have been to meetings that do a 'business card swap' at the end of the meeting. You may even be able to do this sort of work telecommuting for a CFUG if there isn't one local. Look up local non-profit or volunteer run organizations. Can you get involved with their web site, will ColdFusion help. I just don't think it's right for a company to pay someone nothing, (that includes internships) for work. I wouldn't expect an intern or a jr developer to receive the compensation someone w/ 4+ years experience would, either. Ellen Swartz wrote: Very interesting thread. I am not alone and it does not make me feel any better. I have been struggling for the last 6 months between getting several part-time jobs to make some $ and finding an entry level CF position or internship. I got about 10 interviews with local companies that all ended the same way. "Sorry, you don't have enough experience. Go home, work hard and contact us again when you are ready." Let's face it. What company is going to hire an accountant with no experience and barely any knowledge? If CF was tought in college we would not be were we are now. We still would not have the real life experience but we would have a lot more knowledge and consequently a lot more chances to find an entry level CF job. I got to a point where I was wondering if I should pay a company to hire me and give me some real life experience. I would work for freee if I was given the opportunity (only on-site with a local company). It's either that (and I agree I would be taken advantage of) or spent another year strugging learning in 6 months at home what I would probably learn in a month working full time. Why don't we start something. CF guru could teach one or twice a week and be paid for it. Example: I live in Fort Lauderdale, FL. If an experience CF could give a class to 10 CF beginners at least once a week and get paid by us (how much would have to be determined) maybe we would learn faster and smarter. -- Jeff Houser AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- DotComIt, LLC Computer Consultant specializing in database driven web data Lotus Notes/Domino, Cold Fusion -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com http://www.mp3.com/FarCryFly -- Does Everyone Think I'm a Cynical? -- To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _jobs or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to
RE: Complicated Search.
Is anyone reading my posts? -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 11, 2000 11:26 PM To: CF-Talk Subject: Complicated Search. I have several drop downs in a search and with multiple choices the user can select. If the user returns 10 or more hits on their search, I want to be able to create a page 1, 2, 3 kind of like a prev and next button situation. I already know how to do this normally but the problem is if the query has multiple form fields with multiple choices. I also want the data to return in random order and not be repeated in other pages. How can I do this? What if more then 1000 hits are made? Thanks, Nathan Mr.ColdFusion Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Complicated Search.
When you do the next 10, add in part of the where clause to be WHERE column not in (choices already shown) It'll be longer the deeper you go, but will avoid doing any duplicates. Is anyone reading my posts? -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 11, 2000 11:26 PM To: CF-Talk Subject: Complicated Search. I have several drop downs in a search and with multiple choices the user can select. If the user returns 10 or more hits on their search, I want to be able to create a page 1, 2, 3 kind of like a prev and next button situation. I already know how to do this normally but the problem is if the query has multiple form fields with multiple choices. I also want the data to return in random order and not be repeated in other pages. How can I do this? What if more then 1000 hits are made? Thanks, Nathan Mr.ColdFusion -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: fusebox
Why beat around the bush -- just tell it like it is {:-)
Arden Weiss
410-757-3487
-Original Message-
From: BORKMAN Lee [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, November 12, 2000 6:08 PM
To: CF-Talk
Subject:RE: fusebox
Wow Jon!
I don't want to be unkind, but if this message says what I think it does,
it's one of the most wrong-headed things I've ever read.
You are basically arguing that it's MY fault if I don't do things the way
that YOU do them, because if you ever have to work on my code, you won't be
familiar with it's structure; and that MY methodology is therefore somehow
flawed. In short, your are arguging against ANY methodology, except the
one
you already happen to use.
Look, if you want to AVOID this kind of inconvenience when shifting from
your methodology to another one, then wouldn't it be a good idea to adopt a
methodology that is actually being used by a large number of people? That
way you MINIMIZE your potential confusion.
You have to wonder about the kind of developer who does not "care to learn
Fusebox", when FuseBox is given so much praise by so many. I header about
it. I made the time, took a good look, and now I do things better because
of it. When you (or ANYONE else) tell me about the even better way that
you
use, then I'll make the time and learn about that too, then I'll do things
even better.
Anyway, maybe you were kidding about your WHOLE message.
(and no, I don't get your point at all, sorry;-])
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
True on all of the above...but
... trying to do things in
roughly the same way, resulting in a consistency of code that benefits
EVERYONE, and agreeing to help improve the way we are all doing things.
Everyone except those who dont have time to learn or care to learn Fusebox.
When the day comes that someone dumps a site on me that was coded in
Fusebox, and this is my main beef with the whole deal.
It's going to take me LONGER to learn Fusebox and then go about adding the
lastest widget!
I know it's going to happen someday..and I am going to be royally cheesed
off at you personally Lee when that day comes!
just kidding man...but you get my point?
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee. It is confidential and may contain legally privileged
information. No confidentiality or privilege is waived or lost by any
mistaken transmission to you. If you receive this e-mail in error, please
immediately delete it from your system and notify the sender. You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient. The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to it.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Login logic...
Here's how I do this using session variables (sorry this is way late, I'm behind in catching up on my reading): In my application.cfm I have this: cfif Not Session.UserLoggedIn cfset Session.Goto = #CGI.SCRIPT_NAME# cfif CGI.QUERY_STRING NEQ "" cfset Session.Goto = #CGI.SCRIPT_NAME# "?" '#CGI.QUERY_STRING#' /cfif /cfif After the user completes the login form and is sent to the action page to authenticate their login info, I have something like this if they successfully were able to login: CFOUTPUT PYour login was successful.BR You are logged in as: B#GetUser.FName# #GetUser.LName#/B. You have logged in #VisitCount# times./p P cfif Session.Goto IS NOT "" A HREF="#Session.Goto#" cfelse A HREF="somedirectory/someurl.cfm" /cfifContinue/A/p /CFOUTPUT Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner NetObjects Reseller 210-490-3249/888-745-7603Fax 210-490-4692 -Original Message- From: j p [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 1:14 PM To: CF-Talk Subject: Login logic... I have a request that a user be returned to the page from wence they came - if they get rerouted to a log in screen (due to timeing out)... Or in lue of that, if a user is on a page, and they time out, then click on a link...Is there a way to use that "clicked on" link as teh destination after they log back in... Jp Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: ranking a download count.
What he'd like is something like this ...
Rank File Count
-
1 File W 13
2 File L 8
3 File A 4
4 File K 2
If you keep a count of the d/l's in a db then just query your file names,
rank by d/l count, and for the rank just output the Queryname.CurrentRow
value.
For example ...
CFQUERY
Name="myQuery"
Datasource="myDSN"
SELECT Filename, Count
FROM DOWNLOADS
ORDER BY Count
/CFQUERY
table
tr
tdRank/td
tdFile/td
tdCount/td
/tr
CFOUTPUT Query="myQuery"
tr
td#myQuery.CurrentRow#/td
td#myQuery.Filename#/td
td#myQuery.Count#/td
/tr
/CFOUTPUT
/table
Hope this helps,
Steve
-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 4:52 PM
To: CF-Talk
Subject: RE: ranking a download count.
the last sentence doesn't really make sense. you'd like to display the
files by download count, but without ordering by download count?
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 11:31 AM
To: CF-Talk
Subject: ranking a download count.
Im not sure how to go about this. I'm writing a download count to a
database so i can keep track of how many times each file is downloaded.
However, i'd like to display the the files ranking in a top 100 sort of list
only not in order from 1-100. How would i output their rank according to
the amount of times the file has been downloaded without listing the items
in a desc order by download count?
Thanks,
Emmet
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Does Anyone understand encrypt/decrypt??? [CF-Talk]
Check for ASCII values and/or ascii string length - I'll bet the string
you're trying to decrypt has a hidden end-of-line or something that is
causing the decrypt to fail.
HTH,
Truman
-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 20, 2000 9:22 AM
To: Cf-Talk
Subject: Does Anyone understand encrypt/decrypt??? [CF-Talk]
Greets,
I am attempting to encrypt a text file and store it in an SQL table.
First, I create a name, and then see if the file exists...
cfset outfile = "\\web1\reports\cr_store\#answer3#" (where answer3 is the
filename)
cfif fileexists ("#outfile#")
Then, read the file into a variable
cffile action = "read" file="#outfile#" Variable="txtoutput"
Create a key
cfset key='1234567'
Then encrypt it
CFSET encrypted = encrypt(txtoutput, key)
and then I store '#encrypted#' in a text field in an SQL7 table.
Not bad so far...
Now, when I try and view the file, I again set the key,
cfset key='1234567'
And retrieve the field from a query I ran
cfset txtoutput = #get_report.report#
then I attempt to decrypt the file
cfset decrypted = decrypt(txtoutput, key)
And I get the error...
The value to be decrypted is no valid.
Any ideas
Marcus the Desperate
--
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: PCodeDocumentNodeImp::validateSelf
I've seen it once before. Damned if I know - I think its an internal error. BTW, does anybody know how to find anything on the Allaire site? I hear references to a search that works properly, but I've never seen a description of a PCode error yet on their site. David Cummins Bud wrote: What is that? It's giving me an error message on a custom tag (regular cf_ tag not a C++) on one site and not others and it never has before. PCodeDocumentNodeImp::validateSelf Nothing like an error message in English! Cripes! -- 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: profiles.
Store the user profile in a cached query. Select * FROM User_Profile WHERE UserName = 'foo' and Password = 'blah' Since the SQL statement will vary with each user's login values, the CFQUERY can have the same name and the record sets will be distinct. Then you just have to associate each user profile with the parameters you use to maintain state. While it will look like you are running the query with each page request, you will in fact be pulling the user profile from RAM -- not the database. best, paul At 12:27 PM 11/12/00 -0800, you wrote: My question is this... I view this kind of data as user "profile" data stuff that will essentially never change except for a few times after the end user logs in. They may change what queries they'd like to see, but the rest of the data isn't going to change. What I was thinking was to store this user profile data in a tablethen when the end user logs in...this "state" or profile data is pulled up and then acted upon. Is there a better way to store this data somewhere... and cookies are NOT an option here. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Does Anyone understand encrypt/decrypt??? [CF-Talk]
on 11/13/00 9:55 AM, Truman Esmond III at [EMAIL PROTECTED] wrote: And retrieve the field from a query I ran cfset txtoutput = #get_report.report# then I attempt to decrypt the file cfset decrypted = decrypt(txtoutput, key) And I get the error... The value to be decrypted is no valid. You usually need to encode the value before storing it in the table. You can do a tobase64(encrypt(zxxx,xxx)) around the encrypt function and then a decrypt(tostring(tobinary(zxxx,xxx))) to get it back. There is also CF_AHEX at the tag gallery which may be easier to implement (and works pre-4.5) -- Rob Keniger big bang solutions mailto:[EMAIL PROTECTED] http://www.bigbang.net.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Report: Allaire Worldwide Developer Conference 2000
I've uploaded a 7 page report that covers everything you ever wanted to know about the Allaire Worldwide Developer Conference 2000, from product announcements to fun facts. Learn what's behind codenames such as Pharaoh, Trinity, Neo, and Dharma. This is the most complete report available on the net, and it's accompanied by an exclusive product roadmap. A must read for both ColdFusion and JRun developers. You can find the report at http://www.cfvault.com/ , in the 'articles' section. As usual, feedback is welcomed! Best Regards, Stephan Tual Editor Webmaster CFVault.com http://www.cfvault.com Daily News Updates, Jobs, Forums, Articles, Interviews, Events, and in-depth Tutorials from the Allaire World. Direct Line: CFTutorials.com Ltd. +(1) 415 637 5591 Team Allaire Member Allaire Certified Trainer Allaire Certified CF Developer Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Complicated Search.
Nathan If you let CF cache the query, this can be done quite efficiently the same query is reused and only your position pointer need change. As the same query is reused, prior data will *not* be returned in subsequent segments that *you* extract from the query. HTH Dick At 4:30 PM -0600 11/12/00, Nathan Stanford wrote: Is anyone reading my posts? -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 11, 2000 11:26 PM To: CF-Talk Subject: Complicated Search. I have several drop downs in a search and with multiple choices the user can select. If the user returns 10 or more hits on their search, I want to be able to create a page 1, 2, 3 kind of like a prev and next button situation. I already know how to do this normally but the problem is if the query has multiple form fields with multiple choices. I also want the data to return in random order and not be repeated in other pages. How can I do this? What if more then 1000 hits are made? Thanks, Nathan Mr.ColdFusion Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: how do you create new DB tables and Columns with CF
Yes, this is possible... Create a table = cfset newtable="John" cfset datasource="johnsdsn" cfquery name="Test" datasource="#datasource#" CREATE TABLE[#newtable#] ( [InvoiceNum] text, [InvoiceName] text, [Date] text, [InvoiceTax] text, [InoviceType] text, ) /cfquery You can do Drop Table, as well as Alter Table look at other SQL websites to learn about each of them. Nathan www.cftipsplus.com -Original Message- From: Jesse [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 12, 2000 3:22 PM To: CF-Talk Subject: how do you create new DB tables and Columns with CF say I had a access database with one table in it, and I wanted to dynamiclly create new tables within that DB based on user input. and once the new tables are created how can I create the columns in that table based on user input? Is this even possible? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: PCodeDocumentNodeImp::validateSelf
On 11/13/00, David Cummins penned: I've seen it once before. Damned if I know - I think its an internal error. BTW, does anybody know how to find anything on the Allaire site? I hear references to a search that works properly, but I've never seen a description of a PCode error yet on their site. The only thing I found in the knowledge base basically said there's no way to determine what they are. You can do some things that will help you guess, and do some registry hacks in 4.51 that will cause CF server to restart. But I'm using 4.01 since 4.51 is such crap. I just restarted CF server and it went away. I'm using the same custom tag, that the PCode message said caused the error, under multiple sites and it only happened on the one, so it seems to be a random thing. -- 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: PCodeDocumentNodeImp::validateSelf
...I'm using 4.01 since 4.51 is such crap. Really?? I've had no problems with v4.51. What's your beef with it? Ken Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: powerpoint presentation on CF
I thought that there were some at Allaire Alive at one time, but it looks like all of the topics listed use Real Player media. That actually might be a better training platform for your intern than PowerPoint. Anyway, worth checking out: http://alive.allaire.com/. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner NetObjects Reseller 210-490-3249/888-745-7603Fax 210-490-4692 -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 12:46 PM To: CF-Talk Subject: powerpoint presentation on CF Hey all! Does anyone know where one could find a good powerpoint presentation on CF? One of our interns here asked me if I knew of any. I figured if there was one available, someone from this group would know! :) Thanks! Terri Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: how do you create new DB tables and Columns with CF
I dont think creating tables on the fly is good programming or relational database structure. Your could try this, if you really have to... cfquery Name="CreateTable" Datasource="Test" Create tableName (Firstname varchar(50), LastName varchar(50), age Num(3)) /cfquery You should use an account that has table creation permisions.. based on the user input. hope this helps Joe - Original Message - From: "Jesse" [EMAIL PROTECTED] Newsgroups: cf-talk To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 4:22 PM Subject: how do you create new DB tables and Columns with CF say I had a access database with one table in it, and I wanted to dynamiclly create new tables within that DB based on user input. and once the new tables are created how can I create the columns in that table based on user input? Is this even possible? - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Successful CF Mail Sends !!!
Is there some way to determine whether an email sent via CF mail has actually been successfully sent ??? Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Successful CF Mail Sends !!!
If the receiver has HTML email put a 1 by 1 clear pixel in that goes to a ODBC log file... - Original Message - From: AustralianAccommodation.com Pty. Ltd. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, November 12, 2000 10:21 PM Subject: Successful CF Mail Sends !!! Is there some way to determine whether an email sent via CF mail has actually been successfully sent ??? Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
cf error: SQL operation unauthorised
This is a multi-part message in MIME format. --=_NextPart_000_011F_01C04D80.FDC7DB60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The page I have done up is a very simple test page with code: cfquery name=3D"rsHCint" datasource=3D"HCint" username=3D"user" = password=3D"password" SELECT * FROM input /cfquery cfset rsHCint_NumRows =3D 0 cfset rsHCint_Index =3D 1 I am using a Access 97 database, if that helps. Remote, I am getting this error: SQL operation unauthorized.=20 The SQL operation SELECT is unauthorized for the data source 'HCint' I'm sorry if this seems a trivial question, but I'm very green but keen = to learn Cold Fusion - and this has stumped me for 4 days. Any help would be greatly appreciated. Cheers Kylie=20 --=_NextPart_000_011F_01C04D80.FDC7DB60 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.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DVerdanaThe page I have done up is a very simple test = page with=20 code:/FONT/DIV DIVnbsp;/DIV DIVlt;cfquery name=3D"rsHCint" datasource=3D"HCint" username=3D"user" = password=3D"password" gt;BRSELECT * FROM = inputBRlt;/cfquerygt;BRlt;cfset=20 rsHCint_NumRows =3D 0gt;BRlt;cfset rsHCint_Index =3D 1gt;BR/DIV DIVFONT face=3DVerdanaI am using a Access 97 database, if that=20 helps./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DVerdanaRemote, I amnbsp;getting this = error:/FONT/DIV DIVFONT face=3DVerdana PFONT face=3D"Times New Roman"SQL operation unauthorized. /FONT P PFONT face=3D"Times New Roman"The SQL operation SELECT is = unauthorized for the=20 data source 'HCint'/FONT/P PI'm sorry if this seems a trivial question, but I'm very = greennbsp;but keen=20 to learn Cold Fusion - and this has stumped me for 4 days./P PAny help would be greatly appreciated./P PCheers/P P/FONTFONT face=3DVerdanaKylie /P/FONT/DIV/BODY/HTML --=_NextPart_000_011F_01C04D80.FDC7DB60-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
SQL error (minus the mess)
That was a really bad start - please accept my apologies for the mess. Let's try again. The page I have done up is a very simple test page with code: cfquery name="rsHCint" datasource="HCint" username="user" password="password" SELECT * FROM input /cfquery cfset rsHCint_NumRows = 0 cfset rsHCint_Index = 1 I am using a Access 97 database, if that helps. Remote, I am getting this error: SQL operation unauthorized. The SQL operation SELECT is unauthorized for the data source 'HCint' I'm sorry if this seems a trivial question, but I'm very green but keen to learn Cold Fusion - and this has stumped me for 4 days. Any help would be greatly appreciated. Cheers Kylie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL error (minus the mess)
at just a quick glance, is the username/password combination valid for that database? did you give access to the user "username"? access by default does not have security. try removing the username and password attributes from your CFQUERY. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kylie Lovelock [mailto:[EMAIL PROTECTED]] Sent: Monday, November 13, 2000 2:01 AM To: CF-Talk Subject: SQL error (minus the mess) That was a really bad start - please accept my apologies for the mess. Let's try again. The page I have done up is a very simple test page with code: cfquery name="rsHCint" datasource="HCint" username="user" password="password" SELECT * FROM input /cfquery cfset rsHCint_NumRows = 0 cfset rsHCint_Index = 1 I am using a Access 97 database, if that helps. Remote, I am getting this error: SQL operation unauthorized. The SQL operation SELECT is unauthorized for the data source 'HCint' I'm sorry if this seems a trivial question, but I'm very green but keen to learn Cold Fusion - and this has stumped me for 4 days. Any help would be greatly appreciated. Cheers Kylie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: SQL error (minus the mess)
Thanks for taking the time Christopher. I removed the username and password from my CFQUERY - but still receiving the same error of SQL operation unauthorized. Cheers Kylie - Original Message - From: "Christopher Olive, CIO" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 3:29 PM Subject: RE: SQL error (minus the mess) at just a quick glance, is the username/password combination valid for that database? did you give access to the user "username"? access by default does not have security. try removing the username and password attributes from your CFQUERY. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
