CFQUERY Update......
Hi all, I am trying to update a table using CFQUERY. I do not see any error when the query is excuted in CF and I can see the query is correct in the debug mode. But somehow the data is not updated. When I run the same query in SQL Server, the data is updated. Does anybody know why? I am using CF 4.5 and SQL Server 7.0 The query is like this.. UPDATE User SET newpassword = 'arenofun' WHERE ID = 1614 Thanks in advance J ~~ 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
Variable
Besides form and url variables, what other variables could I pass them within each browser instance? I want each browser instance has separate values of the variables. For instance, there are browser A and browser B. A has variables x=1 y=2 z=3. B has variables x=11 y=12 z=13. I want x, y, and z to be passed in each pages in each browser instance. And A and B exist in the SAME machine by the SAME user. And let say A and B are Netscape or IE but not mix. Is this possible? Thanks in advance. J ~~ 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
View source in NS 6
Hi all, I got this problem when i use netscape 6.01. Everything is fine when I use IE 5.5 or NS 4.x. I have a form page with multiple submit buttons (no frames). Basically it calls itself and it does different tasks based on the submit buttons. In NS 6.01, only one submit button works (What i mean is that other submit buttons are missing (no form vars) even though they are clicked). And after clicking the working submit button and viewing the source, I see a CF error in the view-source screen (a form variable is missing). But in the actual NS screen, there is no error and that form variable is shown in the debug section. Anybody knows what's happening? Thanks in advance. JL ~~ 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: [Re: Preventing Simultaneous Logins]
when a user is logging in with user name "Login1" and another user is trying to log in with the same user name, what do u want to do? kick out the first user or stop the second user? The first case is easy. The second case is harder because you need to clean up all the dead users in the table. You don't need to create another table to do this if you are storing the client variables in the database. J "Peter Alexandrou" [EMAIL PROTECTED] wrote: I can think of many similar solutions but they are all useless because most of the time users simply close their browsers or their sessions expire. Surely someone out there has tackled this problem successfully? - Original Message - From: "Pete Freitag" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, October 18, 2000 2:15 PM Subject: RE: Preventing Simultaneous Logins Keep a log of when people login, and when they log out (could get very large, but you could purge it daily). Then when someone logs in do the following... SELECT username FROM audit_table WHERE username = '#form.username#' AND timestamp #DateAdd("n", -30, Now())# ORDER BY action That will see if the user has been around in the last half hour Action could be a boolean field 1 being login 0 being logout cfif audit.recordcount cfif audit.action already logged in cfabort /cfif /cfif login... The problem with this entire process, is that there is no destructor called when a session disappears, or times out. __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM / NETDesign Inc. ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Peter Alexandrou [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 7:37 PM To: CF-Talk Subject: Preventing Simultaneous Logins Hi guys, I'm new to the mailing list and have a quick question for y'all. What is the best way to prevent a userID being logged in twice i.e. someone logs in with "login1" and then another user logs in with the same ID. Thanks, Peter Alexandrou Technical Leader tapestry communications : www.tapestry.net.au phone : 0411 445 111 e-mail : [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Get free email and a permanent address at http://www.netaddress.com/?N=1 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Form Question
Here is the case: let say people can access to a form page in our site. If somebody downloads that page to the computer and load it, how can I prevent him from posting the form to the our site? I don't think i can check cgi.http_referer because in this case, it will be empty (nothing). And I don't think I can reject all empty cgi.http_referer because of the cflocation. Any suggestion? Thanks alot. J Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [RE: CGI Referrer variable]
do you guys check this cgi.http_referer to see whether it's the correct ip? J [EMAIL PROTECTED] wrote: I was wondering how long someone would take to bring it up. Yep, it's mis-spelled. The person writing the standard mis-spelled it and it became a standard before it was caught... or so the story goes. So we're stuck with it. --Doug -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Monday, October 09, 2000 2:41 PM To: CF-Talk Subject: RE: CGI Referrer variable Interestingly enough, that variable name is spelled incorrectly. It is HTTP_REFERER. More variables like it can be found in the docs: cfdocs/Developing_Web_Applications_with_ColdFusion/03_Creating_and_Manipulat ing_Variables/dwa03_12.htm ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Brian bouldernet [mailto:[EMAIL PROTECTED]] Sent: Monday, October 09, 2000 12:47 PM To: CF-Talk Subject: CGI Referrer variable Does anyone know the variable name for refferer? I forgot ofhand... Thnaks, Brian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [Re: Client Session variables?]
Good articles. But it's almost the same as the one in Cold Fusion Journal. I'm not sure which one was written first. Also, some of the query will not work in this article. For instance, those ideas about checking client.LastVisit are wrong. Also, you need to do something to the User on the login page. Otherwise those two tables in CVR DB are wrong. [EMAIL PROTECTED] (paul smith) wrote: Detailed docs on setting up client vars in a DB and more are here: http://www.advantex.net/ColdFusion/CFClusteringDoc.htm best, paul At 09:15 AM 9/30/00 -0400, you wrote: On 9/29/00, W Luke penned: Use client variables, written to a database, whenever possible. Is there any documentation about writing client variables to a database? Or do you have any "starter for tens"?! What kind of documentation? CF will create the necessary tables if you just give it an empty database. The tables and columns it creates are, in Access, I can't remember off the top of my head what the matching data types are in SQL: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [OT: ColdFusion Job Opening at Unisyn Software]
Wailap Lam 11775 S. Shannan St. Apt#415, Olathe, KS 66062, USA (785) 550-3376 E-Mail: [EMAIL PROTECTED] OBJECTIVE Seeking a challenging position as a Software Engineer or Web Programmer in a progressive company where I can apply and extend my knowledge and skills in software development and design. EDUCATION * Bachelor of Science in Computer Science, The University of Kansas, Lawrence, KS, USA, August 1998 * Bachelor of Science in Electrical Engineering, The University of Kansas, Lawrence, KS, USA, May 1997 WORK EXPERIENCE * Programmer, January 1999 - Present SupplyTrak LLC (InterDirect Inc.), Shawnee, Kansas * Develop/Maintain/Enhance/Debug a web-based software SupplyTrak for medical industry. Projects include security system, merchandising reports, automated report system, etc. * Experience in Cold Fusion 4.01, WDDX, JavaScript, Dynamic-HTML, CSS, DOM, HTML, Stored Procedures, Transact-SQL. * Competency with Microsoft NT 4.0 Server, IIS 4.0, Access and SQL Server 6.5/7.0. * Familiar with Internet Explorer (5.X) and Netscape browsers (4.X and 6.0). Program in a database with over 100 tables and several data sources. RELATED COURSES * Software Engineering I * Operating Systems * Database Systems * Computer Systems Assembly Language * Computer Architecture * Computer Algorithms * Programming Language * Communications Systems * Computer Graphics * Compiler PROJECTS * HTTP Web Server Learned the low-level details of how the Web works. Implemented a web server in Chez Scheme to evaluate the server's design and to determine whether or not it can be improved. * Library Database Created a WWW interface using SQL and CGI(C++), in which the user can check in/out or search for a book, and workers can add/delete a member or a worker. TECHNICAL EXPERIENCE * Proficient in programming BASIC, C, C++, Scheme, SQL, RDBMS, HTML, DHTML, CGI, Cold Fusion 4.0, Java 2 (JDK1.2.2, J2SDK1.3), JavaScript, Lex and Yacc, OpenGL, Client/Server, Nachos, and VB5.0 * Experienced in microcontroller applications utilizing Motorola 68HC11 MCU * Experienced in using Microsoft Access and SQL-Server 6.5/7.0 * Familiar with DOS, Windows NT, Windows 95/98, UNIX, and Linux environment PERSONAL INFORMATION * Self-motivated, responsible and able to adapt to new environment * Experienced in technical writing * Willing to relocate Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [RE: RE: Session timeout?]
then do you ever get timeout? if you compare the client.lastvisit with now(), it will never GTE 30 because client.LastVisit is always updated before you excute this piece of code. I use client management too... Andy Ewings [EMAIL PROTECTED] wrote: Yup...this is what I do in mine.. !--- Clear client varaible if no activity in past 30 mins --- cfif DateDiff("n", Client.LastVisit, Now()) GTE 30 cfquery Name="DelClientVars" datasource="DSN" MAXROWS=1 DELETE FROM CDATA WHERE CFID = '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder' /cfquery /cfif OK I am using Clent management and it is being stored in a SQL database but you get the idea -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:27 To: [EMAIL PROTECTED] Subject: RE: RE: Session timeout? Thanks Andy, I cant do that cause i an dynamically logging the user. Is there a ways you could say. isDefined(Sessiontimeout)?? or i have to calculate the time the user spends in the app and log them off! --- Original Message --- Andy Ewings [EMAIL PROTECTED] Wrote on Thu, 24 Aug 2000 15:04:50 +0100 -- Set a param in your application.cfm called Session.Loggedin for example with a default of "no" When a user logs in set this variable to yes. Then in your application.cfm also have code that says: cfif Session.Loggedin IS "No" cflocation url="logon.cfm" /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:01 To: [EMAIL PROTECTED] Subject: Session timeout? Hello all. Is there a way to find whether the session timed out.If the session timed out display the logon page. Some like cfif Not isDefined(Session) cflocation ../logon.cfm /cfif but i cant get this work. Appretiate any comments. thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [RE: [RE: RE: Session timeout?]]
I set another variable client.LastVisit2 = client.LastVisit at the end of application.cfm then I compare the lastvisit2 with now() at the top of application.cfm =) Andy Ewings [EMAIL PROTECTED] wrote: Ummm...ok.but if that's the case how can you ever interrogate the Client.LastVisit variable and get a value other than the current time? -Original Message- From: JL [mailto:[EMAIL PROTECTED]] Sent: 25 August 2000 14:57 To: [EMAIL PROTECTED] Subject: Re: [RE: RE: Session timeout?] then do you ever get timeout? if you compare the client.lastvisit with now(), it will never GTE 30 because client.LastVisit is always updated before you excute this piece of code. I use client management too... Andy Ewings [EMAIL PROTECTED] wrote: Yup...this is what I do in mine.. !--- Clear client varaible if no activity in past 30 mins --- cfif DateDiff("n", Client.LastVisit, Now()) GTE 30 cfquery Name="DelClientVars" datasource="DSN" MAXROWS=1 DELETE FROM CDATA WHERE CFID = '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder' /cfquery /cfif OK I am using Clent management and it is being stored in a SQL database but you get the idea -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:27 To: [EMAIL PROTECTED] Subject: RE: RE: Session timeout? Thanks Andy, I cant do that cause i an dynamically logging the user. Is there a ways you could say. isDefined(Sessiontimeout)?? or i have to calculate the time the user spends in the app and log them off! --- Original Message --- Andy Ewings [EMAIL PROTECTED] Wrote on Thu, 24 Aug 2000 15:04:50 +0100 -- Set a param in your application.cfm called Session.Loggedin for example with a default of "no" When a user logs in set this variable to yes. Then in your application.cfm also have code that says: cfif Session.Loggedin IS "No" cflocation url="logon.cfm" /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:01 To: [EMAIL PROTECTED] Subject: Session timeout? Hello all. Is there a way to find whether the session timed out.If the session timed out display the logon page. Some like cfif Not isDefined(Session) cflocation ../logon.cfm /cfif but i cant get this work. Appretiate any comments. thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a