RE: Getting CF to trigger a SQL data export to text file
At 07:19 PM 11/9/2003, you wrote: Create a DTS in MS SQL Execute the DTS from the Command line. That sounds fine if you were going to export the same data from the same table every time - but I need to be able to vary what table, and what fields within that table, that gets exported. If one has to do part of the setup manually, it won't work for my needs, I fear. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: javascript window.close() twist
The problem is that when you refresh the parent window, the parent-child relationship is destroyed. You can create a frame set with only one frame and open the window from the frameset. This way the relationship still exists after refreshing the frame. When you log out, trigger another function in the frame set to close the child. If frames are not an option, I don't see an easy solution. You could make your child refresh every x seconds and if the user logged out, close the window, but this is not an elegant solution and might give you problems if the menu is using dhtml (can't keep status on refresh) HTH Pascal -Oorspronkelijk bericht- Van: Brrrian [mailto:[EMAIL PROTECTED] Verzonden: ma 10/11/2003 3:13 Aan: CF-Talk CC: Onderwerp: _javascript_ window.close() twist The Issue When the user wants to LogOut I need to Close the Child Window.I can't get anything to work. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Attempts at banking fraud
It staggers me that there are people in the world who will attempt to rob others by cleverly imitating a bank/credit unions email to attempt to gain access to someones funds. They usually attempt this with cleverly crafted HTML email messages. Microsoft has also fallen victim to this atttempt at validity by the look of a message alone. I've received a few of these lately. Keep in mind it is highly unlikely that your own bank would ever send you something via email that would ever ask you for personal information (they would more than likely have it already). In fact your bank would not even really need to know your email address at all. Whenever I receive these bogus messages, and I have received several, I forward them to the Australia Federal Police in their entirety. You should do the same to your respective law enforcers (eg: FBI). PS. I'm not even sure if it was a valid email but Microsoft are offering $25,000 worth of software for $299 through their Partner program. It looks legitimate - clever - but probably not the real deal. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Attempts at banking fraud
The one I just got took the cake: subject was You have won a Sony Handicam (This is not Spam). The message purported to being part of the grand opening of a new online AV store - it provided a code to claim your prize.After stripping the URL ID from the link I went to the site: yes, it said, I won.All I had to do was fill out my information. Standard stuff: address, phone number, etc UNTIL.The bottom of the form had a red apology: We're sorry, but our credit merchant is current experiencing difficulties so we cannot accept credit cards at the moment.To claim your prize please enter your debit card information instead. The form actually had a Debit Card Number AND PIN Number entry boxes. What worries me is that the form looked very professional (up until that point) - I'm sure that at least some people have been taken in. Although, in your case, it may be seeded from the truth.Microsoft does offer a very attractive Partner Provider deal (I'm a subscriber).You join up as a Registered Partner for $299 (I got in on a special $100 deal) and they send you quarterly software packages: pretty much all of their software (not for resale but otherwise full editions) and sales/migration material. The software package is called the Action Pack.Here's a link to it: http://members.microsoft.com/partner/salesmarketing/partnermarket/action pack/default.aspx?nav=ln It's a truly great deal, but I would only subscribe via the official Microsoft.com website.You actually get full copies of all current OSes (Windows 2003 all editions, Windows 2000 Advanced Server, XP Pro and Home, etc), Exchange server, Visio, MS Office, SQL Server, MS Project, and tons more. I do know of at least one scam where people gather many of these packs and then sell the software for huge profits on eBay. Jim Davis -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 6:39 PM To: CF-Talk Subject: OT: Attempts at banking fraud It staggers me that there are people in the world who will attempt to rob others by cleverly imitating a bank/credit unions email to attempt to gain access to someones funds. They usually attempt this with cleverly crafted HTML email messages. Microsoft has also fallen victim to this atttempt at validity by the look of a message alone. I've received a few of these lately. Keep in mind it is highly unlikely that your own bank would ever send you something via email that would ever ask you for personal information (they would more than likely have it already). In fact your bank would not even really need to know your email address at all. Whenever I receive these bogus messages, and I have received several, I forward them to the Australia Federal Police in their entirety. You should do the same to your respective law enforcers (eg: FBI). PS. I'm not even sure if it was a valid email but Microsoft are offering $25,000 worth of software for $299 through their Partner program. It looks legitimate - clever - but probably not the real deal. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: javascript window.close() twist
I do something like this quite regularly.
I open a window on one page, then after a few screen refreshes I close the
window.
The attached is the code that I use.It should work.Generally what it
does is opens the window with a specific name on one screen.
Then after a few screen refreshes the new page runs the code to open a
window with the same name.It doesn't actually open the new window, it just
gets control of the original popup window and then it closes it.
There is other code in these js clips, but you should be able to get rid of
them.
!--- CODE THAT GOES IN THE PAGE THAT OPENS THE CHILD WINDOW ---
script language=_javascript_
!--
function popup() {
var winnew;
CFOUTPUT
var myWtPg = '#InclDir#bau_wait.cfm?type=PROC';
/CFOUTPUT
var myWtPgSet =
'toolbar=0,location=0,status=0,menubar=0,scrollbars=0,width=400,height=200';
var myRetTxt = 'Changes made to the database cannot be rolled back. \n';
myRetTxt = myRetTxt + 'Are you sure you want to run the procedure?';
var ret =confirm(myRetTxt);
if (!ret)
return false;
winnew = window.open(myWtPg, Wait, myWtPgSet);
winnew.focus();
}
//--
/script
!--- CODE THAT GOES IN THE PAGE THAT CLOSES THE CHILD WINDOW ---
script language=_javascript_
!--var winnew;
var myOpts;
myOpts =
toolbar=0,location=0,status=0,menubar=0,scrollbars=0,width=400,height=200;
winnew = window.open( , Wait, myOpts);
winnew.close();
//--
/Script
Steve
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:51 AM
To: CF-Talk
Subject: RE: _javascript_ window.close() twist
The problem is that when you refresh the parent window, the parent-child
relationship is destroyed. You can create a frame set with only one frame
and open the window from the frameset. This way the relationship still
exists after refreshing the frame. When you log out, trigger another
function in the frame set to close the child.
If frames are not an option, I don't see an easy solution. You could make
your child refresh every x seconds and if the user logged out, close the
window, but this is not an elegant solution and might give you problems if
the menu is using dhtml (can't keep status on refresh)
HTH
Pascal
-Oorspronkelijk bericht-
Van: Brrrian [mailto:[EMAIL PROTECTED]
Verzonden: ma 10/11/2003 3:13
Aan: CF-Talk
CC:
Onderwerp: _javascript_ window.close() twist
The Issue
When the user wants to LogOut I need to Close the Child Window.I can't
get anything to work.
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Getting CF to trigger a SQL data export to text file
Create a bcp command line. Then you can make it dynamically. Here is an example... (can be run from query analyzer or made part of a stored procedure) declare @bcpcmdline nvarchar(4000) declare @sqlfilename varchar(100) select @sqlfilename = '\\myserver\mydirectory\myfilename.txt' select @BCPCMDLINE = 'bcp select rec_id, employee_name from ' + ' Employee_table order by employee_name queryout ' + @SQLFILENAME + ' -S ' + @@servername + ' -T -t, -c' EXEC MASTER..XP_CMDSHELL @BCPCMDLINE, NO_OUTPUT What this will do is query the employee_table for rec_id and employee name and save it as a comma delimited file using a trusted connection. You should be able to find out more information of the switches. Also note that it is very easy to modify the @bcpcmdline variable to do what you need dynamically. Steve -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:45 AM To: CF-Talk Subject: RE: Getting CF to trigger a SQL data export to text file At 07:19 PM 11/9/2003, you wrote: Create a DTS in MS SQL Execute the DTS from the Command line. That sounds fine if you were going to export the same data from the same table every time - but I need to be able to vary what table, and what fields within that table, that gets exported. If one has to do part of the setup manually, it won't work for my needs, I fear. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: randRange(); just how random is it?
That would be Randomize(number). Chris -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Saturday, November 08, 2003 6:45 PM To: CF-Talk Subject: RE: randRange(); just how random is it? There should be a way to re-seed the random number generator. -Gel -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Are you calling randomize a lot??? If you do, your random sequences won't be all that random Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Attempts at banking fraud
Actually, the Microsoft Action Pack Subscription is legit.For $299 you get a whole boatload of software, along with 10 licenses (or 10 CAL's for server products).The catch is that it's only licensed for 12 months.In all, it's a good deal, sometimes made even better...I got mine for $99 after a $200 coupon. Pete - Original Message - From: Peter Tilbrook To: CF-Talk Sent: Friday, November 07, 2003 6:39 PM Subject: OT: Attempts at banking fraud It staggers me that there are people in the world who will attempt to rob others by cleverly imitating a bank/credit unions email to attempt to gain access to someones funds. They usually attempt this with cleverly crafted HTML email messages. Microsoft has also fallen victim to this atttempt at validity by the look of a message alone. I've received a few of these lately. Keep in mind it is highly unlikely that your own bank would ever send you something via email that would ever ask you for personal information (they would more than likely have it already). In fact your bank would not even really need to know your email address at all. Whenever I receive these bogus messages, and I have received several, I forward them to the Australia Federal Police in their entirety. You should do the same to your respective law enforcers (eg: FBI). PS. I'm not even sure if it was a valid email but Microsoft are offering $25,000 worth of software for $299 through their Partner program. It looks legitimate - clever - but probably not the real deal. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: randRange(); just how random is it?
Correct, and be sure to seed it with a different number each time (maybe using GetTickCount() or some combination of date and time). --- Ben -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 8:22 AM To: CF-Talk Subject: RE: randRange(); just how random is it? That would be Randomize(number). Chris -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Saturday, November 08, 2003 6:45 PM To: CF-Talk Subject: RE: randRange(); just how random is it? There should be a way to re-seed the random number generator. -Gel -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Are you calling randomize a lot??? If you do, your random sequences won't be all that random Paul _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: randRange(); just how random is it?
Correct, and be sure to seed it with a different number each time (maybe using GetTickCount() or some combination of date and time). Be careful when seeding randomize() with the output of gettickcount() - in MX6.1 the value returned from gettickcount() is too large to fit in an int and hence can't be passed directly to randomize()...I usually do something like this: randomize(right(gettickcount(), 6) * rand()) Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfexecute on unix
Hi Hugo, I had the same thought and the same issues with it. Creating a shell script on the fly with the correct permissions and then executing and deleting it afterwards is a PITA compared to using cfexecute. Thanks for the help though, Adam. -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: 07 November 2003 10:55 To: CF-Talk Subject: RE: cfexecute on unix A workaround that we looked into: You can cfexecute a shell-script with arguments, of where the first argument is the file that you really want to execute, then the script fixes the problem and executes the actual file. It is not a very beautiful solution. (Still waiting for a tech note on this) /Hugo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
crystal report
hi, could you giveme any link for downloading crystal report 6.0 ? see you... - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Attempts at banking fraud
Hi Pete, Where did you get the coupon? Thanks, DavidB -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 8:27 AM To: CF-Talk Subject: Re: Attempts at banking fraud Actually, the Microsoft Action Pack Subscription is legit.For $299 you get a whole boatload of software, along with 10 licenses (or 10 CAL's for server products).The catch is that it's only licensed for 12 months.In all, it's a good deal, sometimes made even better...I got mine for $99 after a $200 coupon. Pete - Original Message - From: Peter Tilbrook To: CF-Talk Sent: Friday, November 07, 2003 6:39 PM Subject: OT: Attempts at banking fraud It staggers me that there are people in the world who will attempt to rob others by cleverly imitating a bank/credit unions email to attempt to gain access to someones funds. They usually attempt this with cleverly crafted HTML email messages. Microsoft has also fallen victim to this atttempt at validity by the look of a message alone. I've received a few of these lately. Keep in mind it is highly unlikely that your own bank would ever send you something via email that would ever ask you for personal information (they would more than likely have it already). In fact your bank would not even really need to know your email address at all. Whenever I receive these bogus messages, and I have received several, I forward them to the Australia Federal Police in their entirety. You should do the same to your respective law enforcers (eg: FBI). PS. I'm not even sure if it was a valid email but Microsoft are offering $25,000 worth of software for $299 through their Partner program. It looks legitimate - clever - but probably not the real deal. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Attempts at banking fraud
| | PS. I'm not even sure if it was a valid email but Microsoft are offering | $25,000 worth of software for $299 through their Partner program. It looks | legitimate - clever - but probably not the real deal. | The Microsoft Action Pack subscriptions are indeed legitimate.You can get all the details by a search on the www.microsoft.com web site. http://members.microsoft.com/partner/salesmarketing/PartnerMarket/ActionPack/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re[2]: Getting CF to trigger a SQL data export to text file
Scott, On 11/10/2003 at 03:45, you wrote: SW That sounds fine if you were going to export the same data from SW the same table every time - but I need to be able to vary what SW table, and what fields within that table, that gets exported. If SW one has to do part of the setup manually, it won't work for my SW needs, I fear. I have an application that passes (cfexecute) a variety of queries to a shell script that calls PostgreSQL's psql utility which writes the query results to a file. Perhaps MS SQL has a similar utility... ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Attempts at banking fraud
In Australia the Microsoft Action Pack is available only to registered partners.You cannot legally buy the US $299 deal and use it in Australia. The Action pack is intended to allow the Microsoft Sales Partners to have fully legit copies of all the latest software, in production environments (but not web sites) running their businesses on the latest stuff, in order to be fully conversant with it when they come to talk to potential customers.It was a clever way to make it more worthwhile for partners to get the software legitimately than the common practice prevailing before the action pack was released - namely buy a copy for inventory or for customer use and make dodgy copies before delivering to customers. It's a splendid idea I think, because suddenly, all those dealers, resellers, recommenders had not only legal copies of the products they normally sell, but the other things they wouldn't normally sell too.Enough to run a small business on. (Larger businesses could afford to buy their own copies of software, Microsoft reasons). I think this is a logic that could prove profitable for Macromedia too.I develop web sites but every time a new version of software comes out, I have to pay to buy full copies of everything(Unless I happen to fluke a freebie at a CFUG meeting!!).If MM want us all to be selling and recommending their products,what better way than to make sure we're all using the latest versions of everything? They wouldn't have to do it for free, or even near-free, as Microsoft has proved.But the MS Action Pack gives the equivalent of the entire business product line for A$500 a year. How many of us were reluctant to update to MX2004 products because of the expense, and the fact that we'd only recently bought MX?How are we all supposed to talk confidently about MX2004 if we're only using MX ourselves? My suggestion?Macromedia start having NFR software available to legit dealers/resellers.At the moment (as I understand it) it's only available to partners, who have to pay some thousands of bucks to be partners.Makes it right out of the ballpark of us small shops. I'm only a one-man business. I can't afford to pay thousands of dollars for anything, no matter how desirable. Specially not if it's going to be out of date in a year, as all software will. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 12:27 AM To: CF-Talk Subject: Re: Attempts at banking fraud Actually, the Microsoft Action Pack Subscription is legit.For $299 you get a whole boatload of software, along with 10 licenses (or 10 CAL's for server products).The catch is that it's only licensed for 12 months.In all, it's a good deal, sometimes made even better...I got mine for $99 after a $200 coupon. Pete - Original Message - From: Peter Tilbrook To: CF-Talk Sent: Friday, November 07, 2003 6:39 PM Subject: OT: Attempts at banking fraud It staggers me that there are people in the world who will attempt to rob others by cleverly imitating a bank/credit unions email to attempt to gain access to someones funds. They usually attempt this with cleverly crafted HTML email messages. Microsoft has also fallen victim to this atttempt at validity by the look of a message alone. I've received a few of these lately. Keep in mind it is highly unlikely that your own bank would ever send you something via email that would ever ask you for personal information (they would more than likely have it already). In fact your bank would not even really need to know your email address at all. Whenever I receive these bogus messages, and I have received several, I forward them to the Australia Federal Police in their entirety. You should do the same to your respective law enforcers (eg: FBI). PS. I'm not even sure if it was a valid email but Microsoft are offering $25,000 worth of software for $299 through their Partner program. It looks legitimate - clever - but probably not the real deal. Peter Tilbrook ColdFusion Applications Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
clustercats problem
oi CF-Talk,!! We are trying to cluster two servers using CFMX Enterprise and ClusterCats with WIN2K and IIS 5.We are following the directions outlined in the Using ClusterCats PDF from the Macromedia website.The problem we are having is with setting up the Dynamic IP addressing so the servers will failover in case one goes down.Below are the steps we have taken: 1) Each server was assigned a unique IP for the website and one for the maintenance address. 2) These IP's were added to the DNS Forward and Reverse lookup tables, and were confirmed using NSLOOKUP. 3) With all IP's bound to the NICs, ClusterCats was installed on each server. 4) A cluster was created using the Wizard, and no maintenance address was specified per the instructions.So far, so good. 5) The website address was removed from each NIC, and each website in IIS was checked to make sure the website IP was still bound to the website. 6) Each machine was rebooted. After rebooting the servers, ClusterCats Explorer shows that the second server (dev2) is unavailable even though the website and all required services are running.The IP for dev1, which shows as available in Explorer, is being properly assigned as that server can be browsed. We have tried several variants of the steps taken above, and each time we find that the second server comes up not available. If we run ClusterCats Explorer/Cluster Wizard from dev2, the same thing happens but in reverse (dev2 is available after reboot, but dev1 comes up as unavailable.) Any ideas would be greatly appreciated! /crit -- --- [This E-mail scanned for viruses by Declude Virus] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Can CF capture output to STDERR?
I am using CFEXECUTE on a PKZIPC application and I need to be able to capture the output of PKZIPC to STDERR. I can successfully capture STDOUT but this does not help if the UNZIP fails for some reason. PKZIPC sends error messages to STDERR explaining the reason for the failure and also returns and error code - all of which are important. Is there a way to capture STDERR within CF or am I just limited to STDOUT? Thanks in advance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Can CF capture output to STDERR?
I found this article: http://www.macromedia.com/support/coldfusion/ts/documents/config_default_err_out.htm As far as I can see, I have two options.One choice is the use the about solution to output the STDERR to file and then read the file.The second choice is the redirect STDERR to STDOUT and then it would be available the variable withinCFEXECUTE. To me, option number 2 looks from promising. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Attempts at banking fraud
The US Action pack also requires you to be a partner, as I am.It is free. All that required was an exchange of email with the MS regional manager, and a telephone call. The main difference between the MS program and the MM reseller programs is that MM requires a substantial up front payment to become a reseller. I have been able to fully utilize the promotional materials and presentations accompanying the action pack from MS to assist in training customers, and it has really enhanced my sales of MS server products.You will receive enough CD-ROM based presentations to satisfy most any presentation need. Another benefit is being able to offer MS software through License Online, where your customer can purchase MS products, (as well as several other products) at attractive discounts, all very legitimate.You are also given access to their mass mail (spam?) marketing list to promote your own services as well as the availability of MS products through you. To me the most exciting new product from MS is actually two products, the first being a fully licensed copy of the new CRM product, which is awesome in itself, but even more exciting is the conferencing software included in the new Office product, that puts MM's Flashcom to shame. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 10, 2003 8:00 AM Subject: RE: Attempts at banking fraud | In Australia the Microsoft Action Pack is available only to registered | partners.You cannot legally buy the US $299 deal and use it in Australia. | The Action pack is intended to allow the Microsoft Sales Partners to have | fully legit copies of all the latest software, in production environments | (but not web sites) running their businesses on the latest stuff, in order | to be fully conversant with it when they come to talk to potential | customers.It was a clever way to make it more worthwhile for partners to | get the software legitimately than the common practice prevailing before the | action pack was released - namely buy a copy for inventory or for customer | use and make dodgy copies before delivering to customers. | | | | It's a splendid idea I think, because suddenly, all those dealers, | resellers, recommenders had not only legal copies of the products they | normally sell, but the other things they wouldn't normally sell too.Enough | to run a small business on. (Larger businesses could afford to buy their own | copies of software, Microsoft reasons). | | | | I think this is a logic that could prove profitable for Macromedia too.I | develop web sites but every time a new version of software comes out, I have | to pay to buy full copies of everything(Unless I happen to fluke a freebie | at a CFUG meeting!!).If MM want us all to be selling and recommending | their products,what better way than to make sure we're all using the | latest versions of everything? They wouldn't have to do it for free, or | even near-free, as Microsoft has proved.But the MS Action Pack gives the | equivalent of the entire business product line for A$500 a year. | | | | How many of us were reluctant to update to MX2004 products because of the | expense, and the fact that we'd only recently bought MX?How are we all | supposed to talk confidently about MX2004 if we're only using MX ourselves? | | | | | My suggestion?Macromedia start having NFR software available to legit | dealers/resellers.At the moment (as I understand it) it's only available | to partners, who have to pay some thousands of bucks to be partners.Makes | it right out of the ballpark of us small shops. I'm only a one-man business. | I can't afford to pay thousands of dollars for anything, no matter how | desirable. Specially not if it's going to be out of date in a year, as | all software will. | | | | | | | | Cheers, | | Michael Kear | | Windsor, NSW, Australia | | AFP Webworks. | | | | | | | | | | | | | | -Original Message- | From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] | Sent: Tuesday, 11 November 2003 12:27 AM | To: CF-Talk | Subject: Re: Attempts at banking fraud | | | | Actually, the Microsoft Action Pack Subscription is legit.For $299 you get | a whole boatload of software, along with 10 licenses (or 10 CAL's for server | products).The catch is that it's only licensed for 12 months.In all, | it's a good deal, sometimes made even better...I got mine for $99 after a | $200 coupon. | | Pete |- Original Message - |From: Peter Tilbrook |To: CF-Talk |Sent: Friday, November 07, 2003 6:39 PM |Subject: OT: Attempts at banking fraud | |It staggers me that there are
RE: OT -- Attempts at banking fraud
To me the most exciting new product from MS is actually two products, the first being a fully licensed copy of the new CRM product, which is awesome in itself, but even more exciting is the conferencing software included in the new Office product, that puts MM's Flashcom to shame. this conf product is just Placewhere rebranded...and a few extra bells + whistles I suppose.Placewhere had Java applets, were these replced in the new M$ version? Doug -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 9:50 AM To: CF-Talk Subject: Re: Attempts at banking fraud The US Action pack also requires you to be a partner, as I am.It is free. All that required was an exchange of email with the MS regional manager, and a telephone call. The main difference between the MS program and the MM reseller programs is that MM requires a substantial up front payment to become a reseller. I have been able to fully utilize the promotional materials and presentations accompanying the action pack from MS to assist in training customers, and it has really enhanced my sales of MS server products.You will receive enough CD-ROM based presentations to satisfy most any presentation need. Another benefit is being able to offer MS software through License Online, where your customer can purchase MS products, (as well as several other products) at attractive discounts, all very legitimate.You are also given access to their mass mail (spam?) marketing list to promote your own services as well as the availability of MS products through you. To me the most exciting new product from MS is actually two products, the first being a fully licensed copy of the new CRM product, which is awesome in itself, but even more exciting is the conferencing software included in the new Office product, that puts MM's Flashcom to shame. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 10, 2003 8:00 AM Subject: RE: Attempts at banking fraud | In Australia the Microsoft Action Pack is available only to registered | partners.You cannot legally buy the US $299 deal and use it in Australia. | The Action pack is intended to allow the Microsoft Sales Partners to have | fully legit copies of all the latest software, in production environments | (but not web sites) running their businesses on the latest stuff, in order | to be fully conversant with it when they come to talk to potential | customers.It was a clever way to make it more worthwhile for partners to | get the software legitimately than the common practice prevailing before the | action pack was released - namely buy a copy for inventory or for customer | use and make dodgy copies before delivering to customers. | | | | It's a splendid idea I think, because suddenly, all those dealers, | resellers, recommenders had not only legal copies of the products they | normally sell, but the other things they wouldn't normally sell too.Enough | to run a small business on. (Larger businesses could afford to buy their own | copies of software, Microsoft reasons). | | | | I think this is a logic that could prove profitable for Macromedia too.I | develop web sites but every time a new version of software comes out, I have | to pay to buy full copies of everything(Unless I happen to fluke a freebie | at a CFUG meeting!!).If MM want us all to be selling and recommending | their products,what better way than to make sure we're all using the | latest versions of everything? They wouldn't have to do it for free, or | even near-free, as Microsoft has proved.But the MS Action Pack gives the | equivalent of the entire business product line for A$500 a year. | | | | How many of us were reluctant to update to MX2004 products because of the | expense, and the fact that we'd only recently bought MX?How are we all | supposed to talk confidently about MX2004 if we're only using MX ourselves? | | | | | My suggestion?Macromedia start having NFR software available to legit | dealers/resellers.At the moment (as I understand it) it's only available | to partners, who have to pay some thousands of bucks to be partners.Makes | it right out of the ballpark of us small shops. I'm only a one-man business. | I can't afford to pay thousands of dollars for anything, no matter how | desirable. Specially not if it's going to be out of date in a year, as | all software will. | | | | | | | | Cheers, | | Michael Kear | | Windsor, NSW, Australia | | AFP Webworks. | | | | | | | | | | | | | | -Original Message- | From: Pete Ruckelshaus [mailto:[EMAIL
RE: SOT: HSphere Control Panel CF DSN Creation
They can easily create them with the CF Administrator panel but obviously that's not something they'll open up to the public. Are you saying that your host refuses to create a DSN for you manually, merely because their choice of control panels doesn't support the function natively?Egads. No, they will gladly create a DSN for you, as a matter of fact they'll create as many of them as you need for Access, Excel, etc.It's just that their current choice of control panels (HSphere) does not support creating CF DSN's.They are pondering switching to Helm for their control panel which would eventually offer CF DSN support. Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: HSphere Control Panel CF DSN Creation
Thanks for the tutorial Jochem!I've been looking for something like that to offer to the hosting service as something that they could try and add to the control panel. We'll see how it goes! Regards! Hatton -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 09, 2003 7:44 AM To: CF-Talk Subject: Re: SOT: HSphere Control Panel CF DSN Creation C. Hatton Humphrey wrote: Okay, this is more for a hosting provider I'm dealing with than me, but I thought I'd go ahead and fire the question out - has anyone had experience with the HSphere Control Panel in working with ColdFusion and creating CF DSN's for accounts? The panel has an ODBC DSN tool which they say doesn't create the right kind of DSN for CF to use.Not sure if that sounds right to me or not. ODBC DSN's are a pain in CF MX. While CF 5 and earlier could use ODBC DSN's defined in the OS directly, for CF MX they need to be defined in the OS, in the ODBC Server and in CF MX. So the story does sound right to me. Best thing would be not to use ODBC but to use pure Java datasources (JDBC Type 3 or 4). Setting them up is very easy to automate in CF MX, all you need to do is add a key to the datasources structure in the datasourceservice: http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12 Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: crystal report
The current version is 9. You can check for downloads at www.crystaldecisions.com http://www.crystaldecisions.com -Original Message- From: ilknur bodur [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 8:50 AM To: CF-Talk Subject: crystal report hi, could you giveme any link for downloading crystal report 6.0 ? see you... - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Scheduled email
Hell, I was asked by a VP if the registration form I created would be able to send a bounce back email three days after a user logged in twice. The form tracks how many times someone uses their email address to access a trail database we have. What is some of the code I need to be able to check when the login = 2 and then schedule an email three days afterwards to check on how they like the database they are using? Do I need to get into the CF Scheduler via the admin? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfoutput?
The only way i can think to do this would be to write the files and then call them or include them. Tyler Clendenin GSL Solutions _ From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 5:07 PM To: CF-Talk Subject: cfoutput? Ok here is another one for ya... I have a bunch of html documents stored in my database and in these documents I need to run some ColdFusion code before it's displayed. But since I'm outputting the html using ColdFusion it will not work. Is there some other way of running my cf code before or after I call it or something? Hopes this makes sense... Thanks, - Neal _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Security concerns regarding GetPageContext()
Folks, sorry if this has been discussed here before but I have two simple questions: 1) What are the security implications of the GetPageContext() function in a shared environment since it's impossible to disable it via CFAdm? Can I manipulate/see or change CFServer info using the function? 2) CF ServiceFactory and access to other CFMX sensitive info/data/config can't really be disabled? I'll offer CF shared hosting for non-for-profit organizations here in Brazil (thanks to MM philanthropy program!) and I think is better to disable CFOBJECT and CreateObject(), even using sandboxes in the servers. Yes, people are very nice, but I'm not sure about their programmers...I know that server, application and other shared scopes are open for everyone but the ServiceFactory represents a very easy way to determine who is on the server, what applications it has and even sessions are running! Does MM provide a TechNote or even some info regarding it? I know they have blocked the access to some objects (eg. SecurityService) but it's a wierd-error blocking and non documented. I've googled a lot of things related but nothing conclusive nor explicative, specially focused on shared hosting. Jochen has some nice info on his site but I'm looking for a way to avoid the use of ServiceFactory instead of using it. PS: multiple instances is not an option. Many thanks!! Alex Alex Hbner - Tecnologia da Informao Amigos da Terra - Amaznia Brasileira http://www.amazonia.org.br +5511 38879369 voz +5511 38842795 fax [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Using complex data with web services
Yes, an article would be a good idea... for all the talk that Macromedia has done to say that CFMX integrates well with .NET via web services, they sure don't bother to giving any good example of how to accomplish this (or I haven't found any yet). Anyways, I believe you've got me going the right direction now, however I'm still not having any luck.I've tried a ton of different variations and am having no success.Do I need to create an oRequest CFC which oCredentials (also a CFC? or a struct?) is part of? Here's the request format that I was given: soap:Body UserIDGet oRequest sCompanyNamestring/sCompanyName sLoginstring/sLogin /oRequest /UserIDGet /soap:Body Thanks, -Nelson - Original Message - From: Matt Liotta To: CF-Talk Sent: Friday, November 07, 2003 6:37 PM Subject: Re: Using complex data with web services Unfortunately, I don't think I made myself clear.I'm trying to invoke a webservice that is set up this way. Actually, I think I was one that wasn't clear. I really need to write an article on this since I seem to be answering this question all the time. Anyway, create a CFC as I described in the my last email. Then do the following: cfscript credentials = CreateObject(component, yournewcfchere); credentials.sCompanyName = ABC; credentials.sUserName = jdoe; credentials.sPassword = abc123; /cfscript cfinvoke webservice=urltowsdlhere method=UserIDGet oCredentials=#credentials# sCompanyName=ABC sLogin=jsmith returnvariable=test Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Does CF Studio 4.52 get along with XP Pro or XP Home?
Dear CF'ers I have been running CF Studio 4.52 for several years on a Win 98 SE machine, using the Personal Web Server. I only develop sites, I do not host. I now need to replace my computer and my question is what problems should I expect with using CF Studio 4.52 with XP Pro or XP Home? I DO NOT want to change from CF Studio 4.52 to a newer upgrade. Thank You Very Much! Tom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Attempts at banking fraud
You can try finding out who owns the domain (if it is a domain).If so, forward the email and contact info to the police department where you the person lives and let them look into it.They'll pass it to the feds if appropriate. I just went through this last week.I was called the next day by the detective asking me for a little bit of personal info and was told he had already spoken over the phone with the guy was bringing him in for questioning. I realize most people that do this sort of thing aren't dumb to do it using a domain registered in their own name, but in this case, it appears the guy was. - Original Message - From: Jim Davis To: CF-Talk Sent: Monday, November 10, 2003 7:31 AM Subject: RE: Attempts at banking fraud The one I just got took the cake: subject was You have won a Sony Handicam (This is not Spam). The message purported to being part of the grand opening of a new online AV store - it provided a code to claim your prize.After stripping the URL ID from the link I went to the site: yes, it said, I won.All I had to do was fill out my information. Standard stuff: address, phone number, etc UNTIL.The bottom of the form had a red apology: We're sorry, but our credit merchant is current experiencing difficulties so we cannot accept credit cards at the moment.To claim your prize please enter your debit card information instead. The form actually had a Debit Card Number AND PIN Number entry boxes. What worries me is that the form looked very professional (up until that point) - I'm sure that at least some people have been taken in. Although, in your case, it may be seeded from the truth.Microsoft does offer a very attractive Partner Provider deal (I'm a subscriber).You join up as a Registered Partner for $299 (I got in on a special $100 deal) and they send you quarterly software packages: pretty much all of their software (not for resale but otherwise full editions) and sales/migration material. The software package is called the Action Pack.Here's a link to it: http://members.microsoft.com/partner/salesmarketing/partnermarket/action pack/default.aspx?nav=ln It's a truly great deal, but I would only subscribe via the official Microsoft.com website.You actually get full copies of all current OSes (Windows 2003 all editions, Windows 2000 Advanced Server, XP Pro and Home, etc), Exchange server, Visio, MS Office, SQL Server, MS Project, and tons more. I do know of at least one scam where people gather many of these packs and then sell the software for huge profits on eBay. Jim Davis -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 6:39 PM To: CF-Talk Subject: OT: Attempts at banking fraud It staggers me that there are people in the world who will attempt to rob others by cleverly imitating a bank/credit unions email to attempt to gain access to someones funds. They usually attempt this with cleverly crafted HTML email messages. Microsoft has also fallen victim to this atttempt at validity by the look of a message alone. I've received a few of these lately. Keep in mind it is highly unlikely that your own bank would ever send you something via email that would ever ask you for personal information (they would more than likely have it already). In fact your bank would not even really need to know your email address at all. Whenever I receive these bogus messages, and I have received several, I forward them to the Australia Federal Police in their entirety. You should do the same to your respective law enforcers (eg: FBI). PS. I'm not even sure if it was a valid email but Microsoft are offering $25,000 worth of software for $299 through their Partner program. It looks legitimate - clever - but probably not the real deal. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Does CF Studio 4.52 get along with XP Pro or XP Home?
How come you don't want to upgrade? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Tom Forbes [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:28 PM To: CF-Talk Subject: Does CF Studio 4.52 get along with XP Pro or XP Home? Dear CF'ers I have been running CF Studio 4.52 for several years on a Win 98 SE machine, using the Personal Web Server. I only develop sites, I do not host. I now need to replace my computer and my question is what problems should I expect with using CF Studio 4.52 with XP Pro or XP Home? I DO NOT want to change from CF Studio 4.52 to a newer upgrade. Thank You Very Much! Tom _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Does CF Studio 4.52 get along with XP Pro or XP Home?
Studio will run fine on XP, XP Pro, and Win2k.In our area most hard core CF'ers are still using studio as opposed to upgrading (migrating?) to Dreamweaver/Homesite+ == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Tom Forbes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:28 PM Subject: Does CF Studio 4.52 get along with XP Pro or XP Home? | Dear CF'ers | | I have been running CF Studio 4.52 for several years on a Win 98 SE | machine, using the Personal Web Server. I only develop sites, I do not host. | | I now need to replace my computer and my question is what problems should I | expect with using CF Studio 4.52 with XP Pro or XP Home? I DO NOT want to | change from CF Studio 4.52 to a newer upgrade. | | Thank You Very Much! | | Tom | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF+MySQL+Apache french characters not properly displayed.
Hello, I've been racking my brain over this for a little bit... I'm running CFMX 6.1, Apache 2.0.48 and MySQL 3.23.58. I'm a bit confused at this behavior... I converted an access db to mysql using a conversion tool. I log in to webmin, look at the data in my tables, everything looks fine. Characters such as ,,.. all display as they should. When I view a page with this same data through my webserver (apache), all the french characters are messed up. Any ideas?? Thanks, Yves [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Does CF Studio 4.52 get along with XP Pro or XP Home?
I use CF Studio 4.52 on WindowsXP and it works fine.I am with you on not wanting to go to Dreamwearver.I have tried to make the switch several times but it didn't take.One reason is that I use ctrl+delete a lot, and Dreamweaver acts different (by deleting the last character of the previous word, instead of stopping before deleting it.I have also customized snippets and short cuts just the way I like'em and don't see an impelling reason to do it again. -sutton _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:49 PM To: CF-Talk Subject: RE: Does CF Studio 4.52 get along with XP Pro or XP Home? How come you don't want to upgrade? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Tom Forbes [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:28 PM To: CF-Talk Subject: Does CF Studio 4.52 get along with XP Pro or XP Home? Dear CF'ers I have been running CF Studio 4.52 for several years on a Win 98 SE machine, using the Personal Web Server. I only develop sites, I do not host. I now need to replace my computer and my question is what problems should I expect with using CF Studio 4.52 with XP Pro or XP Home? I DO NOT want to change from CF Studio 4.52 to a newer upgrade. Thank You Very Much! Tom _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Previous Row in a table
Hi, I'm running a query with a specific row ID.From there, I'm trying to extract a previous row's information where the row meets a bit value of 1.Example, (SQL logic written out, pseudo) queryname=pull_info Query all entries from xyz table where xyz_id = value passed from form Once this row has been identified, I now need to get the xyz_id of the row before it that meets a certain criteria. (SQL logic written out, pseudo) Here's where I'm stuck query all entries from xyz table ??? look before pull_info.xyz_id AND where xyz_sent = 1 Does this make sense? Thanks, D [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Previous Row in a table
cfset xyz_id = someValue/ where xyz_id variables.xyz_id and otherCriteria isnt this what you trying to do? Joe Eugene - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk Sent: Monday, November 10, 2003 1:14 PM Subject: Previous Row in a table Hi, I'm running a query with a specific row ID.From there, I'm trying to extract a previous row's information where the row meets a bit value of 1.Example, (SQL logic written out, pseudo) queryname=pull_info Query all entries from xyz table where xyz_id = value passed from form Once this row has been identified, I now need to get the xyz_id of the row before it that meets a certain criteria. (SQL logic written out, pseudo) Here's where I'm stuck query all entries from xyz table ??? look before pull_info.xyz_id AND where xyz_sent = 1 Does this make sense? Thanks, D [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Previous Row in a table
How about select top 1 * from xyz where xyzID '#form.xyz_id#' Or does the xyz_id from the form represent something else? --Ben Doom [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, I'm running a query with a specific row ID.From there, I'm trying to extract a previous row's information where the row meets a bit value of 1.Example, (SQL logic written out, pseudo) queryname=pull_info Query all entries from xyz table where xyz_id = value passed from form Once this row has been identified, I now need to get the xyz_id of the row before it that meets a certain criteria. (SQL logic written out, pseudo) Here's where I'm stuck query all entries from xyz table ??? look before pull_info.xyz_id AND where xyz_sent = 1 Does this make sense? Thanks, D [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Previous Row in a table
cfset prevrowid = pullinfo[1].xyz_id cfloop query=pullinfo cfif condition=meets some sort of criteria cfquery name=newquery Select * from xyz table where xyz_id = prevrowid and xyz_sent = 1 /cfquery /cfif cfset prevrowid = xyz_id /cfloop _ From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:14 PM To: CF-Talk Subject: Previous Row in a table Hi, I'm running a query with a specific row ID.From there, I'm trying to extract a previous row's information where the row meets a bit value of 1.Example, (SQL logic written out, pseudo) queryname=pull_info Query all entries from xyz table where xyz_id = value passed from form Once this row has been identified, I now need to get the xyz_id of the row before it that meets a certain criteria. (SQL logic written out, pseudo) Here's where I'm stuck query all entries from xyz table ??? look before pull_info.xyz_id AND where xyz_sent = 1 Does this make sense? Thanks, D _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Previous Row in a table
Does this work for ya? SELECT MAX(ID) FROM XYZ WHERE (ID #PullInfo.XYZ_ID#) AND (XYZ_SENT = 1) Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, I'm running a query with a specific row ID.From there, I'm trying to extract a previous row's information where the row meets a bit value of 1.Example, (SQL logic written out, pseudo) queryname=pull_info Query all entries from xyz table where xyz_id = value passed from form Once this row has been identified, I now need to get the xyz_id of the row before it that meets a certain criteria. (SQL logic written out, pseudo) Here's where I'm stuck query all entries from xyz table ??? look before pull_info.xyz_id AND where xyz_sent = 1 Does this make sense? Thanks, D [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Attempts at banking fraud
The only question I have is how to resell under the Action Pack subscription. I am about to close a deal that would involve 3 Windows 2003 servers, SQL Server, and 40 copies of XP. Going through the materials, I still do not know who to call. M -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 9:50 AM To: CF-Talk Subject: Re: Attempts at banking fraud The US Action pack also requires you to be a partner, as I am.It is free. All that required was an exchange of email with the MS regional manager, and a telephone call. The main difference between the MS program and the MM reseller programs is that MM requires a substantial up front payment to become a reseller. I have been able to fully utilize the promotional materials and presentations accompanying the action pack from MS to assist in training customers, and it has really enhanced my sales of MS server products.You will receive enough CD-ROM based presentations to satisfy most any presentation need. Another benefit is being able to offer MS software through License Online, where your customer can purchase MS products, (as well as several other products) at attractive discounts, all very legitimate.You are also given access to their mass mail (spam?) marketing list to promote your own services as well as the availability of MS products through you. To me the most exciting new product from MS is actually two products, the first being a fully licensed copy of the new CRM product, which is awesome in itself, but even more exciting is the conferencing software included in the new Office product, that puts MM's Flashcom to shame. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 10, 2003 8:00 AM Subject: RE: Attempts at banking fraud | In Australia the Microsoft Action Pack is available only to registered | partners.You cannot legally buy the US $299 deal and use it in Australia. | The Action pack is intended to allow the Microsoft Sales Partners to have | fully legit copies of all the latest software, in production environments | (but not web sites) running their businesses on the latest stuff, in order | to be fully conversant with it when they come to talk to potential | customers.It was a clever way to make it more worthwhile for partners to | get the software legitimately than the common practice prevailing before the | action pack was released - namely buy a copy for inventory or for customer | use and make dodgy copies before delivering to customers. | | | | It's a splendid idea I think, because suddenly, all those dealers, | resellers, recommenders had not only legal copies of the products they | normally sell, but the other things they wouldn't normally sell too. Enough | to run a small business on. (Larger businesses could afford to buy their own | copies of software, Microsoft reasons). | | | | I think this is a logic that could prove profitable for Macromedia too.I | develop web sites but every time a new version of software comes out, I have | to pay to buy full copies of everything(Unless I happen to fluke a freebie | at a CFUG meeting!!).If MM want us all to be selling and recommending | their products,what better way than to make sure we're all using the | latest versions of everything? They wouldn't have to do it for free, or | even near-free, as Microsoft has proved.But the MS Action Pack gives the | equivalent of the entire business product line for A$500 a year. | | | | How many of us were reluctant to update to MX2004 products because of the | expense, and the fact that we'd only recently bought MX?How are we all | supposed to talk confidently about MX2004 if we're only using MX ourselves? | | | | | My suggestion?Macromedia start having NFR software available to legit | dealers/resellers.At the moment (as I understand it) it's only available | to partners, who have to pay some thousands of bucks to be partners. Makes | it right out of the ballpark of us small shops. I'm only a one-man business. | I can't afford to pay thousands of dollars for anything, no matter how | desirable. Specially not if it's going to be out of date in a year, as | all software will. | | | | | | | | Cheers, | | Michael Kear | | Windsor, NSW, Australia | | AFP Webworks. | | | | | | | | | | | | | | -Original Message- | From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] | Sent: Tuesday, 11 November 2003 12:27 AM | To: CF-Talk | Subject: Re: Attempts at banking fraud | | | | Actually, the Microsoft Action Pack Subscription is legit.For $299 you get | a whole boatload
queryNew question...
How does one query against a query that was created with the queryNew function. I can sucessfully build a query...I just can't filter against it. Any ideas? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: queryNew question...
Che: You can use Query of Query to filter the dynamically built query. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:04 PM To: CF-Talk Subject: queryNew question... How does one query against a query that was created with the queryNew function. I can sucessfully build a query...I just can't filter against it. Any ideas? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: queryNew question...
got any code samples...or psuedo code...i'm drawing a blank! -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:07 PM To: CF-Talk Subject: RE: queryNew question... Che: You can use Query of Query to filter the dynamically built query. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:04 PM To: CF-Talk Subject: queryNew question... How does one query against a query that was created with the queryNew function. I can sucessfully build a query...I just can't filter against it. Any ideas? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: queryNew question...
never mind...i've got it! -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:07 PM To: CF-Talk Subject: RE: queryNew question... Che: You can use Query of Query to filter the dynamically built query. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:04 PM To: CF-Talk Subject: queryNew question... How does one query against a query that was created with the queryNew function. I can sucessfully build a query...I just can't filter against it. Any ideas? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Attempts at banking fraud
You can't. As far as I know ActionPack is licensed for internal use only. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 2:43 PM To: CF-Talk Subject: RE: Attempts at banking fraud The only question I have is how to resell under the Action Pack subscription. I am about to close a deal that would involve 3 Windows 2003 servers, SQL Server, and 40 copies of XP. Going through the materials, I still do not know who to call. M -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 9:50 AM To: CF-Talk Subject: Re: Attempts at banking fraud The US Action pack also requires you to be a partner, as I am.It is free. All that required was an exchange of email with the MS regional manager, and a telephone call. The main difference between the MS program and the MM reseller programs is that MM requires a substantial up front payment to become a reseller. I have been able to fully utilize the promotional materials and presentations accompanying the action pack from MS to assist in training customers, and it has really enhanced my sales of MS server products.You will receive enough CD-ROM based presentations to satisfy most any presentation need. Another benefit is being able to offer MS software through License Online, where your customer can purchase MS products, (as well as several other products) at attractive discounts, all very legitimate.You are also given access to their mass mail (spam?) marketing list to promote your own services as well as the availability of MS products through you. To me the most exciting new product from MS is actually two products, the first being a fully licensed copy of the new CRM product, which is awesome in itself, but even more exciting is the conferencing software included in the new Office product, that puts MM's Flashcom to shame. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 10, 2003 8:00 AM Subject: RE: Attempts at banking fraud | In Australia the Microsoft Action Pack is available only to registered | partners.You cannot legally buy the US $299 deal and use it in Australia. | The Action pack is intended to allow the Microsoft Sales Partners to have | fully legit copies of all the latest software, in production environments | (but not web sites) running their businesses on the latest stuff, in order | to be fully conversant with it when they come to talk to potential | customers.It was a clever way to make it more worthwhile for partners to | get the software legitimately than the common practice prevailing before the | action pack was released - namely buy a copy for inventory or for customer | use and make dodgy copies before delivering to customers. | | | | It's a splendid idea I think, because suddenly, all those dealers, | resellers, recommenders had not only legal copies of the products they | normally sell, but the other things they wouldn't normally sell too. Enough | to run a small business on. (Larger businesses could afford to buy their own | copies of software, Microsoft reasons). | | | | I think this is a logic that could prove profitable for Macromedia too.I | develop web sites but every time a new version of software comes out, I have | to pay to buy full copies of everything(Unless I happen to fluke a freebie | at a CFUG meeting!!).If MM want us all to be selling and recommending | their products,what better way than to make sure we're all using the | latest versions of everything? They wouldn't have to do it for free, or | even near-free, as Microsoft has proved.But the MS Action Pack gives the | equivalent of the entire business product line for A$500 a year. | | | | How many of us were reluctant to update to MX2004 products because of the | expense, and the fact that we'd only recently bought MX?How are we all | supposed to talk confidently about MX2004 if we're only using MX ourselves? | | | | | My suggestion?Macromedia start having NFR software available to legit | dealers/resellers.At the moment (as I understand it) it's only available | to partners, who have to pay some thousands of bucks to be partners. Makes | it right out of the ballpark of us small shops. I'm only a one-man business. | I can't afford to pay thousands of dollars for anything, no matter how | desirable. Specially not if it's going to be out of date in a year, as | all software will. | | | | | | | | Cheers, | |
RE: How to count sessions
How can you get the info from the session var? I get a number as well as a time stamp like the following when I use that code to loop through the list. I set the session id for their user based on their userid. It is the user id I want to use to query to get the user information. So When I output this I can say 3 users are logged in and the users are. .
Total Active Sessions : 3
90873 - {ts '2003-11-10 14:01:38'}
90874 - {ts '2003-11-10 14:06:05'}
90872 - {ts '2003-11-10 13:59:33'}
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 4:40 PM
To: CF-Talk
Subject: RE: How to count sessions
Eric,
Assuming that Application.UsersInfo is a structure...
cfoutput
cfloop list=#structKeyList(Application.UsersInfo, ',')# index=myLoop
#myLoop# - #Application.UsersInfo[myLoop]#br /
/cfloop
/cfoutput
Steve
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 5:25 PM
To: CF-Talk
Subject: RE: How to count sessions
How can I convert #StructCount(Application.UsersInfo)# into something that
will make the Application.UsersInfo a simple value that I can then use for
querying?
-Original Message-
From: Eric Creese
Sent: Friday, November 07, 2003 4:13 PM
To: CF-Talk
Subject: RE: How to count sessions
ok I did the tutorial and got what I wanted. Now here is a tough one. can I
use the the session vars to to query my users table to display the users
names?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 3:55 PM
To: CF-Talk
Subject: RE: How to count sessions
http://tutorial12.easycfm.com/ http://tutorial12.easycfm.com/
copy paste is your friend ;)
put it in the Application.cfm page
where should I put this code?
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 3:18 PM
To: CF-Talk
Subject: RE: How to count sessions
wonderful... nice trick - very helpful.
-Mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 2:58 PM
To: CF-Talk
Subject: RE: How to count sessions
actually there is...one way in CFMX is this quick stuff
cfapplication name=sessionLister sessionManagement=yes
cfset tracker = createObject(java,
coldfusion.runtime.SessionTracker) cfset sessions =
tracker.getSessionCollection(myappname)
cfdump var=#sessions#
Ray Camden has some other code for this...a flash app even...out on
his blog under
http://www.camdenfamily.com/morpheus/blog/
http://www.camdenfamily.com/morpheus/blog/
Doug
-Original Message-
From: brob [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 3:56 PM
To: CF-Talk
Subject: Re: How to count sessions
I dont think there's a server variable that counts the number of
unique sessions available.You can find out this way
thoughFirst yo have an application variable like
application.counter, and then everytime a member logs in you increment
that counter by 1.
Be sure to check for things like if they are already logged in and are
just signing in again, to not increment the
counter.You can also avoid this problem by writing code on the login
page to forward them to their member page if their logging session
variable is TRUE.That way they dont have to put in their
username/password twice
- Original Message -
From: Eric Creese
To: CF-Talk
Sent: Friday, November 07, 2003 2:22 PM
Subject: How to count sessions
How can you count the number of active session are opened. For
instance I have a membership site and I want to get a
count of members who have logged in and have an open session.
E
_
_
_
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: queryNew question...
Or to just resort any query... -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 2:07 PM To: CF-Talk Subject: RE: queryNew question... Che: You can use Query of Query to filter the dynamically built query. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:04 PM To: CF-Talk Subject: queryNew question... How does one query against a query that was created with the queryNew function. I can sucessfully build a query...I just can't filter against it. Any ideas? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Attempts at banking fraud
Send them to (or you can do it for them) http://www.licenseonline.com/qq2/LicenseOnlineStorefront/Lobby.asp You will be requested to enter your Partner ID numberIf you don't have one, apply for one == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Haggerty, Mike [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:42 PM Subject: RE: Attempts at banking fraud | The only question I have is how to resell under the Action Pack | subscription. I am about to close a deal that would involve 3 Windows | 2003 servers, SQL Server, and 40 copies of XP. Going through the | materials, I still do not know who to call. | | M | | -Original Message- | From: Doug White [mailto:[EMAIL PROTECTED] | Sent: Monday, November 10, 2003 9:50 AM | To: CF-Talk | Subject: Re: Attempts at banking fraud | | | The US Action pack also requires you to be a partner, as I am.It is | free. All | that required was an exchange of email with the MS regional manager, and | a | telephone call. | | The main difference between the MS program and the MM reseller programs | is that | MM requires a substantial up front payment to become a reseller. | | I have been able to fully utilize the promotional materials and | presentations | accompanying the action pack from MS to assist in training customers, | and it has | really enhanced my sales of MS server products.You will receive enough | CD-ROM | based presentations to satisfy most any presentation need. Another | benefit is | being able to offer MS software through License Online, where your | customer can | purchase MS products, (as well as several other products) at attractive | discounts, all very legitimate.You are also given access to their mass | mail | (spam?) marketing list to promote your own services as well as the | availability | of MS products through you. | To me the most exciting new product from MS is actually two products, | the first | being a fully licensed copy of the new CRM product, which is awesome in | itself, | but even more exciting is the conferencing software included in the new | Office | product, that puts MM's Flashcom to shame. | | == | Stop spam on your domain, use our gateway! | For hosting solutions http://www.clickdoug.com | Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. | Suggested corporate Anti-virus policy: | http://www.dshield.org/antivirus.pdf | == | If you are not satisfied with my service, my job isn't done! | | - Original Message - | From: Mike Kear [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Monday, November 10, 2003 8:00 AM | Subject: RE: Attempts at banking fraud | | | In Australia the Microsoft Action Pack is available only to registered | | partners.You cannot legally buy the US $299 deal and use it in | Australia. | | The Action pack is intended to allow the Microsoft Sales Partners to | have | | fully legit copies of all the latest software, in production | environments | | (but not web sites) running their businesses on the latest stuff, in | order | | to be fully conversant with it when they come to talk to potential | | customers.It was a clever way to make it more worthwhile for | partners to | | get the software legitimately than the common practice prevailing | before the | | action pack was released - namely buy a copy for inventory or for | customer | | use and make dodgy copies before delivering to customers. | | | | | | | | It's a splendid idea I think, because suddenly, all those dealers, | | resellers, recommenders had not only legal copies of the products they | | normally sell, but the other things they wouldn't normally sell too. | Enough | | to run a small business on. (Larger businesses could afford to buy | their own | | copies of software, Microsoft reasons). | | | | | | | | I think this is a logic that could prove profitable for Macromedia | too.I | | develop web sites but every time a new version of software comes out, | I have | | to pay to buy full copies of everything(Unless I happen to fluke a | freebie | | at a CFUG meeting!!).If MM want us all to be selling and | recommending | | their products,what better way than to make sure we're all using the | | latest versions of everything? They wouldn't have to do it for | free, or | | even near-free, as Microsoft has proved.But the MS Action Pack gives | the | | equivalent of the entire business product line for A$500 a year. | | | | | | | | How many of us were reluctant to update to MX2004 products because of | the | | expense, and the fact that we'd only recently
RE: Does CF Studio 4.52 get along with XP Pro or XP Home?
Thanks to all of you that gave me the OK to upgrade to XP with CF 4.52. But... If I am just making web sites with cf, would you recommend XP Pro or XP Home? My income depends on my productivity, and when I have to re-learn a piece of software, that reduces my productivity. In addition, I have long ago decided I want nothing that Dream Weaver has to offer. I don't do Flash stuff, and frankly, I don't have a high opinion of MM's techsupport. In addition, their prices are high, and the software is not reliable or there would be about 50% fewer posts on this board. I'm not looking for an onslaught of opposing views here, I just like to stick to software that I know well through years of use. If I could get a new computer with Win98SE loaded, I would not hesitate! Again, thank you very much for your help! Tom At 01:48 PM 11/10/03 -0500, you wrote: How come you don't want to upgrade? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Tom Forbes [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:28 PM To: CF-Talk Subject: Does CF Studio 4.52 get along with XP Pro or XP Home? Dear CF'ers I have been running CF Studio 4.52 for several years on a Win 98 SE machine, using the Personal Web Server. I only develop sites, I do not host. I now need to replace my computer and my question is what problems should I expect with using CF Studio 4.52 with XP Pro or XP Home? I DO NOT want to change from CF Studio 4.52 to a newer upgrade. Thank You Very Much! Tom _ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Scheduled email
Hey Robert, Why not try it this way...once the user login=2, add a record to a table which records the email address, name, and a timestamp. Then write a scheduled event in cf admin which runs a page (daily) containing SQL that checks the login=2 table for #DateFormat(DateAdd(d, -3, now()), mm/dd/)# and use cfmail (with query attribute) to loop through the results. -Ryan -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 11:10 AM To: CF-Talk Subject: Scheduled email Hell, I was asked by a VP if the registration form I created would be able to send a bounce back email three days after a user logged in twice. The form tracks how many times someone uses their email address to access a trail database we have. What is some of the code I need to be able to check when the login = 2 and then schedule an email three days afterwards to check on how they like the database they are using? Do I need to get into the CF Scheduler via the admin? Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to count sessions
cfapplication name=sessionLister sessionManagement=yes
cfset tracker = createObject(java, coldfusion.runtime.SessionTracker)
cfset sessions = tracker.getSessionCollection(appname)
cfloop collection=#sessions# item=key
cfoutput#sessions[#key#].emplid#/cfoutput
/cfloop
each session is stored in the sessions structlooking at the above code.
so loop through this struct and hit the data in each session.Assuming that you set session.emplid for each users session, the above should list the emplids for the current sessions for appname.You can get to whatever other data this way too.
HTH
Doug
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:18 PM
To: CF-Talk
Subject: RE: How to count sessions
How can you get the info from the session var? I get a number as well as a time stamp like the following when I use that code to loop through the list. I set the session id for their user based on their userid. It is the user id I want to use to query to get the user information. So When I output this I can say 3 users are logged in and the users are. .
Total Active Sessions : 3
90873 - {ts '2003-11-10 14:01:38'}
90874 - {ts '2003-11-10 14:06:05'}
90872 - {ts '2003-11-10 13:59:33'}
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 4:40 PM
To: CF-Talk
Subject: RE: How to count sessions
Eric,
Assuming that Application.UsersInfo is a structure...
cfoutput
cfloop list=#structKeyList(Application.UsersInfo, ',')# index=myLoop
#myLoop# - #Application.UsersInfo[myLoop]#br /
/cfloop
/cfoutput
Steve
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 5:25 PM
To: CF-Talk
Subject: RE: How to count sessions
How can I convert #StructCount(Application.UsersInfo)# into something that
will make the Application.UsersInfo a simple value that I can then use for
querying?
-Original Message-
From: Eric Creese
Sent: Friday, November 07, 2003 4:13 PM
To: CF-Talk
Subject: RE: How to count sessions
ok I did the tutorial and got what I wanted. Now here is a tough one. can I
use the the session vars to to query my users table to display the users
names?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 3:55 PM
To: CF-Talk
Subject: RE: How to count sessions
http://tutorial12.easycfm.com/ http://tutorial12.easycfm.com/
copy paste is your friend ;)
put it in the Application.cfm page
where should I put this code?
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 3:18 PM
To: CF-Talk
Subject: RE: How to count sessions
wonderful... nice trick - very helpful.
-Mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 2:58 PM
To: CF-Talk
Subject: RE: How to count sessions
actually there is...one way in CFMX is this quick stuff
cfapplication name=sessionLister sessionManagement=yes
cfset tracker = createObject(java,
coldfusion.runtime.SessionTracker) cfset sessions =
tracker.getSessionCollection(myappname)
cfdump var=#sessions#
Ray Camden has some other code for this...a flash app even...out on
his blog under
http://www.camdenfamily.com/morpheus/blog/
http://www.camdenfamily.com/morpheus/blog/
Doug
-Original Message-
From: brob [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 3:56 PM
To: CF-Talk
Subject: Re: How to count sessions
I dont think there's a server variable that counts the number of
unique sessions available.You can find out this way
thoughFirst yo have an application variable like
application.counter, and then everytime a member logs in you increment
that counter by 1.
Be sure to check for things like if they are already logged in and are
just signing in again, to not increment the
counter.You can also avoid this problem by writing code on the login
page to forward them to their member page if their logging session
variable is TRUE.That way they dont have to put in their
username/password twice
- Original Message -
From: Eric Creese
To: CF-Talk
Sent: Friday, November 07, 2003 2:22 PM
Subject: How to count sessions
How can you count the number of active session are opened. For
instance I have a membership site and I want to get a
count of members who have logged in and have an open session.
E
_
_
_
_
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Deleteing a directory
At 01:50 PM 11/10/2003, you wrote: I am using CFDIRECTORY to delete a directory.then I get an error saying that it can't be delted because the directory is NOT EMPTY.s Generally what you need to do is do a CFDIRECTORY on that dir, loop over the contents and use CFFILE to delete each file as you loop over it, then you can remove the directory. Or perhaps do a command line bit, deleting *.* from that directory, that would be less code and possibly quicker. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF+MySQL+Apache french characters not properly displayed.
Finally, It had to do with MySQL's encoding, 3.23.58 not being compatible with UTF-8 from what I found. So I'm forcing CFMX to use iso-8859-1. Now my pages come out as expected. I have one question if anyone would there be any draw backs to doing this? Thanks, Yves -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: 10 novembre 2003 15:02 To: CF-Talk Subject: CF+MySQL+Apache french characters not properly displayed. Hello, I've been racking my brain over this for a little bit... I'm running CFMX 6.1, Apache 2.0.48 and MySQL 3.23.58. I'm a bit confused at this behavior... I converted an access db to mysql using a conversion tool. I log in to webmin, look at the data in my tables, everything looks fine. Characters such as ,,.. all display as they should. When I view a page with this same data through my webserver (apache), all the french characters are messed up. Any ideas?? Thanks, Yves [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF+MySQL+Apache french characters not properly displayed.
Yves Arsenault wrote: I'm running CFMX 6.1, Apache 2.0.48 and MySQL 3.23.58. I'm a bit confused at this behavior... I converted an access db to mysql using a conversion tool. I log in to webmin, look at the data in my tables, everything looks fine. Characters such as ?,?,?.. all display as they should. Such as which? When I view a page with this same data through my webserver (apache), all the french characters are messed up. Did you specify an encoding in the JDBC URL? Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Deleteing a directory
CFDIRECTORY can't delete a directory unless there are no files or subdirectories.You'll have to use a combination of CFFILE and CFDIRECTORY to make sure the top-level directory is empty before deleting it. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:51 PM To: CF-Talk Subject: Deleteing a directory I am using CFDIRECTORY to delete a directory.then I get an error saying that it can't be delted because the directory is NOT EMPTY. s Can anyone help?lol [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF+MySQL+Apache french characters not properly displayed.
Yves Arsenault wrote: It had to do with MySQL's encoding, 3.23.58 not being compatible with UTF-8 from what I found. So I'm forcing CFMX to use iso-8859-1. Now my pages come out as expected. I have one question if anyone would there be any draw backs to doing this? You can't use characters that are not in ISO-8859-1 (such as the euro character). Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Deleteing a directory
Can someone possibly help me out and help me write a CFEXECUTE to delete a whole directory, as well as make a copy of it?please.I dont know MS DOS or whatever it is u need to know hehehehe - Original Message - From: Scott Weikert To: CF-Talk Sent: Monday, November 10, 2003 2:58 PM Subject: Re: Deleteing a directory At 01:50 PM 11/10/2003, you wrote: I am using CFDIRECTORY to delete a directory.then I get an error saying that it can't be delted because the directory is NOT EMPTY.s Generally what you need to do is do a CFDIRECTORY on that dir, loop over the contents and use CFFILE to delete each file as you loop over it, then you can remove the directory. Or perhaps do a command line bit, deleting *.* from that directory, that would be less code and possibly quicker. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
input boxes ande double quotes
Hey All, Old issue, but I'm checking the consensus Let's say we have this: input type=text name=txtFName value=#FORM.txtFName# and the form posts back to itself which kicks in some validationan error is found and the form is re-displayed along with an error message and populated with exatly what the user typed (pretty standard stuff). So all works fine unless you start throwing some double quotes into that input box.If you do that then the value can be truncated (let's say they entered Biff as the name...with the double quotes).That means the HTML produced on re-display is like this: input type=text name=txtFName value=Biff So now the value is technically or blank because it got truncated (you now have value= and Biff). So what does everybody do about this? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF+MySQL+Apache french characters not properly displayed.
Hey Yves! I was having the same problem on win2k mx 6.1 mysql version 3.xxx whatever it was, if I recall the webserver was IIS but it was the same problems you described... accents converted to ? . I had to resort to setting all the encodings to iso-8859-1.I noticed though that accented characters that were embedded in my .cfm templates who were not from the database worked fine. It was only the ones in the DB..., which I thought was weird.But setting cfprocessing, cfcontent and encoding forms to use iso-8859-1 did the trick for me as well. So far, getting accents to work has been my number one issue with cfmx 6 and 6.1 -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: November 10, 2003 3:59 PM To: CF-Talk Subject: RE: CF+MySQL+Apache french characters not properly displayed. Finally, It had to do with MySQL's encoding, 3.23.58 not being compatible with UTF-8 from what I found. So I'm forcing CFMX to use iso-8859-1. Now my pages come out as expected. I have one question if anyone would there be any draw backs to doing this? Thanks, Yves -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: 10 novembre 2003 15:02 To: CF-Talk Subject: CF+MySQL+Apache french characters not properly displayed. Hello, I've been racking my brain over this for a little bit... I'm running CFMX 6.1, Apache 2.0.48 and MySQL 3.23.58. I'm a bit confused at this behavior... I converted an access db to mysql using a conversion tool. I log in to webmin, look at the data in my tables, everything looks fine. Characters such as ,,.. all display as they should. When I view a page with this same data through my webserver (apache), all the french characters are messed up. Any ideas?? Thanks, Yves _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Unicode with CF and MySQL (re: CF+MySQL+Apache french characters)
Log into the CF Admin Data Sources Choose your MySQL DSN Add to your Connection String: useUnicode=truecharacterEncoding=ISO8859_1 HTH, Adrian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Executing the SQL statement is not allowed
I am completely stumped on this one. I'm trying to execute this query on my development box (Win XP Pro, CFMX 6.1, MS SQL Server 2000 Development, Apache 2): CREATE TABLE [RADIOPrimary].[dbo].[testform2] ( [testform2ID] int NOT NULL IDENTITY PRIMARY KEY, [testcolumn] varchar (8000) NULL, [CMSUseOnlySortOrder] int NULL, [CMSUseOnlyFeatureSortOrder] int NULL, [CMSUseOnlyPublish] bit NULL, [CMSUseOnlyDateTimeStamp] datetime NULL ) I get Executing the SQL statement is not allowed. every time. The datasource uses the MS SQL sa account and the query runs fine with the MS SQL Query Analyzer using sa. The datasource has all permissions checked. At one point this would have worked on my development box. Here's the weird part, the same code runs fine on my Production Box (Win 2K Server, CFMX 6.1). What could possibly be causing this issue? All other queries on this datasource (SELECT, INSERT, DELETE) run fine. Thanks, Jonathan __ Jonathan Mauney Web Application Developer / Manager, Digital Media Properties 1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network Jefferson-Pilot Communications Co. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: input boxes ande double quotes
almost EVERY TIME you include the content of a CF variable onto an HTML page you will want to wrap it in HTMLEDITFORMAT() so your input would look like: input type=text name=txtFName value=#htmleditformat(FORM.txtFName)# Jann -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:08 PM To: CF-Talk Subject: input boxes ande double quotes Hey All, Old issue, but I'm checking the consensus Let's say we have this: input type=text name=txtFName value=#FORM.txtFName# and the form posts back to itself which kicks in some validationan error is found and the form is re-displayed along with an error message and populated with exatly what the user typed (pretty standard stuff). So all works fine unless you start throwing some double quotes into that input box.If you do that then the value can be truncated (let's say they entered Biff as the name...with the double quotes).That means the HTML produced on re-display is like this: input type=text name=txtFName value=Biff So now the value is technically or blank because it got truncated (you now have value= and Biff). So what does everybody do about this? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF+MySQL+Apache french characters not properly displayed.
Yves, You should add the following line into MySQL 'Connection String' of advanced setting. useUnicode=truecharacterEncoding=iso-8859-1 Then, So I'm forcing CFMX to use iso-8859-1. It's not required. Thanks, -- Hiroshi -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:59 PM To: CF-Talk Subject: RE: CF+MySQL+Apache french characters not properly displayed. Finally, It had to do with MySQL's encoding, 3.23.58 not being compatible with UTF-8 from what I found. So I'm forcing CFMX to use iso-8859-1. Now my pages come out as expected. I have one question if anyone would there be any draw backs to doing this? Thanks, Yves -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: 10 novembre 2003 15:02 To: CF-Talk Subject: CF+MySQL+Apache french characters not properly displayed. Hello, I've been racking my brain over this for a little bit... I'm running CFMX 6.1, Apache 2.0.48 and MySQL 3.23.58. I'm a bit confused at this behavior... I converted an access db to mysql using a conversion tool. I log in to webmin, look at the data in my tables, everything looks fine. Characters such as ,,.. all display as they should. When I view a page with this same data through my webserver (apache), all the french characters are messed up. Any ideas?? Thanks, Yves [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Deleteing a directory
Create a batch file and use RMDIR.here's a link to syntax. http://www.easydos.com/rmdir.html You can also use cfdirectory to do this. -Mark -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:07 PM To: CF-Talk Subject: Re: Deleteing a directory Can someone possibly help me out and help me write a CFEXECUTE to delete a whole directory, as well as make a copy of it?please.I dont know MS DOS or whatever it is u need to know hehehehe - Original Message - From: Scott Weikert To: CF-Talk Sent: Monday, November 10, 2003 2:58 PM Subject: Re: Deleteing a directory At 01:50 PM 11/10/2003, you wrote: I am using CFDIRECTORY to delete a directory.then I get an error saying that it can't be delted because the directory is NOT EMPTY.s Generally what you need to do is do a CFDIRECTORY on that dir, loop over the contents and use CFFILE to delete each file as you loop over it, then you can remove the directory. Or perhaps do a command line bit, deleting *.* from that directory, that would be less code and possibly quicker. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF MX 6.1 Migration issue
I am migrating an application for a coworker. This code was operation on a CF 5 server, but is no longer valid on a 6.1 server.Is that a valid statement? !--- INSERT --- cfloop list=#variables.my_table_fields# index=x CFSET structDelete(form,#x#) cfparam name=form.#x# default=#qSelProgTable[#x#]# /cfloop cfinsert tablename=#qryGetAreaInfo.vTable_Name#_live datasource=#REQUEST.AppDSN# formfields=#variables.my_table_fields# Thanks, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFLDAP
Anybody have experience using the CFLDAP tag with MS Active Directory?I am using this tag for the first time, and having trouble parsing information to get what I want.Any help would be most appreciated!I'm don't even know enough to fully express my problems, other I can only get the top level of the directory, at least that is what I believe I am getting.And I start throwing errors when I take blind stabs at drilling down. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: input boxes ande double quotes
Bryan: I usually just replace the double-quotes with quot; (the double-quote entity) using the following code: Replace(myValue, '', quot;, ALL) However, a lot of people tend to just go with the JSStringFormat() function. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 4:08 PM To: CF-Talk Subject: input boxes ande double quotes Hey All, Old issue, but I'm checking the consensus Let's say we have this: input type=text name=txtFName value=#FORM.txtFName# and the form posts back to itself which kicks in some validationan error is found and the form is re-displayed along with an error message and populated with exatly what the user typed (pretty standard stuff). So all works fine unless you start throwing some double quotes into that input box.If you do that then the value can be truncated (let's say they entered Biff as the name...with the double quotes).That means the HTML produced on re-display is like this: input type=text name=txtFName value=Biff So now the value is technically or blank because it got truncated (you now have value= and Biff). So what does everybody do about this? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Entering A Time Stamp in DB -- Problem
My first guess, it's the quotes causing your trouble.Use
PreserveSingleQuotes()
CFQUERY NAME=myTask DATASOURCE=#DataSourceName#
INSERT INTOPingResults ( DomainName,
StartTime,
Dfield1,
Dfield2,
Dfield3,
Dfield4)
VALUES (
'#PreserveSingleQuotes(session.RecordArray[1])#',
'#PreserveSingleQuotes(session.RecordArray[2])#',
'#PreserveSingleQuotes(session.RecordArray[4])#',
'#PreserveSingleQuotes(session.RecordArray[5])#',
'#PreserveSingleQuotes(session.RecordArray[6])#',
'#PreserveSingleQuotes(session.RecordArray[7])#'
/CFQUERY
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 2:26 PM
To: CF-Talk
Subject: Entering A Time Stamp in DB -- Problem
CF V 5
MS Access DB
I have time in the following format that was extracted in one CF template
and stuffed in a DB without any hitch.
{ts '2003-11-07 19:57:14'}
When this same info iss passed as part of a text to another CF template,
using CFHTTP, the same CF DB CFQUERY code throws an error when attempting
to insert into a copy of the same DB.
In both DB's I am trying to stuff the info into a Date/Time field, i.e.,
StartTime.
CFQUERY NAME=myTask DATASOURCE=#DataSourceName#
INSERT INTOPingResults ( DomainName,
StartTime,
Dfield1,
Dfield2,
Dfield3,
Dfield4)
VALUES (
'#session.RecordArray[1]#',
'#session.RecordArray[2]#',
'#session.RecordArray[4]#',
'#session.RecordArray[5]#',
'#session.RecordArray[6]#',
'#session.RecordArray[7]#'
/CFQUERY
Apparently something is being lost in the transfer process, and I don't
know how to get it back.
Thanks,
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Unicode with CF and MySQL (re: CF+MySQL+Apache french characters)
I've seen this before, but one question remains unanswered:does this work to fix mySQL versions that are prior to 4.1 (which is still designated 'alpha')?According to mySQL AB, thats the first version thats Unicode compatible. Or is this connection string some sort of magic bullet? Building my first unicode-compliant sample db app today for a project that'll wind up in Chinese.Looked to me like mySQL needed 4.1 to go Unicode. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Deleteing a directory
Don't know DOS? Heh! I still use it to a degree with even the crappy new WinXP. For gods sake be VERY careful with the CFEXECUTE command. If it was a hosting providers server I would be VERY surprised you would be able to use the command (and others) at all. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Important:This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege.If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament.If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Executing the SQL statement is not allowed
Jonathan, I believe that Identity needs a seed.Also, I know that the limit on the size of a row is somewhere around 8000. Try: create table [RADIOPrimary].[dbo].[testform2] ( [testform2ID] int NOT NULL IDENTITY (1, 1) PRIMARY KEY, [testcolumn] varchar(7000) NULL, [CMSUseOnlySortOrder] int NULL, [CMSUseOnlyFeatureSortOrder] int NULL, [CMSUseOnlyPublish] bit NULL, [CMSUseOnlyDateTimeStamp] datetime NULL) Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:57 PM To: CF-Talk Subject: Executing the SQL statement is not allowed I am completely stumped on this one. I'm trying to execute this query on my development box (Win XP Pro, CFMX 6.1, MS SQL Server 2000 Development, Apache 2): CREATE TABLE [RADIOPrimary].[dbo].[testform2] ( [testform2ID] int NOT NULL IDENTITY PRIMARY KEY, [testcolumn] varchar (8000) NULL, [CMSUseOnlySortOrder] int NULL, [CMSUseOnlyFeatureSortOrder] int NULL, [CMSUseOnlyPublish] bit NULL, [CMSUseOnlyDateTimeStamp] datetime NULL ) I get Executing the SQL statement is not allowed. every time. The datasource uses the MS SQL sa account and the query runs fine with the MS SQL Query Analyzer using sa. The datasource has all permissions checked. At one point this would have worked on my development box. Here's the weird part, the same code runs fine on my Production Box (Win 2K Server, CFMX 6.1). What could possibly be causing this issue? All other queries on this datasource (SELECT, INSERT, DELETE) run fine. Thanks, Jonathan __ Jonathan Mauney Web Application Developer / Manager, Digital Media Properties 1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network Jefferson-Pilot Communications Co. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF MX 6.1 Migration issue
cfloop list=#variables.my_table_fields# index=x CFSET structDelete(form,#x#) cfparam name=form.#x# default=#qSelProgTable[#x#]# /cfloop I don't believe you can use StructDelete() on scopes. I would rewrite the code as follows. cfloop list=#variables.my_table_fields# index=x cfif StructKeyExists(form, x) cfset form[x] = qSelProgTable[x] /cfif /cfloop Although, you may not be able to set values in the form scope either as some scopes have become read-only. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Entering A Time Stamp in DB -- Problem
And - at least with MSAccess you can (when designing the table) set a default attribute (correct term?) of Now() to a date field so that Access automatically can update or insert the date whenever a new record is created. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Important:This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege.If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament.If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF MX 6.1 Migration issue
StructDelete on the Form scope works just fine, as does setting form values: cfdump var=#form# cfset form.foo = hello cfdump var=#form# cfset StructDelete(form, foo) cfdump var=#form# chris From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:49 PM To: CF-Talk Subject: Re: CF MX 6.1 Migration issue cfloop list=#variables.my_table_fields# index=x CFSET structDelete(form,#x#) cfparam name=form.#x# default=#qSelProgTable[#x#]# /cfloop I don't believe you can use StructDelete() on scopes. I would rewrite the code as follows. cfloop list=#variables.my_table_fields# index=x cfif StructKeyExists(form, x) cfset form[x] = qSelProgTable[x] /cfif /cfloop Although, you may not be able to set values in the form scope either as some scopes have become read-only. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF MX 6.1 Migration issue
The code works, but since variables changed over to structures in CF MX I am get the error with cfinsert and cfupdate. Thanks, Andrew -Original Message- From: chris kief [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 5:00 PM To: CF-Talk Subject: RE: CF MX 6.1 Migration issue StructDelete on the Form scope works just fine, as does setting form values: cfdump var=#form# cfset form.foo = hello cfdump var=#form# cfset StructDelete(form, foo) cfdump var=#form# chris From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:49 PM To: CF-Talk Subject: Re: CF MX 6.1 Migration issue cfloop list=#variables.my_table_fields# index=x CFSET structDelete(form,#x#) cfparam name=form.#x# default=#qSelProgTable[#x#]# /cfloop I don't believe you can use StructDelete() on scopes. I would rewrite the code as follows. cfloop list=#variables.my_table_fields# index=x cfif StructKeyExists(form, x) cfset form[x] = qSelProgTable[x] /cfif /cfloop Although, you may not be able to set values in the form scope either as some scopes have become read-only. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Executing the SQL statement is not allowed
Thanks Steve, but that didn't work either. I get the same error. Remember the exact same code works fine in my production environment the only differences are Dev is Win XP and Apache with MS SQL Dev Edition on the same box and the production is on Win 2K Server with IIS and MS SQL is on separate box. -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 4:48 PM To: CF-Talk Subject: RE: Executing the SQL statement is not allowed Jonathan, I believe that Identity needs a seed.Also, I know that the limit on the size of a row is somewhere around 8000. Try: create table [RADIOPrimary].[dbo].[testform2] ( [testform2ID] int NOT NULL IDENTITY (1, 1) PRIMARY KEY, [testcolumn] varchar(7000) NULL, [CMSUseOnlySortOrder] int NULL, [CMSUseOnlyFeatureSortOrder] int NULL, [CMSUseOnlyPublish] bit NULL, [CMSUseOnlyDateTimeStamp] datetime NULL) Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:57 PM To: CF-Talk Subject: Executing the SQL statement is not allowed I am completely stumped on this one. I'm trying to execute this query on my development box (Win XP Pro, CFMX 6.1, MS SQL Server 2000 Development, Apache 2): CREATE TABLE [RADIOPrimary].[dbo].[testform2] ( [testform2ID] int NOT NULL IDENTITY PRIMARY KEY, [testcolumn] varchar (8000) NULL, [CMSUseOnlySortOrder] int NULL, [CMSUseOnlyFeatureSortOrder] int NULL, [CMSUseOnlyPublish] bit NULL, [CMSUseOnlyDateTimeStamp] datetime NULL ) I get Executing the SQL statement is not allowed. every time. The datasource uses the MS SQL sa account and the query runs fine with the MS SQL Query Analyzer using sa. The datasource has all permissions checked. At one point this would have worked on my development box. Here's the weird part, the same code runs fine on my Production Box (Win 2K Server, CFMX 6.1). What could possibly be causing this issue? All other queries on this datasource (SELECT, INSERT, DELETE) run fine. Thanks, Jonathan __ Jonathan Mauney Web Application Developer / Manager, Digital Media Properties 1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network Jefferson-Pilot Communications Co. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Deleteing a directory
Brob, Look for a custom tag in the Developer's Exchange, called CF_DeleteDirectory.Does exactly what Mosh describes, recursively through all files and subs. If you can't find it, give me a holler off-list and I'll send you a copy of the original distribution. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Mosh Teitelbaum wrote: CFDIRECTORY can't delete a directory unless there are no files or subdirectories.You'll have to use a combination of CFFILE and CFDIRECTORY to make sure the top-level directory is empty before deleting it. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:51 PM To: CF-Talk Subject: Deleteing a directory I am using CFDIRECTORY to delete a directory.then I get an error saying that it can't be delted because the directory is NOT EMPTY. s Can anyone help?lol [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Online, the Flash game is
You've gotta have a chuckle at MM's Yoda speak for the current site of the day - Star Wars: Clone Wars. Why is it everyone seems to does this when referencing anything Star Wars? Heh! Check out the game at http://www.cartoonnetwork.com/clonewars/index.html Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Important:This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege.If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament.If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF MX 6.1 Migration issue
I don't believe you can use StructDelete() on scopes. Within CFMX, you can use StructDelete, or any other structure function, on almost any scope, as they are all exposed as writeable structures. Although, you may not be able to set values in the form scope either as some scopes have become read-only. The Form scope hasn't been read-only for some time. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Dynamic SQL
Hey guys I am allowing user to run SQL scripts by typing them into a textarea and submitting them.But for ome reason i keep on getting some syntax error, even though I did an output test of the script on the page and the script looks alright.Any hints?thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Unicode with CF and MySQL (re: CF+MySQL+Apache french characters)
I wrote: Or is this connection string some sort of magic bullet? After some testing I can say its a magic bullet.I've got Russian, English and Chinese text on the same page, stored in the same mySQL 4.0 text field record. In addition to the connection string, I have cfprocessingdirective pageEncoding=utf-8 cfcontent type=text/html; charset=utf-8 at template top, and cfscript SetEncoding(form,utf-8); SetEncoding(url,utf-8); /cfscript in Application.cfm. Dirt simple.Gotta love CFMX! -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic SQL
are you INSANE? Perhaps you're having issues with quotes?CF will automatically escape them from variables that are output within CFQUERY tags.Try wrapping the variable with the preserveSingleQuotes function. cheers, barneyb -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:12 PM To: CF-Talk Subject: Dynamic SQL Hey guys I am allowing user to run SQL scripts by typing them into a textarea and submitting them.But for ome reason i keep on getting some syntax error, even though I did an output test of the script on the page and the script looks alright.Any hints?thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic SQL
Are you frigging insane? How about if someone types in drop table x where x is the name of your table? Anyways, what about apostrophies? are they using those? If so, remember that CF doesn't naturally put them as SQL apostrophies - which is what PreserveSingleQuotes() is for -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 6:12 PM To: CF-Talk Subject: Dynamic SQL Hey guys I am allowing user to run SQL scripts by typing them into a textarea and submitting them.But for ome reason i keep on getting some syntax error, even though I did an output test of the script on the page and the script looks alright.Any hints?thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic SQL
I had this happening just a few days ago, wrap the SQL with a PreserveSingleQuotes() and you should be fixed right up! Hatton -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 6:12 PM To: CF-Talk Subject: Dynamic SQL Hey guys I am allowing user to run SQL scripts by typing them into a textarea and submitting them.But for ome reason i keep on getting some syntax error, even though I did an output test of the script on the page and the script looks alright.Any hints?thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ReSOLVED: Deleteing a directory
Thanks all! :) - Original Message - From: David Delbridge To: CF-Talk Sent: Monday, November 10, 2003 4:24 PM Subject: Re: Deleteing a directory Brob, Look for a custom tag in the Developer's Exchange, called CF_DeleteDirectory.Does exactly what Mosh describes, recursively through all files and subs. If you can't find it, give me a holler off-list and I'll send you a copy of the original distribution. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Mosh Teitelbaum wrote: CFDIRECTORY can't delete a directory unless there are no files or subdirectories.You'll have to use a combination of CFFILE and CFDIRECTORY to make sure the top-level directory is empty before deleting it. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:51 PM To: CF-Talk Subject: Deleteing a directory I am using CFDIRECTORY to delete a directory.then I get an error saying that it can't be delted because the directory is NOT EMPTY. s Can anyone help?lol [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ToString() throwing a NULL NULL...
I'm trying to export a XML file from a XML variable, and the following code has worked for the last several weeks, but now is throwing the Dreaded NULL2 Error*: cfxml variable=Exportsome xml tags/cfxml ...then, this throws an error: cfoutputtextarea cols=75 rows=30 style=width: 100%;#ToString(Export)#/textarea/cfoutputcfabort ...but this does not: cfdump var=#Export# label=Exportcfabort ...so, it must be the ToString() function.I've searched through the rather large variable for any misaligned or malfigured nodes, but everything looks fine.I've googled and searched mm.com for a bug, but can't find anything...can anyone help me out?The best I've got is to use cfsavecontent instead, which I guess works...but I don't like it, cfxml makes me think I'm doing something wrong and I want to get to the bottom of it. Tyler Silcox *(copyrighted, trademarked, and patented-get ready to pay up!) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamic SQL
You probably have to wrap your query in a PreserveSingleQuotes() function.By default, CF will escape single quotes in variables passed to a CFQUERY tag. HTH, Jeff - Original Message - From: brob To: CF-Talk Sent: Monday, November 10, 2003 4:11 PM Subject: Dynamic SQL Hey guys I am allowing user to run SQL scripts by typing them into a textarea and submitting them.But for ome reason i keep on getting some syntax error, even though I did an output test of the script on the page and the script looks alright.Any hints?thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic SQL
First off, standard security warnings about letting people type in SQL free-form: BAD PROGRAMMER [whack!]BAD PROGRAMMER [whack! whack!] That said, how about posting the exact error message so we can get a better idea of what's going on. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 6:12 PM To: CF-Talk Subject: Dynamic SQL Hey guys I am allowing user to run SQL scripts by typing them into a textarea and submitting them.But for ome reason i keep on getting some syntax error, even though I did an output test of the script on the page and the script looks alright.Any hints?thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Attempts at banking fraud
Action pack is for MS Sales Partners to use in their own business.It's to give the partners and their staff real life exposure to the products, to have them using all the latest stuff internally.To sell MS products you have to have a relationship with a distributor, and each distributor makes their own decisions as to who to do business with.Microsoft will give you a list of distributors if you contact the sales partner office where you are. I talked about Action pack originally because I think it's an excellent concept and I think Macromedia would do well to consider a similar concept for their own network.I'm not sure it's a great thing to be talking about Microsoft sales policies on a MM list is it?This is supposed to be a ColdFusion technical list. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 November 2003 7:19 AM To: CF-Talk Subject: RE: Attempts at banking fraud You can't. As far as I know ActionPack is licensed for internal use only. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamic SQL
Wrap your form var in preservesinglequotes(). And wrap your head in a bunch of foam rubber.You have a beating coming from this someday soon, methinks.Sure hope for your sake you've thought this one out real well. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Unicode with CF and MySQL (re: CF+MySQL+Apache french characters)
After some testing I can say its a magic bullet.I've got Russian, English and Chinese text on the same page, stored in the same mySQL 4.0 text field record. i believe its storing the actual utf-8 encoded text rather than ucs2 (ala sql server, java cf). in any case and before you get too giddy, try some string functions within mySQL and also make sure it actually sorts these langauges properly. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Deleteing a directory
I think you have to delete every file (and subdirectory) inside a directory before you can delete the directory itself. -sutton _ From: brob [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 3:51 PM To: CF-Talk Subject: Deleteing a directory I am using CFDIRECTORY to delete a directory.then I get an error saying that it can't be delted because the directory is NOT EMPTY. s Can anyone help?lol _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Data Model Design question
Say you've got a COURSE table that represents many courses. New courses will always be being added to the table. Each course will have many quizzes and questions that need to be stored. You would not want to have a single QUIZ table with a composite key of COURSE_ID and QUIZ_ID because potentially this table would become prohibitively large, correct? Also, each quiz will have many questions, stored in a QUESTION table. This even more so would become prohibitively large if you stored questions for every quiz in every course in one table. Sooo, you would want a QUIZ table and QUESTION table for each course, correct? If so, these table names would be assigned dynamically. That's easy enough if you just, say, appended the COURSE_ID to the end of the QUIZ or QUESTION table, but you run into a problem if you want all database access to be through stored procedures, as I don't know of a way to use dynamic table names in stored procedures with SQL Server. Is there a better way of doing this? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Deleteing a directory
At 06:45 PM 11/10/2003 -0500, you wrote: I think you have to delete every file (and subdirectory) inside a directory before you can delete the directory itself. -sutton While do I sometimes suspect (when this subject comes up) that I'll see a thread the next day titled UN-deleting a directory!!!? :) --min [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Data Model Design question
Cohen, Michael wrote: Say you've got a COURSE table that represents many courses. New courses will always be being added to the table. Each course will have many quizzes and questions that need to be stored. You would not want to have a single QUIZ table with a composite key of COURSE_ID and QUIZ_ID because potentially this table would become prohibitively large, correct? What is prohibitively large? 10 million? 100 million? Also, each quiz will have many questions, stored in a QUESTION table. This even more so would become prohibitively large if you stored questions for every quiz in every course in one table. Sooo, you would want a QUIZ table and QUESTION table for each course, correct? No. Generally speaking, databases scale better in the number of rows per table as in the number of tables per schema. One course table, one quiz table, one question table. Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Data Model Design question
You would not want to have a single QUIZ table with a composite key of COURSE_ID and QUIZ_ID because potentially this table would become prohibitively large, correct? While it might become large - very large, even - I don't think it would become prohibitively large. The same is true for your QUESTION table, for that matter. We've done quite a few survey and HR applications that store many, many records of the same sort - questions, groups of questions, answers, etc. These applications have worked well enough despite the number of records. Sooo, you would want a QUIZ table and QUESTION table for each course, correct? No, I wouldn't. Whenever you find yourself modifying your database schema during the running of your application due to new data being added, that should be a giant red flag signalling to you the potential inadequacy of your schema. Of course, there are exceptions to everything, but for the most part, a well-designed schema should be able to manage any data generated during the normal operation of your application without modification. That's easy enough if you just, say, appended the COURSE_ID to the end of the QUIZ or QUESTION table, but you run into a problem if you want all database access to be through stored procedures, as I don't know of a way to use dynamic table names in stored procedures with SQL Server. You can always execute strings within your stored procedures using EXEC or sp_executesql, but in general, this doesn't help performance any and should be avoided when possible, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Unicode with CF and MySQL (re: CF+MySQL+Apache french characters)
For that matter, I wonder what happens when someone searches on the data.This is a cms with no string functions in the picture.It uses an arbitrary numeric sorting system, so we're safe on that score.If we can store and retrieve, with functioning simple search, we should be OK... maybe. Some of this I have to leave to people who actually speak the language.Frustrating only being able to do half the job... -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Data Model Design question
Thanks guys! I was figuring close to a million records potentially. I gather from Jochem's question that a million is not prohibitively large?:) Even to be querying on all the time?And Dave's comment about modifying your db schema was interesting. I didn't know that. Any db fundamentals book recommendations? Thanks again. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Mon 11/10/2003 6:57 PM To: CF-Talk Cc: Subject: Re: Data Model Design question Cohen, Michael wrote: Say you've got a COURSE table that represents many courses. New courses will always be being added to the table. Each course will have many quizzes and questions that need to be stored. You would not want to have a single QUIZ table with a composite key of COURSE_ID and QUIZ_ID because potentially this table would become prohibitively large, correct? What is prohibitively large? 10 million? 100 million? Also, each quiz will have many questions, stored in a QUESTION table. This even more so would become prohibitively large if you stored questions for every quiz in every course in one table. Sooo, you would want a QUIZ table and QUESTION table for each course, correct? No. Generally speaking, databases scale better in the number of rows per table as in the number of tables per schema. One course table, one quiz table, one question table. Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Unicode with CF and MySQL (re: CF+MySQL+Apache french characters)
For that matter, I wonder what happens when someone searches on the data. This is a cms with no string functions in the picture.It uses an arbitrary numeric sorting system, so we're safe on that score.If we can store and retrieve, with functioning simple search, we should be OK... maybe. good luck but lack of real unicode support was a bad set of problems in cf5, trying to manipulate utf-8 isn't fun (though if you can shift your app logic to clientside, js makes that nasty job much easier). Some of this I have to leave to people who actually speak the language. Frustrating only being able to do half the job... actually you can test sorting yourself, pile in some language text see if it sorts according to unicode block. unicode blocks should sort ok within themselves. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Data Model Design question
Michael, As long as you have proper indexing setup on the table, there shouldn't be an issue with querying it. You can also run a Trace on the table, once it is use, to see if any additional indexes can be created, based on the actual usage stats of the table Dave -Original Message- From: Cohen, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 7:30 PM To: CF-Talk Subject: RE: Data Model Design question Thanks guys! I was figuring close to a million records potentially. I gather from Jochem's question that a million is not prohibitively large?:) Even to be querying on all the time?And Dave's comment about modifying your db schema was interesting. I didn't know that. Any db fundamentals book recommendations? Thanks again. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Mon 11/10/2003 6:57 PM To: CF-Talk Cc: Subject: Re: Data Model Design question Cohen, Michael wrote: Say you've got a COURSE table that represents many courses. New courses will always be being added to the table. Each course will have many quizzes and questions that need to be stored. You would not want to have a single QUIZ table with a composite key of COURSE_ID and QUIZ_ID because potentially this table would become prohibitively large, correct? What is prohibitively large? 10 million? 100 million? Also, each quiz will have many questions, stored in a QUESTION table. This even more so would become prohibitively large if you stored questions for every quiz in every course in one table. Sooo, you would want a QUIZ table and QUESTION table for each course, correct? No. Generally speaking, databases scale better in the number of rows per table as in the number of tables per schema. One course table, one quiz table, one question table. Jochem -- Who needs virtual reality if you can just dream? - Loesje _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
