Authenticating on Active Directory
First off, congrats to Michael Smith and everyone at CFUN-2K for a great conference! Secondly, has anyone found a way to authenticate passwords off of Windows 2000's Active Directory? We were able to set it up through advanced security on one of our servers, but not the other. Are there other methods? Or is there a big secret to setting it up through advanced security that we don't know about? :) Thanks! Norman Elton Information Technology College of William & Mary Williamsburg, VA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Integrating with Flash
Special thanks goes out to Schlomy Gantz and the rest of the CFUN-2K people on a great conference. Schlomy made an inspiring presentation on CF integration with Macromedia Flash. I've got a project that would definitely benefit from it. A few questions: Does anyone know of any good books/resources on building Flash clips? Are there any huge limitations to Flash integration without Generator? Is it worth waiting for Flash 5 to come out? Thanks! Norman Elton -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Integrating with Flash
I'll take a copy of your files too :). Thanks! Norman On Thu, 3 Aug 2000, Reynolds, Adam wrote: > Could you copy me in on this. I would be very interested. > > > -- > > From: Sean Renet[SMTP:[EMAIL PROTECTED]] > > Sent: 03 August 2000 12:24 > > To: [EMAIL PROTECTED] > > Subject:Re: Integrating with Flash > > > > I have a day left of crazy left, then I will email you an fla file and cf > > template off list. > > - Original Message - > > From: "Rich Wild" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, August 03, 2000 1:53 AM > > Subject: RE: Integrating with Flash > > > > > > > Yeah - I wasn't talking semantics though, I am genuinely interested in > > how > > > you pull those variables out - where does the LoadVariables pull the CF > > > variables from? > > > > > > I've used URL variables before fine - but limited as I said, due to the > > max > > > length of a URL string > > > > > > I've used textfiles also - getting CF to create a textfile with the > > > variables written into it: > > > > > > eg: variables.txt > > > ** > > > > > > var1 = Hello > > > var2 = Cheese > > > var3 = red hot poker > > > > > > ** > > > > > > And Then Flash LoadVariables from variables.txt > > > > > > Now I *know* that this is brutish and poor. Must be. Makes me wince just > > > looking at it. > > > > > > How specifically are you handling it? I long for a better way... > > > > > > -- > > > 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: Sean Renet [mailto:[EMAIL PROTECTED]] > > > Sent: 03 August 2000 09:44 > > > To: [EMAIL PROTECTED] > > > Subject: Re: Integrating with Flash > > > > > > > > > I seldom use url variables. I am sure that someone will respond with a > > > url/form variable dissertation. However, I generally have an action > > page > > in > > > the background that does all the work and I have flash pull the > > variables > > > from it using flash's LoadVariables command. I suppose this is more > > like > > a > > > form variable pass as the method is "post". I don't have much time to > > get > > > caught up in symantics, I just do what I think works the best. You > > don't > > > need text output per say, you can just use cfcontent. > > > - Original Message - > > > From: "Rich Wild" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Thursday, August 03, 2000 1:03 AM > > > Subject: RE: Integrating with Flash > > > > > > > > > > Am I right in saying that you are limited to using URL variables when > > > > controlling Flash movies though? That's what I've picked up anyway > > > > > > > > Kind of annoying if you have a lot of text to output... > > > > > > > > > > > > > > > > -- > > > > 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. > > > > --- > > > > > > > > > > > >
RE: Finding an element in an array
You could always convert the array to a list (ArrayToList), then use ListFind... Norman Elton On Thu, 3 Aug 2000, Philip Arnold - ASP wrote: > > Can anyone tell me if it is at all possible to get CF to find an > > element in > > an array? > > I know you use ListFind and StructFind for lists and structures > > respectively > > but don;t know how to do it with an array. > > > > I have a 2-dimensional array so can't use the ArrayToList > > function and then > > do a ListFind...is this correct? what happens if you try to convert a > > multidimensional array into a list? > > You're gonna have to do it the hard way - loop through the array and check > each line > > 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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Studio
This was a bug in (I believe) 4.5. Upgrade to 4.5.1 and your problems should be solved. The download is available on Allaire's site. Hope this helps. Norman Elton Information Technology College of William & Mary -Original Message- From: Ken M. Mevand [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 05, 2000 1:49 AM To: 02 cf-talk Subject: CF Studio anyone has experienced this - after saving a document in studio, close it, then open, the entire file is empty? this has happened many times, and is very, very costly. -ken -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Advice Needed
I am beginning work on a suite of small projects, which all feed off of a central database. I have an idea rolling around in my mind as to the DB design, but am not sure whether to go ahead with it. I'm trying to stay away from zillions of small tables, each representing something different, so here's what I came up with: Break everything down into "objects". Every user is an object. Every message board is an object. Every message on a board is an object. These can all be stored together in one table. Every object has a "type", such as USER, MESSAGEBOARD, MESSAGE, etc. These too can be stored in one table. Every type of object has a list of attributes available to it. This table would show that an object of type USER has attributes FIRSTNAME, LASTNAME, PASSWORD, etc. The last table contains the actual data for the attributes defined above. It shows that a particular user's LastName is 'Smith'. The next record in this table could specify that a particular message was written at 11:30 PM. Now the question: Am I insane? Has anyone tried something like this before? It is definitely an experiment in DB normalization, but I don't want to work on it for 3 weeks, then find myself swamped. Hopefully this makes sense. Any foresight you may have would definitely be appreciated. Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Dynamic Variable Problems
Good evening all! I am having problems with a setting a dynamic variable. I'm trying to set TempArray[1].GroupAccess[1] to some value. It is an array inside a struct, inside an array (whew!) I can execute... ...just fine. But if I try... ... I get an error message saying that the variable name is illegal! If anyone has any ideas as to why this happens, please respond! Thanks in advance! Norman Elton -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Dave Watts is the man!
I was really worrying about this one :) Thanks! Norman Elton -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 06, 2000 2:16 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Dynamic Variable Problems > I am having problems with a setting a dynamic variable. I'm > trying to set TempArray[1].GroupAccess[1] to some value. It > is an array inside a struct, inside an array (whew!) > > I can execute... > > > > ...just fine. But if I try... > > > > > ... I get an error message saying that the variable name is illegal! Keep in mind that the syntax you're using for setting dynamic variables is unsupported; you should probably use the SetVariable function instead - it's a lot less likely to accidentally disappear in future versions of CF. Besides that, though, there's a bigger problem, which would prevent you from using SetVariable in this case as well. That problem is that a member of an array isn't exactly the same as a "variable" from CF's perspective. The array itself is a variable, but if for example you attempt to check for an array member's existence using IsDefined, you'll get an error there as well. Instead, you could do something like 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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: crystal reports and CF
You are correct that CR was bundled "at one stage", unfortunately it is no longer sold this way. I believe version 4.0 was the first to leave it out (someone correct me if I'm wrong here), so older books still refer to it as part of the ColdFusion package. There is a tag for calling Crystal Reports (CFREPORT), but it does not work well with the latest releases of Crystal Reports (version 8). If you really need Crystal Reports, I've been told it's best just to use Crystal's reporting engine rather that can pull from a database rather than trying to integrate it with ColdFusion. Norman Elton Information Technology College of William & Mary On Mon, 7 Aug 2000, Phil Palmer wrote: > Can anyone tell me how the licensing of Crystal Reports and CF works? > > I have documentation which implies that a version of Crystal comes > with CF but I have scanned the disks for CF Server and CF Studio > versions 4.0 and 4.5 but I cannot see it. It doesnt seem to have > installed by default. > > Am I incorrect in assuming that it was bundled as part of CF at one > stage? > > Regards > > Phil Palmer > Technical Director > Engage Technology Pty Ltd > e [EMAIL PROTECTED] > p 0414 353 246 > w www.engagetechnology.com.au > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is there a variable for a query's name?
I'm afraid I might not understand your question, but as I understand it, you
want to return the value specified as the Name="..." in a CFQUERY?
Well, in order to process something like "MyQuery.QueryName", wouldn't you
already know that the query's name is "MyQuery"? The object's name is the
anchor for all the other attributes such as RecordCount and ColumnList, etc.
If you don't already know the name, it's awfully hard to refer to the
object.
Hope this helps. If not, reply!
Norman Elton
Information Technology
College of William & Mary
-Original Message-
From: Sean Renet [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 8:36 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: Is there a variable for a query's name?
No that's not what I meant. What I meant was a cgi variable for the query's
name like myquery.columnlist gives you the query's column list and
myquery.recordcount gives you the query's record count. I want a cgi
variable for the query's name like myquery.queryname
- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 3:14 AM
Subject: RE: Is there a variable for a query's name?
> > I am trying to make a tag that changes the scope of a query to the
> > attributes scope.
> >
> > I want to tagify...
> >
> > > evaluate("RETAILER_INFO.#i#"))>
> >
> >
> > so what I want to do is...
> >
> >
> >
> >
> >
> > Is there a variable for the query's name? There has to be one,
debugging
> > lists the names of the queries...
>
> As this hasn't been answered for a couple of days (and I'm just catching
up
> on emails)...
>
> You can use a variable name and Evaluate;
>
> evaluate("#caller.somequery#.#i#"))>
>
>
> I'm not sure about the multiple scoping on caller.attributes. but the
query
> name should work
>
> 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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Crazy MS Outlook/Access Question
Try this (it seems to work in Access 2000): File -> Get External Data -> Import Under "Files of Type:", choose Outlook() It will walk you through importing your address book into a table. From there you should be able to query the address book. This is assuming you've got all the addresses stored locally on your computer. If you're connecting to a server through LDAP (to an NT server presumably), you'd have to use which is no fun. Reply if this helps... Good luck! Norman Elton Information Technology - Network Engineering College of William & Mary -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 8:00 PM To: [EMAIL PROTECTED] Subject: Crazy MS Outlook/Access Question Hi, I want to know if anyone has ever attempted the impossible and how it was done. I have about 300 names in an Access database that I would like to send a mass email to, but the Access database did not contain their email addresses. What I was thinking is since they all work for the same company maybe I could do a query from MS Outlook and populate my database with their emails from Outlook, doing a simple WHERE statement that would match their First and Last names. Is this possible or should I get started on manually entering their addresses?? 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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: More elegant way of passing URL variables?
Is this code (CF_DecryptURL) available? I've searched the 'net and the Developer's Exchange but can't find it. Thanks! Norman Elton Information Technology College of William & Mary - Original Message - From: "JustinMacCarthy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 11, 2000 9:21 AM Subject: Re: More elegant way of passing URL variables? > Encrypt the url > I wrote a couple of tags that encrypt/ decrypt query_strings > > so instead of index.cfm?value=6&name=jim > > You get > > page2.cfm?94946560A4946560B495214551E01031C1D1A. > and on page2 you include > > and you can still use url.value and url.name etc > > I don't have it handy at the moment though and it chould do with > more testing but I'll end it to you over the weekend if you want ... > > ~ Justin > > - Original Message - > From: "Milks, Jim" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, August 11, 2000 4:49 PM > Subject: More elegant way of passing URL variables? > > > > Hi, > > I am dynamically generating a list of customers, on which a user can click > > to go to a detailed page. To do this, I am putting the customerID into a > URL > > variable in the A HREF path. But the client doesn't want to see the value > in > > the address bar, as they consider it a security risk. > > > > What would be a better solution? A hidden FORM field for each item, and > have > > the HREF call Javascript which posts the form? The problem with that us I > > will get all of the form fields in the detail page, unless the JS passes a > > value to indicate the field I want, but hen I essentially have the same > > problem > > > > Any input appreciated. > > > > James > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: nesting queries
>From the looks of it, you're trying to get an output like: --- City 1 Neighborhood A Neighborhood B Neighborhood C City 2 Neighborhood D Neighborhood E Neighborhood F --- If so, try this: --- select city, neighborhood from areas order by city, neighborhood #City# #Neighborhood# --- The query returns all the neighborhoods and their corresponding cities, sorted for a nice pretty output (this is actually important if your cities appear out of alphabetical order in the database). The first CFOUTPUT tells ColdFusion that you will be outputting the query, and you want to group the output by city. The code outside the second CFOUTPUT is only executed once per city. The code inside the second CFOUTPUT is then executed once per record (i.e. in this case, once per neighborhood). Once a new city is reached, this inner loop stops and the process starts over again with the first CFOUTPUT. Hope this helps. If this wasn't what you were trying to do, well now you know! Norman Elton Information Technology College of William & Mary -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 13, 2000 9:13 PM To: [EMAIL PROTECTED] Subject: Re: nesting queries Its is as easy as >where city = '#cities.city#' At 09:09 PM 13/08/00 -0400, you wrote: >also a novice, and am stuck. Am trying to nest a query theoretically like >the following... > > > select city > from areas > > >#city# > > >select neighborhood >from areas >where city = '#city#' > > #neighborhood# > > > >I know this has got to be quite simple to do, but I'm just lost in all the >unfamiliar phrases and documentation. Can anyone tell me the trick? > >Cheers, > >Mark -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: nesting queries
Well I see responses are rolling, and I've already noticed a problem in mine... the CFQUERY line should read: Insert the name of your datasource (as configured in the CF Administrator) into the "...". Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Novell Authentication
Has anyone seen a way to authenticate a user's password from a Novell NDS server? Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Bizarre error message
I got this message: --- Error Diagnostic Information An error has occurred while processing the expression: ScheduledCounts[CurrentRow].TheCount=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321 --- I found my error, but the CFTempOnly... variable came out of nowhere. Any idea what it actually does? This occured when I ran a CFPARAM. If nothing else, it's interesting.... Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Novell Authentication
Steve, How did you pass the UID and password into LDAP? I searched in Novell's developer website, but couldn't find any useful information about LDAP (i.e. a list of what attributes are available). Also, were you querying GroupWise's LDAP, or NDS directly? Thanks! Norman Elton Information Technology College of William & Mary -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Friday, August 18, 2000 12:44 PM To: [EMAIL PROTECTED] Subject: RE: Novell Authentication I last tried this during the beta of CF 4.5. You can use CF's native SLDAP client functionality to authenticate via an NDS 5 tree. The only thing I ran into was that there isn't a login function per se. I used LDAP to query the tree for specific fields, passing the UID and password along as part of the query. If the username AND/OR password fail a generic "error occurred" message was returned. To be somewhat reliable I wrote a parsing routine that checked returned messages for strings indicating that there was an error. I didn't have the time to really test out this functionality but, it holds promise. I haven't had a chance to look at it yet but, Rick's NWAuth holds possibilities and I'm dying to check it out. Regards, Steve -Original Message- From: Rick Osborne [mailto:[EMAIL PROTECTED]] Sent: Friday, August 18, 2000 10:25 AM To: [EMAIL PROTECTED] Subject: RE: Novell Authentication I didn't see any useful responses to this, so I'll just plug myself for a moment ... :) I wrote a (free with source) ISAPI DLL for IIS that authenticates Novell users against NDS trees. I dunno if that's what you need, but if nothing else you could always just look at the source and use LDAP to recreate it. (I *think* that should work anyway.) It's available at: http://www.rixsoft.com/NWAuth/ HTH, Rick -Original Message- From: Norman Elton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 15, 2000 7:42 PM To: [EMAIL PROTECTED] Subject: Novell Authentication Has anyone seen a way to authenticate a user's password from a Novell NDS server? Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: question about joined tables in query
Jon- If tblCategory.categoryCategory is a non-numeric field (probably text), you'll need single quotes around #FORM.category#. You can just say "SELECT * FROM " to cut down on the length, but I doubt this is causing any problems... Good luck! Norman Elton Information Technology College of William & Mary -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 11:51 PM To: [EMAIL PROTECTED] Subject: question about joined tables in query Anybody know how to make this work: SELECT tblProduct.*, tblCategory.*, tblCollection.*, tblLine.*, tblProductSize.*, tblProductWeight.*, tblProductColor.* FROM(tblProduct LEFT JOIN tblCategory ON tblProduct.productCategoryId = tblCategory.categoryId) LEFT JOIN tblCollection ON tblProduct.productCollectionID = tblCollection.collectionId) LEFT JOIN tblLine ON tblProduct.productLineId = tblLine.lineId) LEFT JOIN tblProductColor ON tblProduct.productId = tblProductColor.productcolorProductId) LEFT JOIN tblProductSize ON tblProduct.productId = tblProductSize.productsizeProductId) LEFT JOIN tblProductWeight ON tblProduct.productId = tblProductWeight.productweightProductId WHERE tblCategory.categoryCategory=#FORM.category# I know the problem is in the WHERE statement, but I can't figure out how ot make it work... -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers & parts Current Need: Tape Drive & PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: Ping & TraceRt from a web page?
I use the custom tag CFX_Ping. Seems to work well for me. You can find it on Macromedia's CF Exchange. As far as a trace route custom tag... I don't know of one, but I would be surprised if there's not one out there somewhere. You could always capture the output of executing tracert.exe. It would be pretty ugly, but would probably work. HTH, Norman Quoting Ryan Pieszak <[EMAIL PROTECTED]>: > Sorry for the OT post, if anybody has any input > on this, you can email me > off list. Thank you. > > I know there are services on the web for this, > so I know it's possible. I > would like to put a link on one of my pages to > ping or tracert a specific > IP. Simply put, I would like to mimic the DOS > commands via this link. > Anybody know how I can do this? Thanks in > advance. > > Ryan J. Pieszak > Applications Engineer > Ziphany, LLC. > (716) 510-0379 > www.ziphany.com > > __ > 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 > __ Get the mailserver that powers this list at http://www.coolfusion.com 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
Too many queries?
Does CF have a maximum number of queries per request? I'm afraid some of my pages will eventually query a DB many (many) times. I can change the DB design to reduce the number of queries, and need to decide whether to do this now or regret it later... Thanks! Norman Elton Information Technology The College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL Stored Procedures
I've got a SQL Server book, and am struggling to make heads or tails of it. Here's what I'm trying to do: Run Query A. If it returns a single record, run Query B. Otherwise, do nothing. I think I understand how to run Query A. I understand how to build a simple IF/THEN structure, but how do I refer to the number of returned records from Query A? If anyone has any good pointers or URLs on sprocs, I would be most appreciative! Thanks! Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFScript VS Tags
I have heard that CFScript runs somewhat faster than the equivalent CF-tags. Is there any truth to this statement? I was under the impression that CFScript was designed solely for the developer's eye :) Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Novell User Management
Previous Message: >>Have a look at the Intranet Hosting Toolkit UserManager. >> >>http://www.intrafoundation.com/intranethostingtoolkit.html >> Has anybody a user management package like this for Novell NDS? Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Windows MySQL
Has anybody done any development with the Windows version of MySQL? How does it rate compared to an Access DB, SQL Server, etc? Thanks for any advice! Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Simple SQL Question
Try this...
INSERT INTO TableName (FieldName1,FieldName2,FieldName3) VALUES
('#Form.Dat1#','#Form.Dat2#','#Form.Dat3#')
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 14, 2000 6:13 PM
To: [EMAIL PROTECTED]
Subject: Simple SQL Question
Ok I want to "conjugate" 3 fields when i am inserting into a database.
this is what i have, but it won't work, am i missing something???
INSERT INTO Data(data1)
VALUES('#FORM.dat1# #FORM.dat2# #FORM.dat3#')
?
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[CF-Talk] Production Server Policies
We're starting a new production-level machine, and are trying to draw up coding guidelines for capable people that want to use it. We run a testbed machine for people to play around with, but want to keep the production box as stable as possible while still allowing different departments to run their own pages. Does anyone have any suggestions (such as "you must use CFLOCK where appropriate), or know of a good article regarding coding practices? Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[CF-Talk] CFHTTP Woes
I've been working with the following CFHTTP code, but keep getting the same "Connection Failure" message, with no StatusCode available http://www.wm.edu/path/authenticate.cfm" METHOD="POST" Timeout=20 ThrowOnError="yes"> Anybody have any ideas? Thanks!!! Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie" CFIF for range of data
You almost had it: Make sure to use GTE (greater than or equals) rather than simply GT (greater than). Norman -Original Message- From: Olson, Kelly [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 24, 2000 3:51 PM To: CF-Talk Subject: Newbie" CFIF for range of data How would you write a conditional statement like this: All of the examples seem to only show an "IS" value. not "IS" range. Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie" CFIF for range of data
Jim got it even better than I did :). CFIF only evaluates the first block matching the specified condition, and skips the rest. Norman Elton Information Technology College of William & Mary -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 24, 2000 4:13 PM To: CF-Talk Subject: Re: Newbie" CFIF for range of data If you're not worried about the number being negative: Jim -Original Message- From: Olson, Kelly <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Sunday, September 24, 2000 1:50 PM Subject: Newbie" CFIF for range of data >How would you write a conditional statement like this: > > > > > > > > > > >All of the examples seem to only show an "IS" value. not "IS" range. > >Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Discussing Rates in a Public Forum -- was National Radio Commercial
Steve- Might want to watch your signature :). >>Steve Pierce, HDL >>"Co-Location starting $99 per month, no setup fee" >>(734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: access front-end for SQL
Yes, it's possible and fairly painless. - Go to your Data Sources (ODBC) Control Panel - Make a new System DSN - Select the driver for MS SQL Server - Follow the wizard's instructions. You'll have to click "Client Configuration" and tell it to use TCP/IP (or whatever protocol you use). - In Access, make a new database. - File -> Get External Data -> Link tables - Change the "Files of Type" to be ODBC Datasources() - Choose your DSN under "Machine Datasources" - Access will walk you through which tables you need You can view and work with data through Access, but you normally can't change the structure of the tables (i.e. Design Mode). Reply to the forum if something doesn't work! Norman Elton Information Technology College of William & Mary -Original Message- From: avex [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 24, 2000 9:59 PM To: CF-Talk Subject: access front-end for SQL Hi guys... I think it has been briefly mentioned.. but does anyone know how to use access 2000 as a front-end for an SQL database? any info would be great... thanks chad -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF College Training
Does anyone know of any schools providing ColdFusion training to its faculty/staff? I have a member of our staff that would like to learn CF, but our Training Dept doesn't offer ColdFusion yet. I noticed that UVA provides it, but am wondering if anybody has had any experience with such a workshop. Thanks! Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF & Remedy Integration
Since CF integration seems to be a popular topic, I thought I would throw in another question: Does anyone use Remedy's Help Desk system? I believe it's technical name is Action Request System. I am looking to integrate an intranet CF interface into its database of trouble tickets. We're in the process of upgrading it to the latest version (five, I believe) to run on an MS SQL database. I suppose if all else fails I could just query the database straight to SQL and avoid Remedy all together? Apparently it comes with an ODBC interface, but I'm having trouble getting it to work correctly. Any advice would be greatly appreciated. Thanks! Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Displaying Source Code
I know there's a way to do this, but it slips my mind: I need to show my source code, so it needs to bypass both ColdFusion and the browser's processing engine. I think this is possible using CFHEADER, but am not sure. Thanks! Norman Elton Information Technology College of William & Mary -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Distinct Alpha
Here's how I do it, hopefully we're talking about the same thing... SELECT CompanyName, Left(CompanyName,1) AS FirstLetter FROM Companies #FirstLetter# #CompanyName# - No guarantees that it works, but I've done similar stuff before. On some databases, you can do a SELECT Distinct(Left(CompanyName,1)) AS FirstLetter FROM Companies to retrieve the list of letters, then run another to retrieve the company names. This involves executing two queries however. Hope this helps Norman Elton __ 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
RE: Templates executing twice CF bug
I must admit, I was a doubter. Here's how I confirmed your bug: CFPARAM a server variable to zero. Increment it by one, then display it. If you include a non-CFOUTPUTed variable in an image tag, the number is displayed incrementing by two. Take out the mysterious IMG tag, or turn it into a garbage "" tag, and the number seems to increment by one. Very bizarre! Norman Elton College of William & Mary -Original Message- From: Max Paperno [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 11:29 PM To: CF-Talk Subject: Templates executing twice CF bug Greetings, I've identified a somewhat minor but possibly damaging bug in CF 5. It's pretty strange, but true. Zac Belado has confirmed that this was also the problem in his case (see his "Page Processing Twice" message from earlier today). It seems to only affect CF5 (4.5 was also tried) but so far only tested on W2K. The bug causes a template to be executed twice by the CF engine. It literally runs everything connected to the request twice (all includes, parent template, etc). There is no indication of this unless you have data that is noticeably affected (such as inserting DB records). The HTTP request is not doubled, only the actual CF code execution. This is not browser or Web server-related in any way. The cause seems to be missing cfoutput tags around a variable call, and apparently specifically in an IMG tag (some others were tried with no problems surfacing). So some code like this: (w/out cfoutput tags anywhere around it) will cause double execution. Wrap it in cfoutputs (or in comments) and the problem goes away. Strange, no? So strange that I wrote a test for this. I've pasted my test template below, but if your email client makes it unreadable then you can also download a version here <http://www.WorldDesign.com/CF/BugTest.cfm.txt>. Instructions are in the comment. I'll also submit this to MM. Comments welcome. Cheers, -Max BugTest.cfm --- - Maxim Paperno, CTO World Design Group, Inc. [ CF Development and Hosting since 1996 ] <http://www.WorldDesign.com/> ~~ 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: CF and Hit Counter
So long as you realize that session variables typically rely on cookies (you'd have to use the SetClientCookies=no attribute of CFApplication - I believe that's what it's called). By default, ColdFusion handles this without you knowing it. There are techniques to use session/client variables without cookies, but it's not as easy! Norman Elton College of William & Mary -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 27, 2002 8:35 PM To: CF-Talk Subject: CF and Hit Counter Hi all, I am in the process of writing a hit counter app in java, but in the meantime, I have thrown a little something together in CF and wanted to get some feedback on it. I have a SQL Server backend to this site and what I do is in the application.cfm page, I check for the existence of a variable called session.visitor. If it exists, it means that the application already ran the next part which is the code to look at the users IP and check for it in a table in my DB... if there is a match it sets the variable session.visitor again, and if no match is found it adds a record and then sets the variable. Is there anything wrong with the way I do this?...is there a more efficient way? Just so you know, I am unable to use cookies on this site. Mike __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CF and Hit Counter
In order to use session variables, CF has to keep track of who is whom. Therefore, it sets two cookies without you knowing it (assuming you've enabled session or client variables): CFID and CFTOKEN. Therefore, if you don't want to use cookies, you have to explicitly disable them in the CFAPPLICATION tag. For more information, check out the Client Variables section of the Developing Web Applications with ColdFusion book (part of the documentation, online if you don't have a hardcopy). There are ways to do session/client tracking without cookies, but you have to manually pass the CFID/CFTOKEN combo in URLs or forms between pages. If you forget even one link or form, the session dies and the user gets a new one. I'm sure there are MANY great presentations floating around with more details on how to do this. If you can't find one, I've got one stashed away someplace. Good luck Norman Elton -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 27, 2002 10:45 PM To: CF-Talk Subject: Re: CF and Hit Counter Why is that? All you need to do is setup a datasource in the ColdFusion Administrator and set it as the default storage mechanism for client variables. CF takes ca re of the rest. - Original Message - From: "Norman Elton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 28, 2002 12:50 PM Subject: RE: CF and Hit Counter > So long as you realize that session variables typically rely on > cookies (you'd have to use the SetClientCookies=no attribute of > CFApplication - > I believe that's what it's called). By default, ColdFusion handles > this without you knowing it. There are techniques to use > session/client variables without cookies, but it's not as easy! > > Norman Elton > College of William & Mary > > -Original Message- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 27, 2002 8:35 PM > To: CF-Talk > Subject: CF and Hit Counter > > > Hi all, > > I am in the process of writing a hit counter app in java, but in the > meantime, I have thrown a little something together in CF and wanted > to get some feedback on it. > > I have a SQL Server backend to this site and what I do is in the > application.cfm page, I check for the existence of a variable called > session.visitor. If it exists, it means that the application already > ra n > the next part which is the code to look at the users IP and check for > i t > in a table in my DB... if there is a match it sets the variable > session.visitor again, and if no match is found it adds a record and > then sets the variable. > > Is there anything wrong with the way I do this?...is there a more > efficient way? Just so you know, I am unable to use cookies on this > site. > > Mike > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CF and Remedy
Michael, We have integrated CF and Remedy to a degree. We made a web "front end" to monitor tickets and to run web-based surveys to customers to gauge customer satisfaction. In our case, Remedy stores its data in a MS SQL database, so I just poked around until I figured out what tables were interesting, and found that I could poll the data from there. We do update one or two fields, but we don't create tickets on the fly. You may be able to figure out what tables to "tamper" with to create tickets, but be sure to keep a backup when you're trying everything out. As I recall, the table we found most interesting was T25, or something along those lines. A Remedy admin may know more. Good luck Norman Elton College of William & Mary -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:22 AM To: CF-Talk Subject: CF and Remedy Hi folks; Anyone have any experience integrating CF and Remedy (now Peregrine)? I am working in an environment where we are using Remedy to enter trouble tickets and would like to be able to do this over the Web. I understand there is a new version which is entirely Web based, unfortunately, the client is the Federal government and they might upgrade ten years from now... Anyways, I was wondering if anyone had any experience working with the product and could contact me here or off list with some notes about any issues they ran into. Thanks, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: OpenIngres Database
Thanks Norman -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 3:58 AM To: CF-Talk Subject: RE: OpenIngres Database I've Just spoken to our resident Ingres expert, and his opinion is that you need to use a DB procedure to do it. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 18:37 To: CF-Talk Subject: OpenIngres Database Help! Does anyone know if there's a way to make an auto- incrementing number field in a CA OpenIngres database? Thanks! Norman Elton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What's with this?
Whoa... Definite bug there! I was able to replicate it without much problem at all :) Last check of the calendar verified that yes, there are only 30 days in June. Norman -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:14 AM To: CF-Talk Subject: RE: What's with this? Doesn't June only have 30 days! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 14:11 To: CF-Talk Subject: What's with this? I have this bit of code... and I'm getting this error on date1 In the function CreateDate(year, month, day) the combination of the arguments, which are 2001- 6-31, have resulted in an invalid date value. The valid range of dates approximately covers the period between 100 AD and AD WHY? Steven D Dworman --- Cold Fusion Programmer Web Applications Developer ComSpec International phone: 248.647.8841 cell: 734.972.9676 --- http://www.comspec-intnl.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What's with this? -- Not a BUG!
CORRECTION! Check out the documentation for DaysInMonth()... You have to supply a DATE object, not a numeric month I fell for that one too! Norman -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:14 AM To: CF-Talk Subject: RE: What's with this? Doesn't June only have 30 days! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 14:11 To: CF-Talk Subject: What's with this? I have this bit of code... and I'm getting this error on date1 In the function CreateDate(year, month, day) the combination of the arguments, which are 2001- 6-31, have resulted in an invalid date value. The valid range of dates approximately covers the period between 100 AD and AD WHY? Steven D Dworman --- Cold Fusion Programmer Web Applications Developer ComSpec International phone: 248.647.8841 cell: 734.972.9676 --- http://www.comspec-intnl.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How many dimensions in a given array?
IsArray(variable) tells you if a given variable is an array... Since a 2D array is simply an array of an array, then IsArray(variable[1]) will tell you if the given variable has a second dimension (or at least one in the first element). Likewise, IsArray(variable[1][1]) would tell you if it was a 3D array. Hope this helps Norman Elton -Original Message- From: JoshMEagle [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 11:24 AM To: CF-Talk Subject: How many dimensions in a given array? How do I test to see how many dimensions a given array posseses? This method gives me all the values of a 2 dimensional array, but I need to know if it's a 2D array BEFORE I try this ... unless someone knows a craftier way... ??? #array[a][aD]# Any help appreciated! Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sorting by IP addresses...
I had the exact same problem. I don't know if it's an option for you, but I ended up storing the four octets seperately. Then simply doing a sort on "IPOctet1, IPOctet2, IPOctet3, IPOctet4". Norman -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 2:36 AM To: CF-Talk Subject: sorting by IP addresses... So I am writing some log reporting for my enjoyment... well to make things a little easier to quantify... one thing I want to be ablt to do is ORDER queries by the value stored of the viewers IP ADDRESS... It doesn't work without some modification of the IP address... anyone worked on anything to do this right... for instance I get this in order: 216.56.6.245 216.66.132.134 24.16.140.8 24.165.85.118 24.178.211.39 not exactly right :) ideas please... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sorting by IP addresses...
As far as converting an IP to binary in CFML... Wouldn't be hard to do BitMaskRead. Loop over the address as if it's a list with a period delimiter. Read the bit mask with a length of 8, and smash them all together. I don't see why it wouldn't work, but I haven't tried it :) I don't know how you could tell SQL to do this though. Perhaps there's a conversion function on the DB? Norman -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 9:41 AM To: CF-Talk Subject: Re: sorting by IP addresses... Thanks Hank... the conversion for the 32bit binary would seem best... So has anyone wrote a function/Cf code to convert IPs to their binary representations? Had seen it done elsewhere in this manner and trust the designer... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: "Hanz Zarcovic" <[EMAIL PROTECTED]> Date: Thu, 07 Jun 2001 09:20:48 -0400 Subject: Re: sorting by IP addresses... > Paris, > > I imagine if you are writing some log analyzing software that you are > dumping the logs into a database for easier analysis ? > If you are dumping them into a database then you should just do some > simple > string parsing to break the IP address up into 4 "tiny int" fields in > this > way you'll be able to do any sort of funky processing you want to > them. > > Or to get really freaky why not process them back into their 32 bit > binary > representations > > If you want some SQL ideas just let me know. > > -eric > > - Original Message - > From: "Paris Lundis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, June 07, 2001 2:35 AM > Subject: sorting by IP addresses... > > > > So I am writing some log reporting for my enjoyment... well to make > > things a little easier to quantify... > > > > one thing I want to be ablt to do is ORDER queries by the value > stored > > of the viewers IP ADDRESS... > > > > It doesn't work without some modification of the IP address... > anyone > > worked on anything to do this right... > > > > for instance I get this in order: > > > > 216.56.6.245 > > 216.66.132.134 > > 24.16.140.8 > > 24.165.85.118 > > 24.178.211.39 > > > > not exactly right :) > > > > ideas please... > > > > -paris > > [finding the future in the past, passing the future in the present] > > [connecting people, places and things] > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Simple Access Query Help
How about:
SELECT Avg(DateDiff("n",BegTime,EndTime)) AS AvgLength FROM Meetings WHERE
DatePart("",BegTime) = 2000 GROUP BY Site
That should return the average time in minutes.
Hope this helps
Norman
-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 10:11 AM
To: CF-Talk
Subject: Simple Access Query Help
Hello,
Can anyone help me with this simple query...? I have a "Meeting Table"
which stores the begining time and ending time of each meeting conducted,
per site. I need to write a query to calculate the average
meeting time per site for the year 2000. Below is an example of my table:
MeetingNumber BegTime EndTime Site
1 2:15am 3:00am 3
2 12:30pm 1:05pm 3
3 6:53am 12:08pm 9
Thanks In Advance!!
Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need decryptor tag for CFUG presentation
>>Is it illegal to have such a utility or is it illegal to use the utiltiy. Or perhaps illegal/unethical to use it for the purpose of then using someone else's code? Here's another issue... Is it bad/unethical to use the undocumented tags/functions found in the CF Administrator? These have been "documented" elsewhere (webpages, allaire forums, etc), although the only way people found them was by decrypting the administrator. Norman -Original Message- From: Michael Bruce [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 11:10 AM To: CF-Talk Subject: RE: Need decryptor tag for CFUG presentation Lets be sure we understand something Is it illegal to have such a utility or is it illegal to use the utiltiy. I do believe there is a similar argument about DVDs and DeCSS??? Just a thought... Mike -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 10:29 AM To: CF-Talk Subject: RE: Need decryptor tag for CFUG presentation It would also be a violation of the Digital Millenium Copyright Act. Lon Lentz Applications Developer & CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 9:50 AM To: CF-Talk Subject: Re: Need decryptor tag for CFUG presentation Saying this as Michael Dinowitz, yes. The decrypt utility is illegal according to the MM licensing contract. > Correct me if I'm wrong, and I'm saying this as Ray Camden, not Ray Camden > of Macromedia, but isn't use of this decryptor illegal? Should we so > casually discuss a piece of a software that is probably illegal to use? > > Also, in general, unless you encrypt your OWN files, you should not be > decrypting other people's templates. If you _do_ encrypt your files, you can > contact Tech support for help. Therefore, there is no need for this > software. > > Am I wrong here? And let's not discuss wether it's "right" or "wrong", I'm > talking about legality. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to combine queries
You can probably do it very easily in CF5 using query-of-queries. Otherwise, take a look at the Query Functions, such as QueryAddRow, etc. If you loop through the CFRegistry query, you ought to be able to append those rows right on to the end of the CFQuery query, one by one. Or store the results in a new, third query. Obviously query-of-query is the easiest and quickest (i would imagine) solution, but unless you've got CF5, you're stuck with the manual way. Norman > -Original Message- > From: JoshMEagle [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 08, 2001 11:02 AM > To: CF-Talk > Subject: How to combine queries > > > This was originally part 2 of a 2 part question 1 was answered ... > > How do I combine 2 queries into one? > > I have a query from and one from ... I'd like to > combine them into one query, say: qCombinedQuery so > that I can use the output in the tag ... > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Encrypt of a Javascript/ColdFusion page
Uwe- I'm not sure if anyone got back to you. I think everyone got caught up in the encryption "debate" :). I'm not exactly sure what you encrypted, but something sounds awry. Encryption of CFM means that the user (supposedly) cannot see the SOURCE of the page (i.e. the ColdFusion code). They only see what gets spit out as results. Obviously, this is required for the browser to display it! Since JavaScript is a client-side script, it cannot be encrypted. The best you can do is put it in a seperate file, and link to it in a SCRIPT tag. The user can still open up that file, as it is publically accessible. If you encrypt JavaScript inside of a CFM page, it simply gets decrypted when it gets sent to the browser. I hope this is what you were asking. If not, send another note :) Norman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 2:51 PM To: CF-Talk Subject: Encrypt of a Javascript/ColdFusion page I would like to encrypt a Javascript embedded in a CF-page. I tried it with codeseal.com. After encryption of the CF page JS isn't working correcty anymore. Is there any change to encrypt JS/CF pages, that people can't see the JS coding anymore ? Thanks for ideas. Uwe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Encrypt of a Javascript/ColdFusion page
Oh I see what they do. That's not exactly encryption. They just escape all of the special characters, and then tell Javascript to spit them back out. This is the same format that ColdFusion's URLEncodedFormat would give you. Interesting, but definitely no secure solution. And I serious doubt it would work for JavaScript. Norman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 09, 2001 4:23 AM To: CF-Talk Subject: AW: Encrypt of a Javascript/ColdFusion page Hi Norman, thanks for the answer. I don't think you are right. You can encrypt JS. Look at www.codeseal.com Maybe the work encryption isn't 100%correct. The code is just not readable for the end-user. This would be enough for me. I don't care for the cfm part. The cfm-code isn't visible for the user since it is processed on the server-side. Sure. I am considering the JS-side only. Any other sources than codeseal.com ?? Uwe -Ursprüngliche Nachricht- Von: Norman Elton [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 9. Juni 2001 05:29 An: CF-Talk Betreff: RE: Encrypt of a Javascript/ColdFusion page Uwe- I'm not sure if anyone got back to you. I think everyone got caught up in the encryption "debate" :). I'm not exactly sure what you encrypted, but something sounds awry. Encryption of CFM means that the user (supposedly) cannot see the SOURCE of the page (i.e. the ColdFusion code). They only see what gets spit out as results. Obviously, this is required for the browser to display it! Since JavaScript is a client-side script, it cannot be encrypted. The best you can do is put it in a seperate file, and link to it in a SCRIPT tag. The user can still open up that file, as it is publically accessible. If you encrypt JavaScript inside of a CFM page, it simply gets decrypted when it gets sent to the browser. I hope this is what you were asking. If not, send another note :) Norman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 2:51 PM To: CF-Talk Subject: Encrypt of a Javascript/ColdFusion page I would like to encrypt a Javascript embedded in a CF-page. I tried it with codeseal.com. After encryption of the CF page JS isn't working correcty anymore. Is there any change to encrypt JS/CF pages, that people can't see the JS coding anymore ? Thanks for ideas. Uwe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Design Help
I built a site very similar to this, using the technique Bill explained, with each record having a "parent" record. If you KNOW for sure that there will be no more than three levels, then you can get away with three tables: grandparents, parents, children. This is risky and not the best design. The "parent record" idea worked very well, but there's an even better method to build trees (that's the term for these things) located on www.secretagents.com, as a free sample tutorial for there tutorial services. It's not simple to pickup, but if anyone is interested in building trees of infinite depth, it's certainly an interesting technique. It reduces the number of queries required to find the parent and grandparent of a given child. Using the parent record theory, you've gotta query twice: once to find the parent, then again to find the parent's parent. At least that was the only way I figured out :). Norman Elton -Original Message- From: Bill King [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 11:41 AM To: CF-Talk Subject: Re: Database Design Help Cody, I think you should still design the system so that it can have more than three levels. Your site structure is very common in sites I have been working with and most stay within those three levels, but sometimes there can be a small change that the client wants that messes everything and requires a fourth. ANYWAY: Here is the way we do it: Create a single table called SiteCategories. Within the table create a column called "parent". The first level categories will all have "0" as the parent. Each category will have an ID and the sub categories will use this ID as it's parent. Here are a few example records: catIDcatTitle catDescriptionParent 1 supportdescription of support 0 2 servicesdescription of services 0 3 online desc. of online support1 4 telephone desc. of phone support1 Now when you click on support simply query all records where the parent record is "1" and you will retrieve all support sub records. Simalarly when you want to brong up "phone support" all you would need to do id determine what its' parent is then query all items with the same parent. You can reply to me directly if I have confused you with this. - BILL - - Original Message - From: "Cody" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 7:23 AM Subject: Database Design Help > Hello. I'm trying to build an application but I'm stuck on designing the DB. I'll try to explain how the site is going to be made, and hopefully someone can help. > > There are only going to be 3 levels of pages. Category pages, sub pages, and sub-sub pages. I want to be able to call any page, whether it's a sub-sub, sub, or category page, just by it's id (like pageid=3). > > Then, using only the pageid information I want to be able to get all the other pages in that category... so, for example: > > If pageid 3 was a sub-sub page... when someone goes to that page, I want to be able to list the main category page it's under, the sub pages under that category, and then the sub-sub pages under the sub page (which the current page belongs to). Can anyone help me figure out how I should build the DB to handle this? > > I feel like an idiot because it seems like it would be so simple (especially since I know the pages will always be only 3 levels deep) but I just can't figure out how to make the DB. Please help! > > Cody > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Design Help
I agree that the stuff on secretagents, although interesting, is complicated
:). I haven't gotten around to using it yet...
Have you tried the "parent record" idea? Here's what the table could look
like
Employees
-
EmployeeID
BossID
FirstName
LastName
Each employee has a unique ID (EmployeeID). Each employee also has a boss,
who's ID is stored in the BossID field. The boss is also an employee, so
he's in the tree, along with his boss, etc.
To find the boss of a given user, try:
SELECT * FROM Employees WHERE EmployeeID = #CurrentEmployee.BossID#
To find the workers that a boss is responsible for, try:
SELECT * FROM Employees WHERE BossID = #CurrentBoss.EmployeeID#
In your case, you'd need two queries to get up two levels ("the boss of the
boss of the current employee") in the tree.
Hope this helps. If not, send another note :)
Norman
-Original Message-
From: Cody [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 11:26 AM
To: CF-Talk
Subject: RE: Database Design Help
I tried setting it up using the tutorial on secretagents.com (based on
Celko's Nested Set model), everything seemed to be going along fine, but the
problem I ran into was sorting the branches. I need to be able to arrange
the branches either by alphabetical order or by manually re-arranging the
branches in a order that the client likes (they need to be able to
re-arrange the links themselves at any time in the future). I couldn't
figure out how to do this... so I dropped the nested set model and now I'm
trying to figure out another way.
I'm getting nervous now, it seems I'm in over my head... and I'm running out
of time on this project. :0
Cody
------ Original Message --
From: "Norman Elton" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Mon, 11 Jun 2001 11:01:49 -0400
>I built a site very similar to this, using the technique Bill explained,
>with each record having a "parent" record. If you KNOW for sure that there
>will be no more than three levels, then you can get away with three tables:
>grandparents, parents, children. This is risky and not the best design.
>
>The "parent record" idea worked very well, but there's an even better
method
>to build trees (that's the term for these things) located on
>www.secretagents.com, as a free sample tutorial for there tutorial
services.
>It's not simple to pickup, but if anyone is interested in building trees of
>infinite depth, it's certainly an interesting technique. It reduces the
>number of queries required to find the parent and grandparent of a given
>child. Using the parent record theory, you've gotta query twice: once to
>find the parent, then again to find the parent's parent. At least that was
>the only way I figured out :).
>
>Norman Elton
>
>-Original Message-
>From: Bill King [mailto:[EMAIL PROTECTED]]
>Sent: Monday, June 11, 2001 11:41 AM
>To: CF-Talk
>Subject: Re: Database Design Help
>
>
>Cody,
>
>I think you should still design the system so that it can have more than
>three levels. Your site structure is very common in sites I have been
>working with and most stay within those three levels, but sometimes there
>can be a small change that the client wants that messes everything and
>requires a fourth.
>
>ANYWAY:
>Here is the way we do it: Create a single table called SiteCategories.
>Within the table create a column called "parent". The first level
>categories will all have "0" as the parent. Each category will have an ID
>and the sub categories will use this ID as it's parent. Here are a few
>example records:
>catIDcatTitle catDescriptionParent
>1 supportdescription of support 0
>2 servicesdescription of services 0
>3 online desc. of online support1
>4 telephone desc. of phone support1
>
>Now when you click on support simply query all records where the parent
>record is "1" and you will retrieve all support sub records. Simalarly
when
>you want to brong up "phone support" all you would need to do id determine
>what its' parent is then query all items with the same parent.
>
>You can reply to me directly if I have confused you with this.
>
>- BILL -
>
>- Original Message -
>From: "Cody" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, June 11, 2001 7:23 AM
>Subject: Database Design Help
>
>
>> Hello. I'm trying to build an application but I'm stuck on designing the
>DB. I'll try to explain how the site is going to be made, and hopefully
>someo
RE: HELP! Application Problem.
I don't have much Oracle experience, so I can't speak from that end, but I know that if you're used to Access, MS SQL Server is an easy transition. The price can be a bit prohibitive, but it behaves well with a good administrative interface. It comes with upsizing wizards that imports all your data from Access (or any other ODBC source). I would imagine Oracle could do the same. If you're tight on cash and need a quick fix, you could run MySQL in the interim. It would probably be better than Access. Dave is right in saying that Access is definitely not the solution for you. Although it works for development, anything at production level needs a production database. Access starts to choke after a few concurrent requests. BTW, the site looks good :) Norman Elton -Original Message- From: Chris Straight [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 1:18 PM To: CF-Talk Subject: RE: HELP! Application Problem. we deffinetly have more than 5 or 6 at one given moment. This is the application that every student uses to look up their books. What DB would you suggest we go to? Is it personal preference or does Oracle have something over SQL Server or vise versa? The funny thing is though that it worked before now for actually a long time so this is quite disconcerting. Chris Straight Web Developer University of Oregon Bookstore 895 E. 13th Ave Eugene, OR 97401 (541) 346-4331 http://www.uobookstore.com -Original Message- From: Dave f [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 6:43 AM To: CF-Talk Subject: Re: HELP! Application Problem. How many concurrent users do you have? Access is well-known for its inability to handle more than 5 or 6 - Original Message - From: "Chris Straight" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 3:35 PM Subject: HELP! Application Problem. > Hey everyone we seem to be having a problem with an application of ours > basically what it does is takes book course registration numbers and brings > back the relevant information for each course book. It also allows the > student to retotal the price. > > Right now the application seems to run fine on all of our machines that we > have at our store except the new ones we just received. We are also > receiving complaints from the students as well so I know it's not just us. > > The problem is that when you go to retrieve the books the browser starts to > hang and the completion bar not to mention the page never goes anywhere. if > anyone could check it out at > http://d165-249.uoregon.edu/coursebooks/book_input_fall.cfm it would be > greatly appreciated. I am also willing to send out code snippets for people > as well. I tried cutting down the Database from 2,000 records to about 1,000 > by splitting up the terms thinking that it might be the database size (we > are using Access) but it still hasn't helped. > Thank you for any help in advance. > > Chris Straight > Web Developer > University of Oregon Bookstore > 895 E. 13th Ave > Eugene, OR 97401 > (541) 346-4331 > http://www.uobookstore.com > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL VS ACCESS
Make sure all your fields that should be indexed are indexed. I think the upsizing wizard forgets about this. Hope this helps Norman -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 1:51 PM To: CF-Talk Subject: OT: SQL VS ACCESS I thought that SQL was suppose to be faster than ACCESS. I am running CF 4.5 with ACCESS 2000 and SQL 7.0 I export/import my ACCESS tables into SQL Running the same pages/queries, SQL is on the average taking twice as long. Can anyone give me reasons for this or things I should look into to speed up the SQL. I have been trying to work with stored procedures to put more processing on the DB side, but this seems to be even slower, any ideas what I am doing wrong? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cached Query
Cached queries don't need to be "stored" anywhere. When you specify a query to be cached, ColdFusion stores the results in a special area. When you make the same SQL request to the same datasource within the given timespan, ColdFusion retrieves the results from this hidden area. There's no way to access the cache directly. Storing the results in the Application scope would allow you to retrieve the data without even calling a new CFQUERY, but can quickly bloat the application storage. Caching the results, and calling a new CFQuery, would be preferable. Just specify the time span to cache within, and you're set :). hope this helps! Norman -Original Message- From: Paul Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 4:15 PM To: CF-Talk Subject: Re: Cached Query If it's cached you don't need to put it in Application scope (and probably don't want to). I put mine in Request scope, but I'm not sure I need to. best, paul At 02:52 PM 6/14/01 -0400, you wrote: >Is a cached query always within the application scope? Or do I need to add >"Application." before the query name? > >Thanks >Duncan Hays ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reference on Cold Fusion 5
I believe there's a great run-down in the recent edition of the ColdFusion Developer's Journal, if you can acquire a copy. Otherwise, it seems like I saw a decent one in the online help when I was trying out the beta, but I'm not exactly sure on that one. Norman -Original Message- From: Greg Czechowicz [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 5:12 PM To: CF-Talk Subject: Reference on Cold Fusion 5 Does anyone have a good reference on all the new features of cold fusion 5? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session time out = never ? Bad?
How about client variables instead of session variables? Slightly different, but they may be just what you're looking for. Also, remember that session variables (or client variables, i suppse) will expire if the cookie on the user's end disappears somehow, assuming you're using cookies to maintain session state. Perhaps they have them set to clear out every so often. A truly "endless" session would be hard to maintain. If the registry starts to get clogged, just store the data in a database instead. This is set from CF Administrator. hth, Norman -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 10:24 AM To: CF-Talk Subject: RE: Session time out = never ? Bad? Yes, I do realize that the server will reboot (guessing) monthly. ;-) After thinking about it last night, I also realized that his office only has about 20 people using the system. And, at best/worse he may have about 30 - 40 sessions open to it at one time from his office. Rather minor load. I am trying to get him to convert to client vars. rather then session for this. Any one have more input? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 5:26 PM To: CF-Talk Subject: RE: Session time out = never ? Bad? I'm thinking: Impossible. I mean, I've heard of servers running for months at a time, but 10 years? Yeah RIGHT! HOWEVER, so long as all the session vars don't suck up the server's memory and crash it, I guess you're OK, right? ---mark Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric > -Original Message- > From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 13, 2001 12:51 PM > To: CF-Talk > Subject: Session time out = never ? Bad? > > > > Would it be "bad" to set a session timeout to 10 years in the future? I > have a client that wants to never time out if he or his office workers are > coming to the site from their office. > > I am thinking this would be "bad". Possible server registry blot? > > > "I'm a little fuzzy on the whole good-bad thing. What do you mean bad?" - > Peter Venckman - Ghostbusters > > Mark W. Breneman > -Cold Fusion Developer > -Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Weird Session Timeouts
This one's got me stumped. In my application.cfm, I've got... CFAPPLICATION NAME="PansophyPrd" CLIENTMANAGEMENT="Yes" SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#" APPLICATIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#" Seems right to me. Technically there shouldn't be quotes are the createtimespans, but it doesn't seem to make any difference. In CF Administrator, the maximum session timeout is 10 hours, the default is 20 minutes. The catch is, sessions seem to time out within an hour. Perhaps it's somehow using the 20 minute default (I was away from my desk the entire hour). This has happened before on other servers, and it certainly troubling. Any advice? Thanks Norman Elton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Weird Session Timeouts
That's what I suspect, but I can't figure out why. Again, there's no guarantee that this is the problem, and it takes about an hour of doing nothing just to test it! :) Norman -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 9:11 AM To: CF-Talk Subject: Re: Weird Session Timeouts Think the value specified in CF Admin controls/over-rides the value in the applicatiion.cfm - Original Message - From: "Norman Elton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 9:01 AM Subject: Weird Session Timeouts > This one's got me stumped. In my application.cfm, I've got... > > CFAPPLICATION NAME="PansophyPrd" CLIENTMANAGEMENT="Yes" > SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" > SESSIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#" > APPLICATIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#" > > Seems right to me. Technically there shouldn't be quotes are the > createtimespans, but it doesn't seem to make any difference. > > In CF Administrator, the maximum session timeout is 10 hours, the default is > 20 minutes. The catch is, sessions seem to time out within an hour. Perhaps > it's somehow using the 20 minute default (I was away from my desk the entire > hour). This has happened before on other servers, and it certainly > troubling. > > Any advice? > > Thanks > > Norman Elton > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Weird Session Timeouts
You are correct. However, my 10 hour maximum setting is well above the 8 hour timeout specified in CFAPPLICATION... Norman -Original Message- From: Avi Flax [mailto:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 12:50 PM To: CF-Talk Subject: Re: Weird Session Timeouts Dylan, you are referring to the Default timeouts specified in Administrator. However, there are also MAXIMUM timeouts specified, which can override a timeout set in a CFAPPLICATION tag. Avi At 06:39 AM 6/15/2001 -0700, Dylan Bromby wrote: >It's other way around. If *no* application.cfm is found, the defaults in the >CF Admin will be used. Otherwise, any application.cfm file found by the app >will override the admin. If the admin took precedence, there would be no use >to setting sessions in any application.cfm file. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Weird Session Timeouts
>> Example: >> CFADMIN has Max application time at 10 hours. >> CFAPPLICATIONS has timeout at 8 hours. >> Application should time out within 8 hours. This is exactly what I've got, and is exactly what I would expect to happen. In reality, the session died within an hour. >> How is your memory on your server? I had a problem recently where my >> server's ram maxed out and it stomped all over the session variables. It >> was timing out my sessions every couple of *seconds*. Good thought. I'll check on it. Also, I might try moving the variables out of the registry and into a database. Norman -Original Message- From: Avi Flax [mailto:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 12:50 PM To: CF-Talk Subject: Re: Weird Session Timeouts Dylan, you are referring to the Default timeouts specified in Administrator. However, there are also MAXIMUM timeouts specified, which can override a timeout set in a CFAPPLICATION tag. Avi At 06:39 AM 6/15/2001 -0700, Dylan Bromby wrote: >It's other way around. If *no* application.cfm is found, the defaults in the >CF Admin will be used. Otherwise, any application.cfm file found by the app >will override the admin. If the admin took precedence, there would be no use >to setting sessions in any application.cfm file. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Weird Session Timeouts
I'm the first to admit I don't know tons about how Windows 2000 manages it's memory, but would this show up on the performance tab in the task manager? Does the memory have to be completely used up before Windows releases the session variables, or does it start bailing water before the ship is sunk? Norman -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 11:11 AM To: CF-Talk Subject: Re: Weird Session Timeouts I agree, from what I have seen, most of the problems with session variables timing out early as long as everything is set up correctly are low memory problems. I ran into it myself not to long ago. I dont believe this behavior is documented anywhere though. jon - Original Message - From: "Tim Painter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 10:22 AM Subject: Re: Weird Session Timeouts > How is your memory on your server? I had a problem recently where my > server's ram maxed out and it stomped all over the session variables. It > was timing out my sessions every couple of *seconds*. > > Incidently, I switched them over to client variables (cookie based) and I > haven't had a problem since. > - Original Message - > From: "Norman Elton" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, June 15, 2001 9:01 AM > Subject: Weird Session Timeouts > > > This one's got me stumped. In my application.cfm, I've got... > > CFAPPLICATION NAME="PansophyPrd" CLIENTMANAGEMENT="Yes" > SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" > SESSIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#" > APPLICATIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#" > > Seems right to me. Technically there shouldn't be quotes are the > createtimespans, but it doesn't seem to make any difference. > > In CF Administrator, the maximum session timeout is 10 hours, the default is > 20 minutes. The catch is, sessions seem to time out within an hour. Perhaps > it's somehow using the 20 minute default (I was away from my desk the entire > hour). This has happened before on other servers, and it certainly > troubling. > > Any advice? > > Thanks > > Norman Elton > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fingerprint authentication with Cold Fusion?
I followed up on Steve's stripe reader, and implemented a similar system. It involves the reader impersonating the keyboard, so that data is "typed" into the users browser just like it came from the keyboard. The reader is plugged into the end user's keyboard port. The keyboard is then plugged into the scanner (hence the term, "wedge scanner"). It would be very interesting if a finger print scanner could do this (send data as raw text through the PS/2 port). If so, what would it send? How could this be "authenticated" on the server end? If you find any devices that are capable of this, send out a note! Norman -Original Message- From: Avi Flax [mailto:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 2:30 PM To: CF-Talk Subject: Re: Fingerprint authentication with Cold Fusion? Stephen, sounds like an interesting project. I myself don't know anything about this kind of thing, but I remembered that Steve Nelson did something like this with magnetic cards, so I found the URL just in case it might help you out. Here you go: http://fusebox.org/members/card/index.cfm?fuseaction=cardloginform HTH! Avi At 10:54 AM 6/15/2001 -0500, Stephen Pintauro wrote: >Hello all, >I am interested in setting up a password-protected Web site that would >allow users to use fingerprint authentication to bypass entering a >username and password. I know there are a number of products on the >market that can do this, but I am looking for a more "customizable" >interface. We will be using this on some computers that we are placing >in community senior centers and we want to minimize the hazzle of >enrolling their fingerprints (for new users) and authenticating their >fingerprints (for returning users). It occured to me that Cold Fusion >may be able to play a part here, although I am not sure exactly how. We >are prepared to invest in the fingerprint input devices. I expect that >we will also need some proprietary software that stores and retrieves >the fingerprint info when needed. I have included below a hypothetical >scenario on how I was imagining this whole system could work. My >questions are as follows: > >Has anyone had any experience with a similar application of Cold Fusion? > >Does anyone have any recommendation on a commercial system that we could >interface with Cold Fusion for this purpose? >If there is anyone interested in taking this on as a freelance >consutling project, I would be interested in discussing it with >him/her. Please feel free to contact me off the list. > >My idea for how this might work is as follows: > >1. User is brought to the Welcome page. They are asked if they are a >New User or a Previous User. They then select New User. > >2. User is prompted to enter: > First Name > Last Name > Other demographic info > >3. When the new user presses the Submit button, Cold Fusion will >automatically assign the first letter of their first name and up to the >first seven letters of their last name as their Username. >Cold Fusion will automatically assign a six-character alphanumeric >Password. > >4. First Name, Last Name, Username and passwords will be saved in a >Password database table. > >5. The Submit button will take the user to a page where they will be >asked to place their index finger on the fingerprint hardware device to >enroll their fingerprint. The enrolled fingerprint will be recorded >to the database table associated with that users First Name, Last Name, >Username and Password. This enrollment page will need to have a >customized look. > >6. After the new user is enrolled, they will have access to all other >parts of the Web site. > >7. When they revisit the site, they will indicate that they are a >Previous User. They will then be presented with a Web page where they >will be prompted to place their index finger on the fingerprint hardware >device. They will not need to enter their username nor password. The >fingerprint identification software will search the database for the >matching fingerprint and the associated First Name of the user. When >the user is authenticated, a Web page will be presented that >says .Welcome back, Stephen ..and the rest of the Web site menu. > > >Thanks, >Stephen Pintauro ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Weird Session Timeouts
Very interesting. I will definitely try this. Yes, I did notice the lack of quotes in the online help files, but it never complained with the quotes there. Thanks for the tip. Norman -Original Message- From: Dimo Michailov [mailto:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 1:03 PM To: CF-Talk Subject: Re: Weird Session Timeouts Norman: Let me give my 2 cents. I think I had a similar issue before -- session variables expiring according to the default value in CF Administrator as opposed to the values I specified in Application.cfm. I think the key in this case is the quotes around #CreateTimeSpan()# functions. It seems odd, but we had this situation before and removing the quotes solved the problem. For example, this code works now: Also, if you look at the HELP for CFAPPLICATION: Syntax -- See? No quotes. Try it this way, I hope it works! Dimo - Original Message - From: "Norman Elton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 9:01 AM Subject: Weird Session Timeouts > This one's got me stumped. In my application.cfm, I've got... > > CFAPPLICATION NAME="PansophyPrd" CLIENTMANAGEMENT="Yes" > SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" > SESSIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#" > APPLICATIONTIMEOUT="#CreateTimeSpan(0,8,0,0)#" > > Seems right to me. Technically there shouldn't be quotes are the > createtimespans, but it doesn't seem to make any difference. > > In CF Administrator, the maximum session timeout is 10 hours, the default is > 20 minutes. The catch is, sessions seem to time out within an hour. Perhaps > it's somehow using the 20 minute default (I was away from my desk the entire > hour). This has happened before on other servers, and it certainly > troubling. > > Any advice? > > Thanks > > Norman Elton > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: single user version of 5.0
The evaluation is supposed to fall into "single ip mode" after 30 days, allowing requests from only one IP address. She is correct that there is no such thing as a "single user version" anymore. It may be able to upgrade on the fly, but you'd probably be best off uninstalling your version, and installing the evaluation. I've never tried this personally, but I've heard it on more than one occasion. Norman -Original Message- From: Chris Giminez [mailto:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 1:03 PM To: CF-Talk Subject: single user version of 5.0 I need the single user version of 5.0 for development. I could not find this at allaire or macr. I called macr and was told by a CSR that the evaluation version will work as a single user version after 30 days. This was after she first told me a single user version did not exist. can someone confirm that it does continue to work as a single user version and if not how i can upgrade my 4.5 single user version to 5.0? I need to be able to develop with these nifty new feature without testing on the live server. the macromedia rep really didn't seem to grasp this concept. Thanks, Chris Giminez Cyber Scriber ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Review: CF 5.0
I think if a company benchmarks its own products, you can
rest assured that the results will be somewhat skewed :)
Norman
Quoting Edward Smith <[EMAIL PROTECTED]>:
> I'm of the opinion that Macromedia cooked the
> benchmark results to get
> what they wanted. Either that, or I'm reading them
> wrong. Macromedia's
> benchmark document is here:
>
>
http://www.macromedia.com/software/coldfusion/productinfo/pe
rformance_brief/cf5_perf_brief.pdf
>
> Please check out page 12 of the PDF.
>
> In the table of settings, note that Macromedia set
> the 4.5 server to 1
> thread per cpu. This is contrary to their own 4.5
> tuning specs, and
> certainly nothing any of us would do on a production
> server
> ('simultaneous requests' in the table). Am I
> reading this wrong? On
> the 5.0 server, they set to 4 threads per cpu.
>
> I find it hard to believe that they would skew their
> testing so
> obviously, but I can't find any other conclusion.
>
> Comments?
>
> Bud wrote:
> >
> > I particularly find this interesting:
> >
> > On Windows 2000, Macromedia benchmarks indicate
> that ColdFusion
> > Server 5 processes page requests up to 5 times
> faster than ColdFusion
> > Server 4.5.1.
> >
> > Anyone have any real life experiences on how much
> faster it REALLY
> > is? How about on NT?
> > --
> >
> > Bud Schneehagen - Tropical Web Creations
> >
> > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > ColdFusion Solutions / eCommerce Development
> > [EMAIL PROTECTED]
> > http://www.twcreations.com/
> > 954.721.3452
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
UUID Woes
I'm starting to use UUIDs as primary keys, and they work great. Using Ingres, I just stored them as strings, and indexed them to be primary keys. According to the Ingres gurus, this wasn't a big deal. I was happy to see that MS SQL 2000 has native support for UUIDs. Unfortunately, their idea of a UUID is a bit different from ColdFusion: MS SQL: ---- ColdFusion: ---xxx Needless to say, SQL won't accept ColdFusion's UUIDs. Does anyone know a way to get around this and allow ColdFusion to specify UUIDs to SQL? Thanks! Norman Elton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: execute programs
If you're looking to run a program on the server, CFEXECUTE works fine. If you want to run a program on the CLIENT's computer, well that's definitely a security risk. There's no built- in feature. You'd have to write up an ActiveX control or something similar, then promise all your users that it's in fact safe. On the other hand, you can still "run" MS Word. Simply send the user a file with extension .DOC, and Word should automatically open. if the user is using Netscape, they'll have to first save the file, then open it by hand. If you want the file to be dynamic, you can use CFCONTENT. Norman Elton -- Original Message -- is there a cutsom tag or a cf tag that would allow me to execute a program from a web browser? like could i run notepad or word thru the web browser? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UUID Woes
That's almost exactly what I've done... It seems to work.
The Insert() function works a bit quicker.
I was thinking of using Varchar(35), but although I don't
understand all the inner workings of how SQL Server stores
it data, I would imagine if they made a datatype for UUIDs,
it's more efficient. I would imagine (hope) it stores it as
hexadecimal rather than a 35-character string.
Thanks again for all the comments/suggestions.
Norman
Quoting "Jones, Matt" <[EMAIL PROTECTED]>:
> you could create a custom tag that does something
> like this
>
>
>
> mid('#newUUID#',24,12)>
>
>
>
>
> -Original Message-
> From: Norman Elton [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 7:17 PM
> To: CF-Talk
> Subject: UUID Woes
>
>
> I'm starting to use UUIDs as primary keys, and they
> work
> great. Using Ingres, I just stored them as strings,
> and
> indexed them to be primary keys. According to the
> Ingres
> gurus, this wasn't a big deal.
>
> I was happy to see that MS SQL 2000 has native
> support for
> UUIDs. Unfortunately, their idea of a UUID is a bit
>
> different from ColdFusion:
>
> MS SQL:
> ----
> ColdFusion:
> ---xxx
>
> Needless to say, SQL won't accept ColdFusion's
> UUIDs. Does
> anyone know a way to get around this and allow
> ColdFusion
> to specify UUIDs to SQL?
>
> Thanks!
>
> Norman Elton
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: gettting value from dynamically created variables
If you're running CF 4.5 or greater, then the Form elements are represented as a structure, so StructFind works wonderfully: StructFind(Form,ii) Should do just what you need. Using Evaluate() would also work, but it's somewhat slower. Hope this helps. Norman ... John Barleycorn wrote: > > hello, > i have a list of dynamically created text boxes that are named with a > string that holds the value of id|name|dataType. on the next page i > extract the id, name and dataType of each item using cfloop on the > FIELDNAMES list and getToken on each part of the list extracted by the > loop. trouble is, i also need the value that the user entered into the > text box. can anyone tell me how i would get this value? > > example: > > cfloop list="#FIELDNAMES#" delimiters="," index="ii" > cfset myID = GetToken(ii, 1, "|") > cfset myName = GetToken(ii, 2, "|") > cfset authMode = GetToken(ii, 3, "|") > cfset valueFromFormField = ??? > /cfloop > > i've searched the archives for an answer to my question, but was > unable to find one. Thanks for any help. > > newbie > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VNC & cfexecute
Mike- Ray was right. You can't directly run programs on a client's computer. It's a big fat security disaster waiting to happen. VNC, however, does allow for backwards connections. The client can be in "listen" mode, and will accept connections from a server. This may accomplish just what you need. Check out the docs at http://www.uk.research.att.com/vnc/winvncviewer.html. Unfortunately, the client must be listening. There's no way to force a connection otherwise. It might take some creative scripting to get it to open the connection to a listening computer, but it's physically possible. Somehow :) Norman Elton -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 4:14 PM To: CF-Talk Subject: VNC & cfexecute Anyone run cfexecute to start up vnc on a client pc with the IP address plugged in? Also does the name path in cfexecute mean the clients path or the servers path? THanks mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does CF 4.5 Pro Support Advanced Security?
4.5 Professional does support advanced security. It's an option when you install the server. In CFAdmin, you'll see a tab for advanced security. This tab won't appear if you didn't install it when you installed CF. The choice to install AS won't appear on OSes that don't support it, such as Windows 98. I believe; however, that NT does support advanced security. In any case, CF Enterprise isn't required. Norman >Correct > -Original Message- > From: Tony Garrido [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 20, 2001 3:31 PM > To: CF-Talk > Subject: Does CF 4.5 Pro Support Advanced Security? > > > > I'm trying to setup CF 4.5 Pro to use NT Authentication, I > can't find the screens to set this up, so I'm guessing I need > Enterprise to do this. > > Can anyone confirm this? > > Sincerly, > > Tony Garrido > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Me Vs. Complexed Table Design
Sounds like you're trying to implement a tree (it's formal name). For a good lesson, check out Steve Nelson's free tutorial at www.secretagents.com. The concepts somewhat complicated, so you might have to read it a few times, but works well. As an alternative, you could just keep track of the following for each record: 1. ID 2. Name 3. Parent ID Where Parent ID is the parent of the current record. This makes it hard to build a link from a record (known as a node) back to the root of the tree. You'd probably have to loop over a CFQUERY, which gets nasty. Hope this helps Norman Quoting Michael Lugassy <[EMAIL PROTECTED]>: > We have a big index of sites, each site belongs to a > certain "main category" > and a sub_category. > > Certain sites are nested inside 2,3 and even 5 > sub-sub categories. > > How can I create a category(ies) table(s) that will > store the catID and catNAME? > (each category/subcategory ID takes 2 places xx) > > Here is an Example: > > The Yahoo! site, for example is in: > > Computers and Internet > Internet > Internet and > Search Engines > Directories > World > > Where Computers and Internet = 24 00 00 00 00 > (I've added space just to explain what I need) > Internet = 24 11 00 00 00 > Internet and Search Engines = 24 11 92 00 00 00 > Directories = 24 11 92 83 00 00 > World = 24 11 92 83 00 > > Ofcourse there could be more then one sub-sub > category named "world" > and the sub-sub count varies. > > Any help, tips, something? > > Michael. > > > ~~ 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
Re: Me Vs. Complexed Table Design
They provide a service (which you must pay for) that unlocks lots of tutorials, but some are available for free. The one you're looking for is "nested trees", and can be found by clicking "You still have time to learn" > "Free online training" > "Nested trees" Good luck! Norman Quoting Michael Lugassy <[EMAIL PROTECTED]>: > I didn't find secretagents' tutorial, > the site looks alot like hotmail, I can't get in > without becoming > a member, or what? :) > > I would like to take a look at it before implement > the alternative. > > Michael. > > - Original Message - > From: "Norman Elton" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, July 23, 2001 8:07 PM > Subject: Re: Me Vs. Complexed Table Design > > > > Sounds like you're trying to implement a tree > (it's formal > > name). For a good lesson, check out Steve Nelson's > free > > tutorial at www.secretagents.com. The concepts > somewhat > > complicated, so you might have to read it a few > times, but > > works well. > > > > As an alternative, you could just keep track of > the > > following for each record: > > > > 1. ID > > 2. Name > > 3. Parent ID > > > > Where Parent ID is the parent of the current > record. This > > makes it hard to build a link from a record (known > as a > > node) back to the root of the tree. You'd probably > have to > > loop over a CFQUERY, which gets nasty. > > > > Hope this helps > > > > Norman > > > > Quoting Michael Lugassy <[EMAIL PROTECTED]>: > > > > > We have a big index of sites, each site belongs > to a > > > certain "main category" > > > and a sub_category. > > > > > > Certain sites are nested inside 2,3 and even 5 > > > sub-sub categories. > > > > > > How can I create a category(ies) table(s) that > will > > > store the catID and catNAME? > > > (each category/subcategory ID takes 2 places > xx) > > > > > > Here is an Example: > > > > > > The Yahoo! site, for example is in: > > > > > > Computers and Internet > Internet > Internet > and > > > Search Engines > Directories > World > > > > > > Where Computers and Internet = 24 00 00 00 00 > > > (I've added space just to explain what I need) > > > Internet = 24 11 00 00 00 > > > Internet and Search Engines = 24 11 92 00 00 > 00 > > > Directories = 24 11 92 83 00 00 > > > World = 24 11 92 83 00 > > > > > > Ofcourse there could be more then one sub-sub > > > category named "world" > > > and the sub-sub count varies. > > > > > > Any help, tips, something? > > > > > > Michael. > > > > > > > > > > > > ~~ 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
Re: Me Vs. Complexed Table Design
You're right, it gets messy very quickly. The big drawback is lots of queries. If you're five or six levels "deep", your page will take five or six queries to figure out the path back to the root. This might not be what you want if you're aiming for performance. Of course, if you cache the queries, you could be in luck. I implemented it once using CFLOOP. Inside the loop is a CFQUERY that fetches the next level up, and stores its data into an array. Keep looping until the "next level up" has the ID of zero, which means you've reached the top. The top level record has a parent of zero. I've wanted to go back and convert it to the nested tree model, but haven't gotten around to it :) If you need more detailed info, i can dig up the code. Norman Quoting Michael Lugassy <[EMAIL PROTECTED]>: > Let's say I'm using the second (following) > alternative: > > CATEGORIES: > catID > parentCat > catName > > SITES: > siteID > siteName > catID (FK) > > and I want to display a tree of categories, based on > a catID from sites > how can I SQL-SELECT recursivley, all the relevent > catNAMES? > > Sounds pretty messy... > > Michael. > > - Original Message - > From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, July 23, 2001 9:13 PM > Subject: RE: Me Vs. Complexed Table Design > > > > > I didn't find secretagents' tutorial, > > > > That's because it's Secret > > > > Actually, it's here > > http://www.secretagents.com/tools/freeviewlets/ > > (You Still Have Time To Learn, Free Online > Training) > > > > or here > > http://www.secretagents.com/tools/viewlets/ > > (You Still Have Time To Learn, Professional Online > Tutorials) > > > > Philip Arnold > > Director > > Certified ColdFusion Developer > > 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. > > > ** > > > > > > > > > ~~ 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
Re: SmServAz.exe...cf server?
SmServAz.exe has to do with SiteMinder, which is part of ColdFusion's Advanced Security. If you're not using advanced security, you probably won't see it. I thought (i could be wrong here) that it also ran under 4.5. Perhaps you weren't running advanced security then? Norman Quoting Don Vawter <[EMAIL PROTECTED]>: > Doesn't exist on my server > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 25, 2001 8:54 AM > Subject: SmServAz.exe...cf server? > > > > Hello, > > > > We just had our server upgraded to CFServer > 5.0 yesterday. This > morning, when we connected via pcanywhere, we get > the "system is busy or > waiting for a response" message and the app that > it's referring to is > SmServAz.exe. Is that an exe file in CF server 5.0? > Our servers are hosted > remotely so I can't look for myself and the folks on > that end are > speculating. > > > > Thanks all! > > > > > > Michael Corrigan > > Programmer > > Endora Digital Solutions > > www.endoradigital.com > > 630/942-5211 x-134 > > > > > > > ~~ 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
Re: CFLDAP
I suggest changing your password. CFLDAP can be finicky. Make sure you've got the right filter/start/scope. If you can find another program to run the same query (an LDAP program), I usually find that it helps a lot. Norman Quoting Kevin Faust <[EMAIL PROTECTED]>: > I'm using a CFLDAP tag to gather some information > for a option grant system the query works but seems > to take up to 15 minutes to run does anyone have any > suggestion on speeding up a LDAP query. > > Server="deun50.corp.newmont.com" > USERNAME="uid=egrant,o=newmont.com" > PASSWORD="one2three" > ACTION="QUERY" > Name="Query_LDAP" > START="O=newmont.com" > SCOPE="SUBTREE" > FILTER="(uid=#Auth_User#)" > ATTRIBUTES="uid,employeenumber,cn,sn,mail" > SORT="uid asc"> > > Thanks Kevin > > > > Kevin Faust > Senior Systems Analyst > Newmont Mining Corporation > 1700 Lincoln Street > Denver, Colorado 80203 > > (303)-837-5731 > [EMAIL PROTECTED] > > > ~~ 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
Weird Memory Address Displayed
Hello all! This afternoon, one of our CFM pages stopped working. Rather than displaying an error, it just gave an odd memory address: -2147417848 (0x80010108) All other pages on the site worked fine. For some reason, just this one page was bad. We created a new site in IIS and copied all the files over. The new "site" worked perfectly, but the old copy of the file was bad. We checked all the error logs, which revealed nothing. We figured it must be an IIS issue, or an issue between IIS and ColdFusion. For now, we're running the application off under the new name, but we'd like to figure out what cause the first one to go bad. Has anyone ever seen this before? Thanks! Norman Elton Information Technology College of William & Mary ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Studio on Linux??
Has anyone found a good way to run CF Studio or Homesite on Linux? I've seen it running on VMWare, and have heard rumors that you can load Homesite using WINE, but am looking for anybody who can verify this. Does anyone else use Linux as a primary OS for development? What editor do you use for CFML? I would use a standard editor, but I would really miss the instant F1 help key :) Thanks! Norman Elton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio on Linux??
I've looked into Quanta. From what I understand it is fairly customizable. Are there any customizations available for CF developers? I certainly don't hate Windows nor Microsoft. They're certainly the driving force behind lots of cool stuff out there. I would; however, like to learn more Linux. Thanks Norman -Original Message- From: Javier Woodhouse [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 7:50 PM To: CF-Talk Subject: RE: Studio on Linux?? hating windows does not mean hating good UI... What most people dont like about windows is Microsofts bussiness tactics... Followed by the operating systems instability and security holes.. > -Original Message- > From: zac [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 27, 2001 10:44 AM > To: CF-Talk > Subject: Re: Studio on Linux?? > > > Michael Rosario wrote: > > > You may want to check out http://quanta.sourceforge.net/ > > Which begs the question: If Linux users hate Windows so much > why do they > clone windows apps and use the same UI conventions as Windows? > > -- > >Don't blame me. >I voted for Kodos. > > >email: [EMAIL PROTECTED] >WWW: http://www.pixelgeek.com/ > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Text will hold something like 2 gigabytes (i don't have the docs in front of me)... If that's not big enough, storing it in SQL probably isn't a good idea. Try storing it in a file and storing the filename in SQL. As a side note... http://terraserver.microsoft.com stores satellite images of most of the US. All the images are stored as BLOBs in a SQL Server cluster. Norman Quoting Andrew Scott <[EMAIL PROTECTED]>: > I need something bigger than 8000, more like double > this... I have tried > all these!! > > > > -Original Message- > > From: Craig Dudley [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, 28 July 2001 1:46 AM > > To: CF-Talk > > Subject: RE: SQL 7.0 > > > > ntext > > > > but I prefer to use varchar(8000) > > > > -Original Message- > > From: Andrew Scott [mailto:[EMAIL PROTECTED]] > > Sent: 27 July 2001 16:28 > > To: CF-Talk > > Subject: SQL 7.0 > > > > > > What is the equivalent to memo in ms SQL 7.0, for > the life of me my > mind > > has gone to the fairies on this one! > > > ~~ 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
Re: Newbie question
That's true, CF comments should be , not > - Original Message - > From: [EMAIL PROTECTED] > To: CF-Talk > Sent: Tuesday, July 31, 2001 5:37 AM > Subject: Newbie question > > > Hi all > I've got a problem and I can't solve it. > I'm trying to follow a book example > > That is the code: > > > Coldfusion Informe > Barcos > > >dbtype="ODBC" username="podsd" password="23524" > > Select C01010, C01015 from SIG00010 where C01010 > ='7327720' > > > > Lloyd : #C01010# > Eslora : #C01015# > > > > > And that's what I obtain: > > Select C01010, C01015 from SIG00010 where C01010 > ='7327720' > Lloyd : #C01010# > Eslora : #C01015# > > The book says that we should obtain the values > which correspond with those fields.It seems like > ColdFusion doesn't recognize his tags > I don't know why > Can anybody tell me what could be happenig? > > Thanks in advance > Best regards > Manuel > ~~ 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
Re: Documentation and numbers to back up best practices?
> Again, after reading this in CFDJ, I tried a test. > Setting 100 > variables using cfset and the same 100 variables > inside of cfscript > both take the same amount of time, within a few > milliseconds. The only test I ever did showed that CFSET was significantly faster than setting the variables in CFSCRIPT, although everything i read says that CFSCRIPT is faster. I figure if I really need to shave of a bazillionth of a microsecond, I'll reconsider. But in the mean time, I've found that they both perform fine. Norman ~~ 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
CFML Validator
Somebody asked me today why the CFML Validator in CF Studio doesn't work right. I must admit, I haven't used it, so I tried it out to see what it did. Any time I put ANY cfml code in the page, it died, saying "CFML Validator Exception. Please contact support with the template that gave this message". Even a simple CFOUTPUT causes the validator to crash. Does anyone know a way to shore it up, or was it designed (like the infamous Design Mode) to be used only for HTML? Thanks in advance Norman Elton ~~ 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
RE: CFML Validator
Studio 4.5.2. I had installed CSE Validator, but took it back off if that makes any difference. Thanks Norman Quoting "Tangorre, Mike" <[EMAIL PROTECTED]>: > mine works fine.. what version are you using? > > > Michael T. Tangorre > > Web Applications Developer > Office Phone: 703-558-4746 > Cellular Phone: 607-426-9277 > AIM: CrazyFlash4 > Personal Email: [EMAIL PROTECTED] > Work Email: [EMAIL PROTECTED] > School Email: [EMAIL PROTECTED] > > This Email contains MillenniuM Information > Systems, LLC Privileged Information which > is Customer or Business Sensitive. > -------- > > > -Original Message- > From: Norman Elton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 08, 2001 12:39 PM > To: CF-Talk > Subject: CFML Validator > > > Somebody asked me today why the CFML Validator in CF > Studio > doesn't work right. I must admit, I haven't used it, > so I > tried it out to see what it did. > > Any time I put ANY cfml code in the page, it died, > > saying "CFML Validator Exception. Please contact > support > with the template that gave this message". Even a > simple > CFOUTPUT causes the validator to crash. > > Does anyone know a way to shore it up, or was it > designed > (like the infamous Design Mode) to be used only for > HTML? > > Thanks in advance > > Norman Elton > ~~ 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
Re: counting form fields
> Is there any way to get a count of the number of > fields that are returned > from a form? Form.FieldNames is a comma delimited list of all the fields returned in a form. You can slap a ListLen() around it and it will return the number of elements in the list. > Also, is there a way to get a count of the number of > records selected by a > cfquery MyQuery.RecordCount works well :) Norman ~~ 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
RE: Storing passwords in database as one way hash
Bob- You store the password hashed. You're right, you can't decrypt it. When someone attempts to login to the system, you hash their attempted password. If that matches the hashed password in the database, then they're in. If not, whatever they typed doesn't match the "dehashed" value in the database. This allows you to authenticate users, but guarantee that nobody can "read" their password. Norman Elton Information Technology College of William & Mary -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 5:55 PM To: CF-Talk Subject: RE: Storing passwords in database as one way hash But if it's a one way hash, why do you need to store it, you can't decrypt it. What is the purpose? Bob Everland -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 4:39 PM To: CF-Talk Subject: RE: Storing passwords in database as one way hash Who ever said it is going to be used one time? I need to securely store the passwords for several dozen competing users On Tue, 17 Oct 2000, Robert Everland spake thusly: > Why even bother storing a password in a one way hash if it's only gonna be > used one time? > > Robert Everland III > Web Developer > Dixon Ticonderoga > > > -Original Message- > From: Cameron Childress [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 17, 2000 2:32 PM > To: CF-Talk > Subject: RE: Storing passwords in database as one way hash > > > > anybody know of anything that does such? > > I am looking for pretty much the same functionality as a standard > > *NIX login > > Look up the function Hash(). I think it was introduced in CF 4.5. > Actually, I just looks at the online cfdocs and don't see it in there, but > it is... maybe introduced in 4.5.1? > > There's also a CFX_HASH in the tag gallery that give many more options of > hash types. > > -Cameron > > > Cameron Childress > ElliptIQ Inc. > p.770.460.7277.232 > f.770.460.0963 > > -- -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] JAPH *** Be alert, the world needs more lerts *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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: Running a Dynamically Created Query
Chad- Make sure you are using the PreserveSingleQuotes function around any string value. ColdFusion will convert your single quotes to double quotes unless you specify otherwise, and this can throw SQL Server off. Norman Elton Information Technology College of William & Mary -Original Message- From: Chad Elley [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 19, 2000 12:19 AM To: CF-Talk Subject: Running a Dynamically Created Query I have set up a series of Cold Fusion templates that build a dynamic SQL statement. I have run into a "stump in the road" as a result. The SQL statement consists almost entirely of variables equaling an integer, but when I have a variable equal to a string, I get errors. For example, when I attempt to drop a value enclosed in single quotes (i.e. city = 'Atlanta'), I get errors. Here is the problem though... We can copy the code into SQL server 2K and it runs perfectly, but when it executes it through Cold Fusion passing it into SQL server, it bombs out. Any suggestions? Thanks, Chad Elley 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]
Current URL Variable?
Isn't there a variable (CGI?) that contains the URL the visitor used to access the current page? I looked through the CGI variables, but couldn't find it. I know it must be very simple :) Thanks! Norman Elton Information Technology College of William & Mary 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: Current URL Variable?
No, HTTP_REFERER returns the name of the page that sent the user to the current page. I need the name of that current page. If a user visits 'http://www.mysite.com/mydir/mypage.cfm', how do I refer to that URL within mypage.cfm? Norman Elton Information Technology College of William & Mary -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 19, 2000 7:26 PM To: CF-Talk Subject: RE: Current URL Variable? Are you thinking of HTTP_REFERER? Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Norman Elton [mailto:[EMAIL PROTECTED]] Isn't there a variable (CGI?) that contains the URL the visitor used to access the current page? I looked through the CGI variables, but couldn't find it. I know it must be very simple :) 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]
Self-referencing Query?
I've got a strange query question for you SQL experts: I've got two tables: Users and Divisions. Each User has one Division (linked by a field on the user), and each division has a director (linked by a field on the division). How can I write a query to return all the users and their division heads (Users --> Divisions --> Users). I'm using MySQL, so subselects are out. Any other ideas? Thanks!!! Norman Elton Information Technology College of William & Mary 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: HTML Anchors displayed as Text
I was able to accomplish this by replacing "<" with "<", and ">" with
">". For example:
<A HREF="whatever">something</A>
should work.
Good luck!
Norman Elton
Information Technology
College of William & Mary
-Original Message-
From: Joseph J. Sanger, M.D. [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 29, 2000 1:35 PM
To: CF-Talk
Subject: HTML Anchors displayed as Text
--_-1239278004==_ma
Content-Type: text/plain; charset="us-ascii" ; format="flowed"
I am storing HTML Anchors in a database (happens to be oracle, but I
don't think that is germane). I would like to read them out and
dispaly the text of the anchor, not have it interpreted and displayed
AS the actual anchor. In other words, I want to see: something, not merely the underlined something.
Is this possible? Thanks.
--
___
Joseph J. Sanger, M.D.| Phone: (212) 263-7410
Associate Professor of Clinical Radiology | Fax: (212) 263-2039
Director, Division of Radiology Informatics |
Co-Director, Division of Nuclear Medicine |
Co-Director, Nuclear Cardiology |
New York University School of Medicine| [EMAIL PROTECTED]
___
--_-1239278004==_ma
Content-Type: text/html; charset="us-ascii"
<!--
blockquote, dl, ul, ol, li { margin-top: 0 ; margin-bottom: 0 }
-->HTML Anchors displayed as Text
I am storing HTML Anchors in a database (happens to be oracle,
but I don't think that is germane). I would like to read them
out and dispaly the text of the anchor, not have it interpreted and
displayed AS the actual anchor. In other words, I want to see:
<A HREF="whatever">something</A>, not merely the
underlined something.
Is this possible? Thanks.
--
___
Joseph J. Sanger,
M.D. | Phone: (212) 263-7410
Associate Professor of Clinical Radiology
| Fax: (212) 263-2039
Director, Division of Radiology Informatics |
Co-Director, Division of Nuclear Medicine
|
Co-Director, Nuclear
Cardiology |
New York University School of
Medicine |
[EMAIL PROTECTED]
___
--_-1239278004==_ma--
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: CFLINUX
Considering the quotes on the left, the articles about Microsoft invading Cuba, the bogus daemon names I'd say it's a hoax. But a good one! :) Norman Elton Information Technology College of William & Mary -Original Message- From: Brian bouldernet [mailto:[EMAIL PROTECTED]] Sent: Monday, October 30, 2000 1:00 AM To: CF-Talk Subject: CFLINUX http://www.mslinux.org/ Any feedback would be great... 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]
Deployment Tools
Does anyone know of any good (preferably free) project deployment tools? Perhaps some sort of FTP script. I use Studio's deployment wizard, but find it cumbersome, and often produces DLL errors! Thanks for any input you may have. Norman Elton Information Technology College of William & Mary 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]
Mail Server Authentication
Does anyone know of a way to authenticate a user off of a mail server? I have been using CFPOP with CFTRY, but this becomes extremely clumsy if the user has hundreds of messages, even if I don't retrieve the message bodies. Thanks! Norman Elton Information Technology College of William & Mary 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: Text box widths in Netscape...
I don't believe Netscape supports the width attribute on TEXTAREA. The only way (that I know of) is to set the COLS attribute, and estimate about how many columns will fit in the appropriate size. If anyone knows of a solution, I'd love to know! Norman Elton Information Technology College of William & Mary -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 01, 2000 9:46 PM To: CF-Talk Subject: RE: Text box widths in Netscape... I can't say that I have seen this before, however it sounds like a css problem. Are you using a styleguide with a font that might not be a native font to all platforms, or do you mean that this is occuring on the same platform machine that uses both browsers. regards Andrew Scott Senior Cold Fusion Application Developer ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: 02 November 2000 08:24 To: CF-Talk Subject: Text box widths in Netscape... Anyone know how to explicit control the width of a text box in Netscape? Everything looks great in IE, but my text boxes in Netscape are twice as wide, and are skewing my table layout... :( -Kev > -Original Message- > From: Richard Kern [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 01, 2000 4:21 PM > To: CF-Talk > Cc: 'Dylan Bromby' > Subject: RE: CFHEADER > > > This may be what you are looking for > > > button to logout -- > > > > --logout action form > > > > You are logged out > > -- response with humor after the logout > process-- > > > > SELECT elapsedtime,userID > FROM uservariables > WHERE (pass = '#session.pass#') > > > You are no longer logged into the site. > You must log on to do any more study. > Thanks, > CDWMVTSHPUSA > Colorado Division of Web Management for > Virtual Traffic School, High Plains of United States of America > > > > The result is that the user cannot go back into the site because the > application.cfm and index.cfm pages are checking for the logged > in value. I > also clear the cache through meta entries so that the user has no access > that way. > > Richard Kern > > > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 01, 2000 2:00 PM > To: CF-Talk > Subject: Re: CFHEADER > > > This didn't work. Has anyone done this? Again - I want to allow users to > logout. If they then use the BACK feature in their browser, I don't want > them to be able to see the page they logged out from. > > --Dylan > -- > -- > 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] 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: Dynamic Variable Names in a CFSET
Try: Norman Elton Information Technology College of William & Mary -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 02, 2000 11:06 PM To: CF-Talk Subject: Dynamic Variable Names in a CFSET Hello, What's the best way to dynamically name variables used in a CFSET tag? I want them named choice0, choice1, etc up through however many loops are made: (which does not work but illustrates what I'm trying to do. Thanks, Dave 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]
Novell Advanced Security Woes
Yes, it's the two things I hate the most: Novell, and Advanced Security But alas I must authenticate users. I've got advanced security setup to authenticate off of LDAP. It fails if you don't enter a valid user name, but it doesn't seem to care what password you type in. Has anybody figured out how to authenticate NDS users? Surely it's been done. Thanks! Norman Elton Information Technology College of William & Mary 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: Dates in the future
You need to remember that 20001031 (Oct. 31st) + 1 = 20001101 (Nov. 1). The "adding one" trick works until you reach the end of the month. Norman Elton Information Technology College of William & Mary -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 04, 2000 5:32 PM To: CF-Talk Subject: Re: Dates in the future > This might not be a solution to your problem, but I'd thought I'd point it > out anyway. > If you DateFormat to MMDD, then every consecutive day is numerically > larger than the last. > So any calculations for dates is very easy. Seems logical...is it really just a case of calculation, though? For instance - taking today to be 20001104 - next week would be 20001104 + 7? 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] 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: Novell Advanced Security Woes
Steve- I've got CFLDAP to find the user in NDS, but I can't seem to make it check the password. Here's what I'm doing now: - One anonymous CFLDAP to find the user's name and verify that it exists. - Another CFLDAP, this time using the name and password. Regardless of what the user types in, CFLDAP happily returns the same data as the first query. I'm not a Novell admin, so unfortunately I don't understand much on that end. I've asked, and he (the novell guy) doesn't know much as far as LDAP for NDS. Any advice? Thanks! Norman Elton Information Technology College of William & Mary -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 04, 2000 10:41 PM To: CF-Talk Subject: RE: Novell Advanced Security Woes With native CF capability you'll have to use CFLDAP to query NDS' LDAP interface directly. This doesn't allow you to use NDS as your AS repository but, it's better than nothing. You could try hand building the schema in NDS. Another option is to use native OS authentication/authorization but, have that redirected to NDS. Like using Client32 for NT. Steve -Original Message- From: Norman Elton [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 04, 2000 3:39 PM To: CF-Talk Subject: Novell Advanced Security Woes Yes, it's the two things I hate the most: Novell, and Advanced Security But alas I must authenticate users. I've got advanced security setup to authenticate off of LDAP. It fails if you don't enter a valid user name, but it doesn't seem to care what password you type in. Has anybody figured out how to authenticate NDS users? Surely it's been done. Thanks! Norman Elton Information Technology College of William & Mary 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]
