client variables jumble?
i have a typical and very random problem. we have a site which uses client variables and have a login-authentication system. difeerent ppl login all the time. but sometimes, out of no where when someone logs in he see's a screen which belongs to someone else. all the data of other person. and these ppl are located in different continents!!. how can it be?? how is someone else session is still maintained and assigned to another person? any ideas leads would be helpful. we client varibles storing in DB (MS-SQL2000) and using CF server 4.5 SP2 on win2k. the client variables settings on CF admin are that they are purged every 10 days. and no global updates. TIA. ::akbar ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: client variables jumble?
well we have asked the users to do so. but it occurs a couple of times in a month. i havent tried the random characters appending to URL's. but is it just bcoz of the client variables?? or cache?? any one have any other info?? ::akbar -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 3:10 PM To: CF-Talk Subject: Re: client variables jumble? Try settings your temporary files/Internet Options to check every time and see if that helps. We had a similar problem where the client variables did not seem to be accurate. We determined that this setting was a factor. We ended up appending some random characters to the end of our urls so that the page would not be read from cache which can sometimes cause old client variables data to be used. Not sure if this is what is happening in your case, but its worth noting Brook At 02:46 PM 15/08/01 -0400, you wrote: i have a typical and very random problem. we have a site which uses client variables and have a login-authentication system. difeerent ppl login all the time. but sometimes, out of no where when someone logs in he see's a screen which belongs to someone else. all the data of other person. and these ppl are located in different continents!!. how can it be?? how is someone else session is still maintained and assigned to another person? any ideas leads would be helpful. we client varibles storing in DB (MS-SQL2000) and using CF server 4.5 SP2 on win2k. the client variables settings on CF admin are that they are purged every 10 days. and no global updates. TIA. ::akbar ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
fearing the failing scheduler
hi all, we have a scheduler which is configured to run every 60 mins. it was working fine until one fine day it decided to run every minute! we had to reboot the server to fix it. but even now, after looking thru all the forums and web sites i am not able to get hold of any good info regarding the misbehaviour of scheduler. can any one point out some links or give any info something like 10 things to do (not to do) with schedulers kinda stuff?? its scary to sit here and wonder when is it gonna strike again? i myself dont have much data to tell u why it occured. but in the log files i see something like TID= 1000 and 732 and 1004 and 1056 and 1044 and 2600 and 2616 and 2484 and so on. what does TID mean? the error code corresponding to SQL server? or cold fusion? i am running, win2k server with SQL 2000 as backend. any ideas. thanx in advance. ::akbar ~~ 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: Create-edit-delete in Access - TAG
try this http://devex.allaire.com/developer/gallery/info.cfm?ID=44C495D9-35E9-11D 4-83D700508B94F85Amethod=Full the custom tag name is CF_ListTable ::akbar -Original Message- From: CF Crazy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 1:54 PM To: CF-Talk Subject: Create-edit-delete in Access - TAG Does anyone know have a good tag that gives control to create, edit and delete rows and fields using an access database. Steph ~~ 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: fearing the failing scheduler
hi tim, we are running, CF server 4.5.1 without SP1 or SP2. does SP1 or SP2 fix this weird behaviour? plz let me know as i need to present a good draft to convince my company so that they upgrade. thanx ::akbar -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 2:43 PM To: CF-Talk Subject: Re: fearing the failing scheduler Akbar, Which version are you running? The scheduler uses cfhttp and there were a number of fixes to cfhttp in service pack 2 of 4.5.1. If you are not running it now, you may want to consider installing this. Tim P. - Original Message - From: Akbar Pasha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 1:35 PM Subject: fearing the failing scheduler hi all, we have a scheduler which is configured to run every 60 mins. it was working fine until one fine day it decided to run every minute! we had to reboot the server to fix it. but even now, after looking thru all the forums and web sites i am not able to get hold of any good info regarding the misbehaviour of scheduler. can any one point out some links or give any info something like 10 things to do (not to do) with schedulers kinda stuff?? its scary to sit here and wonder when is it gonna strike again? i myself dont have much data to tell u why it occured. but in the log files i see something like TID= 1000 and 732 and 1004 and 1056 and 1044 and 2600 and 2616 and 2484 and so on. what does TID mean? the error code corresponding to SQL server? or cold fusion? i am running, win2k server with SQL 2000 as backend. any ideas. thanx in advance. ::akbar ~~ 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) cfm-resources?
just ran a query on netcraft.. http://uptime.netcraft.com/up/graph?mode_u=offmode_w=onsite=www.cfm-re sources.comsubmit=Examine the avg shown is low/normal is suppose. i too am interested to know if anyone here is hosting any site(s) under paid accts?? their prices are best suited for me as i have some 5 sites that i am thinking to host. any info?? TIA ::akbar -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:39 AM To: CF-Talk Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ 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
WDDX shows all the data!!!
Hi all, is there a way to hide all the javascript that CFWDDX tag generates when action is CFML2JS its not only annoying but also shows up all the sensitive data that comes into it. Gosh now thats bad. any ideas?? TIA ::akbar ~~ 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: New CF5 Partner Hosting License
is there any book called PHP by April30th?? ;) just wondering...does PHP run on windows?? coz if it comes to that i dont want to go for ASP. i was planning to do something like CFhosting, sortabut dang!!! my other friend was right... -Original Message- From: Zac [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 1:42 PM To: CF-Talk Subject: RE: New CF5 Partner Hosting License Let me preface this by saying that it isn't meant as a comment about Macromedia but is a general comment They HAVE to know that abandoning us (and yes, I'm definitely in the low end as well) will only result in the death of CF. Publicly held software companies are beholden to their shareholders and the bottom line. If the management of the company thinks that they can make more money in a process that eliminates 90% of their small scale developers they will do it. No question. If the idea is sound in the long term is another matter entirely. And I think you can look at the history of software development firms to see that foresight and long-term planning are not necessarily skills that the management of software companies have in excess. ~~ 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 studio RDS debugging?
hi all, i am trying to debug a page on the remote server (RDS). i have added the required development mappings, and set the start page too. but when i start it, it gives me an error called --Can't debug request. --Unable to convert:0 to a port. --Date/Time: 04/18/01 11:00:22 --Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) --Remote Address: 10.160.1.138 --Query String: cfasdebugsessionid=SKT:localhost:0 how can i configure the port to 80? i copied the same query string and changed it to 80 and opened it in a browser, it works fine. where does the "0" come in from?? any ideas?? i am using CF studio 4.5.1 Eval (for many reasons), CF server 4.5.1 on win2000 professional machine (the remote server too has the same config, except it doesnt have CF studio) TIA ::akbar ~~ 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
compare files??
hi, i was just wondering whether CF studio has any facility to compare 2 ..cfm files and list out the differences. coz i need it very much in my work and if its not there, is there any other way i can do the compare? TIA akbar ~~ 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:(SQL Stored Proc)
hi all, i am sorry to ask SQL question in CF list, but i am not aware of any good SQL mail list. so here i am... is there a way to check the existence of file using SQL?? i mean some SQL function or some kind of query format which will tell me whether the passed file name exists on the computer or not? i need this functionality in a stored proc i am using. and also if someone can kindly point me to any good SQL mail list, it woul help me a lot. thanx in advance. akbar ~~ 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 Stored Proc)
thanx bob. i got it using that.:) -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 3:27 PM To: CF-Talk Subject: RE: (SQL Stored Proc) I haven't done that, but I'd start by looking at xp_cmdshell - you might be able to do something with that and the DIR command. As for a good mailing list, check out www.swynk.com. Bob -Original Message- From: Akbar Pasha [mailto:[EMAIL PROTECTED]] Sent: March 29, 2001 2:56 PM To: CF-Talk Subject: OT:(SQL Stored Proc) hi all, i am sorry to ask SQL question in CF list, but i am not aware of any good SQL mail list. so here i am... is there a way to check the existence of file using SQL?? i mean some SQL function or some kind of query format which will tell me whether the passed file name exists on the computer or not? i need this functionality in a stored proc i am using. and also if someone can kindly point me to any good SQL mail list, it woul help me a lot. thanx in advance. akbar ~~ 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 Stored Proc)
sure. just in case ppl dont think i am spamming them, here is a brief explanation of wat i was trying to do.. we have a scheduler. which calls a stored procedure every 15 mins. and this SP goes thru a table in DB and updates specific fields. and also in the process the SP opens up a .DBF file and gets the data into the DB. these .DBF files are placed in a particular directory. sometimes these DBF files were not uploaded or renamed or something gone wrong..the SP not able to find the file was halting. i mean, if its updating 100 records and it doesnt find a DBF file pertaining to 55th record..it halts and never updates the remaining 44 records. so i was just trying to find out if the file exists then update other wise proceed further (i.e nothing but to go to another record in the cursor) here is the code which worked for me... declare @tresult int declare @tempstr varchar(255) set @tempstr = 'dir c:\common\files\' + @path + '\sample.dbf' exec @tresult = master..xp_cmdshell @tempstr IF (@tresult = 0) BEGIN PRINT 'Success' INSERT INTO #sample(sam_no,status, lastquest) SELECT * FROM OPENQUERY(TEST,'SELECT sam_no, stat_type, lastquest FROM sample') .. END ELSE .. -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 4:17 PM To: CF-Talk Subject: RE: (SQL Stored Proc) Great! Mind sharing your solution with the rest of us? Bob -Original Message- From: Akbar Pasha [mailto:[EMAIL PROTECTED]] Sent: March 29, 2001 3:35 PM To: CF-Talk Subject: RE: (SQL Stored Proc) thanx bob. i got it using that.:) -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 3:27 PM To: CF-Talk Subject: RE: (SQL Stored Proc) I haven't done that, but I'd start by looking at xp_cmdshell - you might be able to do something with that and the DIR command. As for a good mailing list, check out www.swynk.com. Bob -Original Message- From: Akbar Pasha [mailto:[EMAIL PROTECTED]] Sent: March 29, 2001 2:56 PM To: CF-Talk Subject: OT:(SQL Stored Proc) hi all, i am sorry to ask SQL question in CF list, but i am not aware of any good SQL mail list. so here i am... is there a way to check the existence of file using SQL?? i mean some SQL function or some kind of query format which will tell me whether the passed file name exists on the computer or not? i need this functionality in a stored proc i am using. and also if someone can kindly point me to any good SQL mail list, it woul help me a lot. thanx in advance. akbar ~~ 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: CFMAIL - not going out??
we had a similar kind of problem and after raving about it for 3 days we realized that our newly installed firewall was the culprit. it may not be the case with ur setup, but just wanna share that sometimes we concentrate much on the problem and forget to look around. akbar -Original Message- From: Gavin Lilley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 8:47 AM To: CF-Talk Subject: RE: CFMAIL - not going out?? I had this exact problem on an intranet server. I didn't solve the problem but have a snapshot of the server if I do ever find out what the problem was. -- Gavin Lilley Internet / Intranet Developer http://halesowen.ac.uk -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] Sent: 27 March 2001 14:41 To: CF-Talk Subject: Re: CFMAIL - not going out?? Have you checked your mail logs in the CF Administrator? You do have logging turned on, correct? - Douglas Knudsen Leveraged Technologies Group Alltel AIS 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 03/26/2001 06:35 PM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: CFMAIL - not going out?? For three days now, all of the confirmation emails my CF app sends out are being put in the /mail/spool/ directory and NOT sent. They are all sitting there, hundreds of emails. This has been working for months! I am running CF 4.5.2 SP2 on RedHat Linux 6.2. Can anyone give me any hints/tips where to even begin looking for why the mails are just sitting there? How can I "kick" the CF server to send them? I have looked in the logs and find no mention of these emails... (not in applica tion.log nor in mail.log) HELP! -- - Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 ~~ 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_excel??
Is it the proper use of custom tag cf_excel . i want to take the resultset which is on the browser to excel sheet with the same result set appearing in the sheet. but with this tag i managed to pass the link to webpage to excel sheet. but there i could able to see the same code instead of result set. in the first file i given link to xls file like this a href="filename.xls"Go to Excel/a in filename.xls i wrote following customtag code cfset a=#session.cID# cfset b=#dateformat(session.sdate,"mm/dd/yy")# cfset c=#dateformat(session.edate,"mm/dd/yy")# cfoutput cf_excel Datasource="dsnname" Tableheadings = "Bank,Branch,Name,Account,Amount" DataFields="bank,brn,name,Acno,visitamt" SQLCommand="select cc.bank,cc.name,cc.BRN,cc.ACNo,visit.visitamt from cc,visit where cc.cID=#a# and visit.eom=1 and visit.cid= cc.cid and visitdate between #b# and #c# order by cc.cID" /cfoutput so, in the excel sheet i'm getting same code in cfoutput tag not the records. thankx in advance nagesh p.s. can anyone tell me how to insert records in a excel sheet from cold fusion? -- Archives: http://www.eGroups.com/list/cf-talk 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.
RE: CFQUERY problem
the "text" is a keyword in access. so the error -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 25, 2000 2:06 AM To: [EMAIL PROTECTED] Subject: CFQUERY problem Hi, I'm trying to build a dynamically filled drop down select box. However, I keep getting an error message which I cannot resolve, and I'd appreciate some advice. The error message is: "ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. SQL = "SELECT JokeTitle FROM Text" Data Source = "Jokes" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (3:14). " The code for the form is below. Please note that the name of the table is 'text'. CFQUERY DATASOURCE="Jokes" NAME="Titles" SELECT JokeTitle FROM Text /CFQUERY !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleJokes/title /head body h1JOKES/h1 FORM ACTION="jokesaction.cfm" METHOD="POST" Please select the joke titles from the contents of the select boxes below. You may select up to five titles at a time. Joke title #1: SELECT NAME="JokeTitle" OPTION CFOUTPUT QUERY="Titles" OPTION VALUE="#JokeTitle#"#Titles# /cfoutput /select /FORM /body /html Thanks. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view this with a sense of humour!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
RE: Basic datasource question
u should even look into the security issue of login name and pwd. and if u r intending to use spectra enable retrival of long text.:-) -Original Message- From: R Navaneethan [mailto:[EMAIL PROTECTED]] Sent: Monday, April 24, 2000 6:01 PM To: [EMAIL PROTECTED] Subject: Basic datasource question I am trying to create datasource for SQL Server 6.5 database (default Master database). I try with following details: DSN Name: test Server : Sales Database: Master Any other settings necessary to set the dsn? Also, please give the syntax for "Host string" to create DSN for Oracle 8.0 with native driver. Thanks, naveen __ Do You Yahoo!? Send online invitations with Yahoo! Invites. http://invites.yahoo.com -- Archives: http://www.eGroups.com/list/cf-talk 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.eGroups.com/list/cf-talk 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.
next 5 records
hi everybody, this may look silly but i have a small problem. i hvae a query and for the first time i want to display 5 records and on pressing the next button it should show next 5 records...and so on. i remember seeing a solution for this long back but i forgot. so, can anyone plzz send me the code?? thanx in advance akbar -- Archives: http://www.eGroups.com/list/cf-talk 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.