Detect session timeout and prompt messages.
Hi folks, How is it possible to prompt the user a message after session timeout? Or how do we detect whether the session has time out? thanx in adv - Rudy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Mailing Shots in CF (and timeouts)
hi guys, I'll need to send tons of mails and I was reading your posts but I have some questions: - Will the CFX_Wait overwrite the web server and/or Coldfusion server timeouts ? - Who wrote the CFX_WAIT tag? is it reliable ? I mean: is it secure ? trojan free ? in the Developer Exchange it doesn't have an author or website. thanks in advance, ~Jaav If you try to send out a ton of mail at once with CFMAIL, for some reason it just stops working and you have to reboot the server or reinstall the dll. Allaire just hasn't quite got thier arms around CFMAIL and CFFTP yet. And they especially didn't have thier arms around it in 4.0. What I found works is putting CFMAIL inside a loop and foregoing the query attribute. Then use the cfx_wait tag between each iteration of the loop. BTW, Tony Aly came up with this solution, so I cannot take credit for it. It works, give it a try. EG., cfloop query="get_email_addresses" cftry cfmail to="#trim(current_email)#" from="#trim(get_email_message.from_vc)#" subject="#trim(get_email_message.subject_vc)#" server="#trim(attributes.mail_server)#"#get_email_message.message_mem# /cfmail CFX_Wait Sleeptime="1" cfcatch CFX_Wait Sleeptime="10" /cfcatch /cftry /cfloop The CFX_WAIT tag is available in the Allaire tag library ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Detect session timeout and prompt messages.
HI Rudy, I never have tested it but I saw a website where they use a refresh meta-tag. and they did program to show a desconnection page. META HTTP-Equiv=refresh Content="5; URL=YourPage.cfm" hope this helps, ~Jaav - Original Message - From: Rudy Rustam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 10:58 AM Subject: Detect session timeout and prompt messages. Hi folks, How is it possible to prompt the user a message after session timeout? Or how do we detect whether the session has time out? thanx in adv - Rudy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Detect session timeout and prompt messages.
Err... Jaav, I think you misunderstand me. My situation apply after user has logged in to the system. I have to detect if the session has timeout and prompt a nice message. Regards, - Rudy -Original Message- From: JAAV [mailto:[EMAIL PROTECTED]] Sent: Thursday, 29 March 2001 5:22 PM To: CF-Talk Subject: RE: Detect session timeout and prompt messages. HI Rudy, I never have tested it but I saw a website where they use a refresh meta-tag. and they did program to show a desconnection page. META HTTP-Equiv=refresh Content="5; URL=YourPage.cfm" hope this helps, ~Jaav - Original Message - From: Rudy Rustam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 10:58 AM Subject: Detect session timeout and prompt messages. Hi folks, How is it possible to prompt the user a message after session timeout? Or how do we detect whether the session has time out? thanx in adv - Rudy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Detect session timeout and prompt messages.
Just put this in your application.com. cfif isDefined("session.variableName") cflocation template="login.cfm" /cfif jon - Original Message - From: "Rudy Rustam" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 3:58 AM Subject: Detect session timeout and prompt messages. Hi folks, How is it possible to prompt the user a message after session timeout? Or how do we detect whether the session has time out? thanx in adv - Rudy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Questions about calendaring [Was: Re: VCalendar :: Outlook :: Help Needed
Hello. Has anyone worked on writing a ColdFusion app that reads and writes calendar info to either Outlook or Sun's desktop calendar manager? They both claim to export and import vcalendar, and so, in theory, this should be able to be done... In particular, code identifying and resoluting appointment conflicts would really be appreciated. Pointing me to a commercial product would be fine - as long as it doesn't require me to change the client side ... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: database error
I don't understand the following MS SQL error. Both columns for the primary and foreign key are varchar(20). I don't know how to fix this error because I don't even know what it means as it is the first time for this one. Any help? - Unable to create relationship 'FK_TrainingTranslations_WWTunings'. [Microsoft][ODBC SQL Server Driver][SQL Server]The total row size (8132) for table 'TrainingTranslations' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added. As stated by Tony and Seva, SQL Server has a row limit of 8KB - but TEXT fields don't add to this If you've got VARCHAR fields which aren't indexed or used in a WHERE (excuding IS NULL) then make them into TEXT - it's a minor inconvenience, but it's an easy "get around" If you really need to use TEXT fields in a WHERE, then you can always use CONVERT to make them into "virtual" VARCHAR fields... slightly slower, but it works Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Automate FTP
type at /? at the command prompt to find out Alternatively, in Windows2000 use the scheduled tasks control panel Mark At 01:21 AM 3/29/2001, you wrote: I've created a FTP batch file, ftpcmd.bat: %windir%\ftp.exe -s:%f0 goto done open financialcontent.com (user name omitted) (password omitted) lcd d:\website\htdocs\stockgolf\htdocs\data ascii get eod.txt bye :done @echo off cls exit So how do I schedule this with AT? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Detect session timeout and prompt messages.
but jon, no clue to differentiate whether session timeout or session never set before. -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, 29 March 2001 5:51 PM To: CF-Talk Subject: Re: Detect session timeout and prompt messages. Just put this in your application.com. cfif isDefined("session.variableName") cflocation template="login.cfm" /cfif jon - Original Message - From: "Rudy Rustam" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 3:58 AM Subject: Detect session timeout and prompt messages. Hi folks, How is it possible to prompt the user a message after session timeout? Or how do we detect whether the session has time out? thanx in adv - Rudy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Automate FTP
You can use the schedule tasks bit in NT to set this up too - buit read the help text on the sytax for the command ! -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:00 PM To: CF-Talk Subject: Re: OT: Automate FTP type at /? at the command prompt to find out Alternatively, in Windows2000 use the scheduled tasks control panel Mark At 01:21 AM 3/29/2001, you wrote: I've created a FTP batch file, ftpcmd.bat: %windir%\ftp.exe -s:%f0 goto done open financialcontent.com (user name omitted) (password omitted) lcd d:\website\htdocs\stockgolf\htdocs\data ascii get eod.txt bye :done @echo off cls exit So how do I schedule this with AT? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Mailing Shots in CF (and timeouts)
Never used it myself, but I don't like the idea of it for large, large queries. A better option is to install Howie's free Post-SE productwww.coolfusion.com - it's the dogs'. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com hi guys, I'll need to send tons of mails and I was reading your posts but I have some questions: - Will the CFX_Wait overwrite the web server and/or Coldfusion server timeouts ? - Who wrote the CFX_WAIT tag? is it reliable ? I mean: is it secure ? trojan free ? in the Developer Exchange it doesn't have an author or website. thanks in advance, ~Jaav If you try to send out a ton of mail at once with CFMAIL, for some reason it just stops working and you have to reboot the server or reinstall the dll. Allaire just hasn't quite got thier arms around CFMAIL and CFFTP yet. And they especially didn't have thier arms around it in 4.0. What I found works is putting CFMAIL inside a loop and foregoing the query attribute. Then use the cfx_wait tag between each iteration of the loop. BTW, Tony Aly came up with this solution, so I cannot take credit for it. It works, give it a try. EG., cfloop query="get_email_addresses" cftry cfmail to="#trim(current_email)#" from="#trim(get_email_message.from_vc)#" subject="#trim(get_email_message.subject_vc)#" server="#trim(attributes.mail_server)#"#get_email_message.message_mem# /cfmail CFX_Wait Sleeptime="1" cfcatch CFX_Wait Sleeptime="10" /cfcatch /cftry /cfloop The CFX_WAIT tag is available in the Allaire tag library ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle drivers and 8bit (or multibyte) characters
Hi, I've been having some trouble with a simple content management system written in CF, running on RedHat Linux with Apache and connecting to an Oracle 8i database. When an 8bit character (character with code between 128 and 255 inclusive) is added using one of the web forms, it's gets dropped to the 7bit ASCII range. The Merant ODBC driver and the Oracle 80 Native driver both drop 128 from the 8bit character codes, e.g. chr(233), eacute, becomes chr(105), i. I have worked around this through a combination of using HTMLEditFormat and having some custom character code translations, but it is not ideal as this database may be used to publish to print again in the future (ok, I can un-escape characters, but why should I need to?). I have tried using the Oracle ALTER SESSION statement at the start of transactions to try and change the NLS_LANGUAGE, NLS_TERRITORY and NLS_CHARSET environment variables for the connection, but I think I may have the syntax wrong as I'm getting a "missing or invalid option" error. I've included my statement below, if anyone knows what's wrong, please let me know. Has anyone else experienced this? Is there a workaround? Can I force the drivers to send a correct ALTER SESSION statement when opening a connection? Should this be necessary, i.e. is there something amiss with the Oracle DBMS config that connecting clients are using the default Oracle charset of 7bit ASCII rather than the charset which has been set on the server, ISO-8859-1 (AFAIK using the NLS_LANG environment variable). Thanks Mark now, that alter session statement: --- ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN', NLS_TERRITORY = 'AMERICA', NLS_CHARSET = 'WE8ISO8859P1' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Detect session timeout and prompt messages.
Dear all i was also suffering from such type of priblem. When the user logs in by his login name and password.At this time we create a session variable. And now when the user will request any page we will check that session variable is in existance. we check it at the top of every page or simply we write ur statements in Application.cfm file. creation process: session.started="true" To check session cfif not isDefined("session.started") cflocation template="login.cfm" /cfif Plz give response. Best Regards Muhammad Mumtaz Ahmad software Engineer. AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 "Jon Hall" jonhall@ozliTo: CF-Talk [EMAIL PROTECTED] ne.net cc: Subject: Re: Detect session timeout and prompt messages. 03/29/01 02:51 PM Please respond to cf-talk Just put this in your application.com. cfif isDefined("session.variableName") cflocation template="login.cfm" /cfif jon - Original Message - From: "Rudy Rustam" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 3:58 AM Subject: Detect session timeout and prompt messages. Hi folks, How is it possible to prompt the user a message after session timeout? Or how do we detect whether the session has time out? thanx in adv - Rudy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Welcome to Julia Computer Consulting!
This is to announce the new Julia Computer Consulting's Store...at http://juliagreen.safeshopper.com We're not quite ready yet, but a few more days, check back in for business. If you are a new client or thinking of being one, click on our New Clients section, and read away. First and Second Consultations are free. And we offer the same reprogramming and programming web services we have for five years. An old client?? -- going to send that monthly check? Don't write it out yet! There's a colorful section for you with explanations of the goals of each of your organizations. In a few days, our store will have checkwriting privileges that just require you to void a check in your checkbook. No credit cards yet, we'll just start with the small stuff. And finally, my famous self-programming ASP form that some of you have found to be so helpful, don't waste check paper giving a $10 or $15 donation, or reprogramming money for the form. It'll all be there. Of course, as in all new entries, there are snafus -- there's no shipping or taxes involved in Julia Computer Consulting, so if it shows up as $0 on your invoice, don't worry, it's only $0... And the good news, 5% of all services, if you use the coupon I generated...and if you have a friend or co-worker that could use my services, please send them my way. You are all on my List Management Program within safeshopper! So feel honored, even if you don't have much to give, give a $1 or so just to try it out... Welcome to Julia Computer Consulting! Julia Green Julia Computer Consulting www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 PO Box 279 Watertown MA 02471-0279 Fax: 413-771-0306 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Welcome to Julia Computer Consulting!
How fantastic! I have been waiting for months for an ASP house to write to me to tell me how I can pay them money. Nothing I like more than people I've never heard of telling me I can pay them if I choose. See I worry day and night how I'm going to spend all the money I have. And here, the dingbat Julia Green, ASP programming consultancy is there to help me. And a spammer at that. How lucky we all are! Cheers, Mike Kear AFP Webworks Windsor, NSW, Australia On Thu, 29 Mar 2001, Julia Green wrote: This is to announce the new Julia Computer Consulting's Store...at http://juliagreen.safeshopper.com We're not quite ready yet, but a few more days, check back in for business. If you are a new client or thinking of being one, click on our New Clients section, and read away. First and Second Consultations are free. And we offer the same reprogramming and programming web services we have for five years. An old client?? -- going to send that monthly check? Don't write it out yet! There's a colorful section for you with explanations of the goals of each of your organizations. In a few days, our store will have checkwriting privileges that just require you to void a check in your checkbook. No credit cards yet, we'll just start with the small stuff. And finally, my famous self-programming ASP form that some of you have found to be so helpful, don't waste check paper giving a $10 or $15 donation, or reprogramming money for the form. It'll all be there. Of course, as in all new entries, there are snafus -- there's no shipping or taxes involved in Julia Computer Consulting, so if it shows up as $0 on your invoice, don't worry, it's only $0... And the good news, 5% of all services, if you use the coupon I generated...and if you have a friend or co-worker that could use my services, please send them my way. You are all on my List Management Program within safeshopper! So feel honored, even if you don't have much to give, give a $1 or so just to try it out... Welcome to Julia Computer Consulting! Julia Green Julia Computer Consulting www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 PO Box 279 Watertown MA 02471-0279 Fax: 413-771-0306 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: T-SQL and single quote lists
Jeff, I was just involved in this same discussion on the allaire, er I mean Macromedia Forums. http://forums.allaire.com/devconf/Index.cfm?Message_ID=684281 Basically this is supposed to work: cfset l="'1','2','3','7330'" cfstoredproc datasource="earthquakes" procedure="junk" cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@list" value="#l#" type="In" cfprocresult name="x" resultset="1" /cfstoredproc CREATE PROCEDURE junk @list varchar(100) AS declare @code nvarchar(1000) SET @code = 'SELECT * FROM earthquakes WHERE quakeID IN ('+@list+ ')' exec sp_executeSQL @code Regards, Tim P. - Original Message - From: "Jeff Gombala" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 7:14 PM Subject: Re: T-SQL and single quote lists My mistake in copying the code; CustList and request.CustList are the same, and SQL is actually passing 'AFAF', 'AGAX'. I really think the problem is that the @CustList in T-SQL is not being evaluated in the "IN (@CustList)" statement. Have you had any success in passing a list into a stored procedure... Thanks Jeff - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 7:04 PM Subject: RE: T-SQL and single quote lists OK, so there's some difference between your hardcoded list and what #PreserveSingleQuotes(request.CustList)# evaluates to. Did you output it to the screen? I notice your code includes cfset CustList = "'AFAF', 'AGAX'" but in the cfprocparam tag you specifically reference request.CustList; are they the same? Have you turned on debugging to see what SQL is being sent to your db? -Original Message- From: Jeff Gombala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:56 PM To: CF-Talk Subject: Re: T-SQL and single quote lists If I hard code the list into the "IN" statement I get the results I am looking for it I use the parameter in the "IN" statement as such "IN (@CustList)" the query returns nothing not even any errors. It is almost like @CustList is not being evaluated inside the (). - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 6:47 PM Subject: RE: T-SQL and single quote lists What results are you getting? -Original Message- From: Jeff Gombala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:43 PM To: CF-Talk Subject: T-SQL and single quote lists Is it possible to pass a single quoted list into a SQL server stored procedure for use in an "IN" statement: see the following code... *** PROCEDURE *** CREATE PROCEDURE spMEPFundList @mepid varchar(3), @CustList varchar(400), @StandList varchar(400) AS Select tFund_name, tTicker, Cust=0 from tblFunds where tTicker in (@StandList) UNION Select tFund_Name, tTicker, Cust=1 from tblCustomFunds where tTicker in (@CustList) and txtMEP = @mepid CF CODE cfset CustList = "'AFAF', 'AGAX'" cfstoredproc procedure="insertUser" ... cfprocparam cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" dbvarname="@CustList" value="#PreserveSingleQuotes(request.CustList)#" null="no" cfprocparam /cfstoredproc ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Welcome to Julia Computer Consulting!
Ta Love for the spam, -Original Message- From: Julia Green [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 12:12 To: CF-Talk Subject: Welcome to Julia Computer Consulting! This is to announce the new Julia Computer Consulting's Store...at http://juliagreen.safeshopper.com We're not quite ready yet, but a few more days, check back in for business. If you are a new client or thinking of being one, click on our New Clients section, and read away. First and Second Consultations are free. And we offer the same reprogramming and programming web services we have for five years. An old client?? -- going to send that monthly check? Don't write it out yet! There's a colorful section for you with explanations of the goals of each of your organizations. In a few days, our store will have checkwriting privileges that just require you to void a check in your checkbook. No credit cards yet, we'll just start with the small stuff. And finally, my famous self-programming ASP form that some of you have found to be so helpful, don't waste check paper giving a $10 or $15 donation, or reprogramming money for the form. It'll all be there. Of course, as in all new entries, there are snafus -- there's no shipping or taxes involved in Julia Computer Consulting, so if it shows up as $0 on your invoice, don't worry, it's only $0... And the good news, 5% of all services, if you use the coupon I generated...and if you have a friend or co-worker that could use my services, please send them my way. You are all on my List Management Program within safeshopper! So feel honored, even if you don't have much to give, give a $1 or so just to try it out... Welcome to Julia Computer Consulting! Julia Green Julia Computer Consulting www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 PO Box 279 Watertown MA 02471-0279 Fax: 413-771-0306 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: T-SQL and single quote lists
Sounds like a silly point but try taking the space out between the values in the list. i.e. cfset CustList = "AFAF,AGAX" then try it in the SQL -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 12:31 To: CF-Talk Subject: Re: T-SQL and single quote lists Jeff, I was just involved in this same discussion on the allaire, er I mean Macromedia Forums. http://forums.allaire.com/devconf/Index.cfm?Message_ID=684281 Basically this is supposed to work: cfset l="'1','2','3','7330'" cfstoredproc datasource="earthquakes" procedure="junk" cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@list" value="#l#" type="In" cfprocresult name="x" resultset="1" /cfstoredproc CREATE PROCEDURE junk @list varchar(100) AS declare @code nvarchar(1000) SET @code = 'SELECT * FROM earthquakes WHERE quakeID IN ('+@list+ ')' exec sp_executeSQL @code Regards, Tim P. - Original Message - From: "Jeff Gombala" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 7:14 PM Subject: Re: T-SQL and single quote lists My mistake in copying the code; CustList and request.CustList are the same, and SQL is actually passing 'AFAF', 'AGAX'. I really think the problem is that the @CustList in T-SQL is not being evaluated in the "IN (@CustList)" statement. Have you had any success in passing a list into a stored procedure... Thanks Jeff - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 7:04 PM Subject: RE: T-SQL and single quote lists OK, so there's some difference between your hardcoded list and what #PreserveSingleQuotes(request.CustList)# evaluates to. Did you output it to the screen? I notice your code includes cfset CustList = "'AFAF', 'AGAX'" but in the cfprocparam tag you specifically reference request.CustList; are they the same? Have you turned on debugging to see what SQL is being sent to your db? -Original Message- From: Jeff Gombala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:56 PM To: CF-Talk Subject: Re: T-SQL and single quote lists If I hard code the list into the "IN" statement I get the results I am looking for it I use the parameter in the "IN" statement as such "IN (@CustList)" the query returns nothing not even any errors. It is almost like @CustList is not being evaluated inside the (). - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 6:47 PM Subject: RE: T-SQL and single quote lists What results are you getting? -Original Message- From: Jeff Gombala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:43 PM To: CF-Talk Subject: T-SQL and single quote lists Is it possible to pass a single quoted list into a SQL server stored procedure for use in an "IN" statement: see the following code... *** PROCEDURE *** CREATE PROCEDURE spMEPFundList @mepid varchar(3), @CustList varchar(400), @StandList varchar(400) AS Select tFund_name, tTicker, Cust=0 from tblFunds where tTicker in (@StandList) UNION Select tFund_Name, tTicker, Cust=1 from tblCustomFunds where tTicker in (@CustList) and txtMEP = @mepid CF CODE cfset CustList = "'AFAF', 'AGAX'" cfstoredproc procedure="insertUser" ... cfprocparam cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" dbvarname="@CustList" value="#PreserveSingleQuotes(request.CustList)#" null="no" cfprocparam /cfstoredproc ~~ Structure your ColdFusion code with Fusebox. Get the official book at
R U aggry with me on session concept?
Dear Sir Andy i was also suffering from such type of problem. When the user logs in by his login name and password.At this time we create a session variable. And when the user will request for any page, we will check that session variable is in existance.? we check at the top of every page whether session variable is alive or not ..OR simply we write statements in Application.cfm file. creation variable process: session.started="true" To check session variable existance. cfif not isDefined("session.started") cflocation template="login.cfm" /cfif Plz give response. Best Regards Muhammad Mumtaz Ahmad software Engineer. AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(Admin) Re: Welcome to Julia Computer Consulting!
This was spam and the poster was removed from the lists. Lets not make it into a long OT thread. Thanks This is to announce the new Julia Computer Consulting's Store...at http://juliagreen.safeshopper.com We're not quite ready yet, but a few more days, check back in for business. If you are a new client or thinking of being one, click on our New Clients section, and read away. First and Second Consultations are free. And we offer the same reprogramming and programming web services we have for five years. An old client?? -- going to send that monthly check? Don't write it out yet! There's a colorful section for you with explanations of the goals of each of your organizations. In a few days, our store will have checkwriting privileges that just require you to void a check in your checkbook. No credit cards yet, we'll just start with the small stuff. And finally, my famous self-programming ASP form that some of you have found to be so helpful, don't waste check paper giving a $10 or $15 donation, or reprogramming money for the form. It'll all be there. Of course, as in all new entries, there are snafus -- there's no shipping or taxes involved in Julia Computer Consulting, so if it shows up as $0 on your invoice, don't worry, it's only $0... And the good news, 5% of all services, if you use the coupon I generated...and if you have a friend or co-worker that could use my services, please send them my way. You are all on my List Management Program within safeshopper! So feel honored, even if you don't have much to give, give a $1 or so just to try it out... Welcome to Julia Computer Consulting! Julia Green Julia Computer Consulting www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 PO Box 279 Watertown MA 02471-0279 Fax: 413-771-0306 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: R U aggry with me on session concept?
Yup sounds ok to me. The only thing I do extra is to put some code in my Application.cmf which creates a string containing the CFID and CFTOKEN if the user has session level cookies turned off. I then append this string to every hyperlink, form posting, CFLocation in my site to ensure state is maintained -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 12:39 To: CF-Talk Subject: R U aggry with me on session concept? Dear Sir Andy i was also suffering from such type of problem. When the user logs in by his login name and password.At this time we create a session variable. And when the user will request for any page, we will check that session variable is in existance.? we check at the top of every page whether session variable is alive or not ...OR simply we write statements in Application.cfm file. creation variable process: session.started="true" To check session variable existance. cfif not isDefined("session.started") cflocation template="login.cfm" /cfif Plz give response. Best Regards Muhammad Mumtaz Ahmad software Engineer. AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity revisited
I have a couple of Verity collections which have suddenly stopped opening. The error is "collection failed to open". This isn't a Forum, its a searchable collection. Any ideas on how to unlock it? Here's the error: Error Diagnostic Information Error occurred in tag CFINDEX Collection failed to open: read The error occurred while processing an element with a general identifier of (CFINDEX), occupying document position (6:1) to (12:143). If I use the "xxx_VOpenFile.cfm" file, I get a different error: An error occurred while evaluating the expression: Find( '..', URL.ServerFilePath ) or not FindNoCase( WorkingDirectory, URL.ServerFilePath ) Error near line 7, column 2. Error resolving parameter URL.SERVERFILEPATH The specified URL parameter cannot be found. This problem is very likely due to the fact that you have misspelled the parameter name. I've not changed any locations, nor changed anything on the servers themselves. The boxes were physically moved about two feet each. They were shut down and moved but no other changes were made. And I believe both were accessible after the move (I didn't do the moves so I am a little fuzzy on this point). The cfm files and the oracle db's (located on the 2 servers which were moved) function fine. The db that constitutes one of the collections is reachable and can be queried. The library which makes up the other db can be reached over the network and is intact. And other cf interfaces to oracle db's work fine. All cf services are running. I can find no Verity services. I even created a new collection using the above mentioned library. No luck. Still won't open. If I purge and recreate I can index the collection exactly once. The repair function in CF Admin completes successfully but the collections do not open. It's as if I inadvertently locked the collections and threw away the key. I notice there is a "collectn.lck" file. Should there be an unlock as well? Any ideas? andy trusz ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: R U aggry with me on session concept?
Why don't you just use the premade session.URLToken? Yup sounds ok to me. The only thing I do extra is to put some code in my Application.cmf which creates a string containing the CFID and CFTOKEN if the user has session level cookies turned off. I then append this string to every hyperlink, form posting, CFLocation in my site to ensure state is maintained -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 12:39 To: CF-Talk Subject: R U aggry with me on session concept? Dear Sir Andy i was also suffering from such type of problem. When the user logs in by his login name and password.At this time we create a session variable. And when the user will request for any page, we will check that session variable is in existance.? we check at the top of every page whether session variable is alive or not ...OR simply we write statements in Application.cfm file. creation variable process: session.started="true" To check session variable existance. cfif not isDefined("session.started") cflocation template="login.cfm" /cfif Plz give response. Best Regards Muhammad Mumtaz Ahmad software Engineer. AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: R U aggry with me on session concept?
Sir Andy Again i am disturbing you. If Client's browser cookies are disabled then definetly we have to pass a URLTOKEN or (CFID+CFTOKEN) .So server can recognise the state of client. Now the question is Can we handle it in Application.cfm? If we can handle it then let me know? otherwisw ,we have to pass this string(URLTOKEN) to each link (form or hyperlink). Much thanks for quick respose. Thanks Muhammad Mumtaz Ahmad Software Engineer AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 Andy Ewings andy.e@thoughtbTo: CF-Talk [EMAIL PROTECTED] ubble.net cc: Subject: RE: R U aggry with me on session concept? 03/29/01 04:43 PM Please respond to cf-talk Yup sounds ok to me. The only thing I do extra is to put some code in my Application.cmf which creates a string containing the CFID and CFTOKEN if the user has session level cookies turned off. I then append this string to every hyperlink, form posting, CFLocation in my site to ensure state is maintained -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 12:39 To: CF-Talk Subject: R U aggry with me on session concept? Dear Sir Andy i was also suffering from such type of problem. When the user logs in by his login name and password.At this time we create a session variable. And when the user will request for any page, we will check that session variable is in existance.? we check at the top of every page whether session variable is alive or not OR simply we write statements in Application.cfm file. creation variable process: session.started="true" To check session variable existance. cfif not isDefined("session.started") cflocation template="login.cfm" /cfif Plz give response. Best Regards Muhammad Mumtaz Ahmad software Engineer. AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Detect session timeout and prompt messages.
It works though...I charge for creativity ;-) jon - Original Message - From: "Rudy Rustam" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 5:09 AM Subject: RE: Detect session timeout and prompt messages. but jon, no clue to differentiate whether session timeout or session never set before. -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, 29 March 2001 5:51 PM To: CF-Talk Subject: Re: Detect session timeout and prompt messages. Just put this in your application.com. cfif isDefined("session.variableName") cflocation template="login.cfm" /cfif jon - Original Message - From: "Rudy Rustam" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 3:58 AM Subject: Detect session timeout and prompt messages. Hi folks, How is it possible to prompt the user a message after session timeout? Or how do we detect whether the session has time out? thanx in adv - Rudy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Welcome to Julia Computer Consulting!
I apologize -- I thought since I was offering ColdFusion services, the email I sent was not Exactly spam. I will desist from doing so in the future... - Original Message - From: Michael Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:27 AM Subject: Re: Welcome to Julia Computer Consulting! How fantastic! I have been waiting for months for an ASP house to write to me to tell me how I can pay them money. Nothing I like more than people I've never heard of telling me I can pay them if I choose. See I worry day and night how I'm going to spend all the money I have. And here, the dingbat Julia Green, ASP programming consultancy is there to help me. And a spammer at that. How lucky we all are! Cheers, Mike Kear AFP Webworks Windsor, NSW, Australia On Thu, 29 Mar 2001, Julia Green wrote: This is to announce the new Julia Computer Consulting's Store...at http://juliagreen.safeshopper.com We're not quite ready yet, but a few more days, check back in for business. If you are a new client or thinking of being one, click on our New Clients section, and read away. First and Second Consultations are free. And we offer the same reprogramming and programming web services we have for five years. An old client?? -- going to send that monthly check? Don't write it out yet! There's a colorful section for you with explanations of the goals of each of your organizations. In a few days, our store will have checkwriting privileges that just require you to void a check in your checkbook. No credit cards yet, we'll just start with the small stuff. And finally, my famous self-programming ASP form that some of you have found to be so helpful, don't waste check paper giving a $10 or $15 donation, or reprogramming money for the form. It'll all be there. Of course, as in all new entries, there are snafus -- there's no shipping or taxes involved in Julia Computer Consulting, so if it shows up as $0 on your invoice, don't worry, it's only $0... And the good news, 5% of all services, if you use the coupon I generated...and if you have a friend or co-worker that could use my services, please send them my way. You are all on my List Management Program within safeshopper! So feel honored, even if you don't have much to give, give a $1 or so just to try it out... Welcome to Julia Computer Consulting! Julia Green Julia Computer Consulting www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 PO Box 279 Watertown MA 02471-0279 Fax: 413-771-0306 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Welcome to Julia Computer Consulting!
I apologize -- I thought since I was offering ColdFusion services, the email I sent was not Exactly spam. I will desist from doing so in the future... - Original Message - From: Stephen Galligan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:33 AM Subject: RE: Welcome to Julia Computer Consulting! Ta Love for the spam, -Original Message- From: Julia Green [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 12:12 To: CF-Talk Subject: Welcome to Julia Computer Consulting! This is to announce the new Julia Computer Consulting's Store...at http://juliagreen.safeshopper.com We're not quite ready yet, but a few more days, check back in for business. If you are a new client or thinking of being one, click on our New Clients section, and read away. First and Second Consultations are free. And we offer the same reprogramming and programming web services we have for five years. An old client?? -- going to send that monthly check? Don't write it out yet! There's a colorful section for you with explanations of the goals of each of your organizations. In a few days, our store will have checkwriting privileges that just require you to void a check in your checkbook. No credit cards yet, we'll just start with the small stuff. And finally, my famous self-programming ASP form that some of you have found to be so helpful, don't waste check paper giving a $10 or $15 donation, or reprogramming money for the form. It'll all be there. Of course, as in all new entries, there are snafus -- there's no shipping or taxes involved in Julia Computer Consulting, so if it shows up as $0 on your invoice, don't worry, it's only $0... And the good news, 5% of all services, if you use the coupon I generated...and if you have a friend or co-worker that could use my services, please send them my way. You are all on my List Management Program within safeshopper! So feel honored, even if you don't have much to give, give a $1 or so just to try it out... Welcome to Julia Computer Consulting! Julia Green Julia Computer Consulting www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 PO Box 279 Watertown MA 02471-0279 Fax: 413-771-0306 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (Admin) Re: Welcome to Julia Computer Consulting!
I apologize -- I thought since I was offering ColdFusion services, the email I sent was not Exactly spam. I will desist from doing so in the future... Could I be a member of cftalk again -- I will stop sending anything that might be spam? Julia Green Julia Computer Consulting www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 PO Box 279 Watertown MA 02471-0279 Fax: 413-771-0306 - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:41 AM Subject: (Admin) Re: Welcome to Julia Computer Consulting! This was spam and the poster was removed from the lists. Lets not make it into a long OT thread. Thanks This is to announce the new Julia Computer Consulting's Store...at http://juliagreen.safeshopper.com We're not quite ready yet, but a few more days, check back in for business. If you are a new client or thinking of being one, click on our New Clients section, and read away. First and Second Consultations are free. And we offer the same reprogramming and programming web services we have for five years. An old client?? -- going to send that monthly check? Don't write it out yet! There's a colorful section for you with explanations of the goals of each of your organizations. In a few days, our store will have checkwriting privileges that just require you to void a check in your checkbook. No credit cards yet, we'll just start with the small stuff. And finally, my famous self-programming ASP form that some of you have found to be so helpful, don't waste check paper giving a $10 or $15 donation, or reprogramming money for the form. It'll all be there. Of course, as in all new entries, there are snafus -- there's no shipping or taxes involved in Julia Computer Consulting, so if it shows up as $0 on your invoice, don't worry, it's only $0... And the good news, 5% of all services, if you use the coupon I generated...and if you have a friend or co-worker that could use my services, please send them my way. You are all on my List Management Program within safeshopper! So feel honored, even if you don't have much to give, give a $1 or so just to try it out... Welcome to Julia Computer Consulting! Julia Green Julia Computer Consulting www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 PO Box 279 Watertown MA 02471-0279 Fax: 413-771-0306 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: R U aggry with me on session concept?
As far as I'm aware you have to go through your whole site appending the urltoken to every hyperlink, form posting and cflocation. You can't do this in one hit from within the application.cfm. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 13:12 To: CF-Talk Subject: RE: R U aggry with me on session concept? Sir Andy Again i am disturbing you. If Client's browser cookies are disabled then definetly we have to pass a URLTOKEN or (CFID+CFTOKEN) .So server can recognise the state of client. Now the question is Can we handle it in Application.cfm? If we can handle it then let me know? otherwisw ,we have to pass this string(URLTOKEN) to each link (form or hyperlink). Much thanks for quick respose. Thanks Muhammad Mumtaz Ahmad Software Engineer AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 Andy Ewings andy.e@thoughtbTo: CF-Talk [EMAIL PROTECTED] ubble.net cc: Subject: RE: R U aggry with me on session concept? 03/29/01 04:43 PM Please respond to cf-talk Yup sounds ok to me. The only thing I do extra is to put some code in my Application.cmf which creates a string containing the CFID and CFTOKEN if the user has session level cookies turned off. I then append this string to every hyperlink, form posting, CFLocation in my site to ensure state is maintained -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 12:39 To: CF-Talk Subject: R U aggry with me on session concept? Dear Sir Andy i was also suffering from such type of problem. When the user logs in by his login name and password.At this time we create a session variable. And when the user will request for any page, we will check that session variable is in existance.? we check at the top of every page whether session variable is alive or not .OR simply we write statements in Application.cfm file. creation variable process: session.started="true" To check session variable existance. cfif not isDefined("session.started") cflocation template="login.cfm" /cfif Plz give response. Best Regards Muhammad Mumtaz Ahmad software Engineer. AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:
Re: Dynamic radio button Generation
I think I have posted my answer to somebody's personal mailPlease forward it to list. Otherwise...Jeff, I will write againBut write now I have deleted the mail and answer both. Thanks, -Nilesh Thesia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Welcome to Julia Computer Consulting!
Is that WORLD famous, NATIONALLY famous or the run of the mill IN YOUR OWN COUNTY famous? And finally, my famous self-programming ASP form that some of you have found to be so helpful, don't waste check paper giving a $10 or $15 donation, or reprogramming money for the form. It'll all be there - Original Message - From: "Julia Green" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:12 AM Subject: Welcome to Julia Computer Consulting! This is to announce the new Julia Computer Consulting's Store...at http://juliagreen.safeshopper.com We're not quite ready yet, but a few more days, check back in for business. If you are a new client or thinking of being one, click on our New Clients section, and read away. First and Second Consultations are free. And we offer the same reprogramming and programming web services we have for five years. An old client?? -- going to send that monthly check? Don't write it out yet! There's a colorful section for you with explanations of the goals of each of your organizations. In a few days, our store will have checkwriting privileges that just require you to void a check in your checkbook. No credit cards yet, we'll just start with the small stuff. And finally, my famous self-programming ASP form that some of you have found to be so helpful, don't waste check paper giving a $10 or $15 donation, or reprogramming money for the form. It'll all be there. Of course, as in all new entries, there are snafus -- there's no shipping or taxes involved in Julia Computer Consulting, so if it shows up as $0 on your invoice, don't worry, it's only $0... And the good news, 5% of all services, if you use the coupon I generated...and if you have a friend or co-worker that could use my services, please send them my way. You are all on my List Management Program within safeshopper! So feel honored, even if you don't have much to give, give a $1 or so just to try it out... Welcome to Julia Computer Consulting! Julia Green Julia Computer Consulting www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 PO Box 279 Watertown MA 02471-0279 Fax: 413-771-0306 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Textbox validation
Ooops. Fair enough. Rushed it, didn't test it. Sound familiar? -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 28 March 2001 20:06 To: CF-Talk Subject: RE: Textbox validation Why not use the like operator as in SELECT A FROM B WHERE (((A) Like "*GUITAR*")); which would give any string with guitar in it. OK, first of all, this will spit as the quotes won't work - you should use apostrophies Secondly - how many brackets do you need in a WHERE with one condition? Where A like '*guitar*' will work just fine (or '%guitar%' in SQL Server) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: R U aggry with me on session concept?
Thank u very much My ideas exactly match with u. ok Muhammad Mumtaz Ahmad AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 Andy Ewings andy.e@thoughtbTo: CF-Talk [EMAIL PROTECTED] ubble.net cc: Subject: RE: R U aggry with me on session concept? 03/29/01 05:15 PM Please respond to cf-talk As far as I'm aware you have to go through your whole site appending the urltoken to every hyperlink, form posting and cflocation. You can't do this in one hit from within the application.cfm. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 13:12 To: CF-Talk Subject: RE: R U aggry with me on session concept? Sir Andy Again i am disturbing you. If Client's browser cookies are disabled then definetly we have to pass a URLTOKEN or (CFID+CFTOKEN) .So server can recognise the state of client. Now the question is Can we handle it in Application.cfm? If we can handle it then let me know? otherwisw ,we have to pass this string(URLTOKEN) to each link (form or hyperlink). Much thanks for quick respose. Thanks Muhammad Mumtaz Ahmad Software Engineer AcroLogix (Pvt) Ltd. 106/3, Saint Johns Park Lahore, Pakistan. Tel: 92-42-6664301~04 Fax: 6664307 Andy Ewings andy.e@thoughtbTo: CF-Talk [EMAIL PROTECTED] ubble.net cc: Subject: RE: R U aggry with me on session concept? 03/29/01 04:43 PM Please respond to cf-talk Yup sounds ok to me. The only thing I do extra is to put some code in my Application.cmf which creates a string containing the CFID and CFTOKEN if the user has session level cookies turned off. I then append this string to every hyperlink, form posting, CFLocation in my site to ensure state is maintained -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or
RE: limitations of Access
I am doing a quote for a client that has an existing CF site using Access. They are a professional organisation hosting their own server and I'm trying to get them to steer away from Access, as I think the site has the potential to get more hits than Access can easily handle. So far they are determined to stick with it. I need some ammo... I know Access is not suitable for the job they want it to do, but I'm not sure of the facts and figures. I think someone once before said that Access cannot handle more than 5 concurrent users but I'm not 100% sure. So does anyone have any concrete figures on the capabilities of Access? OK... here's some to start with; Access is a Desktop application and not a Server application Access has a 50 concurrent user limit - it errors as soon as this is broken Access uses Table Locking, not Record Locking - so if you want to update/add a record, no other users can add/update to that table - this is hellishly important! Access's ODBC has memory leaks - it will mean the server must regularly be restarted Access isn't Transact SQL - this means you need 1 CFQuery per query - if you want to do tons of INSERT INTOs in a row, this slows up the template Access runs in the processor memory no matter which server isn't on - this means you can't have a separate database server to handle the SQL and a CF server to handle the templates I know there's more, but I just can't think of them... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: limitations of Access
Others off the top of my head - 1) Access Transaction/Rollback support is shaky at best. 2) If a database transaction screws up, it's very easy to corrupt the entire database and leave it unuseable 3) Those DAMN .LDB FILES! -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 13:56 To: CF-Talk Subject: RE: limitations of Access I am doing a quote for a client that has an existing CF site using Access. They are a professional organisation hosting their own server and I'm trying to get them to steer away from Access, as I think the site has the potential to get more hits than Access can easily handle. So far they are determined to stick with it. I need some ammo... I know Access is not suitable for the job they want it to do, but I'm not sure of the facts and figures. I think someone once before said that Access cannot handle more than 5 concurrent users but I'm not 100% sure. So does anyone have any concrete figures on the capabilities of Access? OK... here's some to start with; Access is a Desktop application and not a Server application Access has a 50 concurrent user limit - it errors as soon as this is broken Access uses Table Locking, not Record Locking - so if you want to update/add a record, no other users can add/update to that table - this is hellishly important! Access's ODBC has memory leaks - it will mean the server must regularly be restarted Access isn't Transact SQL - this means you need 1 CFQuery per query - if you want to do tons of INSERT INTOs in a row, this slows up the template Access runs in the processor memory no matter which server isn't on - this means you can't have a separate database server to handle the SQL and a CF server to handle the templates I know there's more, but I just can't think of them... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfugmay2000 :: VCalendar :: Outlook :: Mime Type 97
sorry to keep going on... i have OutLook 2000, also a mime type for vCalendar File. so every thing seems to work for me. but on the OutLook 97 machines they don't have the VCS extension mapped. so i tried to create it manually but it didn't work. i have looked at the docs that came with it am getting no where. i am also going to want to use this to create part of an app to check out company resources through out look. how would i invite another user to a meeting? any advice, url's, help would be great! wish there was more info on this Thank You -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 9:40 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: cfugmay2000 :: VCalendar :: Outlook :: permission to use hello all. i found some code i must have grabbed from some cfug zip for may 2000. it has a neat vcalendar to insert instances from a db into your outlook calendar. just wanted to know if there are more examples like this. Also if i can modify the code for my own use in local Intranet apps"? if you know who did this i would appreciate the contact so i can ask permission to use. also if you have other examples of CF integrating with outlook, i would love to see it. If you're talking about the vCalendar/iCalendar/vCard example from the DC CFUG sponsored by Fig Leaf Software, you're free to use the code however you like. Fig Leaf Software has always released source code shown at CFUGs for public use. Enjoy! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Welcome to Julia Computer Consulting!
Please say that he list accidentally got CC'd on this one... by looking at the message header it doesn't look like it, but who knows, maybe she was just tired. Hatton -Original Message- Subject: Welcome to Julia Computer Consulting! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Layered Security
Maybe I'm missing something or don't understand nt/active directories (we haven't decided which system we'll use but we're leaning toward nt) authentification. I thought that username and password will be checked against a database = successful/unsuccessful login. People can be assigned to group permissions. My teachers will log in on one system- but how do I "connect" the nt/active directories login id with the unique number that was given to them in the 2nd database? The teacherID from the nt/active directories login is not the same as the the 2 fields that make up the teacherID in the db2 database. So my question is more of designing how to connect 2 dissimilar ids. Do I pass the variable username. Do I pass the nt Id # and add a field for it in my other database? Is there a way to add the TeacherID/SchoolID to be part of the nt login/verification? Date: Wed, 28 Mar 2001 08:21:10 -0700 From: "Garza, Jeff" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: layered security Message-ID: 34E9FDD74801D511862A00508B670BD30E87DA@GILEX01 Take a look at using views. You can assign permissions to the view and have it select only those students that belong to that teacher. That way you won't have the added security on the second table. Is this what you were looking for??? Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:08 AM To: CF-Talk Subject: layered security I need to make a "layered"login to a secure site. We are using a SQL2000 database on Windows2000 machine. I assume that I will have the user authenicate through the active directory and be recognized as being part of a "group" and sent to a specialized menu. (am I correct in that assumption?) One group will be for teachers. These teachers will then need to access their students and only their students. This info comes from a second db2 database. Two fields make up the unique number (teacherID and SchoolID). Should I make a 2nd login that will query only their students? I don't want to "overload" the teachers with logins, but I don't know if there is a way to put it into the original login. Any ideas on how to make this "user friendly"? I do have the ability to store the teacher id information into our sql warehouse. does that help me any? Thanks, j Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: limitations of Access
Are these concerns specific to Access 97? What about Access 2000? I realize that in both cases we're talking about a "desktop application," but small differences could make a big difference to a small company trying to decide. -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Access is a Desktop application and not a Server application Access has a 50 concurrent user limit - it errors as soon as this is broken Access uses Table Locking, not Record Locking - so if you want to update/add a record, no other users can add/update to that table - this is hellishly important! Access's ODBC has memory leaks - it will mean the server must regularly be restarted Access isn't Transact SQL - this means you need 1 CFQuery per query - if you want to do tons of INSERT INTOs in a row, this slows up the template Access runs in the processor memory no matter which server isn't on - this means you can't have a separate database server to handle the SQL and a CF server to handle the templates ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript to set cfvariable?
Or in a gif data-pipe if you want to get tricky: http://www.depressedpress.com/DepressedPress/Content/ColdFusio n/Essays/GIFAsPipe/ (watch the line wrap) Now, that's worth taking a look at! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: database design question
Um, that's why I said: "and there certainly could be depending on the application - ie. What school did you graduate from? vs. What school(s) have you attended" And that's my point. For ONE school, a separate relational table is unnecessary. grr!! it does fit in right. it said GRADUATED FROM. i've never known of anyone who has graduated from more than one high school :P - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 10:36 PM Subject: RE: database design question I think your highschoolrelations table is overkill when there is only a 1-1 relationship. If there were a small, finite number of schools, then yes, a table of ids and names of those schools would be useful and you would populate the highschool field of the user with that schools id. But if there could be more than one school per user (and there certainly could be depending on the application - ie. What school did you graduate from? vs. What school(s) have you attended) then your relations table fits the bill nicely. Here is the question. Diod they graduate from high school? If so, which high school? Here is the inference. Those who have a high school name went to high school, and those who didn't have a high school name did not go to high school. i know it's a big DUH, but it's important. here's how i would dersign the database. I would treat the high school name as a city, state or zip code, because there are thousands or gagillions of em. So, i would put them in the same table as the client name so the client table would have another field called high school. if it's null, then that means that they did not graduate from high school, and u can use that as a condition when u need that information. IF there were like only 10 high schools in the world, I would go about a different approach. I would have 3 tables. 1 table has the name of all the clients and their clientID (increment). the 2nd table has the list of all high schools and their highschoolID (increment). The third table builds the relationship between the clients and their school. the third table would have 3 fields. The HighSchoolrelationsID, ClientID, and highschoolID. So if client Amy Gershen had a clientID of 3, and her high school James Brown High had a highschoolID of 12, this is the informationt hat would go into the Highschoolrelations table. HighschoolrelationsID ClientID HighSchoolID - 1 3 12 -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 3:25 PM To: CF-Talk Subject: database design question hello, I am putting together a database and I cannot decide what to do with the Education Table. I have 1000 clients who I need to enter their education level. For example, did they graduate from highschool and if so, what is the name of their highschool. Should I put that info on the same table or create a new table with the clientid and the name of the highchool attended if they did attend. I know that if I put it all on one table there will be a lot of empty fields but I also didnt know if it was "wasteful" to create such a small table just for highschool name. What do you think? Will the system slow down if I have ALOT of tables? Thanks, Julie From: "Julia Green" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: CF Books Date: Tue, 20 Mar 2001 20:00:26 -0500 Julie -- This is late in coming, bu I have a great Adobe Acrobat Documentation book: http://www.allaire.com/documents/cf45docs/acrobatdocs/45dwa.pdf Julia Green Julia Computer Consulting PO Box 279 Watertown MA 02471-0279 http://www.juliagreen.com Email: [EMAIL PROTECTED] Phone: 617-926-3413 FAX: 413-771-0306 - Original Message - From: Julie Clegg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 19, 2001 11:05 AM Subject: CF Books Hello, Can anyone recommend a good CF developers book...we will be building a new application using CF 4.5 and I need something that will be a good reference book for a new CF developer! Thanks, Julie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: limitations of Access
According to MS, Access 2000 can handle 356 (I believe) concurrent users and 10K rows. But I've seen folks here on the list claim to push the number of rows way past 10K. I'd only use small web apps on it. The latest MDAC has much less problems with memory leaks, as far as I know. Dave - Original Message - From: "Owen Leonard" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 8:47 AM Subject: RE: limitations of Access Are these concerns specific to Access 97? What about Access 2000? I realize that in both cases we're talking about a "desktop application," but small differences could make a big difference to a small company trying to decide. -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Access is a Desktop application and not a Server application Access has a 50 concurrent user limit - it errors as soon as this is broken Access uses Table Locking, not Record Locking - so if you want to update/add a record, no other users can add/update to that table - this is hellishly important! Access's ODBC has memory leaks - it will mean the server must regularly be restarted Access isn't Transact SQL - this means you need 1 CFQuery per query - if you want to do tons of INSERT INTOs in a row, this slows up the template Access runs in the processor memory no matter which server isn't on - this means you can't have a separate database server to handle the SQL and a CF server to handle the templates ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Fix your servers - +.htr
For anyone who may have missed the huge thread a few months back I just wanted everyone to please check to make sure your IIS web server has all the latest patches or you have removed: htr htw idc ida printer extensions from the web server. Every single IIS 4 and IIS 5 web server is installed by default with a number of bugs that allow a hacker to take over your web server very very easily. You can test your web server by going to any page and adding +.htr to the end of the page. http://myserver.com/index.cfm+.htr View the source and if you see CF code, you are vulnerable. Further reading is here http://www.wittys.com/files/mab/iis-hacking.html The reason I posted this is that for the last three days in a row I have found a high profile CF based web site (a financial one even) with this bug each day! I wasn't even looking for them, it just habit to check now. I will not say who they are, but todays site, many of you probably had in your inbox this morning. jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: limitations of Access
Since they're running their own server, you should give them 3 quotes: 1. Access now. 2. Client/server DB now 3. Client/server DB later along with your observation that you believe their site will soon get more traffic than Access can handle, and let them decide. best, paul At 02:32 PM 3/29/01 +0800, you wrote: Hi all, I am doing a quote for a client that has an existing CF site using Access. They are a professional organisation hosting their own server and I'm trying to get them to steer away from Access, as I think the site has the potential to get more hits than Access can easily handle. So far they are determined to stick with it. I need some ammo... I know Access is not suitable for the job they want it to do, but I'm not sure of the facts and figures. I think someone once before said that Access cannot handle more than 5 concurrent users but I'm not 100% sure. So does anyone have any concrete figures on the capabilities of Access? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript to set cfvariable?
Or in a gif data-pipe if you want to get tricky: http://www.depressedpress.com/DepressedPress/Content/ColdFusio n/Essays/GIFAsPipe/ (watch the line wrap) Now, that's worth taking a look at! Yes, but what are the baby pictures to do with it??? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Automate FTP
So are you telling me I should enter the following? at 02:00 /every:M,T,W,Th,F,S,Su ftpcmd.bat best, paul At 11:00 AM 3/29/01 +, you wrote: type at /? at the command prompt to find out Alternatively, in Windows2000 use the scheduled tasks control panel Mark At 01:21 AM 3/29/2001, you wrote: I've created a FTP batch file, ftpcmd.bat: %windir%\ftp.exe -s:%f0 goto done open financialcontent.com (user name omitted) (password omitted) lcd d:\website\htdocs\stockgolf\htdocs\data ascii get eod.txt bye :done @echo off cls exit So how do I schedule this with AT? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fix your servers - +.htr (not only but also)
While people are there, you might want to see what appending '?mode=debug' does, and setting the debug settings in administrator to be minited to the localhost IP :-) -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 3:25 PM To: CF-Talk Subject: OT: Fix your servers - +.htr For anyone who may have missed the huge thread a few months back I just wanted everyone to please check to make sure your IIS web server has all the latest patches or you have removed: htr htw idc ida printer extensions from the web server. Every single IIS 4 and IIS 5 web server is installed by default with a number of bugs that allow a hacker to take over your web server very very easily. You can test your web server by going to any page and adding +.htr to the end of the page. http://myserver.com/index.cfm+.htr View the source and if you see CF code, you are vulnerable. Further reading is here http://www.wittys.com/files/mab/iis-hacking.html The reason I posted this is that for the last three days in a row I have found a high profile CF based web site (a financial one even) with this bug each day! I wasn't even looking for them, it just habit to check now. I will not say who they are, but todays site, many of you probably had in your inbox this morning. jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: limitations of Access
I am not totally 100% sure on this, however I do know that we were running an auction site using Access that always was running at least 30 concurrent sessions at a time with 5 items in the database and did not appear to have a major problem. We did upscale the site to Oracle however just to NOT have any possible problems. I know this is not what you wanted to hear, but it is some proof that the low numbers may not be totally accurate. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:33 AM To: CF-Talk Subject: limitations of Access Hi all, I am doing a quote for a client that has an existing CF site using Access. They are a professional organisation hosting their own server and I'm trying to get them to steer away from Access, as I think the site has the potential to get more hits than Access can easily handle. So far they are determined to stick with it. I need some ammo... I know Access is not suitable for the job they want it to do, but I'm not sure of the facts and figures. I think someone once before said that Access cannot handle more than 5 concurrent users but I'm not 100% sure. So does anyone have any concrete figures on the capabilities of Access? Thanks, K. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ultra Dev 4
I use Studio is it a good idea to move to UltraDev? Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Mail is spooled, but never sent
I am having a strange problem. Mail is spooled to the cfusion/mail/spool directory, but it is never sent. If I stop and start the ColdFusion services, then the mail that is currently spooled will be sent, but no other mail is sent until the ColdFusion services are stopped and started again. Any insight would be greatly appreciated. Take Care, Mike Mike Cranford Air Line Pilots Association, Int'l. Strategic Systems Support Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [RE: SQL Business Dates]
Alex - yes, you can call a function from within a SQL statement select countBusDays(dateasgn, '#form.startdate#', '#form.enddate#') "FUNCTION" from dual is one example Brian -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 3:15 PM To: CF-Talk Subject: Re: [RE: SQL Business Dates] thanks but dateasgn and datecomp will always be a business date. the difference between them is the problem nights and weekends get included. Question: Can I write a function in SQLServer like in PLSQL and call that function from within an SQL query? "Hayes, David" [EMAIL PROTECTED] wrote: Look at the DATEPART function. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:31 PM To: CF-Talk Subject: SQL Business Dates I have a query ... SELECT AVG(DATEDIFF(minute, dateasgn, datecomp)) AS diff FROM tblprob WHERE priority = 'urgent' AND datecomp IS NOT NULL AND status = 'closed' AND dateasgn = '#form.startdate#' AND dateasgn = '#form.endDate#' but I only want the business dates (no weekends or nights; just 9AM to 5PM Mon to Fri) This is in SQLServer. Any help appreciated. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ultra Dev 4
not really. I use Ultradev to edit my page layout, not to code. I feel safe (with about a 10% reservation factor) using Ultradev with code that has been riddled with CF code. I've only seen a small percentage of F***ups since Ultradev 4. When I decide in the middle of things that my table needs 5 more colmns, 3 additional rowspans and a few more nested form elemetns, I just might try it in UD first. However, it can't beat CFStudio for pure raw coding in this girls opinion. |-Original Message- |From: Rick Eidson [mailto:[EMAIL PROTECTED]] |Sent: Thursday, March 29, 2001 9:39 AM |To: CF-Talk |Subject: Ultra Dev 4 | | |I use Studio is it a good idea to move to UltraDev? | | |Rick | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Ultra Dev 4
I agree with that assumption 99.9% =) i've had about 20% of my stuff F*#**d up in UD4 though i found it butchers the best when you drag and drop or it does not butcher it dpulicates your code like an extra 4 times lol as you move things around Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to it - Original Message - From: "Patricia Lee" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 10:17 AM Subject: RE: Ultra Dev 4 not really. I use Ultradev to edit my page layout, not to code. I feel safe (with about a 10% reservation factor) using Ultradev with code that has been riddled with CF code. I've only seen a small percentage of F***ups since Ultradev 4. When I decide in the middle of things that my table needs 5 more colmns, 3 additional rowspans and a few more nested form elemetns, I just might try it in UD first. However, it can't beat CFStudio for pure raw coding in this girls opinion. |-Original Message- |From: Rick Eidson [mailto:[EMAIL PROTECTED]] |Sent: Thursday, March 29, 2001 9:39 AM |To: CF-Talk |Subject: Ultra Dev 4 | | |I use Studio is it a good idea to move to UltraDev? | | |Rick | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ultra Dev 4
Or even better, use fusebox and only use ultradev on the dsp_*.cfm files. -- Gavin Lilley Internet / Intranet Developer http://halesowen.ac.uk -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 16:18 To: CF-Talk Subject: RE: Ultra Dev 4 not really. I use Ultradev to edit my page layout, not to code. I feel safe (with about a 10% reservation factor) using Ultradev with code that has been riddled with CF code. I've only seen a small percentage of F***ups since Ultradev 4. When I decide in the middle of things that my table needs 5 more colmns, 3 additional rowspans and a few more nested form elemetns, I just might try it in UD first. However, it can't beat CFStudio for pure raw coding in this girls opinion. |-Original Message- |From: Rick Eidson [mailto:[EMAIL PROTECTED]] |Sent: Thursday, March 29, 2001 9:39 AM |To: CF-Talk |Subject: Ultra Dev 4 | | |I use Studio is it a good idea to move to UltraDev? | | |Rick | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Questions about calendaring [Was: Re: VCalendar :: Outlook :: Help Needed
From: "Lawrence B. Afrin, M.D." [EMAIL PROTECTED] A long time ago (in a galaxy far, far away :-) I wrote a CF app to read a vCalendar export of calendar info from the utility in the Netscape Calendar Server package that does that sort of thing. It allowed web users to see schedules of some of our public resources without their having to login to the Cal Server. Ultra-primitive, but it worked. Oh great Jedi, would you share the secrets of the Source with a simple novice such as I? -- Larry W. Virden URL: mailto:[EMAIL PROTECTED] URL: http://www.purl.org/net/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ultra Dev 4
Welll - I've used both, and prefer Studio for writing the hardcore CFML, and UltraDev / Dreamweaver for tarting it up before / after. That said, I was in UltraEDIT all day today debugging CFML, so YMMV :-) Its a bit of 6 of one, half a dozen of the other really... All IMHO of course ;-) -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 3:39 PM To: CF-Talk Subject: Ultra Dev 4 I use Studio is it a good idea to move to UltraDev? Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
QUESTION: Sybase's equivalent of FULL JOIN and OUTER JOIN
I'm working on an app utilizing a Sybase db. This is my first time using Sybase -- having come from a SQLServer and Oracle background, I'm at a loss as to how to execute a FULL JOIN and and OUTER JOIN. Any ideas? The following is returning this error: Error at line 3. Syntax error near 'a'. CREATE VIEW VW_RESULTS AS( select a.last_first, a.company, a.title, a.id as AID a.member_type, b.activity_type, b.description, c.mailing_lists from NAME a FULL JOIN ACTIVITY b ON a.id = b.id FULL JOIN LISTS c ON a.id = c.id ) thanks, -e E. Ellen Grossman Corporate Web Development USinternetworking, Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Single ODBC Datasource
Isn't there a way to create a singular ODBC Datasource that could access any database on a SQL Server? In the past we've always created a sperate ODBC Datasource for every database, and while this isn't necessarily a bad thing, I'd like to be able to access any database... Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: limitations of Access
Can I possibly add a question to this string ... Larry, you mentioned that: we were running an auction site using Access that always was running at least 30 concurrent sessions at a time with 5 items in the database and did not appear to have a major problem. I don't see how that is possible - but am hoping that you can teach me something here. At the last place I worked, when more than one person accessed the same Access file, they were simply locked out. This would frequently happen when a salesperson tried to get into the product database to answer a customer query, but a product manager would already be in the file. - major disputes in the office when the customer can hear every word down the line :-) You mention "30 concurrent sessions" by which I take it to mean that 30 users can be within the same file at the same moment in time. Surely, with a file-based package, this is not possible? If you can indeed do this, I would greatly appreciate any info you can give me to solve such a problem. Kindest regards, Derek BTW - a leap from Access to Oracle A major leap!! :-) IT Star Web Design, Hosting, Database Integration and Internet Marketing http://www.itstar.co.uk/ [EMAIL PROTECTED] -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 15:40 To: CF-Talk Subject: RE: limitations of Access I am not totally 100% sure on this, however I do know that we were running an auction site using Access that always was running at least 30 concurrent sessions at a time with 5 items in the database and did not appear to have a major problem. We did upscale the site to Oracle however just to NOT have any possible problems. I know this is not what you wanted to hear, but it is some proof that the low numbers may not be totally accurate. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:33 AM To: CF-Talk Subject: limitations of Access Hi all, I am doing a quote for a client that has an existing CF site using Access. They are a professional organisation hosting their own server and I'm trying to get them to steer away from Access, as I think the site has the potential to get more hits than Access can easily handle. So far they are determined to stick with it. I need some ammo... I know Access is not suitable for the job they want it to do, but I'm not sure of the facts and figures. I think someone once before said that Access cannot handle more than 5 concurrent users but I'm not 100% sure. So does anyone have any concrete figures on the capabilities of Access? Thanks, K. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Single ODBC Datasource
yup. When you creat a datasource you are only pointing to a default database. You can be explicit in your SQL statements to access any database registered within the SQL Server like so. SELECT * FROM database.owner.table -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 17:04 To: CF-Talk Subject: Single ODBC Datasource Isn't there a way to create a singular ODBC Datasource that could access any database on a SQL Server? In the past we've always created a sperate ODBC Datasource for every database, and while this isn't necessarily a bad thing, I'd like to be able to access any database... Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: limitations of Access
MSDE ??? instead of access 2000? - Original Message - From: "Owen Leonard" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 5:47 AM Subject: RE: limitations of Access Are these concerns specific to Access 97? What about Access 2000? I realize that in both cases we're talking about a "desktop application," but small differences could make a big difference to a small company trying to decide. -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Access is a Desktop application and not a Server application Access has a 50 concurrent user limit - it errors as soon as this is broken Access uses Table Locking, not Record Locking - so if you want to update/add a record, no other users can add/update to that table - this is hellishly important! Access's ODBC has memory leaks - it will mean the server must regularly be restarted Access isn't Transact SQL - this means you need 1 CFQuery per query - if you want to do tons of INSERT INTOs in a row, this slows up the template Access runs in the processor memory no matter which server isn't on - this means you can't have a separate database server to handle the SQL and a CF server to handle the templates ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cold Fusion Forums
Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:QUESTION: Sybase's equivalent of FULL JOIN and OUTER JOIN
Hope this helps. FYI: Sybase has a site with info and downloads for a lot of the help you might need. Also, check around for Adaptive Server Enterprise Transact-SQL User's Guide -- it may be sitting on a shelf in the db admin's office. SELECT a.last_first, a.company, a.title, a.id as AID a.member_type, b.activity_type, b.description, c.mailing_lists FROMNAME a, activity b, lists c WHERE a.id = b.id AND a.id = c.id Left outer join: a.id *= b.id right outer join: a.id =* b.id Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:QUESTION: Sybase's equivalent of FULL JOIN and OUTER JOIN Author: [EMAIL PROTECTED] Date: 3/29/01 10:56 AM I'm working on an app utilizing a Sybase db. This is my first time using Sybase -- having come from a SQLServer and Oracle background, I'm at a loss as to how to execute a FULL JOIN and and OUTER JOIN. Any ideas? The following is returning this error: Error at line 3. Syntax error near 'a'. CREATE VIEW VW_RESULTS AS( select a.last_first, a.company, a.title, a.id as AID a.member_type, b.activity_type, b.description, c.mailing_lists from NAME a FULL JOIN ACTIVITY b ON a.id = b.id FULL JOIN LISTS c ON a.id = c.id ) thanks, -e E. Ellen Grossman Corporate Web Development USinternetworking, Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Correct Me if im wrong. PLEASE!
but this statement DOES Say "Select ONLY the ContestantID's that have 2 or more DIFFERANT EventID's in the ResultsManager." SELECT ContestantID FROM ResultsManager GROUP BY ContestantID HAVING COUNT (EventID) = 2 OR does this just pull all the contestantID's that are in there twice wether they have two DIFFERANT Event's or not? Could someone please help me out here. im trying to get ONLY Those that have two differant EventID's in this table. Thanks!, Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Single ODBC Datasource
I dont think you can do that in CF4.5 This is a new feature in CF5.0 You can even create odbc connections on the fly in your own code. Very exciting... very scary too!!! HTH! -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:04 AM To: CF-Talk Subject: Single ODBC Datasource Isn't there a way to create a singular ODBC Datasource that could access any database on a SQL Server? In the past we've always created a sperate ODBC Datasource for every database, and while this isn't necessarily a bad thing, I'd like to be able to access any database... Joseph E. Sheble [EMAIL PROTECTED] ===Wizaerd's Realm http://www.wizaerd.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF in Performance Monitor Database
I'm running performance monitor on NT to try to pinpoint where the CF server is being stressed. It seems everytime someone hits the site, the AVG DB time(msec) jumps up anywhere to 40 - 90 on the chart. Everything else stays low on the chart. Our database server is not on the same machine as the CF Server. I was wondering if the numbers I see in performance monitor for this is pointing me to the direction that I need to investigate, which is our database and/or queries ? Thanks, Tracy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
www.simplemessageboard.com/ www.forumspot.org http://www.e-zonemedia.com/fusetalk/index.cfm The first two are free. The third one is commercial but worth a look at. It also includes real-time chat. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "S R" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 11:31 AM Subject: Cold Fusion Forums Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Cold Fusion Forums]
forumspot.org phorum.org coolservlets.com/jive/ "S R" [EMAIL PROTECTED] wrote: Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Single ODBC Datasource
Duh... i was way off... of course you can... just defined your db in your query. sorry about that! -Original Message- From: Andres Leon Sent: Thursday, March 29, 2001 11:43 AM To: CF-Talk Subject: RE: Single ODBC Datasource I dont think you can do that in CF4.5 This is a new feature in CF5.0 You can even create odbc connections on the fly in your own code. Very exciting... very scary too!!! HTH! -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:04 AM To: CF-Talk Subject: Single ODBC Datasource Isn't there a way to create a singular ODBC Datasource that could access any database on a SQL Server? In the past we've always created a sperate ODBC Datasource for every database, and while this isn't necessarily a bad thing, I'd like to be able to access any database... Joseph E. Sheble [EMAIL PROTECTED] ===Wizaerd's Realm http://www.wizaerd.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Correct Me if im wrong. PLEASE!
Jay, Try the query with DISTINCT: SELECT ContestantID FROM ResultsManager GROUP BY ContestantID HAVING COUNT (DISTINCT EventID) = 2 Cheers, Seva Petrov -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:37 AM To: CF-Talk Subject: Correct Me if im wrong. PLEASE! but this statement DOES Say "Select ONLY the ContestantID's that have 2 or more DIFFERANT EventID's in the ResultsManager." SELECT ContestantID FROM ResultsManager GROUP BY ContestantID HAVING COUNT (EventID) = 2 OR does this just pull all the contestantID's that are in there twice wether they have two DIFFERANT Event's or not? Could someone please help me out here. im trying to get ONLY Those that have two differant EventID's in this table. Thanks!, Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Multi year data entry app - database design questions
I've got a data entry application which collects data based on fiscal year. What are there any benefits of keeping this multi-year data in the same database vis a vis separating fiscal years into their own databases? I've always chosen to split up the database - otherwise you're doubling db size with little if any interaction with half of it (the old fiscal year), which considerably slows things down when querying I would think. The only reason I see to keep the data within one database is for multi-year research on the data. It seems that quering one database with multiple fiscal years would be easier than doing union queries across multiple databases. For this reason I'm considering keeping it all together in one db. Anyone maintain such a system? Any thoughts greatly appreciated. Currently using MS Access and eventually migrating to SQL Server. Thanks, Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Money DataType in SQL
ok, just wondering if anyone knows thisI have a money datatype fieldwould anyone happen to know if i should treat this datatype as a string or an integer value? (for inserting purposes) thanks kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Correct Me if im wrong. PLEASE!
using HAVING COUNT (DISTINCT EventID) =2 still returns the same results as w/o the DISTINCT part. doesn't make sense to me. this should return about 10 or 11 records and it returns close to 40 or 50. Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com - Original Message - From: "Seva Petrov" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 9:58 AM Subject: RE: Correct Me if im wrong. PLEASE! Jay, Try the query with DISTINCT: SELECT ContestantID FROM ResultsManager GROUP BY ContestantID HAVING COUNT (DISTINCT EventID) = 2 Cheers, Seva Petrov -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:37 AM To: CF-Talk Subject: Correct Me if im wrong. PLEASE! but this statement DOES Say "Select ONLY the ContestantID's that have 2 or more DIFFERANT EventID's in the ResultsManager." SELECT ContestantID FROM ResultsManager GROUP BY ContestantID HAVING COUNT (EventID) = 2 OR does this just pull all the contestantID's that are in there twice wether they have two DIFFERANT Event's or not? Could someone please help me out here. im trying to get ONLY Those that have two differant EventID's in this table. Thanks!, Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF in Performance Monitor Database
It's hard to tell anything from the performance monitor alone, without knowing what your site does, what the specs on your machines are, etc. And what your database is -- 90ms is a long time on SQL2000, but not unexpected on MSAccess. However -- if you are getting that spike with EVERY hit (and not let's say just an initial login, etc.) it does suggest that you could benefit from caching, either caching pages or server queries. If I were debugging the bottleneck I would enable the display of SQL queries (and time breakdowns) and go through page by page seeing if I could cache the query or page, or push complicated queries into stored procedures. And I would pay more attention to the ms count on the debugging breakdown than on the CF perfomance monitor. In my experience perfmon is a great tool for rough analysis, but not so good for fine tuning. Michael Caulfield Cognitive Arts -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 10:40 AM To: CF-Talk Subject: CF in Performance Monitor Database I'm running performance monitor on NT to try to pinpoint where the CF server is being stressed. It seems everytime someone hits the site, the AVG DB time(msec) jumps up anywhere to 40 - 90 on the chart. Everything else stays low on the chart. Our database server is not on the same machine as the CF Server. I was wondering if the numbers I see in performance monitor for this is pointing me to the direction that I need to investigate, which is our database and/or queries ? Thanks, Tracy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Forums
hello... well, im not sure what you want exactly, but i have been working on a phorum system and I'm just about to take it into Alpha release. anyway, if you are interested, please check out http://www.cfphorum.com Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:31 AM To: CF-Talk Subject: Cold Fusion Forums Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql learning
Just wondering if anyone could refer some good sites with SQL training and information. I know the basics of SQL, can get info in and out of it, just wanting to learn some more about it and learn about more of its features. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Forums
FUSETALK!!!FUSETALK!!!FUSETTAAALLKK!! Its the best! Totally the best! :) The things this board can do..its amazing! Any feature you could want..you got it! There are avatar pics, private messaging, realtime Chat functions! You can hook the registration for the database out to a secondary datastore..an existing user database in other words.. its got everything! I am totally totally pleased with this thing :) www.carigamer.com/forum I can't wait for when we start advertising and throw our next tournaments to see the feedback from the users :) -Gel www.carigamer.com Island Gaming At Its Best!(tm) "The Surgeon General Advises That Playing Violent Video Games Is NOT Harmful To Your Health"-Surgeon General's Report 2001. - Original Message - From: "S R" [EMAIL PROTECTED] Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Correct Me if im wrong. PLEASE!
It creates a count, by contestantID, of the number of records that have an eventID in them, irrespective of the eventID value (or the distinctiveness of it). I would think the COUNT (DISTINCT EventID) would work; it did on my test. Take a step back and just look at the results of SELECT ContestantID, count(eventID) FROM ResultsManager GROUP BY ContestantID I would also take a look at the data in resultsManager. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:20 AM To: CF-Talk Subject: Re: Correct Me if im wrong. PLEASE! using HAVING COUNT (DISTINCT EventID) =2 still returns the same results as w/o the DISTINCT part. doesn't make sense to me. this should return about 10 or 11 records and it returns close to 40 or 50. Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com - Original Message - From: "Seva Petrov" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 9:58 AM Subject: RE: Correct Me if im wrong. PLEASE! Jay, Try the query with DISTINCT: SELECT ContestantID FROM ResultsManager GROUP BY ContestantID HAVING COUNT (DISTINCT EventID) = 2 Cheers, Seva Petrov -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:37 AM To: CF-Talk Subject: Correct Me if im wrong. PLEASE! but this statement DOES Say "Select ONLY the ContestantID's that have 2 or more DIFFERANT EventID's in the ResultsManager." SELECT ContestantID FROM ResultsManager GROUP BY ContestantID HAVING COUNT (EventID) = 2 OR does this just pull all the contestantID's that are in there twice wether they have two DIFFERANT Event's or not? Could someone please help me out here. im trying to get ONLY Those that have two differant EventID's in this table. Thanks!, Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Javascirpt problem on CF
This is my code with Javascript can you pelase help me figure out what's wrong? i know that Javascript is a client side while CF is server side. Can you please help me out to figure what changes do i need to do on my code? What i'm trying to do on my code is they need to click on the checkbox and i will count how many checkboxes they already clicked on and they should have a max of 13 clicks. !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head title/title link href="../Styles/css.css" rel="stylesheet" type="text/css" script language="JavaScript" var cnt_chk = 0; var cnt_sel = 0; function validate(obj){ len = parseFloat(obj.clen.value) cnt_chk = 0 for(i=1; i=len; i++) { byVal = eval("obj.o" + i + ".checked") if(byVal == true) { cnt_chk++ } } if(cnt_chk == 0) { alert("You must select a Candidate"); return false; } if(cnt_chk = 14 OR cnt_chk =12) { alert("You must select exactly 13 Candidates"); return false; } } function fnCountNatin(obj){ cnt_sel = 0; len = parseFloat(document.frmVote.clen.value) for(i=1; i=len; i++) { byVal = eval("document.frmVote.o" + i + ".checked") if(byVal == true) { cnt_sel++ } } document.frmvote.total_sel.value = cnt_sel++ } function fnTotal(obj){ alert("number of Candidates selected: " + obj.value + " ") return false; } /script /head body VLINK="#990099" LINK="Blue" TEXT="Black" ALINK="#7204C3" leftmargin=0 topmargin=0 cfquery name="GetC" datasource="xxx" dbtype="ODBC" Select CID, CFirstName, CLastName, CNickName, CParty From Candidate /cfquery form action="Update/add_vote_form.cfm" method="post" name="frmVote" onSubmit="return validate(this)" Unang Hakbang: Email input type="Text" name="Email" required="No" size="30" maxlength="50" P Pangalawang Hakbang:br table align="center" tr td/td tdMga Kandidato/td tdParty/td /tr cfoutput query="GetC" tr tdinput type="Checkbox" name="o#GetC.CID#" value="#GetC.CID#" onClick="fnCountNatin(this)"/td td#GetC.CFirstName# #GetC.CLastName# #GetC.CNickName#/td td#GetC.CParty#/td /tr /cfoutput /table p Pangatlong Hakbang:br input type="hidden" name="clen" value="34" Number of Candidates selected: input type="text" name="total_sel" maxlength="2" size="3" value="0" onclick="return fnTotal(this)" onkeypress="javascript:return fnTotal(this)"br input type="submit" name="Submit" value=" Vote! " /form ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Money DataType in SQL
If you're asking about whether you need to put single quotes around the value, the answer is no. It's numeric, but is not limited to integers; they can hold up to 4 decimal places. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:00 AM To: CF-Talk Subject: Money DataType in SQL ok, just wondering if anyone knows thisI have a money datatype fieldwould anyone happen to know if i should treat this datatype as a string or an integer value? (for inserting purposes) thanks kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: limitations of Access
I stand corrected - My keywords in that statement were sessions, not connections. I am still fairly new to the terminologies used. We maintain 30 concurrent sessions NOT connections. Big difference - however the site seemed to run smoothly none the less with Access. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Derek Havelock [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 9:43 AM To: CF-Talk Subject: RE: limitations of Access Can I possibly add a question to this string ... Larry, you mentioned that: we were running an auction site using Access that always was running at least 30 concurrent sessions at a time with 5 items in the database and did not appear to have a major problem. I don't see how that is possible - but am hoping that you can teach me something here. At the last place I worked, when more than one person accessed the same Access file, they were simply locked out. This would frequently happen when a salesperson tried to get into the product database to answer a customer query, but a product manager would already be in the file. - major disputes in the office when the customer can hear every word down the line :-) You mention "30 concurrent sessions" by which I take it to mean that 30 users can be within the same file at the same moment in time. Surely, with a file-based package, this is not possible? If you can indeed do this, I would greatly appreciate any info you can give me to solve such a problem. Kindest regards, Derek BTW - a leap from Access to Oracle A major leap!! :-) IT Star Web Design, Hosting, Database Integration and Internet Marketing http://www.itstar.co.uk/ [EMAIL PROTECTED] -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 15:40 To: CF-Talk Subject: RE: limitations of Access I am not totally 100% sure on this, however I do know that we were running an auction site using Access that always was running at least 30 concurrent sessions at a time with 5 items in the database and did not appear to have a major problem. We did upscale the site to Oracle however just to NOT have any possible problems. I know this is not what you wanted to hear, but it is some proof that the low numbers may not be totally accurate. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:33 AM To: CF-Talk Subject: limitations of Access Hi all, I am doing a quote for a client that has an existing CF site using Access. They are a professional organisation hosting their own server and I'm trying to get them to steer away from Access, as I think the site has the potential to get more hits than Access can easily handle. So far they are determined to stick with it. I need some ammo... I know Access is not suitable for the job they want it to do, but I'm not sure of the facts and figures. I think someone once before said that Access cannot handle more than 5 concurrent users but I'm not 100% sure. So does anyone have any concrete figures on the capabilities of Access? Thanks, K. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
2 CFINSERT on ome page?
Hello cf-talk, I have a form with many fields. The fields go to different tables. I'm trying to use CFINSERT with formfields to add data to different tables. When I submit the form, I don't get any errors, but only the first CFINSERT gets processed? CFINSERT DATASOURCE="#application.DSN#" tableName="registration" Formfields=" last_name, first_name, address, city, state, zip, email, phone, gender, person_notify, notify_telephone, tickets_adult, adult1, adult2, adult3, adult4, adult5, adult6, adult7, adult8, adult9, adult10, adult11, adult12. tickets_children, child1, childage1, child2, childage2, child3, childage3, child4, childage4, child5, childage5, child6, childage6, child7, childage7, child8, childage8, tshirtsmall, tshirtmed, tshirtlarge, tshirtxl, else, card, card_number, cardholder, expdate" CFINSERT DATASOURCE="#application.DSN#" tableName="addlregs" Formfields=" alastname, afirstname, aphone, card_number, first_name, last_name" As is, only the first gets processed (makes it into the table), if I comment out the top CFINSERT, then the second makes it into its table and the first does nothing. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: sql learning
the infamous jhoffman SQL tutorial is always a good place to start I think. w3.one.net/~jhoffman/sqltut.htm a good tut and links ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(OT) IIS 5 Problem
My IIS 5 on win2K box, has become corrupted on a server eg if you stop a web site you cannot start it again. I am moving the urls over to another server and setting them up on that server with a clean IIS. I can set up and access normal http non-cf sites so that they point to the files on the old server and the sites are accessed ok. However when I do the same with any cf site, I am getting 404 error. My question is:- How do you set up IIS on Server A were the url for the site is on server A but the site is on Server B? I can see the files in IIS on server A that are located on Server B but cannot access the site from a browser without error 404. I am sure I am being really stupid here but that does not matter as long as I get it to work. Paul Paul Burgess -Original Message- From: Terry Bader [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 6:28 PM To: CF-Talk Subject: RE: Cold Fusion Forums hello... well, im not sure what you want exactly, but i have been working on a phorum system and I'm just about to take it into Alpha release. anyway, if you are interested, please check out http://www.cfphorum.com Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:31 AM To: CF-Talk Subject: Cold Fusion Forums Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Forums
The FuseTalk forums always seen to look the same. Is it customizable at all? Do you have any examples of a FuseTalk forum that doesn't look like a FuseTalk forum, preferably an example of one that is integrated cleanly into the design of a site? Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:30 PM To: CF-Talk Subject: RE: Cold Fusion Forums FUSETALK!!!FUSETALK!!!FUSETTAAALLKK!! Its the best! Totally the best! :) The things this board can do..its amazing! Any feature you could want..you got it! There are avatar pics, private messaging, realtime Chat functions! You can hook the registration for the database out to a secondary datastore..an existing user database in other words.. its got everything! I am totally totally pleased with this thing :) www.carigamer.com/forum I can't wait for when we start advertising and throw our next tournaments to see the feedback from the users :) -Gel www.carigamer.com Island Gaming At Its Best!(tm) "The Surgeon General Advises That Playing Violent Video Games Is NOT Harmful To Your Health"-Surgeon General's Report 2001. - Original Message - From: "S R" [EMAIL PROTECTED] Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascirpt problem on CF
My first suggestion is that you debug your script by putting in alert statements at various points. For example, if(byVal == true) { cnt_chk++; alert(cnt_chk); } -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:33 AM To: CF-Talk Subject: Javascirpt problem on CF This is my code with Javascript can you pelase help me figure out what's wrong? i know that Javascript is a client side while CF is server side. Can you please help me out to figure what changes do i need to do on my code? What i'm trying to do on my code is they need to click on the checkbox and i will count how many checkboxes they already clicked on and they should have a max of 13 clicks. !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head title/title link href="../Styles/css.css" rel="stylesheet" type="text/css" script language="JavaScript" var cnt_chk = 0; var cnt_sel = 0; function validate(obj){ len = parseFloat(obj.clen.value) cnt_chk = 0 for(i=1; i=len; i++) { byVal = eval("obj.o" + i + ".checked") if(byVal == true) { cnt_chk++ } } if(cnt_chk == 0) { alert("You must select a Candidate"); return false; } if(cnt_chk = 14 OR cnt_chk =12) { alert("You must select exactly 13 Candidates"); return false; } } function fnCountNatin(obj){ cnt_sel = 0; len = parseFloat(document.frmVote.clen.value) for(i=1; i=len; i++) { byVal = eval("document.frmVote.o" + i + ".checked") if(byVal == true) { cnt_sel++ } } document.frmvote.total_sel.value = cnt_sel++ } function fnTotal(obj){ alert("number of Candidates selected: " + obj.value + " ") return false; } /script /head body VLINK="#990099" LINK="Blue" TEXT="Black" ALINK="#7204C3" leftmargin=0 topmargin=0 cfquery name="GetC" datasource="xxx" dbtype="ODBC" Select CID, CFirstName, CLastName, CNickName, CParty From Candidate /cfquery form action="Update/add_vote_form.cfm" method="post" name="frmVote" onSubmit="return validate(this)" Unang Hakbang: Email input type="Text" name="Email" required="No" size="30" maxlength="50" P Pangalawang Hakbang:br table align="center" tr td/td tdMga Kandidato/td tdParty/td /tr cfoutput query="GetC" tr tdinput type="Checkbox" name="o#GetC.CID#" value="#GetC.CID#" onClick="fnCountNatin(this)"/td td#GetC.CFirstName# #GetC.CLastName# #GetC.CNickName#/td td#GetC.CParty#/td /tr /cfoutput /table p Pangatlong Hakbang:br input type="hidden" name="clen" value="34" Number of Candidates selected: input type="text" name="total_sel" maxlength="2" size="3" value="0" onclick="return fnTotal(this)" onkeypress="javascript:return fnTotal(this)"br input type="submit" name="Submit" value=" Vote! " /form ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: Cold Fusion Forums
I would have to back that suggestion - Fusetalk is the way to go. Paul Burgess -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 6:30 PM To: CF-Talk Subject: RE: Cold Fusion Forums FUSETALK!!!FUSETALK!!!FUSETTAAALLKK!! Its the best! Totally the best! :) The things this board can do..its amazing! Any feature you could want..you got it! There are avatar pics, private messaging, realtime Chat functions! You can hook the registration for the database out to a secondary datastore..an existing user database in other words.. its got everything! I am totally totally pleased with this thing :) www.carigamer.com/forum I can't wait for when we start advertising and throw our next tournaments to see the feedback from the users :) -Gel www.carigamer.com Island Gaming At Its Best!(tm) "The Surgeon General Advises That Playing Violent Video Games Is NOT Harmful To Your Health"-Surgeon General's Report 2001. - Original Message - From: "S R" [EMAIL PROTECTED] Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 2 CFINSERT on ome page?
Why not do two cfqueries with SQL INSERT commands for the different tables? Hatton -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:48 PM To: CF-Talk Subject: 2 CFINSERT on ome page? Hello cf-talk, I have a form with many fields. The fields go to different tables. I'm trying to use CFINSERT with formfields to add data to different tables. When I submit the form, I don't get any errors, but only the first CFINSERT gets processed? CFINSERT DATASOURCE="#application.DSN#" tableName="registration" Formfields=" last_name, first_name, address, city, state, zip, email, phone, gender, person_notify, notify_telephone, tickets_adult, adult1, adult2, adult3, adult4, adult5, adult6, adult7, adult8, adult9, adult10, adult11, adult12. tickets_children, child1, childage1, child2, childage2, child3, childage3, child4, childage4, child5, childage5, child6, childage6, child7, childage7, child8, childage8, tshirtsmall, tshirtmed, tshirtlarge, tshirtxl, else, card, card_number, cardholder, expdate" CFINSERT DATASOURCE="#application.DSN#" tableName="addlregs" Formfields=" alastname, afirstname, aphone, card_number, first_name, last_name" As is, only the first gets processed (makes it into the table), if I comment out the top CFINSERT, then the second makes it into its table and the first does nothing. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascirpt problem on CF
I have not tested this, but I think this is a generic form or what you want... the main thing i see that can be wrong in your code is here: len = parseFloat(obj.clen.value) is this the length?? obj.clen.value?? maybe obj.clen.length hope this helps len=document.checkboxes.length cnt = 0 for(i=1; i=len; i++) { if (document.checkboxes[i].checked == 1) { cnt++; } } //cnt should be equal to the number that are checked Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:33 PM To: CF-Talk Subject: Javascirpt problem on CF This is my code with Javascript can you pelase help me figure out what's wrong? i know that Javascript is a client side while CF is server side. Can you please help me out to figure what changes do i need to do on my code? What i'm trying to do on my code is they need to click on the checkbox and i will count how many checkboxes they already clicked on and they should have a max of 13 clicks. !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head title/title link href="../Styles/css.css" rel="stylesheet" type="text/css" script language="JavaScript" var cnt_chk = 0; var cnt_sel = 0; function validate(obj){ len = parseFloat(obj.clen.value) cnt_chk = 0 for(i=1; i=len; i++) { byVal = eval("obj.o" + i + ".checked") if(byVal == true) { cnt_chk++ } } if(cnt_chk == 0) { alert("You must select a Candidate"); return false; } if(cnt_chk = 14 OR cnt_chk =12) { alert("You must select exactly 13 Candidates"); return false; } } function fnCountNatin(obj){ cnt_sel = 0; len = parseFloat(document.frmVote.clen.value) for(i=1; i=len; i++) { byVal = eval("document.frmVote.o" + i + ".checked") if(byVal == true) { cnt_sel++ } } document.frmvote.total_sel.value = cnt_sel++ } function fnTotal(obj){ alert("number of Candidates selected: " + obj.value + " ") return false; } /script /head body VLINK="#990099" LINK="Blue" TEXT="Black" ALINK="#7204C3" leftmargin=0 topmargin=0 cfquery name="GetC" datasource="xxx" dbtype="ODBC" Select CID, CFirstName, CLastName, CNickName, CParty From Candidate /cfquery form action="Update/add_vote_form.cfm" method="post" name="frmVote" onSubmit="return validate(this)" Unang Hakbang: Email input type="Text" name="Email" required="No" size="30" maxlength="50" P Pangalawang Hakbang:br table align="center" tr td/td tdMga Kandidato/td tdParty/td /tr cfoutput query="GetC" tr tdinput type="Checkbox" name="o#GetC.CID#" value="#GetC.CID#" onClick="fnCountNatin(this)"/td td#GetC.CFirstName# #GetC.CLastName# #GetC.CNickName#/td td#GetC.CParty#/td /tr /cfoutput /table p Pangatlong Hakbang:br input type="hidden" name="clen" value="34" Number of Candidates selected: input type="text" name="total_sel" maxlength="2" size="3" value="0" onclick="return fnTotal(this)" onkeypress="javascript:return fnTotal(this)"br input type="submit" name="Submit" value=" Vote! " /form ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: limitations of Access
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 -Original Message- From: Derek Havelock [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 9:43 AM To: CF-Talk Subject: RE: limitations of Access Can I possibly add a question to this string ... Larry, you mentioned that: we were running an auction site using Access that always was running at least 30 concurrent sessions at a time with 5 items in the database and did not appear to have a major problem. I don't see how that is possible - but am hoping that you can teach me something here. At the last place I worked, when more than one person accessed the same Access file, they were simply locked out. This would frequently happen when a salesperson tried to get into the product database to answer a customer query, but a product manager would already be in the file. - major disputes in the office when the customer can hear every word down the line :-) Ahhh... They joys of MS Access file permissions. Sure you can have lots of people accessing the same file based DB. Since all accesses go throught the Microsoft JET DB engine, all the locking whatnot is handled for you. The reason you were seeing only one person accessing the file at a time is due to file permissions. In order to get multiple accesses to one MS Access database, JET needs to create a lock file (yourdatabase.ldb). In order to create a lock file, the user that JET is running as needs read/write access to both your Access MDB file *AND* the directory that contains it. Specifically, they need change and create file rights on the directory so they can create that .LDB file. If JET can't create the LDB file, it limits the DB to one user at a time. If you're accessing the site from CF, then the user that CF runs as needs Change rights to the directory. With ASP, it's usually the IUSR that needs that access. We usually just stick Everyone w/ Change rights on that directory for good measure... (See below for more on Access cabilities.) -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:33 AM To: CF-Talk Subject: limitations of Access Hi all, I am doing a quote for a client that has an existing CF site using Access. They are a professional organisation hosting their own server and I'm trying to get them to steer away from Access, as I think the site has the potential to get more hits than Access can easily handle. So far they are determined to stick with it. I need some ammo... I know Access is not suitable for the job they want it to do, but I'm not sure of the facts and figures. I think someone once before said that Access cannot handle more than 5 concurrent users but I'm not 100% sure. So does anyone have any concrete figures on the capabilities of Access? I'm light on concrete figures, but last I checked IMC Online actually refused to host an Access DB that was larger than 10MB or allow one on a site that generated more than 2MB of logfiles per day. They insited on that to maintain server stability, and I certainly don't blaim them for it. Access is a huge hit on a server compared to a dedicated SQL Server. When you add to that Access's occasional spontaneous database corruption, various leaks in the ODBC drivers Access is a huge headache compared to SQL Server. Now certainly SQL Server is an expense, but if your client plans to make money with their site, I'd say SQL Server (or a similar client-server RDBMS) is almost a requirement. We've had more than a few clients insist on using Access, only to come groveling back to us after a year or so when their trafic goes up and their site suddenly starts dieing Not that we complain too much... We charge hourly to convert the site over to SQL Server... ;-) Just to clarify... I'm in no way associated w/ IMC Online, and I'm not sure whether the restrictions I mentioned are still or ever were accurate. I have perused IMC's customer support site in the past when we've hosted various clients there, and I seem to remember something to the effect of what I quoted above. Don't take it as Gospel, tho... Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use iQA/AwUBOsN5JavhLS1aWPxeEQKBegCfQb+Gp2qtzBiCyLVqTr3m0E/xuI0AoKW3 u9dMIcmAYYkWFNAqBx+kwk8H =bXtP -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql learning
Try http://www.swynk.com -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 9:30 AM To: CF-Talk Subject:sql learning Just wondering if anyone could refer some good sites with SQL training and information. I know the basics of SQL, can get info in and out of it, just wanting to learn some more about it and learn about more of its features. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascirpt problem on CF
Well, I see one syntactical error. The OR below should be || if(cnt_chk = 14 OR cnt_chk =12) // SHould read if(cnt_chk = 14 || cnt_chk =12) Don't know if that solves everything... Alec -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:33 PM To: CF-Talk Subject: Javascirpt problem on CF This is my code with Javascript can you pelase help me figure out what's wrong? i know that Javascript is a client side while CF is server side. Can you please help me out to figure what changes do i need to do on my code? What i'm trying to do on my code is they need to click on the checkbox and i will count how many checkboxes they already clicked on and they should have a max of 13 clicks. !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head title/title link href="../Styles/css.css" rel="stylesheet" type="text/css" script language="JavaScript" var cnt_chk = 0; var cnt_sel = 0; function validate(obj){ len = parseFloat(obj.clen.value) cnt_chk = 0 for(i=1; i=len; i++) { byVal = eval("obj.o" + i + ".checked") if(byVal == true) { cnt_chk++ } } if(cnt_chk == 0) { alert("You must select a Candidate"); return false; } if(cnt_chk = 14 OR cnt_chk =12) { alert("You must select exactly 13 Candidates"); return false; } } function fnCountNatin(obj){ cnt_sel = 0; len = parseFloat(document.frmVote.clen.value) for(i=1; i=len; i++) { byVal = eval("document.frmVote.o" + i + ".checked") if(byVal == true) { cnt_sel++ } } document.frmvote.total_sel.value = cnt_sel++ } function fnTotal(obj){ alert("number of Candidates selected: " + obj.value + " ") return false; } /script /head body VLINK="#990099" LINK="Blue" TEXT="Black" ALINK="#7204C3" leftmargin=0 topmargin=0 cfquery name="GetC" datasource="xxx" dbtype="ODBC" Select CID, CFirstName, CLastName, CNickName, CParty From Candidate /cfquery form action="Update/add_vote_form.cfm" method="post" name="frmVote" onSubmit="return validate(this)" Unang Hakbang: Email input type="Text" name="Email" required="No" size="30" maxlength="50" P Pangalawang Hakbang:br table align="center" tr td/td tdMga Kandidato/td tdParty/td /tr cfoutput query="GetC" tr tdinput type="Checkbox" name="o#GetC.CID#" value="#GetC.CID#" onClick="fnCountNatin(this)"/td td#GetC.CFirstName# #GetC.CLastName# #GetC.CNickName#/td td#GetC.CParty#/td /tr /cfoutput /table p Pangatlong Hakbang:br input type="hidden" name="clen" value="34" Number of Candidates selected: input type="text" name="total_sel" maxlength="2" size="3" value="0" onclick="return fnTotal(this)" onkeypress="javascript:return fnTotal(this)"br input type="submit" name="Submit" value=" Vote! " /form ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Ultra Dev 4
I can second this experience. UD4 is good at highlighting "incorrect" HTML which means if often confuses valid CF code for invalid HTML. Usually this is ok and UD shrugs its shoulders at accepts that you know best but occasionally it "tidies up" for you and then you have a mess. Hopefully this will be addressed better now the two are owned by the same folk. Ed Brown www.go-britain.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 2 CFINSERT on ome page?
try using CFQUERY instead of CFINSERT You can string many CFQUERY together into one transaction. -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:48 PM To: CF-Talk Subject: 2 CFINSERT on ome page? Hello cf-talk, I have a form with many fields. The fields go to different tables. I'm trying to use CFINSERT with formfields to add data to different tables. When I submit the form, I don't get any errors, but only the first CFINSERT gets processed? CFINSERT DATASOURCE="#application.DSN#" tableName="registration" Formfields=" last_name, first_name, address, city, state, zip, email, phone, gender, person_notify, notify_telephone, tickets_adult, adult1, adult2, adult3, adult4, adult5, adult6, adult7, adult8, adult9, adult10, adult11, adult12. tickets_children, child1, childage1, child2, childage2, child3, childage3, child4, childage4, child5, childage5, child6, childage6, child7, childage7, child8, childage8, tshirtsmall, tshirtmed, tshirtlarge, tshirtxl, else, card, card_number, cardholder, expdate" CFINSERT DATASOURCE="#application.DSN#" tableName="addlregs" Formfields=" alastname, afirstname, aphone, card_number, first_name, last_name" As is, only the first gets processed (makes it into the table), if I comment out the top CFINSERT, then the second makes it into its table and the first does nothing. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql learning
A great reference book to have around after tutorials is The Practical SQL Handbook by Bowman, Emerson and Darnovsky -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:30 PM To: CF-Talk Subject: sql learning Just wondering if anyone could refer some good sites with SQL training and information. I know the basics of SQL, can get info in and out of it, just wanting to learn some more about it and learn about more of its features. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Forums
You can purchase the oprn code version and do just about anything with it you like. Paul Burgess -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 6:45 PM To: CF-Talk Subject: RE: Cold Fusion Forums The FuseTalk forums always seen to look the same. Is it customizable at all? Do you have any examples of a FuseTalk forum that doesn't look like a FuseTalk forum, preferably an example of one that is integrated cleanly into the design of a site? Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:30 PM To: CF-Talk Subject: RE: Cold Fusion Forums FUSETALK!!!FUSETALK!!!FUSETTAAALLKK!! Its the best! Totally the best! :) The things this board can do..its amazing! Any feature you could want..you got it! There are avatar pics, private messaging, realtime Chat functions! You can hook the registration for the database out to a secondary datastore..an existing user database in other words.. its got everything! I am totally totally pleased with this thing :) www.carigamer.com/forum I can't wait for when we start advertising and throw our next tournaments to see the feedback from the users :) -Gel www.carigamer.com Island Gaming At Its Best!(tm) "The Surgeon General Advises That Playing Violent Video Games Is NOT Harmful To Your Health"-Surgeon General's Report 2001. - Original Message - From: "S R" [EMAIL PROTECTED] Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 2 CFINSERT on ome page?
Hi Jeff, You need to do an SQL insert for each table you want to insert data into. Just line them up one after the other on the page that processes the form. Frank Hilliard http://www.bcinternet.com/~hilliard Jeff Fongemie wrote: Hello cf-talk, I have a form with many fields. The fields go to different tables. I'm trying to use CFINSERT with formfields to add data to different tables. When I submit the form, I don't get any errors, but only the first CFINSERT gets processed? CFINSERT DATASOURCE="#application.DSN#" tableName="registration" Formfields=" last_name, first_name, address, city, state, zip, email, phone, gender, person_notify, notify_telephone, tickets_adult, adult1, adult2, adult3, adult4, adult5, adult6, adult7, adult8, adult9, adult10, adult11, adult12. tickets_children, child1, childage1, child2, childage2, child3, childage3, child4, childage4, child5, childage5, child6, childage6, child7, childage7, child8, childage8, tshirtsmall, tshirtmed, tshirtlarge, tshirtxl, else, card, card_number, cardholder, expdate" CFINSERT DATASOURCE="#application.DSN#" tableName="addlregs" Formfields=" alastname, afirstname, aphone, card_number, first_name, last_name" As is, only the first gets processed (makes it into the table), if I comment out the top CFINSERT, then the second makes it into its table and the first does nothing. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Forums
I don't know how many of you browse the allaire support forums, but they just announced they will be switching to the fusetalk forum in a week or two. Frankly, I like the old forum design better. Check out http://macromediaforums.e-zonemedia.com/ for the new look. Tim P. - Original Message - From: "Benjamin S. Rogers" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 12:44 PM Subject: RE: Cold Fusion Forums The FuseTalk forums always seen to look the same. Is it customizable at all? Do you have any examples of a FuseTalk forum that doesn't look like a FuseTalk forum, preferably an example of one that is integrated cleanly into the design of a site? Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:30 PM To: CF-Talk Subject: RE: Cold Fusion Forums FUSETALK!!!FUSETALK!!!FUSETTAAALLKK!! Its the best! Totally the best! :) The things this board can do..its amazing! Any feature you could want..you got it! There are avatar pics, private messaging, realtime Chat functions! You can hook the registration for the database out to a secondary datastore..an existing user database in other words.. its got everything! I am totally totally pleased with this thing :) www.carigamer.com/forum I can't wait for when we start advertising and throw our next tournaments to see the feedback from the users :) -Gel www.carigamer.com Island Gaming At Its Best!(tm) "The Surgeon General Advises That Playing Violent Video Games Is NOT Harmful To Your Health"-Surgeon General's Report 2001. - Original Message - From: "S R" [EMAIL PROTECTED] Hi Everyone, Can anyone recommend a good software package either from Allaire or someone else that can be used for web forums, sort of like this cf-talk forum? Thank You ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 2 CFINSERT on ome page?
People actually use CFINSERT? - Original Message - From: "C. Hatton Humphrey" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 10:57 AM Subject: RE: 2 CFINSERT on ome page? Why not do two cfqueries with SQL INSERT commands for the different tables? Hatton -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:48 PM To: CF-Talk Subject: 2 CFINSERT on ome page? Hello cf-talk, I have a form with many fields. The fields go to different tables. I'm trying to use CFINSERT with formfields to add data to different tables. When I submit the form, I don't get any errors, but only the first CFINSERT gets processed? CFINSERT DATASOURCE="#application.DSN#" tableName="registration" Formfields=" last_name, first_name, address, city, state, zip, email, phone, gender, person_notify, notify_telephone, tickets_adult, adult1, adult2, adult3, adult4, adult5, adult6, adult7, adult8, adult9, adult10, adult11, adult12. tickets_children, child1, childage1, child2, childage2, child3, childage3, child4, childage4, child5, childage5, child6, childage6, child7, childage7, child8, childage8, tshirtsmall, tshirtmed, tshirtlarge, tshirtxl, else, card, card_number, cardholder, expdate" CFINSERT DATASOURCE="#application.DSN#" tableName="addlregs" Formfields=" alastname, afirstname, aphone, card_number, first_name, last_name" As is, only the first gets processed (makes it into the table), if I comment out the top CFINSERT, then the second makes it into its table and the first does nothing. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascirpt problem on CF
I forgot to mention the error that i am getting: An error has occured on the script... the error says it is expecting 'j'? -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 9:49 AM To: CF-Talk Subject: RE: Javascirpt problem on CF My first suggestion is that you debug your script by putting in alert statements at various points. For example, if(byVal == true) { cnt_chk++; alert(cnt_chk); } -Original Message- From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 11:33 AM To: CF-Talk Subject: Javascirpt problem on CF This is my code with Javascript can you pelase help me figure out what's wrong? i know that Javascript is a client side while CF is server side. Can you please help me out to figure what changes do i need to do on my code? What i'm trying to do on my code is they need to click on the checkbox and i will count how many checkboxes they already clicked on and they should have a max of 13 clicks. !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head title/title link href="../Styles/css.css" rel="stylesheet" type="text/css" script language="JavaScript" var cnt_chk = 0; var cnt_sel = 0; function validate(obj){ len = parseFloat(obj.clen.value) cnt_chk = 0 for(i=1; i=len; i++) { byVal = eval("obj.o" + i + ".checked") if(byVal == true) { cnt_chk++ } } if(cnt_chk == 0) { alert("You must select a Candidate"); return false; } if(cnt_chk = 14 OR cnt_chk =12) { alert("You must select exactly 13 Candidates"); return false; } } function fnCountNatin(obj){ cnt_sel = 0; len = parseFloat(document.frmVote.clen.value) for(i=1; i=len; i++) { byVal = eval("document.frmVote.o" + i + ".checked") if(byVal == true) { cnt_sel++ } } document.frmvote.total_sel.value = cnt_sel++ } function fnTotal(obj){ alert("number of Candidates selected: " + obj.value + " ") return false; } /script /head body VLINK="#990099" LINK="Blue" TEXT="Black" ALINK="#7204C3" leftmargin=0 topmargin=0 cfquery name="GetC" datasource="xxx" dbtype="ODBC" Select CID, CFirstName, CLastName, CNickName, CParty From Candidate /cfquery form action="Update/add_vote_form.cfm" method="post" name="frmVote" onSubmit="return validate(this)" Unang Hakbang: Email input type="Text" name="Email" required="No" size="30" maxlength="50" P Pangalawang Hakbang:br table align="center" tr td/td tdMga Kandidato/td tdParty/td /tr cfoutput query="GetC" tr tdinput type="Checkbox" name="o#GetC.CID#" value="#GetC.CID#" onClick="fnCountNatin(this)"/td td#GetC.CFirstName# #GetC.CLastName# #GetC.CNickName#/td td#GetC.CParty#/td /tr /cfoutput /table p Pangatlong Hakbang:br input type="hidden" name="clen" value="34" Number of Candidates selected: input type="text" name="total_sel" maxlength="2" size="3" value="0" onclick="return fnTotal(this)" onkeypress="javascript:return fnTotal(this)"br input type="submit" name="Submit" value=" Vote! " /form ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists