Recursive List output
hihi.. anyone can help me..?? given a list of numbers, eg: 1,2 ,3, 4 ,5 ,6 ,7 ,8 ,9 ,10 the quantity of numbers in each group.. eg: 6 i suppose to output a list of grouping something like this eg: 1,2,3,4,5,6 1,2,3,4,5,7 : : 1,2,3,4,5,10 1,3,4,5,6,7 1,3,4,5,6,8 : 1,3,4,5,6,10 : : 1,6,7,8,9,10 2,3,4,5,6,7 : 2,6,7,8,9,10 3,4,5,6,7,8 : : : 5,6,7,8,9,10 Numbers in each grp shld be in ASC order.. There will be no repeating of numbers in each group. tried to do it with nested cfloop and list functions... but still cant get it... :( please show me some light if u r able to get it.. :) mail me direct, please ...;p thanx in advance... ;) han ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Possible to send out mail for CFerror..?
Hi all.. is it possible to configure CFError to send out a mail to administrator automatically.. when user hits an error.? i tried putting cfmail inside CFerror codes... but unsuccessful please advice.. han __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Any available suite for spa management?
Hi, anyone know where can i find good spa/hotel management suite for web based available..? or anyone have done it.? will like to purchase it.. coz client need the system in 1 1/2 mths time. Not enough time for our company to develop from scratch.. :( cheers han __ 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: Possible to detect user clicking on top right X to close windows?
THANX.. i shall try that... hope it works.. ;p - Original Message - From: Jesse Houwing [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 5:19 PM Subject: Re: Possible to detect user clicking on top right X to close windows? han peng wrote: Hi.. hi... juz wondering... is it possible for us to find out user clicking on the CLose icon at top right corner? thinking of detecting it.. and then do a proper logging out of our website b4 closing the window. You could try to set the event onclose in javascript. Jesse __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Possible to detect user clicking on top right X to close windows?
sigh... unsuccessful. IE doesnt support onClose(). only Netscape 6+ supports that now. i tried using onunload to call this function.. function leave() { window.open('dsp_logout.cfm','','toolbar=yes,menubar=yes,location=yes,height =500,width=500'); } but hav a problem coz... even reloading of the page will still activate the script.. :( hmm..so.. anyway i can chk for 'ALT+F4' or mousedown for the top right corner.? tried this too.. cant work.. :( function leave() { if (window.closed) { window.open('dsp_logout.cfm','','toolbar=yes,menubar=yes,location=yes,height =500,width=500'); } } han - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 10:43 AM Subject: Re: Possible to detect user clicking on top right X to close windows? THANX.. i shall try that... hope it works.. ;p - Original Message - From: Jesse Houwing [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 5:19 PM Subject: Re: Possible to detect user clicking on top right X to close windows? han peng wrote: Hi.. hi... juz wondering... is it possible for us to find out user clicking on the CLose icon at top right corner? thinking of detecting it.. and then do a proper logging out of our website b4 closing the window. You could try to set the event onclose in javascript. Jesse __ Get the mailserver that powers this list at http://www.coolfusion.com 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
CFMAIL unknown error
Error Diagnostic Information unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (103:5) to (103:145) in the template file . hi... anyone hav any problem like this before..? works fine previously.. but now just suddenly cant work. i'm sure its not the coding problem.. as the same sets of codes can works in another server. any advice anyone.? han __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
Shld CF Server and IIS web server run on separate machines?
Hi all CF gurus.. :) currently i'm running CF server and IIS server on 1 machine (M1)... and MS Sql Server on another machine(M2)... so.. shld i separate the apps server and web server to optimise the performance..? that is to install CF server on another machine (M3)?? hmm... but i 'm juz wondering.. if i configure the IIS application setting to point to M3 through network.. wouldnt that be a slower process as every cfm scripts need to be access from webserver to app server.. ?? hmm.. any place that teach how to do such configuration..?! coz i'm not sure is that the correct way to link both web and CF server together.. thanx in advance.. han __ 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: session cookies to expire immediately on browser close
hmm.. funnies... plugged yr codes into my application.cfm but doesnt seem to work... is there some other setting need to be configured at browser setting.. or Server side.? cheers han - Original Message - From: Jeff Garza [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 3:14 PM Subject: Re: session cookies to expire immediately on browser close Brian, this is a great snippet!!! Thanks. I have been wondering how to force the session to die without an explicit logout. This will definately do the trick. Cheers, Jeff Garza - Original Message - From: Brian Scandale [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 11:39 PM Subject: Re: session cookies to expire immediately on browser close This is what I use I picked it up off I don't actually remember where but it works great. - this is what I use --- !--- At times developers are frustrated that the session does not end when the user closes their browser-that they must wait for the session to time out. If you've found yourself wishing for this behavior in session variables, you'll be happy to know that you can implement this very easily: --- cfif IsDefined( Cookie.CFID ) AND IsDefined( Cookie.CFTOKEN ) cfset localCFID = Cookie.CFID cfset localCFTOKEN = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif !--- Place this code right beneath your cfapplication tag. This code first checks to see if the cookies CFID and CFTOKEN exist. Remember that ColdFusion will try to set these as cookie variables in the cfapplication tag. If they are there, set by cfapplication (and due to the peculiar way cookies operate, they will appear to be present even if the user has their cookies turned off), the value of these cookies will be read into two local variables. Then the pair of cookies will be overwritten, using the same values they had previously, but this time deliberately omitting the expires property of the cfcookie tag. Leaving off the expires property causes the cookie to remain in the browser memory, but not to be written to the user's disk. When the browser is closed, the cookie information goes with it and, by inference, so goes the session. --- At 02:04 PM 5/10/02 +0800, you wrote: hihi.. where am i suppose to put this.. if i want to set cookie to expire when browser close.?? cfcookie expires=NOW name=CFID value=#cookie.cfid# is it at application.cfm? cheers han __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
session cookies to expire immediately on browser close
hihi.. where am i suppose to put this.. if i want to set cookie to expire when browser close.?? cfcookie expires=NOW name=CFID value=#cookie.cfid# is it at application.cfm? cheers han __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: session/browser problem??!!
oh no... seems like no one knows how to solve this strange problem.. sigh.. han - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 04, 2002 12:25 AM Subject: Re: session/browser problem??!! sigh the problem is.. i'm using direct ip to access the website... which is an intranet.. problem still unsolve :( han - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 03, 2002 10:33 PM Subject: RE: session/browser problem??!! i posted the answer to this question a while back. I have found the light http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316112 basically you can't have illegal characters in the domain name. in my case it was a _. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 6:11 AM To: CF-Talk Subject: session/browser problem??!! hihi.. i'm having some problem with the sessions. my codes works perfectly with IE 5, netscape 6 but not for IE 5.5 and IE 6. are there any known issues of session/cookies problem with the latter group?? seems like even i set all cookies and session enabled.. it still cant store my sessions... :( hmm.. probably.. theres some problem with the way i write my codes.. :( can u ppl help me to chk..? application.cfm: == CFAPPLICATION name=evehicle clientmanagement=Yes sessionmanagement=Yes setClientCookies = Yes sessiontimeout=#CreateTimeSpan(0,2,0,0)# applicationtimeout=#CreateTimeSpan(0,2,0,0)# clientstorage=evehicle setdomaincookies=Yes !--- enables closing of browser to kill session --- CFIF NOT IsDefined(cookie.CFID) CFLOCK SCOPE=session TYPE=readonly TIMEOUT=5 CFCOOKIE NAME=CFID VALUE=#session.CFID# CFCOOKIE NAME=CFTOKEN VALUE=#session.CFTOKEN# /CFLOCK /CFIF !--- end kill session --- cfsetting enablecfoutputonly=yes !--- Session-Tracker Code --- cflock name=#APPLICATION.applicationName# type=Exclusive timeout=5 throwontimeout=Yes !--- If Session-Tracker does not exist, generate it --- cfparam name=APPLICATION.SessionTracker default=#StructNew()# /cflock cfsetting enablecfoutputonly=no chklogin.cfm (to chk for valid login.. if true then set to session...) == .. blah.. cflock name=#APPLICATION.applicationName# type=Exclusive timeout=5 throwontimeout=Yes CFIF #StructKeyExists(APPLICATION.SessionTracker, cgi.REMOTE_ADDR)# eq YES cfset userexist= YES CFELSE !--- Log current user --- cfset userexist= No CFSET dummy = StructInsert(APPLICATION.SessionTracker, CGI.REMOTE_ADDR, Now(), true) /CFIF /cflock CFIF #userexist# eq YES SCRIPT LANGUAGE=JAVASCRIPT alert(Multiple Users Login at 1 machine is not allowed. Current Window will be closed.) self.close() /SCRIPT cfoutput query=checkusera href=main/dsp_logout.cfm?strUserName=#CHECKUSER.STRUSERNAME#Force Logout?/a/cfoutput CFELSE CFSET session.login = queryNew(strUserName, IntAccessGroupID, IntCompanyID, strSFID, dtmLastLogin, clientIP) CFSET tempValue = queryAddRow(session.login, 1) CFSET tempValue = querySetCell(session.login, strUserName, #trim(CHECKUSER.strUserName)#) CFSET tempValue = querySetCell(session.login, IntAccessGroupID, #trim(CHECKUSER.IntAccessGroupID)#) CFSET tempValue = querySetCell(session.login, IntCompanyID, #trim(CHECKUSER.IntCompanyID)#) CFSET tempValue = querySetCell(session.login, strSFID, #trim(CHECKUSER.strSFID)#) CFSET tempValue = querySetCell(session.login, dtmLastLogin, #trim(CHECKUSER.dtmLastLogin)#) CFSET tempValue = querySetCell(session.login, clientIP, #cgi.REMOTE_ADDR#) !-- If the user is logged in we transfer him/her to the homepage -- CFQUERY name=UpdateLogin datasource=#request.DSN# UPDATE tblUser SET dtmLastLogin = CURRENT_TIMESTAMP, blnloginStatus = 1 Where strUserName = '#session.login.strUserName#' /CFQUERY SCRIPT LANGUAGE=JavaScript self.location ='./Main'; /SCRIPT /CFIF main/index.cfm (my main page which using fusebox3.. ) cfif not IsDefined(session.login.strUserName) or session.login.strUserName eq CFLOCATION URL=../index.cfm?msg=4 ADDTOKEN=No !--- back to login page.--- /cfif .. .. .. . everytime i reach here.. i was re-routed to login page again. :( thank for yr help in advance.. Lost, han :( __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http
session/browser problem??!!
hihi.. i'm having some problem with the sessions. my codes works perfectly with IE 5, netscape 6 but not for IE 5.5 and IE 6. are there any known issues of session/cookies problem with the latter group?? seems like even i set all cookies and session enabled.. it still cant store my sessions... :( hmm.. probably.. theres some problem with the way i write my codes.. :( can u ppl help me to chk..? application.cfm: == CFAPPLICATION name=evehicle clientmanagement=Yes sessionmanagement=Yes setClientCookies = Yes sessiontimeout=#CreateTimeSpan(0,2,0,0)# applicationtimeout=#CreateTimeSpan(0,2,0,0)# clientstorage=evehicle setdomaincookies=Yes !--- enables closing of browser to kill session --- CFIF NOT IsDefined(cookie.CFID) CFLOCK SCOPE=session TYPE=readonly TIMEOUT=5 CFCOOKIE NAME=CFID VALUE=#session.CFID# CFCOOKIE NAME=CFTOKEN VALUE=#session.CFTOKEN# /CFLOCK /CFIF !--- end kill session --- cfsetting enablecfoutputonly=yes !--- Session-Tracker Code --- cflock name=#APPLICATION.applicationName# type=Exclusive timeout=5 throwontimeout=Yes !--- If Session-Tracker does not exist, generate it --- cfparam name=APPLICATION.SessionTracker default=#StructNew()# /cflock cfsetting enablecfoutputonly=no chklogin.cfm (to chk for valid login.. if true then set to session...) == ... blah.. . cflock name=#APPLICATION.applicationName# type=Exclusive timeout=5 throwontimeout=Yes CFIF #StructKeyExists(APPLICATION.SessionTracker, cgi.REMOTE_ADDR)# eq YES cfset userexist= YES CFELSE !--- Log current user --- cfset userexist= No CFSET dummy = StructInsert(APPLICATION.SessionTracker, CGI.REMOTE_ADDR, Now(), true) /CFIF /cflock CFIF #userexist# eq YES SCRIPT LANGUAGE=JAVASCRIPT alert(Multiple Users Login at 1 machine is not allowed. Current Window will be closed.) self.close() /SCRIPT cfoutput query=checkusera href=main/dsp_logout.cfm?strUserName=#CHECKUSER.STRUSERNAME#Force Logout?/a/cfoutput CFELSE CFSET session.login = queryNew(strUserName, IntAccessGroupID, IntCompanyID, strSFID, dtmLastLogin, clientIP) CFSET tempValue = queryAddRow(session.login, 1) CFSET tempValue = querySetCell(session.login, strUserName, #trim(CHECKUSER.strUserName)#) CFSET tempValue = querySetCell(session.login, IntAccessGroupID, #trim(CHECKUSER.IntAccessGroupID)#) CFSET tempValue = querySetCell(session.login, IntCompanyID, #trim(CHECKUSER.IntCompanyID)#) CFSET tempValue = querySetCell(session.login, strSFID, #trim(CHECKUSER.strSFID)#) CFSET tempValue = querySetCell(session.login, dtmLastLogin, #trim(CHECKUSER.dtmLastLogin)#) CFSET tempValue = querySetCell(session.login, clientIP, #cgi.REMOTE_ADDR#) !-- If the user is logged in we transfer him/her to the homepage -- CFQUERY name=UpdateLogin datasource=#request.DSN# UPDATE tblUser SET dtmLastLogin = CURRENT_TIMESTAMP, blnloginStatus = 1 Where strUserName = '#session.login.strUserName#' /CFQUERY SCRIPT LANGUAGE=JavaScript self.location ='./Main'; /SCRIPT /CFIF main/index.cfm (my main page which using fusebox3.. ) cfif not IsDefined(session.login.strUserName) or session.login.strUserName eq CFLOCATION URL=../index.cfm?msg=4 ADDTOKEN=No !--- back to login page.--- /cfif ... ... ... .. everytime i reach here.. i was re-routed to login page again. :( thank for yr help in advance.. Lost, han :( __ 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: session/browser problem??!!
sigh the problem is.. i'm using direct ip to access the website... which is an intranet.. problem still unsolve :( han - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 03, 2002 10:33 PM Subject: RE: session/browser problem??!! i posted the answer to this question a while back. I have found the light http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316112 basically you can't have illegal characters in the domain name. in my case it was a _. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 6:11 AM To: CF-Talk Subject: session/browser problem??!! hihi.. i'm having some problem with the sessions. my codes works perfectly with IE 5, netscape 6 but not for IE 5.5 and IE 6. are there any known issues of session/cookies problem with the latter group?? seems like even i set all cookies and session enabled.. it still cant store my sessions... :( hmm.. probably.. theres some problem with the way i write my codes.. :( can u ppl help me to chk..? application.cfm: == CFAPPLICATION name=evehicle clientmanagement=Yes sessionmanagement=Yes setClientCookies = Yes sessiontimeout=#CreateTimeSpan(0,2,0,0)# applicationtimeout=#CreateTimeSpan(0,2,0,0)# clientstorage=evehicle setdomaincookies=Yes !--- enables closing of browser to kill session --- CFIF NOT IsDefined(cookie.CFID) CFLOCK SCOPE=session TYPE=readonly TIMEOUT=5 CFCOOKIE NAME=CFID VALUE=#session.CFID# CFCOOKIE NAME=CFTOKEN VALUE=#session.CFTOKEN# /CFLOCK /CFIF !--- end kill session --- cfsetting enablecfoutputonly=yes !--- Session-Tracker Code --- cflock name=#APPLICATION.applicationName# type=Exclusive timeout=5 throwontimeout=Yes !--- If Session-Tracker does not exist, generate it --- cfparam name=APPLICATION.SessionTracker default=#StructNew()# /cflock cfsetting enablecfoutputonly=no chklogin.cfm (to chk for valid login.. if true then set to session...) == .. blah.. cflock name=#APPLICATION.applicationName# type=Exclusive timeout=5 throwontimeout=Yes CFIF #StructKeyExists(APPLICATION.SessionTracker, cgi.REMOTE_ADDR)# eq YES cfset userexist= YES CFELSE !--- Log current user --- cfset userexist= No CFSET dummy = StructInsert(APPLICATION.SessionTracker, CGI.REMOTE_ADDR, Now(), true) /CFIF /cflock CFIF #userexist# eq YES SCRIPT LANGUAGE=JAVASCRIPT alert(Multiple Users Login at 1 machine is not allowed. Current Window will be closed.) self.close() /SCRIPT cfoutput query=checkusera href=main/dsp_logout.cfm?strUserName=#CHECKUSER.STRUSERNAME#Force Logout?/a/cfoutput CFELSE CFSET session.login = queryNew(strUserName, IntAccessGroupID, IntCompanyID, strSFID, dtmLastLogin, clientIP) CFSET tempValue = queryAddRow(session.login, 1) CFSET tempValue = querySetCell(session.login, strUserName, #trim(CHECKUSER.strUserName)#) CFSET tempValue = querySetCell(session.login, IntAccessGroupID, #trim(CHECKUSER.IntAccessGroupID)#) CFSET tempValue = querySetCell(session.login, IntCompanyID, #trim(CHECKUSER.IntCompanyID)#) CFSET tempValue = querySetCell(session.login, strSFID, #trim(CHECKUSER.strSFID)#) CFSET tempValue = querySetCell(session.login, dtmLastLogin, #trim(CHECKUSER.dtmLastLogin)#) CFSET tempValue = querySetCell(session.login, clientIP, #cgi.REMOTE_ADDR#) !-- If the user is logged in we transfer him/her to the homepage -- CFQUERY name=UpdateLogin datasource=#request.DSN# UPDATE tblUser SET dtmLastLogin = CURRENT_TIMESTAMP, blnloginStatus = 1 Where strUserName = '#session.login.strUserName#' /CFQUERY SCRIPT LANGUAGE=JavaScript self.location ='./Main'; /SCRIPT /CFIF main/index.cfm (my main page which using fusebox3.. ) cfif not IsDefined(session.login.strUserName) or session.login.strUserName eq CFLOCATION URL=../index.cfm?msg=4 ADDTOKEN=No !--- back to login page.--- /cfif .. .. .. . everytime i reach here.. i was re-routed to login page again. :( thank for yr help in advance.. Lost, han :( __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
InitCap function in Cold Fusion??
hihi.. is there such a function around.?! need to convert the 1st letter of a string to UpperCase. cheers han __ 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
session cant work in IE 5.5 and 6??
hihi... anyone have such problems before..?? my codes works perfectlyfine in ie 5... but seems like the session variables cant be used in IE 5.5 and 6. i tried to output the values... in 5.. can.. but not in 5.5 and 6.. sigh.. help help sad, han __ 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: session cant work in IE 5.5 and 6??
hmm.. how do i do that..?? please enlighten me... i already enabled Allow per-session cookies at Security Setting, internet options.. still cant work... :( is there other things i have to do..? how do i reset the session variable switch..?? han - Original Message - From: Michael Pool [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 11:44 AM Subject: RE: session cant work in IE 5.5 and 6?? It's a new security patch I thinkgotta turn on your cookies and reset the session variable switch. Thanks a lot MicroSoft! -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 11:37 PM To: CF-Talk Subject: Re: session cant work in IE 5.5 and 6?? I use session variables in 5/5.5 and 6 ...as well as other browsers Don't know what to tell ya ... but it isn't the browser ..unless you have the cookies turned off or something like that.. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder hihi... anyone have such problems before..?? my codes works perfectlyfine in ie 5... but seems like the session variables cant be used in IE 5.5 and 6. i tried to output the values... in 5.. can.. but not in 5.5 and 6.. sigh.. help help sad, han __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
How to display each start and end date of all 12 weeks in a quarter?
hihi anyone know how shld i go abt doing it given a 1,2,3, or 4 as quarter and a year(eg 2002). i shld be able to produce something like this..: User make a choice : 4 th quarter of 2001... DISPLAY: WEEK4243 4445 .. Start date 01/10/200108/10/2001... End Date0710/200115/10/2001... i cant juz set the first day of that quarter as 01/10/2001... as it may not be the start day of the week... pls advice... :( thanx han __ Get the mailserver that powers this list at http://www.coolfusion.com 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
anyone seen such error msg b4??
unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag i got this while running a queryof query.. my codes. CFQUERY name=getModelList datasource=#request.DSN# SELECT strModel FROM tblModel WHERE intcompanyID = #attributes.intCompanyID# ORDER by strModel /CFQUERY CFQUERY name=getProspectList datasource=#request.DSN# select * from tblProspectdetails a, tblcarCompany c where a.dtmEntryDate Between '#DateFrom#' and '#DateTo#' and a.intcompanyID = #attributes.intCompanyID# order by a.strModelInterested, a.dtmEntryDate /CFQUERY CFSET Totalprospect = #getProspectList.recordcount# CFQUERY name=getTestDriveList datasource=#request.DSN# select * from tblProspectdetails a, tbltestdrive b, tblcarCompany c where a.intProspectID = b.intProspectID and b.dtmTestDriveDate Between '#DateFrom#' and '#DateTo#' and a.intcompanyID = #attributes.intCompanyID# order by b.strTestDriveModel, b.dtmTestDriveDate /CFQUERY CFSET totalTestDrive = #getTestDriveList.recordcount# . . . . CFLOOP query=getModelList CFSET currModel= #strModel# CFQUERY name=getProspectCount dbtype=query select count()as noofprospect from getProspectList WHERE strModelInterested = '#currModel#' /CFQUERY CFQUERY name=getTestDriveCount dbtype=query select count()as nooftestdrive from getTestDriveList WHERE strTestDriveModel = '#currModel#' /CFQUERY : : /cfloop any prob with the way i written it..? worried han __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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: anyone seen such error msg b4??
hohoho.. wat a silly mistake.. thank pal!!! cheers han - Original Message - From: Marlon Moyer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 25, 2002 12:19 PM Subject: Re: anyone seen such error msg b4?? doesn't it need to be 'select count(*)...' - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 24, 2002 10:21 PM Subject: anyone seen such error msg b4?? unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag i got this while running a queryof query.. my codes. CFQUERY name=getModelList datasource=#request.DSN# SELECT strModel FROM tblModel WHERE intcompanyID = #attributes.intCompanyID# ORDER by strModel /CFQUERY CFQUERY name=getProspectList datasource=#request.DSN# select * from tblProspectdetails a, tblcarCompany c where a.dtmEntryDate Between '#DateFrom#' and '#DateTo#' and a.intcompanyID = #attributes.intCompanyID# order by a.strModelInterested, a.dtmEntryDate /CFQUERY CFSET Totalprospect = #getProspectList.recordcount# CFQUERY name=getTestDriveList datasource=#request.DSN# select * from tblProspectdetails a, tbltestdrive b, tblcarCompany c where a.intProspectID = b.intProspectID and b.dtmTestDriveDate Between '#DateFrom#' and '#DateTo#' and a.intcompanyID = #attributes.intCompanyID# order by b.strTestDriveModel, b.dtmTestDriveDate /CFQUERY CFSET totalTestDrive = #getTestDriveList.recordcount# .. .. .. .. CFLOOP query=getModelList CFSET currModel= #strModel# CFQUERY name=getProspectCount dbtype=query select count()as noofprospect from getProspectList WHERE strModelInterested = '#currModel#' /CFQUERY CFQUERY name=getTestDriveCount dbtype=query select count()as nooftestdrive from getTestDriveList WHERE strTestDriveModel = '#currModel#' /CFQUERY : : /cfloop any prob with the way i written it..? worried han __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: how to retrieving data by age of record in MSSQL
hmm.. think i cant do that... coz.. thats will oso return 6 yrs 7 yrs.. blah hmm.. anyway... i think i got it... thats a datepart in sqlsever oso... i can use datepart to chk the yr in orderdate = (current yr -5) hope that can work.. havnt try that out... thanx anyway pal!!: ) cheers han - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 22, 2002 12:47 PM Subject: Re: how to retrieving data by age of record in MSSQL !--- get todays date --- cfset todayDate = #Now()# !--- Use the DateAdd function to subtract 5 years from today --- cfset variables.olddate = #DateAdd(, -5, todayDate)# !--- run the query with the less than --- cfquery select columnames from tablename where orderdate #variables.olddate# /cfquery that should do ya up! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 10:48 PM Subject: how to retrieving data by age of record in MSSQL hihi..all gurus.. i know this is not appropriate here... sorry to bother u all i need to write a query to retrieve existing records by age of the records.. eg. user want to see Sales orders that are 5 yrs old.. so i need to write a query to retrieve from sales table.. where theres a orderdate column int it.. datatype is datetime. so how am i going to write the query in mssql..?? oracle can use trunc() .. but mssql dont hav that... :( help help.. hanpeng __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
anyone hosting free forum?
hihi.. i'm thinking of putting up a forum for a non-profitable drama organisation in singapore for their members to interact with each other... so anyone hav any idea i can sign up a free forum for them.?? or anyone here hosting a free one..?? hmm.. or have any simple codes to spare..? sigh.. i too busy doing my office works.. cant write one from scratch : ( thanx for yr help.. cheers han __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
how to retrieving data by age of record in MSSQL
hihi..all gurus.. i know this is not appropriate here... sorry to bother u all i need to write a query to retrieve existing records by age of the records.. eg. user want to see Sales orders that are 5 yrs old.. so i need to write a query to retrieve from sales table.. where theres a orderdate column int it.. datatype is datetime. so how am i going to write the query in mssql..?? oracle can use trunc() .. but mssql dont hav that... :( help help.. hanpeng __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Target back to parent.
okok.. this is wat i do.. i hav it working to call for a look up.. from main.. to a child.. then do a query and pass bk my query result to the parent... heres the codes.. hope it helps.. --- start of parent- SCRIPT LANGUAGE=JavaScript TYPE=text/javascript !-- function find_Street(code) { if((code != '')(document.form.strStreetName.value=='')) { sList = window.open(presale/CFfindStreet.cfm?strPostalCode=+code, _blank, width=1,height=1); } } function find_PostalCode(street,block) { if ((street != '')(block != '')) sList = window.open(presale/CFfindPostalCode.cfm?strStreetName=+street+strBlockN umber=+block, _blank, width=1,height=1); } } function remLink() { if (window.sList window.sList.open !window.sList.closed) window.sList.opener = null; } //-- /SCRIPT . .. ... tr td width=5%BLK/HSE NO./td td width=25%cfinput type=text name=strBlockNumber size=5 maxlength=5 message=Please enter your Block / House Number. required=Yes onerror=setFocus value=#session.prospect.strBlockNumber# onblur=find_PostalCode(document.form.strStreetName.value,this.value);/td td width=5%FLR./td td width=25%cfinput type=text name=strFloorNumber size=5 maxlength=5 message=Please enter numbers only for your floor number. required=No value=#session.prospect.strFloorNumber# validate=integer onerror=setFocus/td td width=5%UNIT/td td width=25%cfinput type=text name=strUnitNumber size=5 maxlength=5 message=Please enter numbers only for your unit number. required=No value=#session.prospect.strUnitNumber# validate=integer onerror=setFocus/td td width=5%nbsp;/td td width=5%nbsp;/td /tr tr tdST/td td colspan =3cfinput type=text name=strStreetName size=50 maxlength=50 message=Please enter your Street Name. required=Yes onerror=setFocus value=#session.prospect.strStreetName# onblur=find_PostalCode(this.value, document.form.strBlockNumber.value);/td tdBLDG/td td colspan =3cfinput type=text name=strBuildingName size=50 maxlength=50 message=Please enter your Building Name. required=No value=#session.prospect.strBuildingName#/td /tr tr tdPD/td tdcfinput type=text name=strPostalName size=8 maxlength=6 message=Please choose your Postal Code. validate=integer required=Yes value=#session.prospect.strPostalName# onerror=setFocus onblur=find_Street(this.value); /td blahblah.. end of parent--- ---start of child--- this only contains how i pass the value bk to parent.. SCRIPT LANGUAGE=JavaScript !-- if (window.opener !window.opener.closed) { window.opener.document.form.strStreetName.value ='#UCASE(StreetName)#'; window.opener.document.form.strPostalName.value ='#strPostalCode#'; window.close(); } // -- /SCRIPT ---end of child--- cheers han - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 5:47 AM Subject: RE: Target back to parent. Niel out of curiosity.. is your child window modal? If so, the rules are a little bit different. We've found that the only way to process the action page nicely (meaning without a blank window opening for a moment), is to use a hidden IFRAME on the modal window, and set our form's target to the IFrame. Before we did this (and having proved it again afterwards), we were getting some tough javascript problems to fix (unable to refresh the current page, etc.). Hope that helps. Shawn Grover -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 2:36 PM To: CF-Talk Subject: Re: Target back to parent. Sigh This is frustrating. What a long day. Neil - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 11, 2002 4:05 PM Subject: RE: Target back to parent. That's what I have netscape for. That's the only thing I like about it, is it's little javascript error log. It catches every javascript error, unlike IE, which sometimes lets them fly on by without doing anything. _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 4:01 PM To: CF-Talk Subject: Re: Target back to parent. Yeah for some reason that bit of code didn't work :( Neil - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 11, 2002 3:51 PM Subject: RE: Target back to parent. You don't need to send the form variables back to the mainwindow. Just submit the form in the child window, process the data there, then close it and reload the main
Re: which is the best way to do auto retrieval of Address...
thanx ppl!! problem solved! but hmm.. anyone know how to hide the popup.. under the parent page.. so that the user dun even know theres a pop up to generate it...??!! HAPPY MAN, han - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:29 AM Subject: RE: which is the best way to do auto retrieval of Address... Yes you could do that, in the onchange paramater of the select box have it popup a new window. Do the query in that new window, then user the following javascript. script opener.formname.streetname = 'qry.StreetName'; opener.formname.city = 'qry.City'; /script If the form isn't named, and you only have 1 form on your page, you can use opener.forms[0].streetname Although this will cause a popup to show and disappear, I think a better way would be to just navigate to the same page with ?zip=12345 at the end of it. You'd have to cfparam all of your form fields this way, like cfparam name=thisform.FirstName default= Then in the form, input type=text name=FirstName value=#thisform.FirstName# At the top of the page you'd need to do something like. cfif isDefined(FORM.postalcode) cfset thisform = StructCopy(FORM) /cfif That will copy everything submitted through the form into the thisform structure, so if they filled out half of the form before selecting a postal code, it will load it all in the form. _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:19 AM To: CF-Talk Subject: Re: which is the best way to do auto retrieval of Address... hmm.. are u saying... upon selected a postal code.. i callup a popup page which will perform a cfquery and do a matching... then pass back the matched value back to parent?? can I do that..?? if can... how shld i pass the value to and fro child and parent page...?? cheers han - Original Message - From: Robert Obreczarek [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 2:44 PM Subject: RE: which is the best way to do auto retrieval of Address... How about using frames? maybe an iframe/ilayer. that way you could click on a name, and the info would pop in a another frame Robert -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:13 PM To: CF-Talk Subject: which is the best way to do auto retrieval of Address... hi... i need to do a address input fields.. where customer can choose their postal code.. and his house number and streetname will be retrieved out automatically... the codes below actually can do the work.. but because theres about 100,000 data to be put into array...so it took almost like a minute to load a page sigh... anyone have a better idea.? i did it this way coz customer wan to retrieve the data instantly.. thanx han Javascript function: function display_Street(box1, box2) { var TotalStreetArray = box2.length; for(i=0; iTotalStreetArray; i++) { if(box2[i][0] == box1) { document.form.strStreetName.value = box2[i][1]; document.form.strBlockNumber.value = box2[i][2]; } } } !--- Database Queries --- CFQUERY name=PostalCode_list datasource=#request.DSN# cachedwithin=#CreateTimeSpan(0, 6, 0, 0)# SELECT a.strPostalCode, a.strBlockNumber, b.strStreetName From tblPostalCode a, tblStreet b WHERE a.strStreetNumber = b.strStreetNumber ORDER BY a.strPostalCode /CFQUERY cfset StreetName_array = arraynew(2) CFSET i =1 CFLOOP query=PostalCode_list cfset StreetName_array[i][1] = #trim(strPostalCode)# cfset StreetName_array[i][2] = #trim(strStreetName)# cfset StreetName_array[i][3] = #trim(strBlockNumber)# CFSET i = i + 1 /CFLOOP CFWDDX INPUT=#StreetName_array# OUTPUT=MyWDDXPacket ACTION=CFML2WDDX CFWDDX INPUT=#MyWDDXPacket# OUTPUT=DynamicJSCode ACTION=WDDX2JS TOPLEVELVARIABLE=StreetName_array scriptcfoutput#DynamicJSCode#/cfoutput/script table width=100% border=0 cellspan=0 tr td width=5%BLK/HSE NO./td td width=25%cfinput type=text name=strBlockNumber size=5 maxlength=5 message=Please enter your Block / House Number. required=Yes onerror=setFocus value=#session.prospect.strBlockNumber#/td td width=5%FLR./td td width=25%cfinput type=text name=strFloorNumber size=5 maxlength=5 message=Please enter your Floor Number. required=No value=#session.prospect.strFloorNumber#/td td width=5%UNIT/td td width=25%cfinput type=text name=strUnitNumber size=5 maxlength=5 message=Please enter your Unit Number. required=No value=#session.prospect.strUnitNumber#/td td width=5
Auto running of Codes to update data..
hihi hmm my customer required a booking request whereby the booking will be automatically cancelled after 3 days if it is not confirmed i have a Status Column for that booking table and a Booking Date column so how do i enable the system to automatically update the status column ?? eg tblRoom= 1 RoomID01 Booked 25/02/2002 2 RoomID02 Booked 25/02/2002 3 RoomID03 Confirmed 25/02/2002 4 RoomID04 Available 25/02/2002 5 RoomID05 Available 25/02/2002 today's is 28/02/2002 so system is to run thru the database and update data 1 and 2 to available and date to 28/02/2002 hmm can i use CF server scheduled task to do it?? or is there any such tool at Database side?? i'm using mssql 2000 thanx han __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
which is the best way to do auto retrieval of Address...
hi... i need to do a address input fields.. where customer can choose their postal code.. and his house number and streetname will be retrieved out automatically... the codes below actually can do the work.. but because theres about 100,000 data to be put into array...so it took almost like a minute to load a page sigh... anyone have a better idea.? i did it this way coz customer wan to retrieve the data instantly.. thanx han Javascript function: function display_Street(box1, box2) { var TotalStreetArray = box2.length; for(i=0; iTotalStreetArray; i++) { if(box2[i][0] == box1) { document.form.strStreetName.value = box2[i][1]; document.form.strBlockNumber.value = box2[i][2]; } } } !--- Database Queries --- CFQUERY name=PostalCode_list datasource=#request.DSN# cachedwithin=#CreateTimeSpan(0, 6, 0, 0)# SELECT a.strPostalCode, a.strBlockNumber, b.strStreetName From tblPostalCode a, tblStreet b WHERE a.strStreetNumber = b.strStreetNumber ORDER BY a.strPostalCode /CFQUERY cfset StreetName_array = arraynew(2) CFSET i =1 CFLOOP query=PostalCode_list cfset StreetName_array[i][1] = #trim(strPostalCode)# cfset StreetName_array[i][2] = #trim(strStreetName)# cfset StreetName_array[i][3] = #trim(strBlockNumber)# CFSET i = i + 1 /CFLOOP CFWDDX INPUT=#StreetName_array# OUTPUT=MyWDDXPacket ACTION=CFML2WDDX CFWDDX INPUT=#MyWDDXPacket# OUTPUT=DynamicJSCode ACTION=WDDX2JS TOPLEVELVARIABLE=StreetName_array scriptcfoutput#DynamicJSCode#/cfoutput/script table width=100% border=0 cellspan=0 tr td width=5%BLK/HSE NO./td td width=25%cfinput type=text name=strBlockNumber size=5 maxlength=5 message=Please enter your Block / House Number. required=Yes onerror=setFocus value=#session.prospect.strBlockNumber#/td td width=5%FLR./td td width=25%cfinput type=text name=strFloorNumber size=5 maxlength=5 message=Please enter your Floor Number. required=No value=#session.prospect.strFloorNumber#/td td width=5%UNIT/td td width=25%cfinput type=text name=strUnitNumber size=5 maxlength=5 message=Please enter your Unit Number. required=No value=#session.prospect.strUnitNumber#/td td width=5%nbsp;/td td width=5%nbsp;/td /tr tr tdST/td td colspan =3cfinput type=text name=strStreetName size=50 maxlength=50 message=Please enter your Street Name. required=Yes onerror=setFocus value=#session.prospect.strStreetName#/td tdBLDG/td td colspan =3cfinput type=text name=strBuildingName size=50 maxlength=50 message=Please enter your Building Name. required=No value=#session.prospect.strBuildingName#/td /tr tr tdPD/td tdcfSELECT name=strPostalName display=strPostalCode value=strPostalCode query=postalCode_list size=1 message=Please choose your Postal Code. required=Yes onerror=setFocus Selected=#session.prospect.strPostalName# onChange=display_Street(this.options[this.selectedIndex].value, StreetName_array);/CFSELECT/td tdTYPE/td tdcfselect name=strAddressType message=Please enter your Housing Type. required=Yes onerror=setFocus Selected=#session.prospect.strAddressType# size=1 option value=A cfif #session.prospect.strAddressType# eq 'A'SELECTED/cfifA/option option value=B cfif #session.prospect.strAddressType# eq 'B'SELECTED/cfifB/option /cfselect/td tdnbsp;/td tdnbsp;/td tdnbsp;/td tdnbsp;/td /tr /table __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: which is the best way to do auto retrieval of Address...
hmm.. are u saying... upon selected a postal code.. i callup a popup page which will perform a cfquery and do a matching... then pass back the matched value back to parent?? can I do that..?? if can... how shld i pass the value to and fro child and parent page...?? cheers han - Original Message - From: Robert Obreczarek [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 2:44 PM Subject: RE: which is the best way to do auto retrieval of Address... How about using frames? maybe an iframe/ilayer. that way you could click on a name, and the info would pop in a another frame Robert -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:13 PM To: CF-Talk Subject: which is the best way to do auto retrieval of Address... hi... i need to do a address input fields.. where customer can choose their postal code.. and his house number and streetname will be retrieved out automatically... the codes below actually can do the work.. but because theres about 100,000 data to be put into array...so it took almost like a minute to load a page sigh... anyone have a better idea.? i did it this way coz customer wan to retrieve the data instantly.. thanx han Javascript function: function display_Street(box1, box2) { var TotalStreetArray = box2.length; for(i=0; iTotalStreetArray; i++) { if(box2[i][0] == box1) { document.form.strStreetName.value = box2[i][1]; document.form.strBlockNumber.value = box2[i][2]; } } } !--- Database Queries --- CFQUERY name=PostalCode_list datasource=#request.DSN# cachedwithin=#CreateTimeSpan(0, 6, 0, 0)# SELECT a.strPostalCode, a.strBlockNumber, b.strStreetName From tblPostalCode a, tblStreet b WHERE a.strStreetNumber = b.strStreetNumber ORDER BY a.strPostalCode /CFQUERY cfset StreetName_array = arraynew(2) CFSET i =1 CFLOOP query=PostalCode_list cfset StreetName_array[i][1] = #trim(strPostalCode)# cfset StreetName_array[i][2] = #trim(strStreetName)# cfset StreetName_array[i][3] = #trim(strBlockNumber)# CFSET i = i + 1 /CFLOOP CFWDDX INPUT=#StreetName_array# OUTPUT=MyWDDXPacket ACTION=CFML2WDDX CFWDDX INPUT=#MyWDDXPacket# OUTPUT=DynamicJSCode ACTION=WDDX2JS TOPLEVELVARIABLE=StreetName_array scriptcfoutput#DynamicJSCode#/cfoutput/script table width=100% border=0 cellspan=0 tr td width=5%BLK/HSE NO./td td width=25%cfinput type=text name=strBlockNumber size=5 maxlength=5 message=Please enter your Block / House Number. required=Yes onerror=setFocus value=#session.prospect.strBlockNumber#/td td width=5%FLR./td td width=25%cfinput type=text name=strFloorNumber size=5 maxlength=5 message=Please enter your Floor Number. required=No value=#session.prospect.strFloorNumber#/td td width=5%UNIT/td td width=25%cfinput type=text name=strUnitNumber size=5 maxlength=5 message=Please enter your Unit Number. required=No value=#session.prospect.strUnitNumber#/td td width=5%nbsp;/td td width=5%nbsp;/td /tr tr tdST/td td colspan =3cfinput type=text name=strStreetName size=50 maxlength=50 message=Please enter your Street Name. required=Yes onerror=setFocus value=#session.prospect.strStreetName#/td tdBLDG/td td colspan =3cfinput type=text name=strBuildingName size=50 maxlength=50 message=Please enter your Building Name. required=No value=#session.prospect.strBuildingName#/td /tr tr tdPD/td tdcfSELECT name=strPostalName display=strPostalCode value=strPostalCode query=postalCode_list size=1 message=Please choose your Postal Code. required=Yes onerror=setFocus Selected=#session.prospect.strPostalName# onChange=display_Street(this.options[this.selectedIndex].value, StreetName_array);/CFSELECT/td tdTYPE/td tdcfselect name=strAddressType message=Please enter your Housing Type. required=Yes onerror=setFocus Selected=#session.prospect.strAddressType# size=1 option value=A cfif #session.prospect.strAddressType# eq 'A'SELECTED/cfifA/option option value=B cfif #session.prospect.strAddressType# eq 'B'SELECTED/cfifB/option /cfselect/td tdnbsp;/td tdnbsp;/td tdnbsp;/td tdnbsp;/td /tr /table __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
help:opening a excel file on web but read only to user
hihi... making help calls to all gurus/ expert out there... to open a EXCEL file in web... window.location='test.xls' how i can let a user to open a excel file to view the content but disable them from editing..? currently.. I'm using fusebox.. and including all files in the index.cfm.. so... is it possible to open that EXCEL file within index.cfm?? thanx in advance... han : ) __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: help! cant use multiple transaction
Oh no.. seems like no one had such an encounter before sigh... - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 05, 2002 9:24 AM Subject: help! cant use multiple transaction hihi... funny things happening... this query works fine for past few days.. but yesterday suddenly wanted to take a break... anyone know wats the cause..?? hmm.. i can insert the values successfully.. but cant retrieve the new ID inserted.. Error msg saying this #INSERTNEWCUSTOMER.intCustomerID# not found. CFQUERY NAME=INSERTNEWCUSTOMER datasource=#application.DSN# INSERT INTO tblCustomer Values ( '#session.prospect.strTitle#', '#session.prospect.strCustomerName#', '#session.prospect.strStreetName#', '#session.prospect.strFloorNumber#', '#session.prospect.strUnitNumber#', '#session.prospect.strBlockNumber#', '#session.prospect.strBuildingName#', '#session.prospect.strPostalName#', '#session.prospect.strNRICNo#', '#session.prospect.strHomeNo#', '#session.prospect.strMobileNo#', '#session.prospect.strPagerNo#', '#session.prospect.strOfficeNo#', '#session.prospect.strEmail#', 'P', '#session.prospect.strAddressType#', NULL ); SELECT @@IDENTITY as intCustomerID; SET nocount off; /CFQUERY CFSET session.prospect.intCustomerID = #INSERTNEWCUSTOMER.intCustomerID# __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
help! cant use multiple transaction
hihi... funny things happening... this query works fine for past few days.. but yesterday suddenly wanted to take a break... anyone know wats the cause..?? hmm.. i can insert the values successfully.. but cant retrieve the new ID inserted.. Error msg saying this #INSERTNEWCUSTOMER.intCustomerID# not found. CFQUERY NAME=INSERTNEWCUSTOMER datasource=#application.DSN# INSERT INTO tblCustomer Values ( '#session.prospect.strTitle#', '#session.prospect.strCustomerName#', '#session.prospect.strStreetName#', '#session.prospect.strFloorNumber#', '#session.prospect.strUnitNumber#', '#session.prospect.strBlockNumber#', '#session.prospect.strBuildingName#', '#session.prospect.strPostalName#', '#session.prospect.strNRICNo#', '#session.prospect.strHomeNo#', '#session.prospect.strMobileNo#', '#session.prospect.strPagerNo#', '#session.prospect.strOfficeNo#', '#session.prospect.strEmail#', 'P', '#session.prospect.strAddressType#', NULL ); SELECT @@IDENTITY as intCustomerID; SET nocount off; /CFQUERY CFSET session.prospect.intCustomerID = #INSERTNEWCUSTOMER.intCustomerID# __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
session variables expires prematurely
hi ppl... i remember seeing this somewhere.. abt setting a around the time span or wat.. but i tried both ways.. with and without the quotes.. still cant work.. is there any setting to be done at SERVER administration side..?? cheers han __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: cfquery from a cfquery
hihi.. thanks for yr reply. sorry.. i dont know how to use request.DSN.. so how do i declare it..? and.. if i use request.DSN... does it mean i dont need to use CFLOCK..? cheers han - Original Message - From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 4:57 PM Subject: RE: cfquery from a cfquery This is not a query of queries. Change the 2nd CFQUERY to CFQUERY Name=PendingProspect DataSource=#application.DSN# SELECT intCustomerID from tblprospectdetails where intCustomerID IN #QuotedValueList(CustomerExist.intCustomerID)# and Depending on what you want to do, you can probably do One query using a join or a subquery. PS I see you are using application.DSN, so dont forget to put a CFLOCK around all your queries. This is a hughe performance loss, so I would suggest switching to request.DSN. Pascal -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: woensdag 30 januari 2002 3:56 To: CF-Talk Subject: cfquery from a cfquery hi.. i try to search for this from archives but unsuccessful so any can teach me how can i do it..?? eg. CFQUERY Name=CustomerExist DataSource=#application.DSN# Select intCustomerID from tblCustomer Where UPPER(strCustomerName) Like '%#CustomerName#%' order by intCustomerID /CFQUERY CFQUERY Name=PendingProspect dbtype=CustomerExist SELECT intCustomerID from tblprospectdetails where intCustomerID = '#CustomerExist.intCustomerID#' and /CFQUERY is it this way..?? cheers han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
how to do Google-like search??
Hi ppl.. is there a built in function or wat in MSSQL to perform search query like Google..?? for example.. i need to search for Hello beautiful World... how to write the query to search thru a column of a table where the return results can be... Beautiful Hello World World Helllo Beautiful Helllo World beautiful how to do it?? han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
cfquery from a cfquery
hi.. i try to search for this from archives but unsuccessful so any can teach me how can i do it..?? eg. CFQUERY Name=CustomerExist DataSource=#application.DSN# Select intCustomerID from tblCustomer Where UPPER(strCustomerName) Like '%#CustomerName#%' order by intCustomerID /CFQUERY . CFQUERY Name=PendingProspect dbtype=CustomerExist SELECT intCustomerID from tblprospectdetails where intCustomerID = '#CustomerExist.intCustomerID#' and /CFQUERY is it this way..?? cheers han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
where to find MS SQL Commands
Hihi.. i know this is not suppose to be here... but i just dunno where to find the list of SQL commands for MSSQL. its so different from Oracle command.. sigh.. Thanx in advance..!! Cheers han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: multi-page forms
hihi... juz curious.. wat do u mean by locking the session variables..?? how do u do it..? any examples..?? thanx han - Original Message - From: David Hannum (Ohio University) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 8:38 AM Subject: Re: multi-page forms Option B baby. Just lock 'em. Dave - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 28, 2002 5:49 PM Subject: multi-page forms Hi. I am building a login/registration system for the Intranet site that I manage. In order to collect user data from new users, I am creating a multi-page form. I am breaking into multiple pages to make it less overwhelming for the user. But this introduces the issue of passing variables from page to page. I see several options open to me, but I was wondering whether there were any thoughts out there (I'm sure there are plenty!) as to which is the best option, what pitfalls may exist, etc. What most concerns me is the likely-to-be-very-common occurrence of users backing up through the process to revise data. I am concerned that it will be a major headache to keep track of things when there are so many options for how the user might get to each page (e.g., got to page 2 by submitting page 1 or got to page 2 by clicking back button on page 3, etc.) The options I see: A) Pass all variables through forms from page to page, using hidden variables on page 2 to pass the variables from page 1, etc. Variables from each page would be validated as the first step of the next page. At the end of the multi-page form, all of these accumulated variables are written to the SQL database. B) Each page's submit button sends the form to an action page which validates the data, puts it in session variables, and sends the user on to the next page. At the end of the multi-page form, the values of the session variables are passed to the database. C) Like option B, but variables are written to temporary SQL table record instead of to temporary session variable. Thoughts? Thanks, __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
Help on Duty Roster
Help help!! hi anyone tried to code a duty roster before..?? anyone can shed some light to how to get it up using a cost effective way? sigh.. i can only think of putting every single day, mth, year with its relevant fields into a table. but its going to be tedious if the duty roster need to be done up a few years in advance.. stressed han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: how to prevent user from opening multiple browsers..
hi.. mark and lewis.. thank you very much for yr suggestions.. i'm running my application in intranet.. so mark suggestion is useful... but how do i capture the ip?? to a database..? or?? pls shed some light to it.. as for lewis.. yr method cant restrict people from having 2 different logins at same machine... and guess... if i combine these 2 suggestions together... it will solve the problem.for me..!! so still a big thank you to u both!!! : ) cheers han - Original Message - From: Mark Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 3:11 AM Subject: RE: how to prevent user from opening multiple browsers.. Good point and probably a little bit more cleaner. Mark -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:55 AM To: CF-Talk Subject: Re: how to prevent user from opening multiple browsers.. On Wed, 9 Jan 2002 09:15:28 -0500, Mark Stewart [EMAIL PROTECTED] wrote: If I understand you correctly, once a user has logged in, you don't want them to click on the IE icon or Nutscrape and go to your site and log in again? If this is right, just capture their IP on login. When the next user logs in, make sure that the IP's aren't the same. In general I find that IP's are fairly worthless with anything having to do with login's unless you are in a controlled intranet. And even then... Basically the simpliest thing to do is simply use a mutex on the user's database record. That is, a lock, or a numeric field say called lock with a default of 0. When someone logs in you +1 the record. When they log out you -1 the record. Don't allow any more login's when lock is 0. Put a timedate field for lock expiration in to allow incidnets to resolves themselves after a peroid of time so the admin isn't hassled to reset the lock. --min __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Better Javascript/DHTML Calender!
hihi... mind if u can send me a copy of that pls..?!! cheers han - Original Message - From: ronmyers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 4:12 AM Subject: RE: Better Javascript/DHTML Calender! I got it. Must of been the last one for the day to get it. If you want it let me know and I will email you a copy 30.4kb -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:44 AM To: CF-Talk Subject: RE: Better Javascript/DHTML Calender! it's down they have reached their max transfer load for the day, that's a free site for ya -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:39 AM To: CF-Talk Subject: RE: Better Javascript/DHTML Calender! That link doesn't work The site is down or doesn't exist -Original Message- From: Zac spitzer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:18 AM To: CF-Talk Subject: Better Javascript/DHTML Calender! similair to Popup Calander XP or whatever, except it's free and not $150 US it's a cross browser, inline DHTML calender http://www.geocities.com/bazillyo/spiffy/calendar/ z __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
how to prevent user from opening multiple browsers..
hi people... how do u ppl prevent yr user to open multiple internet browsers to run yr application concurrently..? for instance.. if i login into my system as userA.. the system will assign its details.. to specific session variables... but if i open up another browser and login as User.. all the session values will be overwritten... so anyone know how to prevent that to happen.. or any other way to differentiate each browser application...? cheers han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
CF DB enquiries...
Hi ppl, does anyone know wat kind of odbc/jdbc whatever etc, connection does CF supports? Does CF works well with PostgreSQL? or MYSQL? i have used CF w/ oracle and mssql.. but due to budget contraints.. we r looking into something cheaper.. wat i know abt this 2 software.. MySQL (fast but not very feature-complete, beta support for transactions etc) PostgreSQL (slightly better cause got more features) so anyone hav any experience to share? thanx, han __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
can CF do multiple DB connection?
hi... ppl... i will like to check with u..ppl can cold fusion link to multiple database at the same time..?? i noticed under application.cfm .. we normally put only 1 DSN connection. juz wonder.. is it possible to create multiple DSN connection..? and is it possible to do multiple database query from a single query statement? hmm.. is there any gd website.. where i can find more info abt this..?!! coz i need to do a recommendation which software to use for our new project. cheers han ~~ 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: can CF do multiple DB connection?
thank you ppl for yr fast reply.. :) ok... wat i need is to hav multiple DB connection in a query statement.. for example.. i need to hav a joint query from a oracle database and a ms sql database.. can i actually do this..? cfquery name =eg1 datasource=oracle.dsn, mssql.dsn . . /cfquery ?? or must it be query within a query? cfquery name =eg1 datasource=oracle.dsn . . cfquery name =eg2 datasource=mssql.dsn . . ./cfquery /cfquery thanx you ppl.. : ) by the way.. any gd site for CF 5 info to recommend ?? cheers han - Original Message - From: Darryl Lyons [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 05, 2001 4:10 AM Subject: RE: can CF do multiple DB connection? If your using db like SQL Server you can do cross database joins by doing this: SELECT n.name FROM Dbname.dbo.tablename r, dbname2.dbo.tablename2 n WHERE r.id = n.r_id AND n.id = @id Etc etc Is that what you mean? Darryl -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Monday, 5 November 2001 2:55 AM To: CF-Talk Subject: Re: can CF do multiple DB connection? It sounds like you are confused by why the application.cfm has the DSN connection defined -- the main reason is so that you don't have to define it on every page and can change it in one place if you need to change it for any reason. If you want to use more than one, simply define more than one variable on the application.cfm page or hard-code the DSNs into the cfquery tags. You can have as many database connections as you need. Also, in CF 5 you can do a query of a query so that you can do queries across mulitple databases if you need to. tom han peng [EMAIL PROTECTED] wrote in message 003301c1654d$e04aa500$5b9a15a5@qubitsonyvaio">news:003301c1654d$e04aa500$5b9a15a5@qubitsonyvaio... hi... ppl... i will like to check with u..ppl can cold fusion link to multiple database at the same time..?? i noticed under application.cfm .. we normally put only 1 DSN connection. juz wonder.. is it possible to create multiple DSN connection..? and is it possible to do multiple database query from a single query statement? hmm.. is there any gd website.. where i can find more info abt this..?!! coz i need to do a recommendation which software to use for our new project. cheers han ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
concurrency problem..
hi ppl... i have a hotel booking system that lets the users to reserve room thru the web. I retrieve the hotel room capacity to show the current room available... if the capacity is zero.. the page will indicate fully booked. In order to have the most updated info.. i actually retrieve the room capacity again from the database juz before updating... but seems still have slight chance to have multiple submission at microsec difference... i thinking of using CFLOCK to contain the read,update queries.. however.. at the admin module... i have a function that enable the administrator to update the total room capacity... so.. which means i cant use CFLOCK (..from my understanding.. CFLOCK only locks requests from same page...) Any advice?? heard that i can use stored procedure from the DB to lock the table...?? i never use stored procedure b4... so any kind soul can kindly guide me to some examples or website where i can learn?? thanx in advance... han ~~ 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
mailto: in alertbox?
hi ppl... is it possible to have a mailto: in a alertbox message?? i tried doing this but cant... pls advise... alert(we noted that u blah...blah.. blah... Please email us at mailto:[EMAIL PROTECTED] for yr request.blah.. blah...); cheers han ~~ 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
put a name and email address in CFMAIL
hi ppl... thought i saw this sometime back... but 4got to save it... so any kind soul like to send me again how to go abt doing it..?? i try doing this way.. but seems cant work... cfloop query=mailing_list cfmail to=#fullname##emailaddress# from=Editor[EMAIL PROTECTED] subject=Test server=server.com blah..blah... If you have received this email in error or wish to be removed from our list,click mailto:Editor[EMAIL PROTECTED]?subject=Unsubscribe or email [EMAIL PROTECTED] with unsubscribe as the subject. /cfmail /cfloop thanx in advance, han ~~ 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
display results in pages
hi ppl... any know how i can go abt doing this in CF?? thinking of doing a custom tag for this function.. the look.. --- page 1 | 2 | 3 | 4.. wat i think of is .. after i did my query search... i wan to pass the recordcount, the maxrow required, the currentpage and the url link to the custom tag. to process the above. so.. is there any existing code around.. or any hints to go abt it? regards, han ~~ 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: display results in pages
hi all.. thanx for al yr help.. : ) hmm.. i look thru the custom tags.. hmm ok.. dun really customise to my need.. hmm.. think i would like to try do one myself for my company..so that my colleague can reuse this tags for our future projects.. :Þ heehe.. a challenge to me.. (heehe.. maybe a small challenge to all expert out there.. :) another question... i notice all the custom tags are encrypted... so is it a must for me to encrypt my codes after i finish..?? so to protect my coding logic?? cheers Han Peng, Lim X-media Pte Ltd. Engineer, Technology. Singapore. - Original Message - From: Semrau, Steven L Mr SRA [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 9:56 PM Subject: RE: display results in pages If the custom tags that the other people have suggested don't work out for you please post again in CF-Talk, I have one of my own that I have written that does what you are looking for. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 8:11 AM To: CF-Talk Subject: display results in pages hi ppl... any know how i can go abt doing this in CF?? thinking of doing a custom tag for this function.. the look.. --- page 1 | 2 | 3 | 4.. wat i think of is .. after i did my query search... i wan to pass the recordcount, the maxrow required, the currentpage and the url link to the custom tag. to process the above. so.. is there any existing code around.. or any hints to go abt it? regards, han ~~ 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
cfloop for 2 list?!!!
hi.. i hav a prob. here. i hav a tool to key in remarks for mulitple users. Eg. Page1.cfm form action="page2.cfm" method="post" cfloop query="part_info" textarea cols="20" rows="2" name="p_arrival_remarks"#p_arrival_remarks#/textarea input type="hidden" name="p_username" value="#part_info.p_username#" /cfloop input type="submit" value="Submit" /form So in page2.cfm... how can i insert the remarks into the database using the respective username.?? i cant use cfloop INDEX="test" LIST="??!!" as it can only use for 1 list... another prob.. i try CFOUTPUT the 2 list... #p_username#,#p_arrival_remarks# and notice that if theres no input for remarks.. both list length doesnt match.. any advice how i shld go abt doing it?!! thanx in advance, han ~~ 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: cfloop for 2 list?!!!
hi adkins... thanx for yr reply... however the prob is still not solved.. maybe i can giv u a clearer idea... there r mulitple input.. : Input1 : blah,,,... id: 1 Input2: hee id:2 Input3: empty id:3 Input4: hoo.. id:4 if i use yr method to write in.. i will hav mismatch data.. as CFOUPUT of the above will look like this blah, hee,hoo.. 1,2,3,4 the empty string is not taken in. still trying hard to solve.. han. - Original Message - From: Adkins, Randy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 7:44 PM Subject: RE: cfloop for 2 list?!!! For inserting the remarks into the DB simply suffix your textarea variable with the ID number or some unique value that would indicate the record they are putting the remarks to. Example: -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 5:32 AM To: CF-Talk Subject: cfloop for 2 list?!!! form action="page2.cfm" method="post" cfloop query="part_info" textarea cols="20" rows="2" name="p_arrival_remarks"#p_arrival_remarks#/textarea input type="hidden" name="p_username" value="#part_info.p_username#" input type="hidden" name="ID" value="#part_info.part_info_ID#" /cfloop input type="submit" value="Submit" /form ON PAGE2.CFM IF INSERTING INTO A NEW TABLE: cfquery name=insremarks datasource=blahblahblah insert into remarksTable(remark_id,Username,remarks) values(#form.ID#,'#form.p_username#','#form.p_arrivale_remarks#') /cfquery IF UPDATING THE TABLE WITH THE REMARKS cfquery name=updateremarks datasource=blahblahblah UPDATE remarksTable Set Remarks = '#form.P-arrival_remarks#' Where Part_info_ID = #form.ID# /cfquery This UPDATE is assuming you have a UNIQUE Identifier within the table. Else you will have to determine the unique record by some means of combining fields. hi.. i hav a prob. here. i hav a tool to key in remarks for mulitple users. Eg. Page1.cfm form action="page2.cfm" method="post" cfloop query="part_info" textarea cols="20" rows="2" name="p_arrival_remarks"#p_arrival_remarks#/textarea input type="hidden" name="p_username" value="#part_info.p_username#" /cfloop input type="submit" value="Submit" /form So in page2.cfm... how can i insert the remarks into the database using the respective username.?? i cant use cfloop INDEX="test" LIST="??!!" as it can only use for 1 list... another prob.. i try CFOUTPUT the 2 list... #p_username#,#p_arrival_remarks# and notice that if theres no input for remarks.. both list length doesnt match.. any advice how i shld go abt doing it?!! thanx in advance, han ~~ 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: cfloop for 2 list?!!!
hi.. pha.. sorry i dun quite get u... how to put the form name as dynamic?? coz the no. of input fields r depended on the query. by the way.. i miss out some info on this question.. i doing update .. not insert... and the p_username is unique key. sigh, han - Original Message - From: Phoeun Pha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 23, 2000 7:50 PM Subject: Re: cfloop for 2 list?!!! insteadof using a list, dynamically name your input forms, then in your cfoutput, u can output those forms. like #Form.Question1# #Form.Remark1# #Form.Question1# #Form.Remark1# - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 4:32 AM Subject: cfloop for 2 list?!!! hi.. i hav a prob. here. i hav a tool to key in remarks for mulitple users. Eg. Page1.cfm form action="page2.cfm" method="post" cfloop query="part_info" textarea cols="20" rows="2" name="p_arrival_remarks"#p_arrival_remarks#/textarea input type="hidden" name="p_username" value="#part_info.p_username#" /cfloop input type="submit" value="Submit" /form So in page2.cfm... how can i insert the remarks into the database using the respective username.?? i cant use cfloop INDEX="test" LIST="??!!" as it can only use for 1 list... another prob.. i try CFOUTPUT the 2 list... #p_username#,#p_arrival_remarks# and notice that if theres no input for remarks.. both list length doesnt match.. any advice how i shld go abt doing it?!! thanx in advance, han ~~ 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: cfloop for 2 list?!!!
Hey ppl!!! i got the answer using this... hmm.. pha.. do u actually mean this?!! cheers han page1.cfm form action="page2.cfm" method="post" cfloop query="part_info" textarea cols="20" rows="2" name="#part_info.p_username#"#p_arrival_remarks#/textarea /cfloop input type="submit" value="Submit" /form page2.cfm CFLOOP INDEX="test" LIST="#form.fieldnames#" cfquery name="update_remarks" datasource="#application.DSN#" update table_name set p_arrival_remarks = '#evaluate(test)#' where p_username = '#test#' /cfquery /CFLOOP - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 4:32 AM Subject: cfloop for 2 list?!!! hi.. i hav a prob. here. i hav a tool to key in remarks for mulitple users. Eg. Page1.cfm form action="page2.cfm" method="post" cfloop query="part_info" textarea cols="20" rows="2" name="p_arrival_remarks"#p_arrival_remarks#/textarea input type="hidden" name="p_username" value="#part_info.p_username#" /cfloop input type="submit" value="Submit" /form So in page2.cfm... how can i insert the remarks into the database using the respective username.?? i cant use cfloop INDEX="test" LIST="??!!" as it can only use for 1 list... another prob.. i try CFOUTPUT the 2 list... #p_username#,#p_arrival_remarks# and notice that if theres no input for remarks.. both list length doesnt match.. any advice how i shld go abt doing it?!! thanx in advance, han ~~ 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: Application generating HTML?
I think in general it's not only what works at the moment, but what will also work for the foreseeable future that should be used. nice quote, max!!! will remember this :Þ cheers han ~~ 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
gettting form.variables using pure html?
hi.. juz to confirm my thoughts... is there any way we can pass variables of a form to another page and display the variables.. using pure html?? my friend thinking of doing a simple homepage at those free hosting site. Hes thinking of having a form that can send email directly w/o using the mail program. i know we can do this w/ CF... but can this be done using pure html.. or maybe w/ javascript? cheers han ~~ 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
autorun cd rom for html
hi... a client of my company request for a cdrom version of their website. (for their presentation purposes) They request the index.html to be autorun once they load the cd into the cdrom drive.. so.. can we actually do this?? i know autorun.inf normally open .EXE file.. or can it open html file too? cheers han ~~ 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: Building Cold Fusion Search - Dynamic SQL
hmm.. maybe u hav to set #frmSkill# as array... then put each skill into different variables at yr query.. use AND for each isdefined(variables.skill) hope this help.. cheers han - Original Message - From: Kim Mayhall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 3:23 AM Subject: Building Cold Fusion Search - Dynamic SQL I'm trying to build some sql statements based on selections from a list box: select name="frmSkill" option Skill1 option Skill2 option Skill3 option Skill4 (etcthis size will vary as it's dynamically populated) /select A user can do a multiple select, so let's say the user picked option 1 and option 3. On my action page, I want to pick ONLY the employees that have the 2 skills selected. If I use an IN statement, I get employees with one skill or the other, but I only want those with both: SELECT e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId How can I write the SQL to select only the employees with both, or do I use Cold Fusion to do that? Kim Mayhall The Garrigan Lyman Group http://www.glg.com http://www.glg.com/ (206) 223-5548 ~~ 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: Browsercall for opening html files on a CD
thanx guys..!! will try that.. cheers han - Original Message - From: Sean Renet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 5:49 PM Subject: Browsercall for opening html files on a CD http://www.ashzfall.com/products/autorun/browsercall.html ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: gettting form.variables using pure html?
thanx for yr reply.. well.. yr codes still need to open a mail program like outlook.. eudora.. etc.. to send mail.. hmmm.. wat they wan is to send it directly.. after they click submit... on the webpage.. anyway.. thanx for yr help.. :Þ cheers han - Original Message - From: Sean Renet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 5:37 PM Subject: Re: gettting form.variables using pure html? you mean something like this? form action="mailto:[EMAIL PROTECTED]?subject=Some subject" method="post" input type="text" name="name" value="John Doe"br input type="text" name="age" value="21"br input type="submit" name="submit" /form Both browsers will fire off a warning, and the form fields will be name value pairs sent as an attachment to the email. Like this... name=John+Doeage=21submit=Submit+Query You could also href it or javascript the same... A HREF="mailto:[EMAIL PROTECTED]?subject=Some subjectbody=this is the body of this email"Sean Renet/a - Original Message - From: "han peng" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 12:01 AM Subject: gettting form.variables using pure html? hi.. juz to confirm my thoughts... is there any way we can pass variables of a form to another page and display the variables.. using pure html?? my friend thinking of doing a simple homepage at those free hosting site. Hes thinking of having a form that can send email directly w/o using the mail program. i know we can do this w/ CF... but can this be done using pure html.. or maybe w/ javascript? cheers han ~~ 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
1 user login at a time
hi... anyone know how can i restrict only 1 user login at a time? eg. USER1 w/ login_id--admin1 USER2 w/ login_id---admin2 once admin1 log into the system... admin2 cant log in.. qs.. : can i use global session to capture the id? and is using global session safe? i oso think of using DB to control the login... like i update the table column (login_status) =1 for a new login.. and set to 0 only when logout. then whoever wan to login.. and if login_status ==1.. access denied. but i foresee that if the person didnt logout.. how?!! anyone can advise me on this?? cheers han ~~ 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
chking of version in CF?
hi.. is there any wayi can chk the version of the client's browser in CF?? ... or i must use javascript? hmm.. any one know abt this javascript print function.. "javascript:window.print()" hmm which version support it? currently i know IE4 cant.. IE5 and above can.. how abt netscape? cheers han ~~ 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
using template in html?
hi all... is there a way in html that works like CFINCLUDE?? coz the designers normally use dreamweaver to do prototype.. and that software seem unable to read cfm files... or is there a better way for the designers to do templates so that the programmers can easily integrate the codes...?? cheers han ~~ 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 in Netscape
yeah!! thank you!! solve that silly mistake finally!!!... thanx a million ppl.. :Þ cheers han - Original Message - From: Christoph Schmitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 4:31 AM Subject: AW: Javascript in Netscape Hi Han, you need to use "resizable" instead of "resizeable"... just drop the "e". HTH, Chris -Ursprüngliche Nachricht- Von: han peng [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 8. Januar 2001 09:19 An: CF-Talk Betreff: Javascript in Netscape hey i had a prob i'm opening a new window with size 500,370. but for the link in there.. i wan the next page to be shown as full screen or at least can be resized... tried the codes below.. can work for IE.. but cant for netscape.. any solution? cheers han File A: function openwin(location, x, y) { para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y; msgWindow=window.open(location, "displaywindow", para); } A href="javascript:openwin('userid.html', 500, 370)"User ID/a userid.html : function openwin(location, x, y) { para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y; msgWindow=window.open(location, "displaywindow", para); } A href="register_email.cfm?action=forget"forgotten/a also tried this: A href="javascript:openwin('register_email.cfm?action=forget', 640, 480)"forgotten/a ~~ 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
Javascript in Netscape
hey i had a prob i'm opening a new window with size 500,370. but for the link in there.. i wan the next page to be shown as full screen or at least can be resized... tried the codes below.. can work for IE.. but cant for netscape.. any solution? cheers han File A: function openwin(location, x, y) { para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y; msgWindow=window.open(location, "displaywindow", para); } A href="javascript:openwin('userid.html', 500, 370)"User ID/a userid.html : function openwin(location, x, y) { para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y; msgWindow=window.open(location, "displaywindow", para); } A href="register_email.cfm?action=forget"forgotten/a also tried this: A href="javascript:openwin('register_email.cfm?action=forget', 640, 480)"forgotten/a ~~ 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