Is this a job for Verity?
Hi all, I have an application hosted on CFAS 4.0.1/MS SQL Server 7 which requires a search feature for news articles. The article text for each item is stored in an external html file. The title, category, date and filename for each article is stored in the db. I am kinda stumped as to how I can elegantly search the full text of the articles. Could this be a job for Verity? I have not used it before. And if it is, how can I associate the correct db entry with the text in the external file in my search results? Thanks for any pointers, K. __ Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Alternative To SQL Server Enterprise Manager
DataBaseBlocks is cool. http://www.commerceblocks.com Rick - Original Message - From: "Lee Fuller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 10:10 AM Subject: RE: Alternative To SQL Server Enterprise Manager > Actually, I'd like to find something that my clients can use, to login to > their SQL database and make changes. Also, that will work with the security > of the SQL server to keep unwanted eyes out of other DB's. (Kinda like what > MySQL will do.) > > Lee > > > > -Original Message- > > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 02, 2001 9:58 AM > > To: CF-Talk > > Subject: RE: Alternative To SQL Server Enterprise Manager > > > > > > DB Artisan and ERStudio are pretty slick. > > > > -Original Message- > > From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 02, 2001 8:18 AM > > To: CF-Talk > > Subject: OT: Alternative To SQL Server Enterprise Manager > > > > > > I'm wondering if any CF'ers here has found an affordable > > alternative to SQL > > Server's Enterprise Manager? I had found SQL Navigator from > > http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking > > in a lot of areas, as well as buggy as h*ll... > > > > Enterprise Manager gives a lot of functionality, but mostly operates as an > > SDI application where multiple windows would be tremendously > > useful, plus a > > way to filter the system objects out of the view? Plus provide a data > > browser, a way to change the properties of a table, build indexes, build > > stored procedures, change/add/delete data, etc... > > > > Does anyone know of such a critter? > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ot: where are my checkboxes?
Sorry this is OT, but I cant figure this one out, and since I seem to have misplaced God's email address, my next best resource of omniscience would be cf-talk ;-) I have a collapsible JavaScript menu that is generated from a query. It works wonderfully in IE, but in Netscape my checkboxes are not displayed. Here is the link to the page. http://216.54.222.28/checkbox.cfm and here is the source...output code is bolded http://216.54.222.28/checkbox_src.cfm any help would be much appreciated jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Update to Null
Hmm. I'm using Oracle. I thought I tried this just before I escaped from my office today. I'll try it again in the morning. Thanks. -David On Tue, 02 Jan 2001 22:27:17 -0600 [EMAIL PROTECTED] (Rick Lamb) writes: >UPDATE Employees >SET Age = NULL >WHERE Id = 2 > > This has always worked fine for me using MS SQL 7.0 and MS Access. > > Rick > > -Original Message- > From: David Shadovitz [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 9:31 PM > To: CF-Talk > Subject: OT: Update to Null > > > Is it possible to UPDATE the value of a numeric field to NULL? > > Here's the scenario, which must be common: > > The records of the Employees database table are displayed in an HTML > table, with an Edit and Delete button in each row. The user clicks > Edit > to display a particular record in an editable form. If the user > clears > the Age field and submits the form, what would the SQL UPDATE > statement > look like? > > I don't think this works: >UPDATE Employees >SET Age = NULL >WHERE Id = 2 > > I could test on FORM.Age and then do "SET Age = -1" if no age was > specified, but I'd rather not. > > Thanks. > -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update to Null
UPDATE Employees SET Age = NULL WHERE Id = 2 This has always worked fine for me using MS SQL 7.0 and MS Access. Rick -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 9:31 PM To: CF-Talk Subject: OT: Update to Null Is it possible to UPDATE the value of a numeric field to NULL? Here's the scenario, which must be common: The records of the Employees database table are displayed in an HTML table, with an Edit and Delete button in each row. The user clicks Edit to display a particular record in an editable form. If the user clears the Age field and submits the form, what would the SQL UPDATE statement look like? I don't think this works: UPDATE Employees SET Age = NULL WHERE Id = 2 I could test on FORM.Age and then do "SET Age = -1" if no age was specified, but I'd rather not. Thanks. -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Update to Null
Is it possible to UPDATE the value of a numeric field to NULL? Here's the scenario, which must be common: The records of the Employees database table are displayed in an HTML table, with an Edit and Delete button in each row. The user clicks Edit to display a particular record in an editable form. If the user clears the Age field and submits the form, what would the SQL UPDATE statement look like? I don't think this works: UPDATE Employees SET Age = NULL WHERE Id = 2 I could test on FORM.Age and then do "SET Age = -1" if no age was specified, but I'd rather not. Thanks. -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic form controls
I endorse Aaron's view. I spent most part of a day trying to figure out the javascript for doing this ( I really must spend time learning javascript!) and after I had finally got it to work, I read a post here on CF-talk about this CF_TwoSelectsRelated tag. The second page I did, using the tag, runs faster and smoother than my javascript one, and took me half an hour to build, rather than the day I spent on the first one that I'm still not really happy with. Also Nat has another version of the tag that handles more than two, so you could have suburbs, cities and states if you wanted. If you want to see the two versions and compare them for yourself, see the hand-built javascript one at http://www.choice.com.au/calculators/ancap1.cfm and the one using Nat's tag at http://www.choice.com.au/calculators/usedcarsafety1.cfm(The second one isn't finished yet - the results page doesn't give you any data yet, but the tag works). Cheers, Mike Kear Windsor, NSW, Australia AFP Web Development -Original Message- From: Aaron Johnson [ mailto:[EMAIL PROTECTED]] Sent: Wednesday, 3 January 2001 6:19 AM To: CF-Talk Subject: RE: dynamic form controls -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi Matthieu, Check out Nate Weiss's tag to do exactly this: http://www.nateweiss.com/taggallery/TwoSelectsRelated/CF_TwoSelectsRel ated.html Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. ~~ 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
Sorry
Test ~~ 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: Request VS Application scope
Here Here!! Finally someone seems to understand/agree with my frustration on this point. The way Cold Fusion handles locking is just DUMB. It is ASKING for application instability, which in the long run will ruin the reputation of Cold Fusion as a web development environment. It is especially bad when you consider that much of the focus of Cold Fusion is to allow less experienced programmers to produce excellent complex web sites very rapidly. This is also the reason I have been ranting about Automatic Read locking on this list lately. It works. There is NO performance penalty over properly used manual read locking. I am sure the ONLY reason it isn't at least the default if not the ONLY choice is simply a legacy from older versions of Cold Fusion. I submit that the "right way" is to use Automatic Read locking for those shared scopes that you use in your application. Use manual write locking for writes. I challenge anyone to give an example where this ISN'T the right thing to do from a complexity or performance point of view. And I also agree with Benjamin that automatic EVERYTHING locking, implemented properly inside the Cold Fusion server, would be the true "right way" to do it. At 05:47 PM 1/2/01 -0500, Benjamin S. Rogers wrote: >> The reason why locking is visible to the developer is because it is much >> more efficient if the person writing the code, who knows how the >application >> should work, decides where to lock and more importantly what type of lock >to >> use. If the ColdFusion server had to decide whether to use a ReadOnly or >> Exclusive lock, there would be enormous performance degradation. It is >much >> more efficient if the programmer tells the server which type of lock to >use. >> It's the same thing as telling the server which scope a variable is in, >> instead of having the CF Server go through the variable scope hierarchy. > >This is incorrect. ColdFusion should handle all locking internally except >transactional locking. I have yet to see a reason (aside from developer >laziness) that an exclusive lock should not occur when a session variable is >being written or a read lock should occur when a session variable is being >read. > >A much better analogy is that of the RDBMSs we all know and love. In those >environments, locking is handled by the application. If the developer needs >to combine a series of commands into a single lock (a.k.a. a transaction), >then that option is available to the developer. > >Unlocked commands can cause dirty data at best and system instability at >worst. I don't see why this would be the default behavior of ColdFusion as >opposed to locking all commands except where the developer chooses to >override this to ensure transactional integrity. > >I've argued this point before, both on this list and elsewhere. I maintain >that the issues with are the result of asking a single threaded >application server to behave as a multithreaded application server. Rather >than rewrite the portions of the ColdFusion server that did not behave >properly in a multithreaded environment, they have shuffled off this >responsibility to ColdFusion developers. > >Benjamin S. Rogers >Web Developer, c4.net >voice: (508) 240-0051 >fax: (508) 240-0057 > > > ~~ 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: Request VS Application scope
Here Here!! Finally someone seems to understand/agree with my frustration on this point. The way Cold Fusion handles locking is just DUMB. It is ASKING for application instability, which in the long run will ruin the reputation of Cold Fusion as a web development environment. It is especially bad when you consider that much of the focus of Cold Fusion is to allow less experienced programmers to produce excellent complex web sites very rapidly. This is also the reason I have been ranting about Automatic Read locking on this list lately. It works. There is NO performance penalty over properly used manual read locking. I am sure the ONLY reason it isn't at least the default if not the ONLY choice is simply a legacy from older versions of Cold Fusion. I submit that the "right way" is to use Automatic Read locking for those shared scopes that you use in your application. Use manual write locking for writes. I challenge anyone to give an example where this ISN'T the right thing to do from a complexity or performance point of view. And I also agree with Benjamin that automatic EVERYTHING locking, implemented properly inside the Cold Fusion server, would be the true "right way" to do it. At 05:47 PM 1/2/01 -0500, Benjamin S. Rogers wrote: > The reason why locking is visible to the developer is because it is much > more efficient if the person writing the code, who knows how the application > should work, decides where to lock and more importantly what type of lock to > use. If the ColdFusion server had to decide whether to use a ReadOnly or > Exclusive lock, there would be enormous performance degradation. It is much > more efficient if the programmer tells the server which type of lock to use. > It's the same thing as telling the server which scope a variable is in, > instead of having the CF Server go through the variable scope hierarchy. This is incorrect. ColdFusion should handle all locking internally except transactional locking. I have yet to see a reason (aside from developer laziness) that an exclusive lock should not occur when a session variable is being written or a read lock should occur when a session variable is being read. A much better analogy is that of the RDBMSs we all know and love. In those environments, locking is handled by the application. If the developer needs to combine a series of commands into a single lock (a.k.a. a transaction), then that option is available to the developer. Unlocked commands can cause dirty data at best and system instability at worst. I don't see why this would be the default behavior of ColdFusion as opposed to locking all commands except where the developer chooses to override this to ensure transactional integrity. I've argued this point before, both on this list and elsewhere. I maintain that the issues withare the result of asking a single threaded application server to behave as a multithreaded application server. Rather than rewrite the portions of the ColdFusion server that did not behave properly in a multithreaded environment, they have shuffled off this responsibility to ColdFusion developers. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ 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
Differences between OLE and ODBC
Hello All, In my search to find out the time difference between OLE and ODBC, i created this little script. I have two simple queries: SELECT * FROM TeaserUsers SELECT * FROM TeaserUsers Then i output the record counts like this: #FindUsers.recordcount# users found under OLE #FindUsers_odbc.recordcount# users found under ODBC The first is using SQLOLEDB as its data connection. The second uses ODBC. The issue is that the first query returns only 5 records while the second query returns all 73 records. The table contains 73 records. Does anyone have any ideas as to why this may happen? Do i apply any special settings to permit OLE to retrieve all records? Any light on this issue will be greatly appreciated! Andres ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Date/time with Javascript
Can anyone point me to some resources or even tell me what functions are available to JS with regards to ODBC datetime values Is it possible to convert using JS to a normal date/time string. What I am looking at doing is using JS to compare that a cookie has expired, by doing a compare on the 2 dates. So if anyone has done this or has a resource site that I can visit that would be great, thanks. regards Andrew Scott Senior Cold Fusion Application Developer ~~ 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: A cure for CFDecrypt (don't get excited - it's humorous)
> http://mindprod.com/unmain.html Eeh. That's how I write me codelfish anyway. :) --min ~~ 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: Adding items to Shopping cart
Well, yeah.
The most basic approach is like this:
1) on your form, make a text box for each product, and name the text field
quantity_XXX, where XXX is the product ID;
2) on your form-handler, loop through all of the form fields. If fieldName
is of the form "quantity_XXX", and the value of the field [evaluate("form."
& fieldName)] is greater than 0, then process that product.
3) wrap the entire form-handler in a CFTRANSACTION.
That works fine. You can do nicer things with JavaScript and possibly
multi-row Select boxes to accumulate your total order before submitting, but
that's another large step up in complexity.
Let us know how you go,
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
-Original Message-
From: JayB [mailto:[EMAIL PROTECTED]]
One of the things I really like about our current cgi shopping cart system
is that a customer can add multiple items to the cart from one page with a
single click of the add to basket button.
I haven't looked into it yet but I thought I'd ask first...can CF do this
kind of thing?
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.
~~
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: Request VS Application scope
> The reason why locking is visible to the developer is because it is much > more efficient if the person writing the code, who knows how the application > should work, decides where to lock and more importantly what type of lock to > use. If the ColdFusion server had to decide whether to use a ReadOnly or > Exclusive lock, there would be enormous performance degradation. It is much > more efficient if the programmer tells the server which type of lock to use. > It's the same thing as telling the server which scope a variable is in, > instead of having the CF Server go through the variable scope hierarchy. This is incorrect. ColdFusion should handle all locking internally except transactional locking. I have yet to see a reason (aside from developer laziness) that an exclusive lock should not occur when a session variable is being written or a read lock should occur when a session variable is being read. A much better analogy is that of the RDBMSs we all know and love. In those environments, locking is handled by the application. If the developer needs to combine a series of commands into a single lock (a.k.a. a transaction), then that option is available to the developer. Unlocked commands can cause dirty data at best and system instability at worst. I don't see why this would be the default behavior of ColdFusion as opposed to locking all commands except where the developer chooses to override this to ensure transactional integrity. I've argued this point before, both on this list and elsewhere. I maintain that the issues with are the result of asking a single threaded application server to behave as a multithreaded application server. Rather than rewrite the portions of the ColdFusion server that did not behave properly in a multithreaded environment, they have shuffled off this responsibility to ColdFusion developers. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 ~~ 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
A cure for CFDecrypt (don't get excited - it's humorous)
http://mindprod.com/unmain.html ~~ 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: Access. um, access on a Linux box Redux
At 17:10 1/2/01 -0500, you wrote: >Oops. I forgot to add: > >The two datasources we'd be connecting to are an Access DB and an Oracle DB. you should have no problem connecting to an Oracle database (running on any platform) from Linux. MS Access is harder. I know it can be done with perl, you can install Perl on the Winbox and then connect to that winbox using Perl on the linux box. But I don't know if you can just connect to the winbox with anything, I think you have to use the Perl interface, but with some research you should be able to figure out if its possible. RPS ~~ 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: Access. um, access on a Linux box
The thing is these are existing datasources, and the admin who's going to be in charge of maintaining the servers has minimal NT experience. He wants to migrate over to Linux where the client was once using NT/Apache. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Ryan <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Tuesday, January 02, 2001 5:05 PM Subject: Re: Access. um, access on a Linux box >At 17:05 1/2/01 -0500, you wrote: >>Hi everyone, >> >>I have been asked to determine if there is a way for a client to run a >>CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there >>a good ODBC bridge that will fix this (preferably free/OSS)? >> >>I'm looking at a few potential possibilities, but I wanted to see if any of >>you have already solved my problem. :) > >You can run MySQL on a Winbox, but their license was worded such that >it was not free if you were running on Windows. I don't know if its >still that way. > >You can connect to MSSQL on a winbox from Linux/CF. > >I have no idea why anyone would *want* their data running on >a winbox if they were running everything else on a linux box. >MySQL is quick and easy to setup on linux, they could just put >their data there. > >RPS > > > ~~ 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: Access. um, access on a Linux box
At 17:05 1/2/01 -0500, you wrote: >Hi everyone, > >I have been asked to determine if there is a way for a client to run a >CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there >a good ODBC bridge that will fix this (preferably free/OSS)? > >I'm looking at a few potential possibilities, but I wanted to see if any of >you have already solved my problem. :) You can run MySQL on a Winbox, but their license was worded such that it was not free if you were running on Windows. I don't know if its still that way. You can connect to MSSQL on a winbox from Linux/CF. I have no idea why anyone would *want* their data running on a winbox if they were running everything else on a linux box. MySQL is quick and easy to setup on linux, they could just put their data there. RPS ~~ 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: Access. um, access on a Linux box Redux
Oops. I forgot to add: The two datasources we'd be connecting to are an Access DB and an Oracle DB. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Jamie Keane <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Tuesday, January 02, 2001 4:56 PM Subject: Access. um, access on a Linux box >Hi everyone, > >I have been asked to determine if there is a way for a client to run a >CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there >a good ODBC bridge that will fix this (preferably free/OSS)? > >I'm looking at a few potential possibilities, but I wanted to see if any of >you have already solved my problem. :) > >Thanks, >Jamie > >-- >Jamie Keane >Programmer >SolutionMasters, Inc. >9111 Monroe Rd., Suite 100 >Charlotte, NC 28270 >www.solutionmasters.com >704.849.7771 x 228 Voice >704.849.9291 Fax > > > ~~ 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: Help with a SQL statement
SELECT teaserusers.userid, teaserusers.nickname, teaserusers.firstname, teaserusers.lastnames, teaserusers.email, teaserusers.registereddate, log_userstatus.* FROM teaserusers LEFT JOIN log_userstatus ON teaserusers.userid = log_userstatus.userid This statement does two incorrect things: 1. doubles the rows of users according to how-many times they have entries in the "log_userstatus" table 2. provides a NULL value to the userid of users who ARE NOT listed in the "log_userstatus" table. Am i way off? thanx! andres -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 4:54 PM To: CF-Talk Subject: Re: Help with a SQL statement Can we see your current SQL statement? --Greg - Original Message - From: "Andres" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 4:42 PM Subject: Help with a SQL statement > I need some help with a sql statement: > I have two tables: > > 1 ---> * > teaserusers log_userstatus > --- -- > userid (varchar) logid (varchar) > nickname (text) userid (varchar) > firstname (text) fieldchanged (varchar) > email (text) logdate (datetime) > etc... etc... > > The "teaserusers" table has the data about all users. > The "log_userstatus" table keeps track of specific events and tracks their > occurrence. > > These tables, although not explicitly related in the RDBMS, have a > "one-to-many" relationship based on the "userid." > > I would like to write a statement that gives me a list of all users in the > "teaserusers" table and the last "logdate" entered into the table for each > user listed. > > Here's the catch, and i think this is what is preventing my code from > working: Not all users have entries in the "log_userstatus" table. This > means that a simple inner join will not work. I've also tried the left outer > and full outer joins, not providing the results i need. > > > Is this possible? if so, can you all please help me write the sql code for > it? > > > Thanks for all your help! > > andres > > ~~ 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
Access. um, access on a Linux box
Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential possibilities, but I wanted to see if any of you have already solved my problem. :) Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~~ 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: Help with a SQL statement
Can we see your current SQL statement? --Greg - Original Message - From: "Andres" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 4:42 PM Subject: Help with a SQL statement > I need some help with a sql statement: > I have two tables: > > 1 ---> * > teaserusers log_userstatus > --- -- > userid (varchar) logid (varchar) > nickname (text) userid (varchar) > firstname (text) fieldchanged (varchar) > email (text) logdate (datetime) > etc... etc... > > The "teaserusers" table has the data about all users. > The "log_userstatus" table keeps track of specific events and tracks their > occurrence. > > These tables, although not explicitly related in the RDBMS, have a > "one-to-many" relationship based on the "userid." > > I would like to write a statement that gives me a list of all users in the > "teaserusers" table and the last "logdate" entered into the table for each > user listed. > > Here's the catch, and i think this is what is preventing my code from > working: Not all users have entries in the "log_userstatus" table. This > means that a simple inner join will not work. I've also tried the left outer > and full outer joins, not providing the results i need. > > > Is this possible? if so, can you all please help me write the sql code for > it? > > > Thanks for all your help! > > andres > > ~~ 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
Help with a SQL statement
I need some help with a sql statement: I have two tables: 1 ---> * teaserusers log_userstatus --- -- userid (varchar)logid (varchar) nickname (text) userid (varchar) firstname (text)fieldchanged (varchar) email (text) logdate (datetime) etc... etc... The "teaserusers" table has the data about all users. The "log_userstatus" table keeps track of specific events and tracks their occurrence. These tables, although not explicitly related in the RDBMS, have a "one-to-many" relationship based on the "userid." I would like to write a statement that gives me a list of all users in the "teaserusers" table and the last "logdate" entered into the table for each user listed. Here's the catch, and i think this is what is preventing my code from working: Not all users have entries in the "log_userstatus" table. This means that a simple inner join will not work. I've also tried the left outer and full outer joins, not providing the results i need. Is this possible? if so, can you all please help me write the sql code for it? Thanks for all your help! andres ~~ 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: Request VS Application scope
> In the real world ColdFusion doesnt handle its persistent > variables so well. There is the factor of locking and > many things that should not be visible to the developer > (in a language like CF... which are). The reason why locking is visible to the developer is because it is much more efficient if the person writing the code, who knows how the application should work, decides where to lock and more importantly what type of lock to use. If the ColdFusion server had to decide whether to use a ReadOnly or Exclusive lock, there would be enormous performance degradation. It is much more efficient if the programmer tells the server which type of lock to use. It's the same thing as telling the server which scope a variable is in, instead of having the CF Server go through the variable scope hierarchy. > The tradeoff is you are dealing with a > non persistent scope, so request scope is easier > but implemented properly application scope should > and CAN be much faster Not to sound cynical, but have you done tests? I would like to see how much of a performance increase you get from locking application variables for read only every page request as opposed to setting request variables each page request. That is originally what this thread was asking about, if I understand the original authors thread correctly. --Greg - Original Message - From: "Jeremy Allen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 4:35 PM Subject: RE: Request VS Application scope > One of the points to using application variables is the > fact that they are persistent. The entire scope is a > shared memory scope which means that your variables persist > which means you dont have to continually set them every > time. > > Request scope does not persist beyond one template call.. > > So the difference in performance is, setting variables > you need each time, or simply reading variables back > out of a scope that persists. > > Of course that is in ideal world.. > > In the real world ColdFusion doesnt handle its persistent > variables so well. There is the factor of locking and > many things that should not be visible to the developer > (in a language like CF... which are). Thus it becomes > a bit easier to deal with if you dont have to worry > locking. The tradeoff is you are dealing with a > non persistent scope, so request scope is easier > but implemented properly application scope should > and CAN be much faster... And typically if you are > doing more reading than writing this is still > true, it is just cumbersome to lock everything. > > Jeremy Allen > elliptIQ Inc. > > >-Original Message- > >From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] > >Sent: Tuesday, January 02, 2001 4:21 PM > >To: CF-Talk > >Subject: Re: Request VS Application scope > > > > > >> So it appears your choice is to properly lock access to shared variables > >and take the slight performance hit > >> using either automatic locking or manual locking, or do not properly lock > >access to shared variables and have > >> an unstable server > > > >If I understand your response correctly (which I may not have), here is my > >reply: > > > >I wasn't saying that you shouldn't properly lock you application variables. > >You always should lock those variables. However, with the request > >scope you > >do not have to lock your variables therefore you gain performance using the > >request scope. Of course setting your constants for every user with the > >request scope also degrades some performance, but I think that the tradeoff > >makes it worth using the Reqeust scope. > > > >--Greg > >- Original Message - > >From: "Peter Theobald" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Tuesday, January 02, 2001 3:38 PM > >Subject: Re: Request VS Application scope > > > > > >> But as a recent thread discussed, proper coding requires that you should > >always lock every access to an Application variable, in which case > >automatic > >read locking on Application scope variables does not degrade > >performance any > >more than manual read locking of every read of an Application scope > >variable. So it appears your choice is to properly lock access to shared > >variables and take the slight performance hit using either > >automatic locking > >or manual locking, or do not properly lock access to shared variables and > >have an unstable server. > >> > >> Richard Kern wrote: > >> [...]Summary of lock testing on CF Server > >> [...]First the method of locking whether on the server or actual > >page does > >not > >> significantly affect the application performance.[...] > >> > >> > >> At 03:38 PM 1/2/01 -0500, Greg Wolfinger wrote: > >> >To my understanding using automatic read locking degrades the > >performance > >of > >> >a server greatly. Also, any performance degrade with using the Request > >> >scope won't make too much of a noticable difference. This is only my > >> >understanding, but I'm not
RE: Request VS Application scope
One of the points to using application variables is the fact that they are persistent. The entire scope is a shared memory scope which means that your variables persist which means you dont have to continually set them every time. Request scope does not persist beyond one template call.. So the difference in performance is, setting variables you need each time, or simply reading variables back out of a scope that persists. Of course that is in ideal world.. In the real world ColdFusion doesnt handle its persistent variables so well. There is the factor of locking and many things that should not be visible to the developer (in a language like CF... which are). Thus it becomes a bit easier to deal with if you dont have to worry locking. The tradeoff is you are dealing with a non persistent scope, so request scope is easier but implemented properly application scope should and CAN be much faster... And typically if you are doing more reading than writing this is still true, it is just cumbersome to lock everything. Jeremy Allen elliptIQ Inc. >-Original Message- >From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, January 02, 2001 4:21 PM >To: CF-Talk >Subject: Re: Request VS Application scope > > >> So it appears your choice is to properly lock access to shared variables >and take the slight performance hit >> using either automatic locking or manual locking, or do not properly lock >access to shared variables and have >> an unstable server > >If I understand your response correctly (which I may not have), here is my >reply: > >I wasn't saying that you shouldn't properly lock you application variables. >You always should lock those variables. However, with the request >scope you >do not have to lock your variables therefore you gain performance using the >request scope. Of course setting your constants for every user with the >request scope also degrades some performance, but I think that the tradeoff >makes it worth using the Reqeust scope. > >--Greg >- Original Message - >From: "Peter Theobald" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, January 02, 2001 3:38 PM >Subject: Re: Request VS Application scope > > >> But as a recent thread discussed, proper coding requires that you should >always lock every access to an Application variable, in which case >automatic >read locking on Application scope variables does not degrade >performance any >more than manual read locking of every read of an Application scope >variable. So it appears your choice is to properly lock access to shared >variables and take the slight performance hit using either >automatic locking >or manual locking, or do not properly lock access to shared variables and >have an unstable server. >> >> Richard Kern wrote: >> [...]Summary of lock testing on CF Server >> [...]First the method of locking whether on the server or actual >page does >not >> significantly affect the application performance.[...] >> >> >> At 03:38 PM 1/2/01 -0500, Greg Wolfinger wrote: >> >To my understanding using automatic read locking degrades the >performance >of >> >a server greatly. Also, any performance degrade with using the Request >> >scope won't make too much of a noticable difference. This is only my >> >understanding, but I'm not positive. So as far as I am >concerned the use >of >> >the Request scope is the way to go. >> > >> >--Greg >> >- Original Message - >> >From: "Bryan Love" <[EMAIL PROTECTED]> >> >To: "CF-Talk" <[EMAIL PROTECTED]> >> >Sent: Tuesday, January 02, 2001 2:43 PM >> >Subject: Request VS Application scope >> > >> > >> >> Here's an interesting question: >> >> >> >> We all know that setting global variables in the request scope is >faster >> >and >> >> more thread-safe than using the Application scope, but does >that remain >> >true >> >> as we scale? >> >> >> >> >> >> Environment: 50 request variables are set in application.cfm (so they >are >> >> set every time a page is called) OR >> >>50 application variables are set one time. >> >> >> >> Scenario 1: >> >> One person hits the site. One of the following happens depending on >> >> how you've written the application: >> >> a. 50 request variables are set and five are read >> >> b. 5 application variables are read >> >> >> >> Scenario 2: >> >> 5,000 people hit the site at once (i.e. Amazon opens sale of PS2 to >> >> public). One of the following happens: >> >> a. 250,000 request variables are set and 25,000 are read >> >> b. 25,000 application variables are read with automatic read >> >> locking set to ON in the CF admin >> >> >> >> >> >> I would very much like to hear some feedback on this if >anyone wants to >> >> hypothesize about the results. >> >> >> >> Bryan Love ACP >> >> [EMAIL PROTECTED] >> >> >> >> >> >> >> > >> > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/36
Re: Request VS Application scope
> So it appears your choice is to properly lock access to shared variables and take the slight performance hit > using either automatic locking or manual locking, or do not properly lock access to shared variables and have > an unstable server If I understand your response correctly (which I may not have), here is my reply: I wasn't saying that you shouldn't properly lock you application variables. You always should lock those variables. However, with the request scope you do not have to lock your variables therefore you gain performance using the request scope. Of course setting your constants for every user with the request scope also degrades some performance, but I think that the tradeoff makes it worth using the Reqeust scope. --Greg - Original Message - From: "Peter Theobald" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 3:38 PM Subject: Re: Request VS Application scope > But as a recent thread discussed, proper coding requires that you should always lock every access to an Application variable, in which case automatic read locking on Application scope variables does not degrade performance any more than manual read locking of every read of an Application scope variable. So it appears your choice is to properly lock access to shared variables and take the slight performance hit using either automatic locking or manual locking, or do not properly lock access to shared variables and have an unstable server. > > Richard Kern wrote: > [...]Summary of lock testing on CF Server > [...]First the method of locking whether on the server or actual page does not > significantly affect the application performance.[...] > > > At 03:38 PM 1/2/01 -0500, Greg Wolfinger wrote: > >To my understanding using automatic read locking degrades the performance of > >a server greatly. Also, any performance degrade with using the Request > >scope won't make too much of a noticable difference. This is only my > >understanding, but I'm not positive. So as far as I am concerned the use of > >the Request scope is the way to go. > > > >--Greg > >- Original Message - > >From: "Bryan Love" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Tuesday, January 02, 2001 2:43 PM > >Subject: Request VS Application scope > > > > > >> Here's an interesting question: > >> > >> We all know that setting global variables in the request scope is faster > >and > >> more thread-safe than using the Application scope, but does that remain > >true > >> as we scale? > >> > >> > >> Environment: 50 request variables are set in application.cfm (so they are > >> set every time a page is called) OR > >>50 application variables are set one time. > >> > >> Scenario 1: > >> One person hits the site. One of the following happens depending on > >> how you've written the application: > >> a. 50 request variables are set and five are read > >> b. 5 application variables are read > >> > >> Scenario 2: > >> 5,000 people hit the site at once (i.e. Amazon opens sale of PS2 to > >> public). One of the following happens: > >> a. 250,000 request variables are set and 25,000 are read > >> b. 25,000 application variables are read with automatic read > >> locking set to ON in the CF admin > >> > >> > >> I would very much like to hear some feedback on this if anyone wants to > >> hypothesize about the results. > >> > >> Bryan Love ACP > >> [EMAIL PROTECTED] > >> > >> > >> > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
scheduling app. revisited
A while back there were a few discussions on a scheduling app. Some people had expressed interest in looking at one that I am developing. The app is in an early alpha and more or less works, (as long as you don't try to break it ;), well enough to give you an idea of what it will do when 100% complete. Unfortunately, I lost the E-mail addresses of everyone who contacted me. If you're interested in taking a look at it, send an E-mail to [EMAIL PROTECTED] Comments, suggestions, and flames are welcome, as this is still a work in progress :) Todd Ashworth - Web Application Developer Network Administrator - Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 - [EMAIL PROTECTED] ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Request VS Application scope
But as a recent thread discussed, proper coding requires that you should always lock every access to an Application variable, in which case automatic read locking on Application scope variables does not degrade performance any more than manual read locking of every read of an Application scope variable. So it appears your choice is to properly lock access to shared variables and take the slight performance hit using either automatic locking or manual locking, or do not properly lock access to shared variables and have an unstable server. Richard Kern wrote: [...]Summary of lock testing on CF Server [...]First the method of locking whether on the server or actual page does not significantly affect the application performance.[...] At 03:38 PM 1/2/01 -0500, Greg Wolfinger wrote: >To my understanding using automatic read locking degrades the performance of >a server greatly. Also, any performance degrade with using the Request >scope won't make too much of a noticable difference. This is only my >understanding, but I'm not positive. So as far as I am concerned the use of >the Request scope is the way to go. > >--Greg >- Original Message - >From: "Bryan Love" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, January 02, 2001 2:43 PM >Subject: Request VS Application scope > > >> Here's an interesting question: >> >> We all know that setting global variables in the request scope is faster >and >> more thread-safe than using the Application scope, but does that remain >true >> as we scale? >> >> >> Environment: 50 request variables are set in application.cfm (so they are >> set every time a page is called) OR >>50 application variables are set one time. >> >> Scenario 1: >> One person hits the site. One of the following happens depending on >> how you've written the application: >> a. 50 request variables are set and five are read >> b. 5 application variables are read >> >> Scenario 2: >> 5,000 people hit the site at once (i.e. Amazon opens sale of PS2 to >> public). One of the following happens: >> a. 250,000 request variables are set and 25,000 are read >> b. 25,000 application variables are read with automatic read >> locking set to ON in the CF admin >> >> >> I would very much like to hear some feedback on this if anyone wants to >> hypothesize about the results. >> >> Bryan Love ACP >> [EMAIL PROTECTED] >> >> >> > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Request VS Application scope
To my understanding using automatic read locking degrades the performance of a server greatly. Also, any performance degrade with using the Request scope won't make too much of a noticable difference. This is only my understanding, but I'm not positive. So as far as I am concerned the use of the Request scope is the way to go. --Greg - Original Message - From: "Bryan Love" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 2:43 PM Subject: Request VS Application scope > Here's an interesting question: > > We all know that setting global variables in the request scope is faster and > more thread-safe than using the Application scope, but does that remain true > as we scale? > > > Environment: 50 request variables are set in application.cfm (so they are > set every time a page is called) OR >50 application variables are set one time. > > Scenario 1: > One person hits the site. One of the following happens depending on > how you've written the application: > a. 50 request variables are set and five are read > b. 5 application variables are read > > Scenario 2: > 5,000 people hit the site at once (i.e. Amazon opens sale of PS2 to > public). One of the following happens: > a. 250,000 request variables are set and 25,000 are read > b. 25,000 application variables are read with automatic read > locking set to ON in the CF admin > > > I would very much like to hear some feedback on this if anyone wants to > hypothesize about the results. > > Bryan Love ACP > [EMAIL PROTECTED] > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternative To SQL Server Enterprise Manager
If anyone has a problem getting this app running, shoot me an email and I will assist you. Here are the basics: There is a sql script in the sql scripts folder. create a database or run this script on an existing db and then in the application.cfm change the variable 'dsn' to the dsn you are using. Then call up the index.cfm file in the root of the directory you unzipped this to and there will be a link in the main content frame. Click on that link and add a DSN to the newly add tables and then refresh the left frame and you will see your database there. ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Request VS Application scope
Here's an interesting question: We all know that setting global variables in the request scope is faster and more thread-safe than using the Application scope, but does that remain true as we scale? Environment: 50 request variables are set in application.cfm (so they are set every time a page is called) OR 50 application variables are set one time. Scenario 1: One person hits the site. One of the following happens depending on how you've written the application: a. 50 request variables are set and five are read b. 5 application variables are read Scenario 2: 5,000 people hit the site at once (i.e. Amazon opens sale of PS2 to public). One of the following happens: a. 250,000 request variables are set and 25,000 are read b. 25,000 application variables are read with automatic read locking set to ON in the CF admin I would very much like to hear some feedback on this if anyone wants to hypothesize about the results. Bryan Love ACP [EMAIL PROTECTED] ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternative To SQL Server Enterprise Manager
oopss.. sorry that one is encrypted... one sec and I will replace it... -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 1:31 PM To: CF-Talk Subject: RE: Alternative To SQL Server Enterprise Manager Here is the link to the zip file. This is a little more than an alternative to Enterprise Manager. I have not encrypted the code so you can modify it in any way that you want. I would appreciate it if you that use this let me know what you think(offline of course). I have a new and better version of what I am sending out here. Have fun with it, I did. Clint http://www.cfm-resources.com/c/cfxpert/download/download.cfm ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternative To SQL Server Enterprise Manager
Here is the link to the zip file. This is a little more than an alternative to Enterprise Manager. I have not encrypted the code so you can modify it in any way that you want. I would appreciate it if you that use this let me know what you think(offline of course). I have a new and better version of what I am sending out here. Have fun with it, I did. Clint http://www.cfm-resources.com/c/cfxpert/download/download.cfm ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic form controls
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi Matthieu, Check out Nate Weiss's tag to do exactly this: http://www.nateweiss.com/taggallery/TwoSelectsRelated/CF_TwoSelectsRel ated.html Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. 617.350.0339 617.350.8884 66172567 [EMAIL PROTECTED] ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dynamic form controls
You can preload all of the cities and all of the countries using JavaScript to get instant changes. This may take a while longer for the page to display on the users end. Or you could write a javascript that automatically submits the form to itself after changing the drop down list value that then pulls the city data from the database and displays the same page again with the new cities. --Greg - Original Message - From: "Cornillon, Matthieu" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 2:07 PM Subject: dynamic form controls > Happy new year, everyone. > > I have a form with a couple of drop down controls. I'll call them > dd_country and dd_city. I would like the contents of dd_city to be based on > the contents of dd_country. If the user selects France, the dd_city should > hold Paris, Marseilles, Nice. If the user selects Italy, the dd_city should > hold Florence, Rome, Venice, Ortisei. Etc. > > I know how to set up the database and do the lookup, but I don't know how to > make this happen on the fly. I cannot do the lookup for dd_city until the > user selects a value from dd_country. Aside from setting these up as > separate pages, is there a non-convoluted way to do this? I considered > having the page drill down to itself on dd_country's onChange event, feeding > back in the value of dd_country, but that gets messy for other reasons. > > Any thoughts? > > Thanks in advance, > Matthieu > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternative To SQL Server Enterprise Manager
Sure... send the link. Thanks... Lee > -Original Message- > From: Clint Tredway [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 10:17 AM > To: CF-Talk > Subject: RE: Alternative To SQL Server Enterprise Manager > > > I have a tool that does just that. It allows you to view data and update > each row. You just plug in the DSN that is setup with CF admin and go. If > anyone is interested let me know and I will send you a link to > down load it. > > -Original Message- > From: Lee Fuller [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 12:10 PM > To: CF-Talk > Subject: RE: Alternative To SQL Server Enterprise Manager > > > Actually, I'd like to find something that my clients can use, to login to > their SQL database and make changes. Also, that will work with > the security > of the SQL server to keep unwanted eyes out of other DB's. > (Kinda like what > MySQL will do.) > > Lee > > > > -Original Message- > > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 02, 2001 9:58 AM > > To: CF-Talk > > Subject: RE: Alternative To SQL Server Enterprise Manager > > > > > > DB Artisan and ERStudio are pretty slick. > > > > -Original Message- > > From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 02, 2001 8:18 AM > > To: CF-Talk > > Subject: OT: Alternative To SQL Server Enterprise Manager > > > > > > I'm wondering if any CF'ers here has found an affordable > > alternative to SQL > > Server's Enterprise Manager? I had found SQL Navigator from > > http://www.quest.com/sql_navigator_ss/index.asp, but have found > it lacking > > in a lot of areas, as well as buggy as h*ll... > > > > Enterprise Manager gives a lot of functionality, but mostly > operates as an > > SDI application where multiple windows would be tremendously > > useful, plus a > > way to filter the system objects out of the view? Plus provide a data > > browser, a way to change the properties of a table, build indexes, build > > stored procedures, change/add/delete data, etc... > > > > Does anyone know of such a critter? > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
dynamic form controls
Happy new year, everyone. I have a form with a couple of drop down controls. I'll call them dd_country and dd_city. I would like the contents of dd_city to be based on the contents of dd_country. If the user selects France, the dd_city should hold Paris, Marseilles, Nice. If the user selects Italy, the dd_city should hold Florence, Rome, Venice, Ortisei. Etc. I know how to set up the database and do the lookup, but I don't know how to make this happen on the fly. I cannot do the lookup for dd_city until the user selects a value from dd_country. Aside from setting these up as separate pages, is there a non-convoluted way to do this? I considered having the page drill down to itself on dd_country's onChange event, feeding back in the value of dd_country, but that gets messy for other reasons. Any thoughts? Thanks in advance, Matthieu ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Alternative To SQL Server Enterprise Manager
Id like to take a look at it Clint Clint Tredway wrote: > One more thing, this is CF based. It will run on the web server so you cna > get to it anywhere. > > -Original Message- > From: Lee Fuller [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 12:10 PM > To: CF-Talk > Subject: RE: Alternative To SQL Server Enterprise Manager > > Actually, I'd like to find something that my clients can use, to login to > their SQL database and make changes. Also, that will work with the security > of the SQL server to keep unwanted eyes out of other DB's. (Kinda like what > MySQL will do.) > > Lee > > > -Original Message- > > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 02, 2001 9:58 AM > > To: CF-Talk > > Subject: RE: Alternative To SQL Server Enterprise Manager > > > > > > DB Artisan and ERStudio are pretty slick. > > > > -Original Message- > > From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 02, 2001 8:18 AM > > To: CF-Talk > > Subject: OT: Alternative To SQL Server Enterprise Manager > > > > > > I'm wondering if any CF'ers here has found an affordable > > alternative to SQL > > Server's Enterprise Manager? I had found SQL Navigator from > > http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking > > in a lot of areas, as well as buggy as h*ll... > > > > Enterprise Manager gives a lot of functionality, but mostly operates as an > > SDI application where multiple windows would be tremendously > > useful, plus a > > way to filter the system objects out of the view? Plus provide a data > > browser, a way to change the properties of a table, build indexes, build > > stored procedures, change/add/delete data, etc... > > > > Does anyone know of such a critter? > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can only send 2046 characters through CFMAIL?
It *sounds* to me like like somewhere along the line there's a "char line[2048]" or "char line[2048+1]". That is, someone is assuming lines won't be more than about 2048 characters long (remember the crlf and the null). Which isn't a bad assumpttoin, considering I believe the official RFC's dicate that lines above 1024 characters are not allowed and SHOULD be truncated. Or something to that effect. Try breaking up the text into more lines. I'm fairly certain your problem is your smtp server is simply following the RFC guidelines. :) --min ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating Datasources Using CF
> Check the CF Developer Gallery for creating datasources. > > Hi All > > Can i write CF codes to create datasources instead of using cold fusion > admin? Specifically, aeons ago I wrote cf_autoaddmdb. I believe there are others now. Requires CFREGISTRY. --min ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternative To SQL Server Enterprise Manager
I have a tool that does just that. It allows you to view data and update each row. You just plug in the DSN that is setup with CF admin and go. If anyone is interested let me know and I will send you a link to down load it. -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 12:10 PM To: CF-Talk Subject: RE: Alternative To SQL Server Enterprise Manager Actually, I'd like to find something that my clients can use, to login to their SQL database and make changes. Also, that will work with the security of the SQL server to keep unwanted eyes out of other DB's. (Kinda like what MySQL will do.) Lee > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 9:58 AM > To: CF-Talk > Subject: RE: Alternative To SQL Server Enterprise Manager > > > DB Artisan and ERStudio are pretty slick. > > -Original Message- > From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 8:18 AM > To: CF-Talk > Subject: OT: Alternative To SQL Server Enterprise Manager > > > I'm wondering if any CF'ers here has found an affordable > alternative to SQL > Server's Enterprise Manager? I had found SQL Navigator from > http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking > in a lot of areas, as well as buggy as h*ll... > > Enterprise Manager gives a lot of functionality, but mostly operates as an > SDI application where multiple windows would be tremendously > useful, plus a > way to filter the system objects out of the view? Plus provide a data > browser, a way to change the properties of a table, build indexes, build > stored procedures, change/add/delete data, etc... > > Does anyone know of such a critter? > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternative To SQL Server Enterprise Manager
One more thing, this is CF based. It will run on the web server so you cna get to it anywhere. -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 12:10 PM To: CF-Talk Subject: RE: Alternative To SQL Server Enterprise Manager Actually, I'd like to find something that my clients can use, to login to their SQL database and make changes. Also, that will work with the security of the SQL server to keep unwanted eyes out of other DB's. (Kinda like what MySQL will do.) Lee > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 9:58 AM > To: CF-Talk > Subject: RE: Alternative To SQL Server Enterprise Manager > > > DB Artisan and ERStudio are pretty slick. > > -Original Message- > From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 8:18 AM > To: CF-Talk > Subject: OT: Alternative To SQL Server Enterprise Manager > > > I'm wondering if any CF'ers here has found an affordable > alternative to SQL > Server's Enterprise Manager? I had found SQL Navigator from > http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking > in a lot of areas, as well as buggy as h*ll... > > Enterprise Manager gives a lot of functionality, but mostly operates as an > SDI application where multiple windows would be tremendously > useful, plus a > way to filter the system objects out of the view? Plus provide a data > browser, a way to change the properties of a table, build indexes, build > stored procedures, change/add/delete data, etc... > > Does anyone know of such a critter? > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Animated tutorial on assertions
Looks great. I was wondering what was in the "Copy of Neo" directory. dave At 09:19 AM 1/2/2001 -0500, you wrote: >Happy New Year/New Millennium, everyone! > >I've put together an animated tutorial on making assertions in CF. >Assertions help ensure that what we expect is what we get -- or at least we >know if we don't! There's a link at www.halhelms.com as well as a custom tag >for making assertions. > >Thanks to Steve Nelson for introducing to me the concept of animated >tutorials. I love 'em. > >Hal Helms >== See www.ColdFusionTraining.com for info on "Best Practices with >ColdFusion & Fusebox" training, Jan 22-25 == > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternative To SQL Server Enterprise Manager
Actually, I'd like to find something that my clients can use, to login to their SQL database and make changes. Also, that will work with the security of the SQL server to keep unwanted eyes out of other DB's. (Kinda like what MySQL will do.) Lee > -Original Message- > From: Dylan Bromby [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 9:58 AM > To: CF-Talk > Subject: RE: Alternative To SQL Server Enterprise Manager > > > DB Artisan and ERStudio are pretty slick. > > -Original Message- > From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 8:18 AM > To: CF-Talk > Subject: OT: Alternative To SQL Server Enterprise Manager > > > I'm wondering if any CF'ers here has found an affordable > alternative to SQL > Server's Enterprise Manager? I had found SQL Navigator from > http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking > in a lot of areas, as well as buggy as h*ll... > > Enterprise Manager gives a lot of functionality, but mostly operates as an > SDI application where multiple windows would be tremendously > useful, plus a > way to filter the system objects out of the view? Plus provide a data > browser, a way to change the properties of a table, build indexes, build > stored procedures, change/add/delete data, etc... > > Does anyone know of such a critter? > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternative To SQL Server Enterprise Manager
DB Artisan and ERStudio are pretty slick. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 8:18 AM To: CF-Talk Subject: OT: Alternative To SQL Server Enterprise Manager I'm wondering if any CF'ers here has found an affordable alternative to SQL Server's Enterprise Manager? I had found SQL Navigator from http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking in a lot of areas, as well as buggy as h*ll... Enterprise Manager gives a lot of functionality, but mostly operates as an SDI application where multiple windows would be tremendously useful, plus a way to filter the system objects out of the view? Plus provide a data browser, a way to change the properties of a table, build indexes, build stored procedures, change/add/delete data, etc... Does anyone know of such a critter? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FirstDayOfMonth problems
Gina, You're making just one mistake in your code. That's in using the function FirstDayOfMonth(). This function returns the ordinal day in the year, a number from 1 to 365 (or 366). When you then use the function DayOfWeek() on this number the results don't really have any meaning, since DayOfWeek() is supposed to take a number from 1 to 7. #DayOfWeekAsString(DayOfWeek(FirstDayOfMonth(firstdate)))# All you really need is the function DayOfWeek(), which takes any date (always use the first day in the month) and returns a number from one to seven. Jim - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 9:37 AM Subject: FirstDayOfMonth problems > I am trying to create an option in my CF calendar that allows repeating > events that relocate themselves to the first business day of the month. For > example, if the 1st falls on a Saturday, relocate that event to the 3rd, or > Monday, the first business day. I have a problem with FirstDayOfMonth, > however - it keeps returning the wrong day (one day earlier than it > should). Here is my example code, with April 1, 2001 hard coded in since > April 1st falls on a Sunday: > > > > > > Date: #dateFormat(thedate, "mm/dd/")#. > This date is a #DayofWeekAsString(DayOfWeek(thedate))#, day > #DayOfWeek(thedate)# in the week. > This is day #Day(thedate)# in the month of > #MonthAsString(Month(thedate))#, which has > #DaysInMonth(thedate)# days. > This date is in week #Week(thedate)# of #Year(thedate)# (day > #DayofYear(thedate)# of #DaysinYear(thedate)#). > This date is in a leap year > This date is not in a leap year > > The first day of #DateFormat(thedate,"")#, > #DateFormat(thedate,"")# is > a #DayOfWeekAsString(DayOfWeek(FirstDayOfMonth(thedate)))# *NOTE* (this should return Sunday but returns Saturday), > day #FirstDayOfMonth(thedate)# of the year. > > > > The first day of the month is: #DayOfWeek(FirstDayOfMonth(thedate))# *NOTE* (This should return 1 but returns 7) > > > > > > first business day = #DateFormat(firstbusinessday,", dd, ")# *NOTE* (This should return Monday, 04/02/2001 but returns > Tuesday, 04/03/2001) > > > > > first business day = #dateformat(firstbusinessday,", dd, ")# > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sessions/cookies
CF usually doesn't care about case (except for string comparison functions that aren't of the "NoCase" variety), but if you wanted to fake case-insensitivity just in case, use lcase() on the strings. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Jeffry Houser <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Tuesday, January 02, 2001 12:29 PM Subject: Re: Sessions/cookies > > I don't know if you missed my additional comments in the code or not, but just >to re-specify, > >You use CFPARAM to set the default to 'na' and when you check the >value (in the else statement) you are checking for 'NA' . Technically, the >two values are different. Does anyone know if the CF default is to check >cases or not? It's the only other idea I can think of... > > >Michael Ross wrote: > >> Yes thats exactly what it should do. But in the first instance I define the session.user_name as a unique number. so the next time round it will update the table. I know why the query isn't working, it shouldn't be getting the na in the first place. > >-- >Jeff Houser | mailto:[EMAIL PROTECTED] >AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 >-- >Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 >Due out 3rd Quarter 2001 >-- >DotComIt, LLC >database driven web data using ColdFusion, Lotus Notes/Domino >-- >Half of the Alternative Folk Acoustic Duo called Far Cry Fly >http://www.farcryfly.com | http://www.mp3.com/FarCryFly >-- >Promise me no dead end streets, and I'll guarantee we'll have a road > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
wrap results in a table
Hello all, I was wondering if anybody knows of any way to wrap results list in a table? For the windows users, when you drop to a command prompt and use dir /w, it wraps the columns like I'd like to do. I'm sure there's a way to do a long drawn out script that compares the query.CurrentRow and manually wraps, but I was hoping for possibly an easy solution. E ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can only send 2046 characters through CFMAIL?
> I just tried your code on a WIN2K server (sorry but I don't have a Linux > box) and it works fine. The only thing that I can think of is that you're > not terminating the message body with CRLF pairs and the body is one long > line. If that's the case then you need to break up the lines with CRLF > pairs. Using WinNT and both CF4 and 4.5 I've sent over 10kb emails (HTML ones) without any problems It MIGHT be a Linux thing, but I can't see that... Maybe you could take a look at a CFMail file, then create your own one and drop it in to be spooled to see if it's CF or the mail server 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. ** ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: setting structures into arrays
Rick/Hal: The duplicate function worked like a charm since I am running 4.5. However, it would be nice to have a work around in case I run into this situation with a 4.0 live server. --Greg - Original Message - From: "Rick Lamb" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 11:25 AM Subject: RE: setting structures into arrays > I seem to remember last time I did something like this that ArrayAppend > worked. Either way I know I found another way around this without using the > duplicate function sense I was not using cfs 4.5. Let me know if you are in > a similar situation and I will look up the code I used. > > Rick > > -Original Message- > From: Hal Helms [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 11:08 AM > To: CF-Talk > Subject: RE: setting structures into arrays > > > The problem is that setting the array variable as you have just puts a > pointer to "order". When that changes, so will your reference. Instead, use > "history[1] = Duplicate( order )". > > Hal Helms > == See www.ColdFusionTraining.com for info on "Best Practices with > ColdFusion & Fusebox" training, Jan 22-25 == > > > -Original Message- > From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 12:05 PM > To: CF-Talk > Subject: setting structures into arrays > > > Hey Guys: > > I am having problems creating an array of structures and serializing it into > a wddx package for client storage in a db. My code looks like this: > > > history=ArrayNew(1); > order=StuctNew(); > StructInsert(order, "id", "0001"); > StructInsert(order, "date", "01/01/2001"); > history[1]=order; > StructClear(order); > StuctInsert(order, "id", "0002"); > StrictInsert(order, "date", "01/02/2001"); > history[2]=order; > > > I then serialize and store the data. However what happends is that the > "history" array has a length of two, but both are set to the second > structures values. Any ideas?? > > Thanks in advance, > > > Greg > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sessions/cookies
I don't know if you missed my additional comments in the code or not, but just to re-specify, You use CFPARAM to set the default to 'na' and when you check the value (in the else statement) you are checking for 'NA' . Technically, the two values are different. Does anyone know if the CF default is to check cases or not? It's the only other idea I can think of... Michael Ross wrote: > Yes thats exactly what it should do. But in the first instance I define the >session.user_name as a unique number. so the next time round it will update the >table. I know why the query isn't working, it shouldn't be getting the na in the >first place. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: setting structures into arrays
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It doesn't look like you're handling the name of the structure programatically so you could do this: // populate the first structure order = StructNew(); order.id = 0001; order.date = "01/01/2001"; // move the structure to the array history[1] = order; //populate the second structure order2 = structnew(); order2.id = 0002; order2.date = "/01/02/2001"; // move the structure to the array history[2] = order2; That works. To handle the name of the structure programatically, do soemthing like this: // populate the structure order = StructNew(); order.id = "#i#"; order.date = "01/#i#/2001"; // move the structure to the array history[i] = order; HTH's. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. 617.350.0339 617.350.8884 66172567 [EMAIL PROTECTED] ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: setting structures into arrays
I seem to remember last time I did something like this that ArrayAppend worked. Either way I know I found another way around this without using the duplicate function sense I was not using cfs 4.5. Let me know if you are in a similar situation and I will look up the code I used. Rick -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 11:08 AM To: CF-Talk Subject: RE: setting structures into arrays The problem is that setting the array variable as you have just puts a pointer to "order". When that changes, so will your reference. Instead, use "history[1] = Duplicate( order )". Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion & Fusebox" training, Jan 22-25 == -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 12:05 PM To: CF-Talk Subject: setting structures into arrays Hey Guys: I am having problems creating an array of structures and serializing it into a wddx package for client storage in a db. My code looks like this: history=ArrayNew(1); order=StuctNew(); StructInsert(order, "id", "0001"); StructInsert(order, "date", "01/01/2001"); history[1]=order; StructClear(order); StuctInsert(order, "id", "0002"); StrictInsert(order, "date", "01/02/2001"); history[2]=order; I then serialize and store the data. However what happends is that the "history" array has a length of two, but both are set to the second structures values. Any ideas?? Thanks in advance, Greg ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FirstDayOfMonth problems
Your code is doing what you tell it to Gina :) >first business day = #DateFormat(firstbusinessday,", dd, >")# *NOTE* (This should return Monday, >04/02/2001 but returns > Tuesday, 04/03/2001) > Okay what is going on here, you have 4/01/01 as your date up top. This is the first time you modify the date.. You are calling the date add and adding two days to the current date. Two days is 4/03/01. That is as it should be. Then adding another day later would push your date to 4/04/01. A really simple way is to start out on the first day of the month check to see if it is a weekend day, if it is increment the day until you hit a non weekend day... first business day of the month. Pseudo Code. This accomplishes what you want.. The nice thing about dates is they remain fairly consistent so you can hardcode stuff and it does not really change. You can get that code a bit more effecient.. but it works, and is simple. If you are looking for the first Monday-Fri business week of the month that is still relatively simple, using the same idea. Jeremy Allen elliptIQ Inc. >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, January 02, 2001 11:37 AM >To: CF-Talk >Subject: FirstDayOfMonth problems > > >I am trying to create an option in my CF calendar that allows repeating >events that relocate themselves to the first business day of the month. For >example, if the 1st falls on a Saturday, relocate that event to the 3rd, or >Monday, the first business day. I have a problem with FirstDayOfMonth, >however - it keeps returning the wrong day (one day earlier than it >should). Here is my example code, with April 1, 2001 hard coded in since >April 1st falls on a Sunday: > > > > > >Date: #dateFormat(thedate, "mm/dd/")#. >This date is a #DayofWeekAsString(DayOfWeek(thedate))#, day > #DayOfWeek(thedate)# in the week. >This is day #Day(thedate)# in the month of > #MonthAsString(Month(thedate))#, which has >#DaysInMonth(thedate)# days. >This date is in week #Week(thedate)# of #Year(thedate)# (day > #DayofYear(thedate)# of #DaysinYear(thedate)#). >This date is in a leap year >This date is not in a leap year > >The first day of #DateFormat(thedate,"")#, > #DateFormat(thedate,"")# is >a #DayOfWeekAsString(DayOfWeek(FirstDayOfMonth(thedate)))# > *NOTE* (this should return Sunday but returns Saturday), > day #FirstDayOfMonth(thedate)# of the year. > > > >The first day of the month is: >#DayOfWeek(FirstDayOfMonth(thedate))# *NOTE* >(This should return 1 but returns 7) > > > > > >first business day = #DateFormat(firstbusinessday,", dd, >")# *NOTE* (This should return Monday, >04/02/2001 but returns > Tuesday, 04/03/2001) > > > > >first business day = #dateformat(firstbusinessday,", dd, ")# > > > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can only send 2046 characters through CFMAIL?
I just tried your code on a WIN2K server (sorry but I don't have a Linux box) and it works fine. The only thing that I can think of is that you're not terminating the message body with CRLF pairs and the body is one long line. If that's the case then you need to break up the lines with CRLF pairs. Regards, Howie - Original Message - From: "Ryan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 11:49 AM Subject: Re: Can only send 2046 characters through CFMAIL? > OK, here is the entire tag. The code where it actually sends the email is > near the bottom. > > > Note that the more "why so short? " strings I put inbetween the CFMAIL > tags, the more #Attributes.body# is truncated. Only 2046 characters > between the CFMAIL tags will be sent. > > BTW, I'm running 4.5.1 SP2 on linux. > > Thanks, > Ryan ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: setting structures into arrays
Here is some code I use loop over a recordset (rs) and creates an array of structure with is stored as WDDX tmp = StructNew(); tmp.ID = #id#; tmp.StatusCode = #statusid#; // add current thing to list MyArray[rs.CurrentRow] = tmp; Justin > >history=ArrayNew(1); >order=StuctNew(); >StructInsert(order, "id", "0001"); >StructInsert(order, "date", "01/01/2001"); >history[1]=order; >StructClear(order); >StuctInsert(order, "id", "0002"); >StrictInsert(order, "date", "01/02/2001"); >history[2]=order; > > >I then serialize and store the data. However what happends is >that the "history" array has a length of two, but both are set to >the second structures values. Any ideas?? > >Thanks in advance, > > >Greg > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: setting structures into arrays
The problem is that setting the array variable as you have just puts a pointer to "order". When that changes, so will your reference. Instead, use "history[1] = Duplicate( order )". Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion & Fusebox" training, Jan 22-25 == -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 12:05 PM To: CF-Talk Subject: setting structures into arrays Hey Guys: I am having problems creating an array of structures and serializing it into a wddx package for client storage in a db. My code looks like this: history=ArrayNew(1); order=StuctNew(); StructInsert(order, "id", "0001"); StructInsert(order, "date", "01/01/2001"); history[1]=order; StructClear(order); StuctInsert(order, "id", "0002"); StrictInsert(order, "date", "01/02/2001"); history[2]=order; I then serialize and store the data. However what happends is that the "history" array has a length of two, but both are set to the second structures values. Any ideas?? Thanks in advance, Greg ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
setting structures into arrays
Hey Guys: I am having problems creating an array of structures and serializing it into a wddx package for client storage in a db. My code looks like this: history=ArrayNew(1); order=StuctNew(); StructInsert(order, "id", "0001"); StructInsert(order, "date", "01/01/2001"); history[1]=order; StructClear(order); StuctInsert(order, "id", "0002"); StrictInsert(order, "date", "01/02/2001"); history[2]=order; I then serialize and store the data. However what happends is that the "history" array has a length of two, but both are set to the second structures values. Any ideas?? Thanks in advance, Greg ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternative To SQL Server Enterprise Manager
Hi, Its not perfect, and sometimes it falls over (slightly more often than enterprise manager), but access2000 offers a slightly more convienient interface that enterprise manager - to connect to a SQL db through access, create a new project to an existing datasource, and Robert is your Parental sibling... -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: 02 January 2001 16:18 To: CF-Talk Subject: OT: Alternative To SQL Server Enterprise Manager I'm wondering if any CF'ers here has found an affordable alternative to SQL Server's Enterprise Manager? I had found SQL Navigator from http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking in a lot of areas, as well as buggy as h*ll... Enterprise Manager gives a lot of functionality, but mostly operates as an SDI application where multiple windows would be tremendously useful, plus a way to filter the system objects out of the view? Plus provide a data browser, a way to change the properties of a table, build indexes, build stored procedures, change/add/delete data, etc... Does anyone know of such a critter? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: preparing for CF certification...
> >structures and error handling as well as some basic stuff not CF related > >(SQL, WebServer stuff etc) > > I hope its SQL and web server stuff in general, not MSSQL and IIS? > I use linux/apache/MySQL, and am just starting to learn MSSQL. I > hope to take the test in the next year or so. Please tell me they > don't test you on IIS knowledge. All non-CF questions are generic SQL and web server (and HTML) As long as you know your general non-CF stuff, then it's a breeze - the hard bits are the ambiguous questions which they want one answer and there are 2 or 3 which could be right... you have to predict which one you think they want as the answer Unless they've fixed the questions that is - when I took it at the Conf, I'm sure I got 3 or 4 wrong because I was answering them "Real World" rather than "What they want as the answer" 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. ** ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can only send 2046 characters through CFMAIL?
At 11:33 1/2/01 -0500, you wrote: >There is no difference between calling cfmail from a custom tag. And, since >you've already done a test and it is not your mail server then I think there >is more than likely a bug in your custom tag. If you post the code then it >would be easier to diagnoe. OK, here is the entire tag. The code where it actually sends the email is near the bottom. SELECT errorsto FROM cfggeneral why so short? why so short? #Attributes.body# Note that the more "why so short? " strings I put inbetween the CFMAIL tags, the more #Attributes.body# is truncated. Only 2046 characters between the CFMAIL tags will be sent. BTW, I'm running 4.5.1 SP2 on linux. Thanks, Ryan ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Alternative To SQL Server Enterprise Manager
that is exactly what the doctor ordered... thanx... It remains as an SDI application, but I've lived with it this long, guess I can take it a bit longer... At 10:41 AM 1/2/01 -0600, you wrote: >You can filter out system tables in Enterprise Manager by right clicking on >the server name and then selecting "Edit SQL Server Registration >Properties". Uncheck "Show system databases and system objects." > >Chris >- Original Message - >From: "Joe Sheble aka Wizaerd" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, January 02, 2001 10:18 AM >Subject: OT: Alternative To SQL Server Enterprise Manager > > > > I'm wondering if any CF'ers here has found an affordable alternative to >SQL > > Server's Enterprise Manager? I had found SQL Navigator from > > http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking > > in a lot of areas, as well as buggy as h*ll... > > > > Enterprise Manager gives a lot of functionality, but mostly operates as an > > SDI application where multiple windows would be tremendously useful, plus >a > > way to filter the system objects out of the view? Plus provide a data > > browser, a way to change the properties of a table, build indexes, build > > stored procedures, change/add/delete data, etc... > > > > Does anyone know of such a critter? > > > > > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Alternative To SQL Server Enterprise Manager
You can filter out system tables in Enterprise Manager by right clicking on the server name and then selecting "Edit SQL Server Registration Properties". Uncheck "Show system databases and system objects." Chris - Original Message - From: "Joe Sheble aka Wizaerd" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 10:18 AM Subject: OT: Alternative To SQL Server Enterprise Manager > I'm wondering if any CF'ers here has found an affordable alternative to SQL > Server's Enterprise Manager? I had found SQL Navigator from > http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking > in a lot of areas, as well as buggy as h*ll... > > Enterprise Manager gives a lot of functionality, but mostly operates as an > SDI application where multiple windows would be tremendously useful, plus a > way to filter the system objects out of the view? Plus provide a data > browser, a way to change the properties of a table, build indexes, build > stored procedures, change/add/delete data, etc... > > Does anyone know of such a critter? > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sessions/cookies
Yes thats exactly what it should do. But in the first instance I define the
session.user_name as a unique number. so the next time round it will update the
table. I know why the query isn't working, it shouldn't be getting the na in the
first place.
Thanks everyone..
>>> [EMAIL PROTECTED] 01/02/01 10:07AM >>>
Session variables do time out after a period of time. If it's not defined, I don't
think you
would want to update your table, but rather force the user to log in again.
Based on your code, it looks as if the user hits the homepage and the
variable session.user_name is not defined. It runs through the first set of code,
assigning defaults.
Then the person hits a second page, thus re-running the application.cfm.
Session.user_name is defined as the default, which is NA so it goes into the
else statement and executes that code, giving an error.
Michael Ross wrote:
> Sorry to ask a question about this but I am having problems. I set up my
>application.cfm for sessions. I am able to use them almost all the time. Then out
>of the blue I will get this error message.
>
> Error Diagnostic Information
> ODBC Error Code = S0022 (Column not found)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'na'.
>
> SQL = "UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE IDNUMBER= na"
>
> Data Source = "assets"
>
> I know what the error means I can fix that. Its why I am getting this that is
>puzzling. I know its not setting the session.user_name. But why?? out of the blue.
>
> Here is my application page.
>
>---
> SESSIONMANAGEMENT="YES"
> SESSIONTIMEOUT="#CREATETIMESPAN(0,0,30,0)#">
>
>
>
>
>
>
>
>
>
Just for the record, this is bad use of the CFPARAM tag. You already checked
for the existence of session.user_name, so CFPARAM is doing extra work. Can you
assume that if 'session.user_name' exists, so does session.name, session.securegroup,
etc.. etc..If you want to make this assumption, change your group of CFPARAMs into
CFSETs, or for even efficiency a CFSCRIPT block.
>
>
>
>
> SELECT IDNUMBER
> FROM tblsessions
> WHERE IDNUMBER = #IDNUMBER#
>
>
>
>
>
>
>
>
>
>
> INSERT INTO tblsessions(TIMEIN, IDNUMBER, IPADDRESS)
> VALUES('#VARIABLES.TIMET#', #SESSION.USER_NAME#, '#REMOTE_ADDR#')
>
>
>
>
>
>
Just to be on the safe side, change the above into:
You may want to add a CFOUTPUT somewhere so that you can debug the
value of session.username when you get the error.
I didn't think that CF was case sensitive, but that is the only reason I can think of
that
it would enter this if statement.
>
> UPDATE tblsessions
> SET LASTTIME ='#VARIABLES.TIMEL#'
> WHERE IDNUMBER= #SESSION.USER_NAME#
>
>
>
>
>
>
>
>
>
>
>
--
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Promise me no dead end streets, and I'll guarantee we'll have a road
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can only send 2046 characters through CFMAIL?
There is no difference between calling cfmail from a custom tag. And, since you've already done a test and it is not your mail server then I think there is more than likely a bug in your custom tag. If you post the code then it would be easier to diagnoe. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get yout free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Ryan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 11:25 AM Subject: Can only send 2046 characters through CFMAIL? > I am calling a custom tag that calls CFMAIL, no matter what content I > put between the tags, I only get 2046 characters of > it when it arrives via email. > > If I just setup a simple CF template with just a single call to CFMAIL, > all the characters come though. So I don't think its my email server > or anything. > > So is there some wierd limit on the number of chars cfmail can handle > when calling it from a custom tag? > > Thanks, > Ryan > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FirstDayOfMonth problems
I am trying to create an option in my CF calendar that allows repeating events that relocate themselves to the first business day of the month. For example, if the 1st falls on a Saturday, relocate that event to the 3rd, or Monday, the first business day. I have a problem with FirstDayOfMonth, however - it keeps returning the wrong day (one day earlier than it should). Here is my example code, with April 1, 2001 hard coded in since April 1st falls on a Sunday: Date: #dateFormat(thedate, "mm/dd/")#. This date is a #DayofWeekAsString(DayOfWeek(thedate))#, day #DayOfWeek(thedate)# in the week. This is day #Day(thedate)# in the month of #MonthAsString(Month(thedate))#, which has #DaysInMonth(thedate)# days. This date is in week #Week(thedate)# of #Year(thedate)# (day #DayofYear(thedate)# of #DaysinYear(thedate)#). This date is in a leap year This date is not in a leap year The first day of #DateFormat(thedate,"")#, #DateFormat(thedate,"")# is a #DayOfWeekAsString(DayOfWeek(FirstDayOfMonth(thedate)))# *NOTE* (this should return Sunday but returns Saturday), day #FirstDayOfMonth(thedate)# of the year. The first day of the month is: #DayOfWeek(FirstDayOfMonth(thedate))# *NOTE* (This should return 1 but returns 7) first business day = #DateFormat(firstbusinessday,", dd, ")# *NOTE* (This should return Monday, 04/02/2001 but returns Tuesday, 04/03/2001) first business day = #dateformat(firstbusinessday,", dd, ")# ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Generating unique values
While this is true in your case , it depends on the machine being used etc. GUIDs are created using a complicated algorithm which take several factors into consideration. Sometimes this results in consecutive UUID (Guids) being 1 apart, other times it doesn't. It depends on the resource etc. etc. For example if the GUID function drops its counter it has to start again at a point that is definitely past the last one it generated. Justin MacCarthy >-Original Message- >From: C Frederic Valone [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, January 02, 2001 3:51 PM >To: CF-Talk >Subject: Re: Generating unique values > > >> I just checked this out by generating a loop of 50 uuid's and >found that none of the values are incremented by 1 they differ in >various ways although the last portion of the id is the same in all cases. > >> Here is the list that was generated > >00075D9C-F809-1A51-B7D6809AFF5FEEB7 >00075E16-F809-1A51-B7D6809AFF5FEEB7 >00075E7D-F809-1A51-B7D6809AFF5FEEB7 >0007B5EE-F809-1A51-B7D6809AFF5FEEB7 >0007B64F-F809-1A51-B7D6809AFF5FEEB7 > >> >> >> Tuesday, January 02, 2001, 6:15:41 AM, you wrote: >> >> J> But it doesn't create values which are not easy to guess. >> >> J> Two consecutive UUID will have similar values + 1 >> >> J> Justin ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can only send 2046 characters through CFMAIL?
I am calling a custom tag that calls CFMAIL, no matter what content I put between the tags, I only get 2046 characters of it when it arrives via email. If I just setup a simple CF template with just a single call to CFMAIL, all the characters come though. So I don't think its my email server or anything. So is there some wierd limit on the number of chars cfmail can handle when calling it from a custom tag? Thanks, Ryan ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Generating unique values
Erm, isnt this to do with the fact that the id's are taken from a combination of your NIC ID and your system clock? The fact that the template would have been processed in such a fraction of a second could be the answer. Just a thought. N http://www.mcbdigital.com ---> ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Alternative To SQL Server Enterprise Manager
I'm wondering if any CF'ers here has found an affordable alternative to SQL Server's Enterprise Manager? I had found SQL Navigator from http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking in a lot of areas, as well as buggy as h*ll... Enterprise Manager gives a lot of functionality, but mostly operates as an SDI application where multiple windows would be tremendously useful, plus a way to filter the system objects out of the view? Plus provide a data browser, a way to change the properties of a table, build indexes, build stored procedures, change/add/delete data, etc... Does anyone know of such a critter? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Animated tutorial on assertions
Did I mention that I get 90% of anything you make with that, now? ;=) That is a great tool. It takes just a little getting used to cursor placement, but wow! Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion & Fusebox" training, Jan 22-25 == -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 11:07 AM To: CF-Talk Subject: FW: Animated tutorial on assertions Hey! That assert is good stuff. I must admit though, that I was blown away by that little Viewlet applet :) I think that's a great tool! :) Thanks to you for showing this animated tutorial utility to me heh heh -Gel -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED]] I've put together an animated tutorial on making assertions in CF. Assertions help ensure that what we expect is what we get -- or at least we know if we don't! There's a link at www.halhelms.com as well as a custom tag for making assertions. Thanks to Steve Nelson for introducing to me the concept of animated tutorials. I love 'em. ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: preparing for CF certification...
I don't think anything is IIS specific. - Original Message - From: "Ryan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 9:52 AM Subject: Re: preparing for CF certification... > At 10:51 1/2/01 -0600, you wrote: > >structures and error handling as well as some basic stuff not CF related > >(SQL, WebServer stuff etc) > > I hope its SQL and web server stuff in general, not MSSQL and IIS? > I use linux/apache/MySQL, and am just starting to learn MSSQL. I > hope to take the test in the next year or so. Please tell me they > don't test you on IIS knowledge. > > RPS > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: preparing for CF certification...
no its all generic i use Linux/Apache & Sybase =) so its all basic stuff should be a breeze Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 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 unauthorized alterations to this e-mail or attachment to it -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 10:52 AM To: CF-Talk Subject: Re: preparing for CF certification... At 10:51 1/2/01 -0600, you wrote: >structures and error handling as well as some basic stuff not CF related >(SQL, WebServer stuff etc) I hope its SQL and web server stuff in general, not MSSQL and IIS? I use linux/apache/MySQL, and am just starting to learn MSSQL. I hope to take the test in the next year or so. Please tell me they don't test you on IIS knowledge. RPS ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Windows 2000 Error Codes
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sarcasm aside, there's too many to have in one list. First stop, try Microsoft Knowledge Base Search: http://search.support.microsoft.com/kb/c.asp You can usually find any and all errors there. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. 617.350.0339 617.350.8884 66172567 [EMAIL PROTECTED] ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: Animated tutorial on assertions
Hey! That assert is good stuff. I must admit though, that I was blown away by that little Viewlet applet :) I think that's a great tool! :) Thanks to you for showing this animated tutorial utility to me heh heh -Gel -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED]] I've put together an animated tutorial on making assertions in CF. Assertions help ensure that what we expect is what we get -- or at least we know if we don't! There's a link at www.halhelms.com as well as a custom tag for making assertions. Thanks to Steve Nelson for introducing to me the concept of animated tutorials. I love 'em. ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: preparing for CF certification...
I've done that and scored a Master's Certification from it. Thanks though. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Nick Betts <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Tuesday, January 02, 2001 10:14 AM Subject: RE: preparing for CF certification... >Try looking at www.brainbench.com. They have a free certification exam on >there which is good prep. > >Nick Betts > >-Original Message- >From: Jamie Keane [mailto:[EMAIL PROTECTED]] >Sent: 02 January 2001 15:18 >To: CF-Talk >Subject: preparing for CF certification... > > >Hi folks. I'm thinking about going for my Allaire CF Certification in the >moderately near future. What are some of the things I can do to help >prepare? > >Just looking for suggestions. :) > >Thanks and hope you all had a happy and safe New Year's! >Jamie > >-- >Jamie Keane >Programmer >SolutionMasters, Inc. >9111 Monroe Rd., Suite 100 >Charlotte, NC 28270 >www.solutionmasters.com >704.849.7771 x 228 Voice >704.849.9291 Fax > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Generating unique values
> I just checked this out by generating a loop of 50 uuid's and found that none of the >values are incremented by 1 they differ in various ways although the last portion of >the id is the same in all cases. > Here is the list that was generated 00075D9C-F809-1A51-B7D6809AFF5FEEB7 00075E16-F809-1A51-B7D6809AFF5FEEB7 00075E7D-F809-1A51-B7D6809AFF5FEEB7 00075EE1-F809-1A51-B7D6809AFF5FEEB7 00075F44-F809-1A51-B7D6809AFF5FEEB7 00075FA6-F809-1A51-B7D6809AFF5FEEB7 00076009-F809-1A51-B7D6809AFF5FEEB7 0007606B-F809-1A51-B7D6809AFF5FEEB7 000760CD-F809-1A51-B7D6809AFF5FEEB7 00076130-F809-1A51-B7D6809AFF5FEEB7 00076192-F809-1A51-B7D6809AFF5FEEB7 000761F4-F809-1A51-B7D6809AFF5FEEB7 00076257-F809-1A51-B7D6809AFF5FEEB7 000762B9-F809-1A51-B7D6809AFF5FEEB7 0007631B-F809-1A51-B7D6809AFF5FEEB7 0007637D-F809-1A51-B7D6809AFF5FEEB7 000763DF-F809-1A51-B7D6809AFF5FEEB7 00076441-F809-1A51-B7D6809AFF5FEEB7 000764A3-F809-1A51-B7D6809AFF5FEEB7 00076505-F809-1A51-B7D6809AFF5FEEB7 00076567-F809-1A51-B7D6809AFF5FEEB7 000765C9-F809-1A51-B7D6809AFF5FEEB7 0007662B-F809-1A51-B7D6809AFF5FEEB7 0007668C-F809-1A51-B7D6809AFF5FEEB7 000766EE-F809-1A51-B7D6809AFF5FEEB7 00076750-F809-1A51-B7D6809AFF5FEEB7 000767B2-F809-1A51-B7D6809AFF5FEEB7 00076815-F809-1A51-B7D6809AFF5FEEB7 00076877-F809-1A51-B7D6809AFF5FEEB7 000768D9-F809-1A51-B7D6809AFF5FEEB7 0007693B-F809-1A51-B7D6809AFF5FEEB7 000769A0-F809-1A51-B7D6809AFF5FEEB7 00076A04-F809-1A51-B7D6809AFF5FEEB7 00076A66-F809-1A51-B7D6809AFF5FEEB7 0007B06A-F809-1A51-B7D6809AFF5FEEB7 0007B0EE-F809-1A51-B7D6809AFF5FEEB7 0007B156-F809-1A51-B7D6809AFF5FEEB7 0007B1BB-F809-1A51-B7D6809AFF5FEEB7 0007B21D-F809-1A51-B7D6809AFF5FEEB7 0007B27E-F809-1A51-B7D6809AFF5FEEB7 0007B2E0-F809-1A51-B7D6809AFF5FEEB7 0007B342-F809-1A51-B7D6809AFF5FEEB7 0007B3A3-F809-1A51-B7D6809AFF5FEEB7 0007B405-F809-1A51-B7D6809AFF5FEEB7 0007B467-F809-1A51-B7D6809AFF5FEEB7 0007B4C8-F809-1A51-B7D6809AFF5FEEB7 0007B52A-F809-1A51-B7D6809AFF5FEEB7 0007B58C-F809-1A51-B7D6809AFF5FEEB7 0007B5EE-F809-1A51-B7D6809AFF5FEEB7 0007B64F-F809-1A51-B7D6809AFF5FEEB7 > > > Tuesday, January 02, 2001, 6:15:41 AM, you wrote: > > J> But it doesn't create values which are not easy to guess. > > J> Two consecutive UUID will have similar values + 1 > > J> Justin > > >>-Original Message- > >>From: listmb [mailto:[EMAIL PROTECTED]] > >>Sent: Sunday, December 31, 2000 10:01 PM > >>To: CF-Talk > >>Subject: Re[2]: Generating unique values > >> > >> > >>Thanks Nick, > >> > >>That was just what I was looking for! > >> > >>Best, > >>WayGee > >> > >> > >>Hello Nick, > >> > >>Sunday, December 31, 2000, 4:00:40 PM, you wrote: > >> > >>NM> You can use the CreateUUID function. > >> > >>NM> It generates a Universally Unique ID. It does contain both > >>letters and numbers. > >> > >>NM> At 03:58 PM 12/31/2000 -0500, you wrote: > Hi, > > Being new to cold fusion (1 week), can anyone let me know if there is > a way to create unique random numbers or strings in cold fusion? > It should not be iterative or easily guessed. > > > This would help alot! > > -- > Best regards, > WayGee mailto:[EMAIL PROTECTED] > > > > > >>NM> > >> > J> > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: preparing for CF certification...
At 10:51 1/2/01 -0600, you wrote: >structures and error handling as well as some basic stuff not CF related >(SQL, WebServer stuff etc) I hope its SQL and web server stuff in general, not MSSQL and IIS? I use linux/apache/MySQL, and am just starting to learn MSSQL. I hope to take the test in the next year or so. Please tell me they don't test you on IIS knowledge. RPS ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Windows 2000 Error Codes
Does anyone know of a good web reference for windows 2000 error codes? Thanks, Kevin Schmidt, Web Technology Manager Allaire Certified Cold Fusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: preparing for CF certification...
structures and error handling as well as some basic stuff not CF related (SQL, WebServer stuff etc) - Original Message - From: "Jamie Keane" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 9:18 AM Subject: preparing for CF certification... > Hi folks. I'm thinking about going for my Allaire CF Certification in the > moderately near future. What are some of the things I can do to help > prepare? > > Just looking for suggestions. :) > > Thanks and hope you all had a happy and safe New Year's! > Jamie > > -- > Jamie Keane > Programmer > SolutionMasters, Inc. > 9111 Monroe Rd., Suite 100 > Charlotte, NC 28270 > www.solutionmasters.com > 704.849.7771 x 228 Voice > 704.849.9291 Fax > > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Image Thumbnail
Paint Shop Pro from Jasc Software (www.jasc.com) has a good batch operation that can do this. This however isn't done on the server on the fly. --Greg - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 02, 2001 10:15 AM Subject: Image Thumbnail > Does anyone know of a good CF application or any other kind of tool to make > a thumbnail image? > > I tried CF_AutoResize, and it worked very well. The only problem i had was > some of my users will be uploading CMYK files, PDF's, all kinds of > different image files. > > Thanks > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sessions/cookies
SQL = "UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE
IDNUMBER= na"
Use single quotes around the na, so it should look like this
UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE
IDNUMBER='na'
--Greg
- Original Message -
From: "Michael Ross" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 02, 2001 9:37 AM
Subject: Sessions/cookies
> Sorry to ask a question about this but I am having problems. I set up my
application.cfm for sessions. I am able to use them almost all the time.
Then out of the blue I will get this error message.
> --
--
> Error Diagnostic Information
> ODBC Error Code = S0022 (Column not found)
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'na'.
>
>
> SQL = "UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE
IDNUMBER= na"
>
> Data Source = "assets"
> --
--
> I know what the error means I can fix that. Its why I am getting this
that is puzzling. I know its not setting the session.user_name. But why??
out of the blue.
>
> Here is my application page.
> --
-
> SESSIONMANAGEMENT="YES"
> SESSIONTIMEOUT="#CREATETIMESPAN(0,0,30,0)#">
>
>
>
>
>
>
>
>
>
>
>
>
> SELECT IDNUMBER
> FROM tblsessions
> WHERE IDNUMBER = #IDNUMBER#
>
>
>
>
>
>
>
>
>
>
> INSERT INTO tblsessions(TIMEIN, IDNUMBER, IPADDRESS)
> VALUES('#VARIABLES.TIMET#', #SESSION.USER_NAME#, '#REMOTE_ADDR#')
>
>
>
>
>
> UPDATE tblsessions
> SET LASTTIME ='#VARIABLES.TIMEL#'
> WHERE IDNUMBER= #SESSION.USER_NAME#
>
>
>
>
>
>
>
>
>
>
>
>
>
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: preparing for CF certification...
Just make sure who know the tag :-) ~Cynical Justin > >Hi folks. I'm thinking about going for my Allaire CF Certification in the >moderately near future. What are some of the things I can do to help >prepare? >Thanks and hope you all had a happy and safe New Year's! >Jamie ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfstoredproc problem
Hi, You might already solved the problem. Since I do not see any post here I reply it anyway. First, if you use SQL server , you have to set up the return code you self in the stored procedure. Because the default return code is 0. The stored procedure should look something like: CREATE PROCEDURE spUpdateUser @@picture char(20), @@userid char(20 ) As UPDATE PasUsers SET picture = '@picture' WHERE userid = '@userid' Return @@Rowcount GO The @@Rowcount is the number of the record affected by the update action, in this case should be 1. I made up the data type by guessing you should change them to the correct ones. Second, after the calling of the stored procedure, You put: UpdateOK record has been updated in the database Sorry, it failed You can customize the if statement to suit your needs. Hope this helps Sima "S R" tmail.com> cc: Subject: cfstoredproc problem 12/29/00 05:32 PM Please respond to cf-talk I have been at this for the past 35 minutes and I just can't figure it out. This cfstoredproc just isn't working. I've tested the actual stored procedure on SQL Server by placing some actual values in the stored procedure and it worked. But when I try to use this cfstoredproc to do the stored procedure it doesn't do anything. The #cfstoredproc.statuscode# is even at 0> can you see anything wrong? here is my stored procedure: UPDATE PasUsers SET picture = '@picture' WHERE userid = '@userid' ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: preparing for CF certification...
Try looking at www.brainbench.com. They have a free certification exam on there which is good prep. Nick Betts -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: 02 January 2001 15:18 To: CF-Talk Subject: preparing for CF certification... Hi folks. I'm thinking about going for my Allaire CF Certification in the moderately near future. What are some of the things I can do to help prepare? Just looking for suggestions. :) Thanks and hope you all had a happy and safe New Year's! Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Image Thumbnail
Does anyone know of a good CF application or any other kind of tool to make a thumbnail image? I tried CF_AutoResize, and it worked very well. The only problem i had was some of my users will be uploading CMYK files, PDF's, all kinds of different image files. Thanks ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
preparing for CF certification...
Hi folks. I'm thinking about going for my Allaire CF Certification in the moderately near future. What are some of the things I can do to help prepare? Just looking for suggestions. :) Thanks and hope you all had a happy and safe New Year's! Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sessions/cookies
Session variables do time out after a period of time. If it's not defined, I don't
think you
would want to update your table, but rather force the user to log in again.
Based on your code, it looks as if the user hits the homepage and the
variable session.user_name is not defined. It runs through the first set of code,
assigning defaults.
Then the person hits a second page, thus re-running the application.cfm.
Session.user_name is defined as the default, which is NA so it goes into the
else statement and executes that code, giving an error.
Michael Ross wrote:
> Sorry to ask a question about this but I am having problems. I set up my
>application.cfm for sessions. I am able to use them almost all the time. Then out
>of the blue I will get this error message.
>
> Error Diagnostic Information
> ODBC Error Code = S0022 (Column not found)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'na'.
>
> SQL = "UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE IDNUMBER= na"
>
> Data Source = "assets"
>
> I know what the error means I can fix that. Its why I am getting this that is
>puzzling. I know its not setting the session.user_name. But why?? out of the blue.
>
> Here is my application page.
>
>---
> SESSIONMANAGEMENT="YES"
> SESSIONTIMEOUT="#CREATETIMESPAN(0,0,30,0)#">
>
>
>
>
>
>
>
>
>
Just for the record, this is bad use of the CFPARAM tag. You already checked
for the existence of session.user_name, so CFPARAM is doing extra work. Can you
assume that if 'session.user_name' exists, so does session.name, session.securegroup,
etc.. etc..If you want to make this assumption, change your group of CFPARAMs into
CFSETs, or for even efficiency a CFSCRIPT block.
>
>
>
>
> SELECT IDNUMBER
> FROM tblsessions
> WHERE IDNUMBER = #IDNUMBER#
>
>
>
>
>
>
>
>
>
>
> INSERT INTO tblsessions(TIMEIN, IDNUMBER, IPADDRESS)
> VALUES('#VARIABLES.TIMET#', #SESSION.USER_NAME#, '#REMOTE_ADDR#')
>
>
>
>
>
>
Just to be on the safe side, change the above into:
You may want to add a CFOUTPUT somewhere so that you can debug the
value of session.username when you get the error.
I didn't think that CF was case sensitive, but that is the only reason I can think of
that
it would enter this if statement.
>
> UPDATE tblsessions
> SET LASTTIME ='#VARIABLES.TIMEL#'
> WHERE IDNUMBER= #SESSION.USER_NAME#
>
>
>
>
>
>
>
>
>
>
>
--
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Promise me no dead end streets, and I'll guarantee we'll have a road
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Admin E-mail (newbie level question)
Justin >-Original Message- >From: Scott Wolf [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, January 02, 2001 2:46 PM >To: CF-Talk >Subject: Admin E-mail (newbie level question) > > >My brain has completely locked up on me (must had >a bit too much to drink on Sunday), but I can't >remember how to change the admin e-mail for a >specific application. The CF-Administrator says >it's possible, but I can't find it in the docs. >If someone could help me, I'd really appreciate >it. Thanks in advance, and Happy New Year! > >Scott Wolf > > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sessions/cookies
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael, Change your query to: SELECT IDNUMBER FROM tblsessions WHERE IDNUMBER = '#IDNUMBER#' Right now you're telling your database server "Get me the idnumber from tblsessions where the id NUMBER is two letters"and your db server is expecting to see numbers. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. 617.350.0339 617.350.8884 66172567 [EMAIL PROTECTED] ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sessions/cookies
Try putting ## around na
UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE IDNUMBER=
#na#
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: 02 January 2001 14:38
To: CF-Talk
Subject: Sessions/cookies
Sorry to ask a question about this but I am having problems. I set up my
application.cfm for sessions. I am able to use them almost all the time.
Then out of the blue I will get this error message.
Error Diagnostic Information
ODBC Error Code = S0022 (Column not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'na'.
SQL = "UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE
IDNUMBER= na"
Data Source = "assets"
I know what the error means I can fix that. Its why I am getting this that
is puzzling. I know its not setting the session.user_name. But why?? out
of the blue.
Here is my application page.
---
SELECT IDNUMBER
FROM tblsessions
WHERE IDNUMBER = #IDNUMBER#
INSERT INTO tblsessions(TIMEIN, IDNUMBER, IPADDRESS)
VALUES('#VARIABLES.TIMET#', #SESSION.USER_NAME#,
'#REMOTE_ADDR#')
UPDATE tblsessions
SET LASTTIME ='#VARIABLES.TIMEL#'
WHERE IDNUMBER= #SESSION.USER_NAME#
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Admin E-mail (newbie level question)
My brain has completely locked up on me (must had a bit too much to drink on Sunday), but I can't remember how to change the admin e-mail for a specific application. The CF-Administrator says it's possible, but I can't find it in the docs. If someone could help me, I'd really appreciate it. Thanks in advance, and Happy New Year! Scott Wolf ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Sessions/cookies
Sorry to ask a question about this but I am having problems. I set up my
application.cfm for sessions. I am able to use them almost all the time. Then out of
the blue I will get this error message.
Error Diagnostic Information
ODBC Error Code = S0022 (Column not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'na'.
SQL = "UPDATE tblsessions SET LOGIN = 'rumm01', LOGGEDIN = 'YES' WHERE IDNUMBER= na"
Data Source = "assets"
I know what the error means I can fix that. Its why I am getting this that is
puzzling. I know its not setting the session.user_name. But why?? out of the blue.
Here is my application page.
---
SELECT IDNUMBER
FROM tblsessions
WHERE IDNUMBER = #IDNUMBER#
INSERT INTO tblsessions(TIMEIN, IDNUMBER, IPADDRESS)
VALUES('#VARIABLES.TIMET#', #SESSION.USER_NAME#, '#REMOTE_ADDR#')
UPDATE tblsessions
SET LASTTIME ='#VARIABLES.TIMEL#'
WHERE IDNUMBER= #SESSION.USER_NAME#
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating Datasources Using CF
Here is a CFHTTP method for creating the FastTrack to ColdFusion class Datasource. This might give you some ideas. http://#CGI.SERVER_NAME#/cfide/administrator/datasources/editdsinfo.cfm " METHOD="POST" RESOLVEURL="YES"> #cfhttp.filecontent# -Original Message- From: Tan Siew Ling [mailto:[EMAIL PROTECTED]] Sent: Monday, January 01, 2001 11:01 PM To: CF-Talk Subject: Creating Datasources Using CF Hi All Can i write CF codes to create datasources instead of using cold fusion admin? Thanks, Siew Ling ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Animated tutorial on assertions
Happy New Year/New Millennium, everyone! I've put together an animated tutorial on making assertions in CF. Assertions help ensure that what we expect is what we get -- or at least we know if we don't! There's a link at www.halhelms.com as well as a custom tag for making assertions. Thanks to Steve Nelson for introducing to me the concept of animated tutorials. I love 'em. Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion & Fusebox" training, Jan 22-25 == ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[4]: Generating unique values
Depends what you want to do but something like : #key# Justin MacCarthy >-Original Message- >From: listmb [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, January 02, 2001 12:50 PM >To: CF-Talk >Subject: Re[4]: Generating unique values > > >Thanks this sounds like they are using a guid call to generate this. >Is there some other algorihth i could use or ways I could do this? > >Thanks, >WayGee > >Hello JustinMacCarthy, > >Tuesday, January 02, 2001, 6:15:41 AM, you wrote: > >J> But it doesn't create values which are not easy to guess. > >J> Two consecutive UUID will have similar values + 1 > > >J> Justin > >>>-Original Message- >>>From: listmb [mailto:[EMAIL PROTECTED]] >>>Sent: Sunday, December 31, 2000 10:01 PM >>>To: CF-Talk >>>Subject: Re[2]: Generating unique values >>> >>> >>>Thanks Nick, >>> >>>That was just what I was looking for! >>> >>>Best, >>>WayGee >>> >>> >>>Hello Nick, >>> >>>Sunday, December 31, 2000, 4:00:40 PM, you wrote: >>> >>>NM> You can use the CreateUUID function. >>> >>>NM> It generates a Universally Unique ID. It does contain both >>>letters and numbers. >>> >>>NM> At 03:58 PM 12/31/2000 -0500, you wrote: >Hi, > >Being new to cold fusion (1 week), can anyone let me know if there is >a way to create unique random numbers or strings in cold fusion? >It should not be iterative or easily guessed. > > >This would help alot! > >-- >Best regards, >WayGee mailto:[EMAIL PROTECTED] > > > > >>>NM> >>> >J> > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[4]: Generating unique values
Thanks this sounds like they are using a guid call to generate this. Is there some other algorihth i could use or ways I could do this? Thanks, WayGee Hello JustinMacCarthy, Tuesday, January 02, 2001, 6:15:41 AM, you wrote: J> But it doesn't create values which are not easy to guess. J> Two consecutive UUID will have similar values + 1 J> Justin >>-Original Message- >>From: listmb [mailto:[EMAIL PROTECTED]] >>Sent: Sunday, December 31, 2000 10:01 PM >>To: CF-Talk >>Subject: Re[2]: Generating unique values >> >> >>Thanks Nick, >> >>That was just what I was looking for! >> >>Best, >>WayGee >> >> >>Hello Nick, >> >>Sunday, December 31, 2000, 4:00:40 PM, you wrote: >> >>NM> You can use the CreateUUID function. >> >>NM> It generates a Universally Unique ID. It does contain both >>letters and numbers. >> >>NM> At 03:58 PM 12/31/2000 -0500, you wrote: Hi, Being new to cold fusion (1 week), can anyone let me know if there is a way to create unique random numbers or strings in cold fusion? It should not be iterative or easily guessed. This would help alot! -- Best regards, WayGee mailto:[EMAIL PROTECTED] >>NM> >> J> ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating Datasources Using CF
Folks, You might want to bear in mind that it is not good to leave CFregistry active on a production server.. Regards Stephen > -Original Message- > From: Allan Pichler [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 02 January 2001 10:46 > To: CF-Talk > Subject: RE: Creating Datasources Using CF > > > > This code has worked fine for me on a windows box! > > > > > > > > > > > branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI" > ENTRY="#newdatasource#" type="KEY"> > branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#" > ENTRY="Description" value="#description#"> > branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#" > ENTRY="Database" value="#database#"> > branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#" > ENTRY="server" value="#server#"> > branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#" > ENTRY="Trusted_Connection" value="#trusted_connection#"> > branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#" > ENTRY="UseProcForPrepare" value="#UseProcForPrepare#"> > branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#" > ENTRY="OEMTOANSI" value="#OEMTOANSI#"> > branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#" > ENTRY="Driver" value="#driver#"> > branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources" > ENTRY="#newdatasource#" value="SQL Server"> > > Allan Pichler > Machine Dreams Inc. > > > -Original Message- > From: Johan Coens [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 02, 2001 12:29 AM > To: CF-Talk > Subject: RE: Creating Datasources Using CF > > > Check the CF Developer Gallery for creating datasources. > > Regards, > Johan Coens > > -Original Message- > From: Tan Siew Ling [mailto:[EMAIL PROTECTED]] > Sent: dinsdag 2 januari 2001 5:01 > To: CF-Talk > Subject: Creating Datasources Using CF > > > Hi All > > Can i write CF codes to create datasources instead of using cold fusion > admin? > > Thanks, > Siew Ling > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Generating unique values
But it doesn't create values which are not easy to guess. Two consecutive UUID will have similar values + 1 Justin >-Original Message- >From: listmb [mailto:[EMAIL PROTECTED]] >Sent: Sunday, December 31, 2000 10:01 PM >To: CF-Talk >Subject: Re[2]: Generating unique values > > >Thanks Nick, > >That was just what I was looking for! > >Best, >WayGee > > >Hello Nick, > >Sunday, December 31, 2000, 4:00:40 PM, you wrote: > >NM> You can use the CreateUUID function. > >NM> It generates a Universally Unique ID. It does contain both >letters and numbers. > >NM> At 03:58 PM 12/31/2000 -0500, you wrote: >>>Hi, >>> >>>Being new to cold fusion (1 week), can anyone let me know if there is >>>a way to create unique random numbers or strings in cold fusion? >>>It should not be iterative or easily guessed. >>> >>> >>>This would help alot! >>> >>>-- >>>Best regards, >>>WayGee mailto:[EMAIL PROTECTED] >>> >>> >>> >>> >NM> > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
