RE: How to get field names in MSAccess
Found this old piece of code hope it helps It's bad code, inefficient, not documented... but it worked I think I used it to mimic sp_columns in SQL. I think you have to create a regular DSN for this to work. Shlomy Gantz Certified Macromedia Instructor President, Bluebrick Inc. -Original Message- From: Terry [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 6:32 PM To: CF-Talk Subject: How to get field names in MSAccess I know this is simple, but can't remember. How do use a query to get list of column or field names. Using CF5.0 Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: UUID's ( maybe OT)
http://www.codebits.com/uuid/index.htm a great explanation about why you should use UUID (by David Medinets). Personally I use UUIDs for large applications since it solves a lot of problems in synchronization and aggregation of content and data from globally distributes sub-systems. However, in many cases UUID are just plain overkill. I use UUIDs in Oracle more than in MSSQL simply because the affect on performance is very minimal in Oracle. my 2c Shlomy -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:33 PM To: CF-Talk Subject: RE: UUID's ( maybe OT) My DBE tells me, however, that UUIDs (or GUIDs) are terrible for joins. Better to just use integers. > -Original Message- > From: Brian Thornton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 18, 2002 3:59 PM > To: CF-Talk > Subject: Re: UUID's ( maybe OT) > > > UUIDs with a datatype of uniquidentifier are indexed just as pk's > > > - Original Message - > From: "Zac Spitzer" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 18, 2002 10:15 AM > Subject: UUID's ( maybe OT) > > > > I am probably OT here, but I see so many people using UUID's when > > simpler normal numeric keys are better... a classic example > for me is > > article id's... look at cfcomet for example... the article > ids aren't > > user friendly, it reminds me of good old lotus notes and we > all know how > > short urls are better than long one ( email wrapping for example ) > > > > not to mention that your database and CF load is much > higher using long > > text pk's than with nice short numeric keys and your page size is > > increased a lot too.. > > > > just letting off steam. don't want to create a flame > war or anything > > > > z > > > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: run CF from db
It's main use is within IF and Evaluate, preventing them from treating strings as expressions and trying to evaluate them (hence the name : delay evaluation).ColdFusion will try to evaluate anything within pound signs first, using DE() allows you to have it evaluate the internal parts surrounded by pound signs later, rather than trying to evaluate the whole thing as an expression. I use evaluate() and de() mostly for dynamic logical processing (implementing rules and complex data filters) but I find the writing dynamic code using CFFILE and including it is much faster for large/high-volume or complex applications. After reading this explanation I wonder if I truly understand it as well... Shlomy -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:34 AM To: CF-Talk Subject: Re: run CF from db I have to say I've never grasped what de() actually does! :-( - Original Message ----- From: "Shlomy Gantz" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 10:47 PM Subject: RE: run CF from db > I am not sure that is entirely correct. > > I use evaluate() and de() and it works fine. > > #evaluate(de(getContentTypes.CTEmailTemplate))# > > It is not fast but definetly works. evaluate() and de() together are really > slow, but they work even with HTML tags in the database. > > example: > > > > > dynText: #dynText# > > > dynOut: #dynOut# > > > > Shlomy > > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 3:17 PM > To: CF-Talk > Subject: RE: run CF from db > > > Generally this won't work. It would only work if you were storing a cf > expression, e.g "int(3.1415)". It won't handle cf tags or expressions > mixed with html. > > > -Original Message- > > From: Jesse Houwing [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, 18 September 2002 10:17 a.m. > > To: CF-Talk > > Subject: Re: run CF from db > > > > > > Nick Varner wrote: > > > Is there a way to evaluate Coldfusion after it is pulled > > from a db instead > > > of CF thinking its text? > > > > That would be the use of evaluate... but I would not reccomend it... > > > > Jesse > > > > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: run CF from db
I am not sure that is entirely correct. I use evaluate() and de() and it works fine. #evaluate(de(getContentTypes.CTEmailTemplate))# It is not fast but definetly works. evaluate() and de() together are really slow, but they work even with HTML tags in the database. example: dynText: #dynText# dynOut: #dynOut# Shlomy -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:17 PM To: CF-Talk Subject: RE: run CF from db Generally this won't work. It would only work if you were storing a cf expression, e.g "int(3.1415)". It won't handle cf tags or expressions mixed with html. > -Original Message- > From: Jesse Houwing [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 18 September 2002 10:17 a.m. > To: CF-Talk > Subject: Re: run CF from db > > > Nick Varner wrote: > > Is there a way to evaluate Coldfusion after it is pulled > from a db instead > > of CF thinking its text? > > That would be the use of evaluate... but I would not reccomend it... > > Jesse > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: More list spam
http://www.cflib.org/udf.cfm?ID=405 this UDF should do the trick Shlomy -Original Message- From: Shlomy Gantz [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 3:52 AM To: CF-Talk Subject: RE: More list spam One thing you can do is hide your email address using HTML special charachters ... for instance : mailto:info@bluebr; ick.com">info@b& #108;uebrick.com It cut down the amount of spam I got in half Shlomy -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 4:09 PM To: CF-Talk Subject: Re: More list spam I'm still looking into this. The only thing I can see is that if a person goes to an archive and scans the posts, they can see email addresses that have been replied to. This is true in all archives from the 2 official ones to the 1 unofficial (and soon to be dead one). Someone with an agent can read through any of these places to scan for addresses. I'm adding a login to the HoF archive soon anyway so that'll slow down a scanner (but not stop one if written well). I'll also check the logs to see if someone's been hitting me and if so, they're blocked. > Apparently, SPAM is the deal of the day here on the CF lists...I just got an > email from "Michael McFayden" regarding "PC Mall and Mac Mall computer > solutions", and it was delivered to an address that I ONLY use for this list > (CF-Talk, Spectra-Talk, and CF-Jobs). Here are the headers: > > >>>>>>>>>>>>>>>>>>>>>>>> > Received: from ccnt_smtp1.cc-inc.com [209.233.130.81] by zeus.cosmotek.net > with ESMTP > (SMTPD32-6.06) id A89E3FE0258; Wed, 10 Jul 2002 13:02:22 -0400 > Received: by ccnt_smtp1.cc-inc.com with Internet Mail Service (5.5.2650.21) > id ; Wed, 10 Jul 2002 10:19:31 -0700 > Message-ID: <[EMAIL PROTECTED]> > From: Michael McFayden <[EMAIL PROTECTED]> > To: Michael McFayden <[EMAIL PROTECTED]> > Subject: PC Mall and Mac Mall computer solutions > Date: Wed, 10 Jul 2002 10:19:23 -0700 > MIME-Version: 1.0 > X-Mailer: Internet Mail Service (5.5.2650.21) > Content-Type: multipart/alternative; > boundary="_=_NextPart_001_01C22835.EF346000" > X-RCPT-TO: <[EMAIL PROTECTED]> > X-UIDL: 12720 > Status: U > > >>>>>>>>>>>>>>>>>>>>>>>> > > Pete > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: More list spam
One thing you can do is hide your email address using HTML special charachters ... for instance : mailto:info@bluebr; ick.com">info@b& #108;uebrick.com It cut down the amount of spam I got in half Shlomy -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 4:09 PM To: CF-Talk Subject: Re: More list spam I'm still looking into this. The only thing I can see is that if a person goes to an archive and scans the posts, they can see email addresses that have been replied to. This is true in all archives from the 2 official ones to the 1 unofficial (and soon to be dead one). Someone with an agent can read through any of these places to scan for addresses. I'm adding a login to the HoF archive soon anyway so that'll slow down a scanner (but not stop one if written well). I'll also check the logs to see if someone's been hitting me and if so, they're blocked. > Apparently, SPAM is the deal of the day here on the CF lists...I just got an > email from "Michael McFayden" regarding "PC Mall and Mac Mall computer > solutions", and it was delivered to an address that I ONLY use for this list > (CF-Talk, Spectra-Talk, and CF-Jobs). Here are the headers: > > > Received: from ccnt_smtp1.cc-inc.com [209.233.130.81] by zeus.cosmotek.net > with ESMTP > (SMTPD32-6.06) id A89E3FE0258; Wed, 10 Jul 2002 13:02:22 -0400 > Received: by ccnt_smtp1.cc-inc.com with Internet Mail Service (5.5.2650.21) > id ; Wed, 10 Jul 2002 10:19:31 -0700 > Message-ID: <[EMAIL PROTECTED]> > From: Michael McFayden <[EMAIL PROTECTED]> > To: Michael McFayden <[EMAIL PROTECTED]> > Subject: PC Mall and Mac Mall computer solutions > Date: Wed, 10 Jul 2002 10:19:23 -0700 > MIME-Version: 1.0 > X-Mailer: Internet Mail Service (5.5.2650.21) > Content-Type: multipart/alternative; > boundary="_=_NextPart_001_01C22835.EF346000" > X-RCPT-TO: <[EMAIL PROTECTED]> > X-UIDL: 12720 > Status: U > > > > Pete > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Admin Password
Not sure but you can try open c:\Program Files\ColdFusionMX\lib\neo-security.xml change to: Shlomy -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:13 PM To: CF-Talk Subject: Admin Password Hello all, Is there anyway to retrieve a lost admin password for CFMX? Thanks. - j __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists