Recursive List output

2002-12-26 Thread han peng
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 : :

Possible to send out mail for CFerror..?

2002-09-19 Thread han peng
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

Any available suite for spa management?

2002-08-21 Thread han peng
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

Re: Possible to detect user clicking on top right X to close windows?

2002-07-28 Thread han peng
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

Re: Possible to detect user clicking on top right X to close windows?

2002-07-28 Thread han peng
'); } } 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

CFMAIL unknown error

2002-06-20 Thread han peng
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

Shld CF Server and IIS web server run on separate machines?

2002-06-14 Thread han peng
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

Re: session cookies to expire immediately on browser close

2002-05-10 Thread han peng
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

session cookies to expire immediately on browser close

2002-05-09 Thread han peng
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

Re: session/browser problem??!!

2002-05-05 Thread han peng
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

session/browser problem??!!

2002-05-03 Thread han peng
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

Re: session/browser problem??!!

2002-05-03 Thread han peng
://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

InitCap function in Cold Fusion??

2002-05-02 Thread han peng
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

session cant work in IE 5.5 and 6??

2002-04-09 Thread han peng
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

Re: session cant work in IE 5.5 and 6??

2002-04-09 Thread han peng
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

How to display each start and end date of all 12 weeks in a quarter?

2002-04-02 Thread han peng
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

anyone seen such error msg b4??

2002-03-24 Thread han peng
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

Re: anyone seen such error msg b4??

2002-03-24 Thread han peng
(*)...' - 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

Re: how to retrieving data by age of record in MSSQL

2002-03-23 Thread han peng
://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

anyone hosting free forum?

2002-03-23 Thread han peng
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..

how to retrieving data by age of record in MSSQL

2002-03-21 Thread han peng
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

Re: Target back to parent.

2002-03-13 Thread han peng
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) {

Re: which is the best way to do auto retrieval of Address...

2002-02-28 Thread han peng
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

Auto running of Codes to update data..

2002-02-28 Thread han peng
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

which is the best way to do auto retrieval of Address...

2002-02-26 Thread han peng
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

Re: which is the best way to do auto retrieval of Address...

2002-02-26 Thread han peng
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

help:opening a excel file on web but read only to user

2002-02-25 Thread han peng
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..

Re: help! cant use multiple transaction

2002-02-05 Thread han peng
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

help! cant use multiple transaction

2002-02-04 Thread han peng
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

session variables expires prematurely

2002-02-04 Thread han peng
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

Re: cfquery from a cfquery

2002-01-30 Thread han peng
-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

how to do Google-like search??

2002-01-29 Thread han peng
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

cfquery from a cfquery

2002-01-29 Thread han peng
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 .

where to find MS SQL Commands

2002-01-28 Thread han peng
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

Re: multi-page forms

2002-01-28 Thread han peng
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:

Help on Duty Roster

2002-01-21 Thread han peng
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

Re: how to prevent user from opening multiple browsers..

2002-01-09 Thread han peng
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

Re: Better Javascript/DHTML Calender!

2002-01-09 Thread han peng
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

how to prevent user from opening multiple browsers..

2002-01-08 Thread han peng
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..

CF DB enquiries...

2002-01-03 Thread han peng
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

can CF do multiple DB connection?

2001-11-04 Thread han peng
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

Re: can CF do multiple DB connection?

2001-11-04 Thread han peng
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"

concurrency problem..

2001-05-09 Thread han peng
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

mailto: in alertbox?

2001-05-03 Thread han peng
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

put a name and email address in CFMAIL

2001-05-02 Thread han peng
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

display results in pages

2001-04-25 Thread han peng
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

Re: display results in pages

2001-04-25 Thread han peng
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

cfloop for 2 list?!!!

2001-03-13 Thread han peng
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"

Re: cfloop for 2 list?!!!

2001-03-13 Thread han peng
?!!! 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

Re: cfloop for 2 list?!!!

2001-03-13 Thread han peng
# #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

Re: cfloop for 2 list?!!!

2001-03-13 Thread han peng
al_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

Re: Application generating HTML?

2001-02-27 Thread han peng
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

gettting form.variables using pure html?

2001-02-27 Thread han peng
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

autorun cd rom for html

2001-02-27 Thread han peng
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

Re: Building Cold Fusion Search - Dynamic SQL

2001-02-27 Thread han peng
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,

Re: Browsercall for opening html files on a CD

2001-02-27 Thread han peng
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

Re: gettting form.variables using pure html?

2001-02-27 Thread han peng
ttachment 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

1 user login at a time

2001-01-10 Thread han peng
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

chking of version in CF?

2001-01-10 Thread han peng
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

using template in html?

2001-01-08 Thread han peng
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...??

Re: Javascript in Netscape

2001-01-08 Thread han peng
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.

Javascript in Netscape

2001-01-07 Thread han peng
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