window Close (JavaScript OT)
Hi ,
How do u fire this function goExit()? Is there
any event that would fire this function like
OnUnload?
Thanks
Joe
Put the below code in the head of your document to open another
window
when
the browser window is closed.
Gary Groomer
script language=javascript!--
function goExit() {
nextWin=window.open('http://localhost/PopUp.htm','lastWin','status=no,resiz
ble=yes,scrollbars=no,location=no,left=0,top=0,width=400,height=400');
}
//--
/script
- Original Message -
From: Joseph Eugene [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, May 05, 2001 9:33 AM
Subject: Close window : JavaScript (OT)
Hi all,
I would like to know, if you guys had any code
to
1.Open a new window when the User tries to close
his Browser.
2. Close the new window Just opened when the user
tried to
close
his browser.
The above really is to Log the User Out and terminate
his
session.
Appretiate any help
Thanks
Joe
-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
~~
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
window Close (JavaScript OT)
Hi ,
How do u fire this function goExit()? Is there
any event that would fire this function like
OnUnload?
Thanks
Joe
Put the below code in the head of your document to open another
window
when
the browser window is closed.
Gary Groomer
script language=javascript!--
function goExit() {
nextWin=window.open('http://localhost/PopUp.htm','lastWin','status=no,resiz
ble=yes,scrollbars=no,location=no,left=0,top=0,width=400,height=400');
}
//--
/script
- Original Message -
From: Joseph Eugene [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, May 05, 2001 9:33 AM
Subject: Close window : JavaScript (OT)
Hi all,
I would like to know, if you guys had any code
to
1.Open a new window when the User tries to close
his Browser.
2. Close the new window Just opened when the user
tried to
close
his browser.
The above really is to Log the User Out and terminate
his
session.
Appretiate any help
Thanks
Joe
-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF to AS400 connection
Mak, What odbc connector are you using?. The only connector that i know of that works is ok is Client Access Express v4 or later. You install this on your web server and the AS/400 should be configured for TCPIP and you are all set to go.. We are running it on NT, am not sure about solaris Hope this helps.. Joe --- Original Message --- "Mak Wing Lok" [EMAIL PROTECTED] Wrote on Fri, 16 Feb 2001 12:35:13 +0800 -- Hi People, The DB2 client will require specific parameters to be set on both Solaris and AS/400. What are those parameters for the AS/400? ~~ 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
CFLocks??? overlapping..
Hi All, Can someone please help me with Cflocking this session and application variable CFSET APPLICATION.USERSLOGGEDIN["#Session.Userid#"]=SESSION I am adding the Current Session user structure to the application structure to keep track of the users in the app. if i turn off full checking on locks in cf admin, this works fine. Appretiate all help Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! ~~ 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
Contract work??? OT
Hello all, I have been developing in ColdFusion, Sql Server, DB400(AS/400), Oracle, ASP, JavaScript, Html on NT/2000 Platforms.. Do you guys know any website/company that outsources/sub-contracts Projects/Contracts. Preferably Remote Development. Appreciate it. Sorry for the OT question. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! ~~ 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
cfcookie acting wierd???
Hello all, I have to set some cookie's for another application to work and the "Name" of the cookie has to be specific which is in lower case and upper case.. like cfcookie Name="MyHotCookie" value="beLLe" Path="/tunnel" domain=".cookies.com" ColdFusion v4.5 running under NT sp5 is messing up the "Name" of the cookie to "ALL Upper Case" like "MYHOTCOOKIE" Has anybody run into a similar bug and any solutions.. Please advice.. Thanks in advance.. Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Server log error???
Hello all, I am getting a this error in ColdFusion server log file(Server.Log). "Windows NT error number 109 occurred" Does anyone know what this error is and how i can rectify this problem. Appretiate any help. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: RE: Html email??
Thanks, I dont have a query in the CFMAIL but i build multiple database queries stored in varaibles that are included in the body of the email and the groupcasesensitive shouldnt matter, i have the type="html" also set. I have cutomers using Outlook Express 5.0 and Messenger 4.7 and they still get junk. Is there anything else wrong? Appretiate any help. Thanks Joe --- Original Message --- "Neil Clark" [EMAIL PROTECTED] Wrote on Wed, 18 Oct 2000 09:47:18 +0100 -- this should do the trick cfmail to="" from="" subject="" type="HTML" groupcasesensitive="Yes"/cfmail Neil ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
CGI. Auth_user timeout??
Hello All, Does anyone know whether or how the "CG.AUTH_USER" timesout or does it timeout at all. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Force sessiontimeout??
Hello all, Does the Code below kill the session and destroy the session variables? CFAPPLICATION NAME="TEST" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,0,0,0)#" Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Session timeout?
Hello all. Is there a way to find whether the session timed out.If the session timed out display the logon page. Some like cfif Not isDefined(Session) cflocation ../logon.cfm /cfif but i cant get this work. Appretiate any comments. thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Session timeout?
Thanks Andy, I cant do that cause i an dynamically logging the user. Is there a ways you could say. isDefined(Sessiontimeout)?? or i have to calculate the time the user spends in the app and log them off! --- Original Message --- Andy Ewings [EMAIL PROTECTED] Wrote on Thu, 24 Aug 2000 15:04:50 +0100 -- Set a param in your application.cfm called Session.Loggedin for example with a default of "no" When a user logs in set this variable to yes. Then in your application.cfm also have code that says: cfif Session.Loggedin IS "No" cflocation url="logon.cfm" /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:01 To: [EMAIL PROTECTED] Subject: Session timeout? Hello all. Is there a way to find whether the session timed out.If the session timed out display the logon page. Some like cfif Not isDefined(Session) cflocation ../logon.cfm /cfif but i cant get this work. Appretiate any comments. thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Oracle Time...again
Scott,
You could update using 'Sysdate' which will update the
record with date and time. I havent been using oracle in
a while, look at what 'sysdate' inserts and pass the sql string
in same format.
Hope this helps.
Thanks
Joe
--- Original Message ---
Scott Mulholland [EMAIL PROTECTED] Wrote on
Mon, 14 Aug 2000 08:13:03 -0400
--
Joe,
Thanks for the reply...I am not having any issues with the date,
I can
insert/update these with no problem, it is when I try to capture
the time as
well that it is failing.
Scott
-Original Message-
From: Joseph Eugene [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 5:02 PM
To: [EMAIL PROTECTED]
Subject: Re: Oracle Time...again
Scott,
The date format is Oracle is very picky. Its worth
having an
Oracle sql referrence book.
If you just want the current date
"update MyTable
set API_UPDATE = 'Sysdate'"
This will update the date field to the current oracle
db date.
If you want to manually update the date with CF
you have to use the format
"12-Jun-2000"
The month should be abbreviated to 3 chars
Thanks
Joe
- Original Message -
From: "Scott Mulholland" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 13, 2000 10:31 AM
Subject: Oracle Time...again
This message is in MIME format. Since your mail reader does
not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/plain;
charset="iso-8859-1"
I am using the following statement to insert a date/time string
into an
Oracle table (date field type):
update MyTable
set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
#TimeFormat(Now(),"hh:mm:ss tt")#')
I keep getting the error message: ORA-01843: not a valid month
Any ideas?
Thanks,
Scott
--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/html;
charset="iso-8859-1"
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD
BODY
DIVSPAN class=030583114-13082000FONT face=Arial size=2I
am using the
following statement to insert a date/time string into an Oracle
table
(date
field type):/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000FONT face=Arial
size=2/FONT/SPAN /DIV
DIVSPAN class=030583114-13082000FONT face=Arial size=2update
MyTable/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000FONT face=Arial size=2set
/FONT/SPANSPAN class=030583114-13082000FONT face=Arial
size=2API_UPDATE
= TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
tt")#')/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000FONT face=Arial
size=2/FONT/SPAN /DIV
DIVSPAN class=030583114-13082000FONT face=Arial size=2I
keep getting
the
error message: FONT face="Times New Roman" size=3ORA-01843:
not a valid
month
/FONT/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000/SPAN /DIV
DIVSPAN class=030583114-13082000FONT face=Arial size=2Any
ideas?/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000FONT face=Arial
size=2/FONT/SPAN /DIV
DIVSPAN class=030583114-13082000FONT face=Arial
size=2Thanks,/FONT/SPAN/DIV
DIVFONT face=Arial size=2Scott/FONT/DIV/BODY/HTML
--_=_NextPart_001_01C00533.33F6C520--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Oracle Time...again
Scott,
You could update using 'Sysdate' which will update the
record with date and time. I havent been using oracle in
a while, look at what 'sysdate' inserts and pass the sql string
in same format.
Hope this helps.
Thanks
Joe
--- Original Message ---
Scott Mulholland [EMAIL PROTECTED] Wrote on
Mon, 14 Aug 2000 08:13:03 -0400
--
Joe,
Thanks for the reply...I am not having any issues with the date,
I can
insert/update these with no problem, it is when I try to capture
the time as
well that it is failing.
Scott
-Original Message-
From: Joseph Eugene [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 5:02 PM
To: [EMAIL PROTECTED]
Subject: Re: Oracle Time...again
Scott,
The date format is Oracle is very picky. Its worth
having an
Oracle sql referrence book.
If you just want the current date
"update MyTable
set API_UPDATE = 'Sysdate'"
This will update the date field to the current oracle
db date.
If you want to manually update the date with CF
you have to use the format
"12-Jun-2000"
The month should be abbreviated to 3 chars
Thanks
Joe
- Original Message -
From: "Scott Mulholland" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 13, 2000 10:31 AM
Subject: Oracle Time...again
This message is in MIME format. Since your mail reader does
not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/plain;
charset="iso-8859-1"
I am using the following statement to insert a date/time string
into an
Oracle table (date field type):
update MyTable
set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
#TimeFormat(Now(),"hh:mm:ss tt")#')
I keep getting the error message: ORA-01843: not a valid month
Any ideas?
Thanks,
Scott
--_=_NextPart_001_01C00533.33F6C520
Content-Type: text/html;
charset="iso-8859-1"
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD
BODY
DIVSPAN class=030583114-13082000FONT face=Arial size=2I
am using the
following statement to insert a date/time string into an Oracle
table
(date
field type):/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000FONT face=Arial
size=2/FONT/SPAN /DIV
DIVSPAN class=030583114-13082000FONT face=Arial size=2update
MyTable/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000FONT face=Arial size=2set
/FONT/SPANSPAN class=030583114-13082000FONT face=Arial
size=2API_UPDATE
= TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
tt")#')/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000FONT face=Arial
size=2/FONT/SPAN /DIV
DIVSPAN class=030583114-13082000FONT face=Arial size=2I
keep getting
the
error message: FONT face="Times New Roman" size=3ORA-01843:
not a valid
month
/FONT/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000/SPAN /DIV
DIVSPAN class=030583114-13082000FONT face=Arial size=2Any
ideas?/FONT/SPAN/DIV
DIVSPAN class=030583114-13082000FONT face=Arial
size=2/FONT/SPAN /DIV
DIVSPAN class=030583114-13082000FONT face=Arial
size=2Thanks,/FONT/SPAN/DIV
DIVFONT face=Arial size=2Scott/FONT/DIV/BODY/HTML
--_=_NextPart_001_01C00533.33F6C520--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: one more try re: oracle stored proc and session mgmt
maybe you could also use a call statement.. cfquery Name="Test" Datasource="your_data" Call FunctionName(Param1, param2); /cfquery --- Original Message --- "Matt Rodosky" [EMAIL PROTECTED] Wrote on Mon, 14 Aug 2000 07:42:25 -0600 -- 1. Call the stored procedure (pass the sessionid and valid hours to the sp): cfstoredproc procedure="db_app_std.chk_ses" datasource="yourDSN" cfprocparam type="in" dbvarname="sesid" value="#sessionid# cfsqltype"datatype" cfprocparam type="in" dbvarname="valid_hrs" value="#validhrs# cfsqltype"datatype" cfprocparam type="out" variable="sp_results" cfsqltype"varchar2" /cfstoredproc 2. Put the call: in your application.cfm 3. Loginaction: add the logged-in userid to the correct record in the database, create variables for sessionid and validhrs 4. application.cfm: run the stored procedure, if the output is null, the user is not supposed to be logged in anymore. If it returns a user id, make sure its the right user and all that. 5. Oracle stored procedures don't return a regular recordset to cf, so you might need to play with the "sp_results" to get the output to work. hth, Matt -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:11 AM To: [EMAIL PROTECTED] Subject: one more try re: oracle stored proc and session mgmt I am desperate for help here. My deadline is this Friday, and I have no clue how to make this work... I have been provided with an Oracle stored procedure by our dba that provides a session id when a user logs in to my application with their domain name and password. I have successfully gotten this to work (i.e., I get a session id passed back to me). Now, I have also been provided with an Oracle function for the stored proc. I have NO idea what I'm supposed to do with this: FUNC: DB_APP_STD.chk_ses(sesid, valid_hrs) Input: sesid (varchar2) valid_hrs (number) optional, default is 3 hrs Returns: Varchar2 'UserID' OR NULL - Apparently the plan is to call the above function via an include page in any of the pages that I want password-protected. Apparently it is for checking that the user is, in fact, logged in. What I don't understand is, how do I call this function? Do I put it in my login_action page with the original stored procedure? What files do I need? I know I need the application.cfm file--do I put this function in there? What goes in the application.cfm file (other than my cfapplication tag) vs. what goes in my login_action.cfm file vs. what goes in my include page? Do I even need that third include page? PLEASE, if anyone has more of a clue than I do, let me know! Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: one more try re: oracle stored proc and session mgmt
maybe you could also use a call statement.. cfquery Name="Test" Datasource="your_data" Call FunctionName(Param1, param2); /cfquery --- Original Message --- "Matt Rodosky" [EMAIL PROTECTED] Wrote on Mon, 14 Aug 2000 07:42:25 -0600 -- 1. Call the stored procedure (pass the sessionid and valid hours to the sp): cfstoredproc procedure="db_app_std.chk_ses" datasource="yourDSN" cfprocparam type="in" dbvarname="sesid" value="#sessionid# cfsqltype"datatype" cfprocparam type="in" dbvarname="valid_hrs" value="#validhrs# cfsqltype"datatype" cfprocparam type="out" variable="sp_results" cfsqltype"varchar2" /cfstoredproc 2. Put the call: in your application.cfm 3. Loginaction: add the logged-in userid to the correct record in the database, create variables for sessionid and validhrs 4. application.cfm: run the stored procedure, if the output is null, the user is not supposed to be logged in anymore. If it returns a user id, make sure its the right user and all that. 5. Oracle stored procedures don't return a regular recordset to cf, so you might need to play with the "sp_results" to get the output to work. hth, Matt -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:11 AM To: [EMAIL PROTECTED] Subject: one more try re: oracle stored proc and session mgmt I am desperate for help here. My deadline is this Friday, and I have no clue how to make this work... I have been provided with an Oracle stored procedure by our dba that provides a session id when a user logs in to my application with their domain name and password. I have successfully gotten this to work (i.e., I get a session id passed back to me). Now, I have also been provided with an Oracle function for the stored proc. I have NO idea what I'm supposed to do with this: FUNC: DB_APP_STD.chk_ses(sesid, valid_hrs) Input: sesid (varchar2) valid_hrs (number) optional, default is 3 hrs Returns: Varchar2 'UserID' OR NULL - Apparently the plan is to call the above function via an include page in any of the pages that I want password-protected. Apparently it is for checking that the user is, in fact, logged in. What I don't understand is, how do I call this function? Do I put it in my login_action page with the original stored procedure? What files do I need? I know I need the application.cfm file--do I put this function in there? What goes in the application.cfm file (other than my cfapplication tag) vs. what goes in my login_action.cfm file vs. what goes in my include page? Do I even need that third include page? PLEASE, if anyone has more of a clue than I do, let me know! Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: one more try re: oracle stored proc and session mgmt
maybe you could also use a call statement.. cfquery Name="Test" Datasource="your_data" Call FunctionName(Param1, param2); /cfquery --- Original Message --- "Matt Rodosky" [EMAIL PROTECTED] Wrote on Mon, 14 Aug 2000 07:42:25 -0600 -- 1. Call the stored procedure (pass the sessionid and valid hours to the sp): cfstoredproc procedure="db_app_std.chk_ses" datasource="yourDSN" cfprocparam type="in" dbvarname="sesid" value="#sessionid# cfsqltype"datatype" cfprocparam type="in" dbvarname="valid_hrs" value="#validhrs# cfsqltype"datatype" cfprocparam type="out" variable="sp_results" cfsqltype"varchar2" /cfstoredproc 2. Put the call: in your application.cfm 3. Loginaction: add the logged-in userid to the correct record in the database, create variables for sessionid and validhrs 4. application.cfm: run the stored procedure, if the output is null, the user is not supposed to be logged in anymore. If it returns a user id, make sure its the right user and all that. 5. Oracle stored procedures don't return a regular recordset to cf, so you might need to play with the "sp_results" to get the output to work. hth, Matt -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, August 14, 2000 7:11 AM To: [EMAIL PROTECTED] Subject: one more try re: oracle stored proc and session mgmt I am desperate for help here. My deadline is this Friday, and I have no clue how to make this work... I have been provided with an Oracle stored procedure by our dba that provides a session id when a user logs in to my application with their domain name and password. I have successfully gotten this to work (i.e., I get a session id passed back to me). Now, I have also been provided with an Oracle function for the stored proc. I have NO idea what I'm supposed to do with this: FUNC: DB_APP_STD.chk_ses(sesid, valid_hrs) Input: sesid (varchar2) valid_hrs (number) optional, default is 3 hrs Returns: Varchar2 'UserID' OR NULL - Apparently the plan is to call the above function via an include page in any of the pages that I want password-protected. Apparently it is for checking that the user is, in fact, logged in. What I don't understand is, how do I call this function? Do I put it in my login_action page with the original stored procedure? What files do I need? I know I need the application.cfm file--do I put this function in there? What goes in the application.cfm file (other than my cfapplication tag) vs. what goes in my login_action.cfm file vs. what goes in my include page? Do I even need that third include page? PLEASE, if anyone has more of a clue than I do, let me know! Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
output the session??
--- Original Message --- Karl Simanonok [EMAIL PROTECTED] Wrote on Thu, 03 Aug 2000 09:54:45 -0700 -- If you're talking about getting past the Username/password form box that NT pops up when NT user authentication is enabled, all you have to do is pass the username and password in the URL like so: Plain URL: http://mysite.com Do this: http://username:[EMAIL PROTECTED] The only problem is that the exposed URL on the called page shows the username and password in the address bar of the browser, so once you're in you should immediately redirect the template using CFLOCATION or Javascript. Regards, Karl Simanonok original message: === Date: Wed, 2 Aug 2000 16:04:05 +0400 From: "Stanislav Maximov" [EMAIL PROTECTED] To: "[EMAIL PROTECTED]" [EMAIL PROTECTED] Subject: HTTP Authorization Message-ID: [EMAIL PROTECTED] Do anybody have any idea how to make HTTP authorization with CF? I've tried something like this with no success (assuming user will enter "user"/"password" as the credentials: --- cfif Auth_User is "user" and Auth_Password is "password" success! cfelse cfheader name="'WWW-Authenticate" value="BASIC base64encodingofname realm=""Private""" cfheader statuscode="401" statustext="Unauthorized" /cfif --- Please tell me were am I wrong? TIA stas@ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
output the session??
Hello all, I thought you could output the session. like cfoutput#Session#/cfoutput and i think i did it once , i cant get to work now.. How do output the session.? Thanks - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: what is better varchar or char
field1 Varchar(10) - if you insert "xyz" charaters, it will be automatically trimmed, ie "xyz" field1 Char(10) - whatever you insert which is = 10 chars the field will have the value and spaces. ie xyz and 7 spaces. for binary type data object, this will padded with "0" Well this can also be set at Database level: If you using SqlSever SET ANSI_PADDING ON | OFF --- Original Message --- "Johan Coens" [EMAIL PROTECTED] Wrote on Tue, 1 Aug 2000 09:14:52 +0200 -- Hello, I allways use varchar. Not because of better performance but because of the following: If I insert into the database the value 'xyz' in a char(5) field, the value of it in the dBase will be 'xyz '. It automaticly puts spaces behind to fill up the empty space. This means you always have to trim you're values before u use them ... Maybe there's a setting in the dbServer, but i'm not such a dbWizard. Best Regards, Johan Coens -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: maandag 31 juli 2000 20:52 To: cf-talk Subject: OT: what is better varchar or char This is a multi-part message in MIME format. --=_NextPart_000_001B_01BFFAF6.7FFB2ED0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I was told that char is better than varchar. Is this right? =20 I am going to have fields that are set to be either 25 50 100 or 150 = characters long. Is there a reason any of these fields should be char or = varchar? I have allways used varchar but I would like to know what is = best. =20 Feel free to respond directly to me since it is OT ;-) Art =20 =20 --=_NextPart_000_001B_01BFFAF6.7FFB2ED0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.3825.1300" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I was told that char is better than = varchar. Is=20 this right?BR BRI am going to have fields that are set to be = either=20 25 50 100 or 150 characters long. Is there a reason any of these = fields=20 should be char or varchar? I have allways used varchar but I would like = to know=20 what is best.BR BRFeel free to respond directly to me since it = is OT=20 ;-)/FONT/DIV DIVFONT face=3DArial size=3D2/FONT /DIV DIVFONT face=3DArial size=3D2Art/FONTBRFONT face=3DArial=20 size=3D2 BR /FONT/DIV/BODY/HTML --=_NextPart_000_001B_01BFFAF6.7FFB2ED0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Problem Handling Sessions
You are refreshing the page by submitting the form, which means you can loose your session. Work around. You have to manually set the cookie CFID AND CFTOKEN or change your settings in Admin to point your CFID And CFTOKEN to a database, rather than the registry. Which also is needed for clustering. cfcookie Name="CFID" value="#CFID#" cftoken Name="CFToken" value="#CFToken#" or use a Session variable cfparam Name="Session.Sid" default="#Session.CFID##Session.CFTOKEN#" Test: If you just have one page to see what your CFID and CFTOKENS are and hit the refresh button of IE or the Reload button of Netscape, you will see the CFID and CFTOKENS change. -- I have two questions about sessions. 1) I have an application that opens a pop-up javascript window with a form. This on the javascript window submits itself back to the template that opened it. It seemed to be working fine, but suddenly I am loosing my session when the form is submitted. (Its changing to a new CFID and CFTOKEN). The question is what could be causing me to loose the session in this way and how do I fix this? Do I have to start passing URLTOKEN around? --- Original Message --- "Steve Martin" [EMAIL PROTECTED] Wrote on Tue, 1 Aug 2000 09:54:08 +0100 -- I have two questions about sessions. 1) I have an application that opens a pop-up javascript window with a form. This on the javascript window submits itself back to the template that opened it. It seemed to be working fine, but suddenly I am loosing my session when the form is submitted. (Its changing to a new CFID and CFTOKEN). The question is what could be causing me to loose the session in this way and how do I fix this? Do I have to start passing URLTOKEN around? Have you also suddenly turned off cookies? If you haven't been passing URLToken around previously then you must have been relying on cookies to perpetuate the session. Or, has the domain portion of the popup box changed i.e. is your main site www.a.com and the popup box in www.b.com - this would cause cookie loss and hence session loss. 2) What methods can I use to prolong the length of a session? I can't change the timeout value because I am using an ISP. Eron, just because you're using an ISP it doesn't mean that you can't change the timeout values. Sure, you can't change the default timout values as set in the administrator but you can override these with your own settings in your CFAPPLICATION tag (e.g. sessiontimeout="#CreateTimeSpan(0,0,30,0)#"). Thanks, Eron NP Steve -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Function for padding strings???
Hello all, This might sound like a very stupid question, I need to pad a string with spaces, so that i can pass the value to a DB2 AS/400 Stored procedure. The SP has to get in format with no "," or any chars. Its kinda like a List with no special chars but the width of the list should be 300 and each part should be 15 chars long.. picky DB2/RPG SP. Ljustify is not working!!! Is there a fuction to pad strings?? Appretiate any comments thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Can't get cfschedule to run
Try using the CF administrator to create the task intstead of writing it into a page and enable schedule logging, so you know what cf server is doing.. hope this helps --- Original Message --- "Craig A. Zingerline" [EMAIL PROTECTED] Wrote on Wed, 26 Jul 2000 08:11:11 -0400 -- Hello, I have a simple task that I would like to schedule. When I run the cfschedule file, it sets up the task in the CF Administrator area. However, the task that is supposed to be run never runs. Does anyone know the solution? Thanks in advance for your time. !--- Here is the tag, which gets added to the CF administrator schedule fine --- cfschedule action="UPDATE" task="task1" operation="HTTPRequest" startdate="07/25/00" starttime="16:22:00" url="http://localhost/projects/tests/schedule_test/send_mail.cfm" interval="60" !--- Here is the task to be performed (send_mail.cfm) --- cfmail from="#email#" to="#admin_email#" subject="schedule test" Email text here. /cfmail Thanks! Craig A. Zingerline Advanced Media Productions Web Application Developer [EMAIL PROTECTED] Phone: 508.647.5151 Fax: 508.647.5150 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Timingout session on browser closeout ???
Hello all, Does anyone know how to hande the "X" or "Close" button of a browser? I need to timeout the session, when the user closes the browser out, without logging off. I thought there was a JavaScript function or some that could handle this, cant find any and Onunload doesnt do it. Appretiate any help Thanks inadvance Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Timingout session on browser closeout ???
--- Original Message --- [EMAIL PROTECTED] Wrote on Mon, 17 Jul 2000 10:42:26 -0700 -- Hello all, Does anyone know how to hande the "X" or "Close" button of a browser? I need to timeout the session, when the user closes the browser out, without logging off. I thought there was a JavaScript function or some that could handle this, cant find any and Onunload doesnt do it. Appretiate any help Thanks inadvance Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Force database connections to close....
Hello all, It looks like CF doesnt like to release the data brought down, which hogs up on the memory. Is there a way to force the database connection to close or to release memory as data is dumped to the client..??? some like connection.close() This would really be a powerful feature to have... Any ideas Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Session Management
Hi, If you are using CF session management, i think you could still use cfcookie Name="CFID" value="0" cfcookie Name="CFTOKEN" value="0" Maybe have a LogOff button and direct them to a template, where you delete your session variables and log off the user. StructClear(Session) has never worked for me on CF4.5, just messes up the session. Any ideas? --- Original Message --- [EMAIL PROTECTED] Wrote on Fri, 7 Jul 2000 16:26:30 +1000 -- expire the cookie immediately This won't work if you are using CF's session management because you don't specifically set cookies - it either uses CFID and CFTOKEN stored as a cookie OR as a URL argument. The expiration of the cookies is set by ColdFusion and is tied to the session timeout value. Many users don't accept cookies so relying on cookies alone to manage state is not a good idea. You should test for cookie ability at the start of a session and pass the values as a token on the URLs if cookies are not enabled by appending something like #application.addtoken# to every URL. More work, but it gives you fairly bulletproof session management. --- Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How the heck can I do this?
Jeff, I think you are actually bringing down the entire record set by specifying Maxrows="5" If you are using Sql Server use Select Top 5 Bid_Price, Bidder_Name, Bidder_Address .. from Auction_Bid_Table This will only bring down the record set, you need. If you only want to show the 5th max bidder price, In your cfoutput, use a count variable and display the the 5th only when the var is 5 cfset x="0" cfoutput query="Get_5maxBidder" cfset x=x+1 #name# cfif x eq "5"#5thMaxBidder#/cfif /cfoutput hope this helps Joe --- Original Message --- "Jeff Fongemie" [EMAIL PROTECTED] Wrote on Thu, 6 Jul 2000 08:19:11 -0400 -- I'm setting up a real simple auction application. Super simple. People submit bids via a form, then the top 5 bids are displayed on a page. The catch is, I only want the 5th highest bid to show the actual bid. So, I can order the query by bid descending and for output bids 1 through 5 will give the bidders name, but I need to have the bid amounts hidden for the top 4 bids, and show the 5th. To display only the top 5 bids, I'm using maxrows =5 in my output. Is there a way to control all this stuff with the SQL, or do I have a basic query, order by bid desc. and control the results through output? With the output method, I can't seem to be able to get the results to populate the 5th bid amt., but not the first 4. Thanks, Jeff Fongemie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Executing Stored Procedures on AS/400 or DB2???
Hello all, Has anyone been able to execute stored procedures on AS/400? with ColdFusion?. Our Asp developers have been able to execute the same procedures through ADO and it works fine for them, for some reason i am not able to Pass parameters using the CFSTOREDPROC,CFPROCPARAM (using client Express or DB2 Connect). errors -- Invalid tokens, execute statement is not in a prepared state etc. Does anyone have a work around this.? Appretitate any comments. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Running Stored Procedures on AS/400 or DB2???
Hello all, I am trying to run a Stored Procedure on an AS/400 using DB2 Connect and Client Express ODBC Connectors. Neither of them work. Have you guys been able to run stored procedures on AS/400 or Db2 successfully? Appretiate any help. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle vs SQL server
Tom, I have worked with both the databases and i think Sql server is "much more easier to set up and to work with". Sql server is much more flexible than oracle, Oracle might have some advantages for large databases, but i guess the latest Sql server version is equally powerful. Joe --- Original Message --- Tom Nunamaker [EMAIL PROTECTED] Wrote on Wed, 21 Jun 2000 13:18:43 +0200 -- Hi everyone. We're using SQL server 7.0 and it's working great. The DoD recently purchases a site license for the entire DoD for Oracle. My question is should I move my SQL server DB to Oracle? I tend to say no just because everything is already working, including some stored procedures and triggers. Has anyone had to do this migration path? What are the Advantages of Oracle over SQL Server?I've read some great things about SQL server 2000 and wonder if any advantages Oracles has at the moment will be gone with SQL Server 2000 is released later this year. Any other thoughts? Thanks Tom Nunamaker, Maj, USAF USAFE AMOCC/SC Chief, Communications Branch Senior Web Developer Ramstein AB, Germany -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Jrun variables in ColdFusion ?
Hello all, We have an application using Jrun which logs in the user and other stuff,this application is going against AS/400 real time, using sockets. I would like to know of a possible way to grab the "Userid" and "Password" in ColdFusion from Jrun app? Appretiate any help Thanks Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Client Access for IBM
Robert, Client Access is a miserable software, it is not meant to run on a Multiuser Odbc platform and using OLE DB , it wont allow you to pass username and password etc. The latest release of client Access v5 and all the latest Patch still does not address Memory leak Issues However, Ibm says Client Express will resolve these issues. I am getting ready to test, will have the software in a week or so. I also tried DB2 Connect, havent got it work either. Sound like this whole IBM stuff sucks. If you want email me sometime next week. we might have a solution or DataMirror AS400 Db2 to sql Server which is really fast and resolves all the problems, but AS400 geeks dont want to do it --- Original Message --- Robert Everland [EMAIL PROTECTED] Wrote on Thu, 25 May 2000 16:24:03 -0400 -- Has anyone been successful in using Client Access OLE DB drivers provided with Client Access with ColdFusion. Please respond if you have. Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Re: what is ODBC 37000 error ??
What Sql server version are you using? Are you overiding any Constraint violations? Primary key, foreign key etc Doing all the looping, i guess would slow down the transaction and might fail. If you are searching through large junks of data and have parameters for this, it would be apt to do this with a Stored Procedure. How big is your returned dataset, could you do subqueries ? or Joins , thats might speed up things, but i guess it better to this using a Stored Procedure. --- Original Message --- vincy [EMAIL PROTECTED] Wrote on Wed, 17 May 2000 18:00:48 +0530 -- hi, yeah, well I've posting this problem all over the place, and on one seems to be able to figure it out. The thing is that part of the code in brief does this : CFloop1 query query CFloop2 query query /lCFoop /CFloop Actually there are more queries. So, basically there are nested loops and in that there are queries to the SQL server. So, now if 500-700 people hit the site a day, I was wondering if this kind of CF coding would choke the SQL server ! vince At 06:23 PM 5/17/00 +1200, David Cummins wrote: I don't actually know the answer, but if you do find out, let me know. One of our sites, the server (which is hosted by someone else) is chewing up 10k of memory every second for no known reason. They recently installed Service Pack 6, or something like that. Luckily its not our problem, but its good to know these things... David vincy wrote: hi, Im running my site on the coldfusion 4.0 server, with NT 4.0 and SQL 7.0 The strangest thing has been happening the last few days, Ive been getting these ODBC 37000 errors quite often. It says that there is not enough memory to run the query. No one at the place that is hosting the site can figure out what page is causing this. They say that over a period of time the memory gets eaten up until it the server runs out of memory. Im guessing that one of the pages that is used often is a page that has a number of queries and loops to the SQL server . Anyone have any ideas on this ...Im running out of time. I cant have the server crashing once in two days. regards, vince -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Will the last person leaving Cold Fusion please turn out the lights?
Developed in WebObjects for a Project, Support developers/Mentors never knew anything more than wizards. Basic database calls and data manipulation took a lot of coding and complexity and still the site is slow, so what good is the product?? What can be done and be done with in ColdFusion in 2 weeks takes about 3months to develop in WebObjects. Its a Mockery when they(Apple) talks about rapid application development, if you want something solid to be developed in WebObjects, you have to code from Scratch and 1000's of lines of code and yet the site is damn too slow. Doesn't that prove why the prices slashed from 50,000 to 600? whoha "Wanna perfect unbreakable site, go code in C++, whos gonna pay for your time?"" --- Original Message --- "Gregory Harris" [EMAIL PROTECTED] Wrote on Wed, 17 May 2000 10:59:19 -0700 -- Ok, let's put it this way... ColdFusion Clients: ToysRus FAO Shwartz (and more) WebObjects Clients: Nissan (congratulations, you found a near bankrupt Auto company) Is ColdFusin dead? About as dead as the Internet around it...hehehe... Gregory Harris (tekiegreg) [EMAIL PROTECTED] -Original Message- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 17, 2000 9:32 AM To: [EMAIL PROTECTED] Subject: Re: Will the last person leaving Cold Fusion please turn out the lights? At 12:00 PM 5/17/00 -0400, you wrote: Well, it was a good run, but I guess this pretty much wraps it for Cold Fusion. Not too many people are going to want to bother with it given that now they can get something much better for about the same amount of money. Oh well, nothing lasts forever. Time to move on. I'm not doubting the quality of the product, but I question your motives for sending this message. You have never sent us a message before, but suddenly you send us a message including a press release and your "opinion" that this is a better product and that we will all be abandoning the one that the list supports. Plus, you sent it from an anonymous emailer. Frankly, I just searched Apple.com for your name. I didn't find it, but then again, I didn't find the names of any Apple sales representatives. I don't appreciate being spammed. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
AS/400 Screen Scraping data and reading data???
Hello all, I am dealing with quite a Complex project where the data from the Web Interface has to be pushed through AS/400 Screens for the RGP program on the AS/400 to process for the finanacials. I came across a Software called ScreenSurfer and the CF_Surfer tag, has anyone development with this software or a better software? Is there any possible straight forward way, i could push data through these AS/400 screens, I cannot write into AS/400 databases cause, the RPG program does quite a lot of processing for financials through this screen. Would anybody know of any other methods/Software to achieve this? Appretiate it. Thanks Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: AS/400 Screen Scraping data and reading data???
Thanks, It was my suggestion to E-commerce board to store the data on sql server and write the data from Sql server into AS/400 and make the Rpg program process this data, well they dont want to alter their RPG program or dont want to spend time making some simple changes, after all , all that changes is where the rpg program gets the data. This make my Job a lot more harder. --- Original Message --- "Perez, Bismark" [EMAIL PROTECTED] Wrote on Mon, 15 May 2000 11:20:31 -0400 -- Is the info been entered into the /400 in real time? do they needed in real time... if not, one approach you could use is to save the data from the web into a file (incremental record) on a /400 folder and have a CL run an RPG (every xx min/hours) that will populate the data (kind of a copy of the screen program)... Bismarck Perez *1-617-563-2896 * G10H * [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 15, 2000 11:06 AM To: [EMAIL PROTECTED] Subject: AS/400 Screen Scraping data and reading data??? Hello all, I am dealing with quite a Complex project where the data from the Web Interface has to be pushed through AS/400 Screens for the RGP program on the AS/400 to process for the finanacials. I came across a Software called ScreenSurfer and the CF_Surfer tag, has anyone development with this software or a better software? Is there any possible straight forward way, i could push data through these AS/400 screens, I cannot write into AS/400 databases cause, the RPG program does quite a lot of processing for financials through this screen. Would anybody know of any other methods/Software to achieve this? Appretiate it. Thanks Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Cfhttp behind firewall???
Hello all, I am having trouble using CFHTTP to connect outside the firewall, i have specified all the specifiations need proxyserver, port etc and CF gives me back an error "Connection Failure" has anyone had similar problems? We are using CF4.5.1 My code looks like CFhttp url="http://www.yahoo.com" Method="Get" proxyserver="" resolveurl="Yes" /Cfhttp Cfoutput #Cfhttp.filecontent# /cfoutput and this gives me "Connection Failure". Appretiate it. Thanks Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Convert cfm to Pdf files on the fly???
Hello all, Is it possible to convert a dynamically created CF page to a PDF File on the fly, this is actually for printing purposes. Is this possible?? any ideas? Thanks Joe "Is something wrong with this list, i am not getting to post messages and its quite slow"??? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Saving Email To Database
Dave, I havent done this, but i think you could achive this using CFPop, get your emails and i guess you should be able to insert them into your database. --- Original Message --- "David Hannum" [EMAIL PROTECTED] Wrote on Tue, 9 May 2000 21:26:42 -0400 -- I'd like to have a copy of emails that are sent to a drop box deposited into a database? Is anybody doing this? If so, care to share how you're approaching it? Thanks, Dave -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Date question in CF
Use #DateFormat(date,"DD/MM/")# where date is the field Name of date from your database. --- Original Message --- "WL" [EMAIL PROTECTED] Wrote on Mon, 1 May 2000 12:14:04 +0100 -- Hi, I have a SQL query that goes like "SELECT date FROM details" - except that it displays the date and time - something like 30/04/00 00:00:00. I'm using MS Access, (.mdb) - how can I change the display format of the date? I would ideally like to display it as dd// and with no time in it. Thanks in advance, Will -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Incrementation of a value
set the default value to be a three digit. lets say "100" So the 1st record will have the value id 100 Increment it your form cfset Value_id=#ValueidFromDatabase# + 1 Insrt the Value_id in your next record. There might be a way to set default values too Sql sever allows to set the default value and increment it by whatever value you want. Access should allow this feature too! --- Original Message --- Denny dd [EMAIL PROTECTED] Wrote on 1 May 00 07:40:29 MDT -- Hi! I have an insert form and I want that when ever this form is loaded the value of my "Code" field should be incremented.I know that in access database we have the option of datatype as autonumber but I want my code to be of 3 digits. Thanks in advance Denny Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Preselect option in select
cfset ... the selection and return the variable on the link or you could use history.back() function of the browser, so you dont loose the selection. select ... option value="Var" cfif #var# eq #yoursetVariable#Selected/cfif #query.value# /select --- Original Message --- "Tiberiu Vasilica" [EMAIL PROTECTED] Wrote on Fri, 28 Apr 2000 12:19:15 +0300 -- This is a multi-part message in MIME format. --=_NextPart_000_0029_01BFB10B.F7FCCE00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello all, How I can preselect an option so when the user comes back to the = selection page to find his last selection in a list form? Thank you Tibbs SELECT name=3D"suport" CFOUTPUT query=3D"showsupport" OPTION value=3D"#SupportID#" #SupportName#/OPTION /cfoutput /SELECT --=_NextPart_000_0029_01BFB10B.F7FCCE00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hello all,/FONT/DIV DIV /DIV DIVFONT face=3DArial size=3D2How I can preselect an option so when = the user=20 comes back to the selection page to find his last selection in a list=20 form?/FONT/DIV DIV /DIV DIVFONT face=3DArial size=3D2Thank you/FONT/DIV DIVFONT face=3DArial size=3D2Tibbs/FONT/DIV DIV /DIV DIVFONT face=3DArial size=3D2 SELECT=20 name=3D"suport"BR CFOUTPUT=20 query=3D"showsupport"BROPTION=20 value=3D"#SupportID#"=20 #SupportName#/OPTIONBR /cfoutputB= R /SELECT/FONT/DIV/BODY/HTML --=_NextPart_000_0029_01BFB10B.F7FCCE00-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Re: CFHttp and Wddx posting for results only???
Thanks Sharon, How do i parse the page returned back(ie #cfhttp.filecontent#) to get only the results of the query. I would like to know, how can one Parse the info from a page without the forms fields and such. Appretiate it. Thanks Joe --- Original Message --- Sharon DiOrio [EMAIL PROTECTED] Wrote on Fri, 28 Apr 2000 10:50:04 -0400 -- You can use cfhttp and WDDX to query other sites, provided the other site is cooperating. Otherwise you're stuck with querying the site and parsing out all of the extraneous page information. A tedious process at best. Sharon At 09:30 AM 4/25/2000 -0700, [EMAIL PROTECTED] wrote: Hello all, I am Wondering whether is possible to use Cfhttp and Wddx to query other sites for information and return back just the results rather than site2's entire page. How do i know whether site2 allows use of Method="Post" of Cfhttp, How can i achive this?? Thank inadvance. Appretiate it Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHttp and Wddx posting for results only???
Thanks Dick, This is my sample code. CFHTTP URL="http://search.yahoo.com/bin/search?" Method="Post" CFhttpParam name="P" type="URL" value="Usa" /CFHTTP CFOUTPUT #cfhttp.filecontent#BR BR H3BThe mime-type:/B/H3BR #cfhttp.mimetype#BR H3BThe Status Code:/B/H3BR #cfhttp.statuscode#BR H3BThe Raw Header:/B/H3BR #cfhttp.header#BR /CFOUTPUT I can get this to work with Method="Get" and pass the parameter via Url. I downloaded the CFHTTP bug release for CF4.5 and its still saying Connection Failure, is there something wrong in the code? How can i return/Parse the results only from the returned(#cfhttp.filecontent#), if i can do this, thats pretty slick. Thanks a lot for your help. Appretiate it. Thanks Joe --- --- Original Message --- Dick Applebaum [EMAIL PROTECTED] Wrote on Thu, 27 Apr 2000 07:08:36 -0700 -- Joe If you don't have access to the other site to install a stub, then you will get whatever the other serves to the browser as if you visited the page and sublitted a form. The returned results can be parsed (usually with regexps). You usually must do a little detective work to determine how to pares... do some page requests display the source The Connection Failure problem may be a CF bug (especially CF 4.5) If you post your CFHTTP code, I'll try it on CF 4.0 Dick At 6:06 AM -0700 4/27/2000, [EMAIL PROTECTED] wrote: Thanks Dick, Can i accomplish this without having complete access to the other site. Lets say i wanted to check for a SpecificBusiness at NetWorkSolutions.com, Is it possible to get only the results back using the Method="Post". i tried this and i am getting a connection faliure error. Appretiate your help Thanks Joe --- Original Message --- Dick Applebaum [EMAIL PROTECTED] Wrote on Wed, 26 Apr 2000 21:08:53 -0700 -- Joe If you have access to the other site, you can install a stub program, then communicate with this stub via CFHTTP, passing WDDX packet(s) as form fields. So, for example Site A serializes a WDDX packet of an SQL query statements (to be issued on Site B) Site A passes this query to Site B via CFHTTP (invokes the stub) Sitw B deserializes the WDDX packet and issues the SQL Query against a dsn on site B. Site B Serializes the results of the SQL Query (record set) into a WDDX packet Site B returns this WDDX packet as the output of the CFHTTP request (from site A) Site A receives the WDDX packet in CFHTTP,FileContent Site A Deserializes the packet into a SWL query result (record set) Site A presents the Query to the user... I have done exactly this to move a large database (many related tables), piecemeal, form one web/SQL server to another web/SQL server. for example populate a (duplicate) table on Site A with a Query (Record set) from Site B It works amazingly well. HTH Dick At 10:26 PM -0400 4/27/2000, Joseph Eugene wrote: - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 25, 2000 12:30 PM Subject: CFHttp and Wddx posting for results only??? Hello all, I am Wondering whether is possible to use Cfhttp and Wddx to query other sites for information and return back just the results rather than site2's entire page. How do i know whether site2 allows use of Method="Post" of Cfhttp, How can i achive this?? Thank inadvance. Appretiate it Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com
CFHttp and Wddx posting for results only???
Hello all, I am Wondering whether is possible to use Cfhttp and Wddx to query other sites for information and return back just the results rather than site2's entire page. How do i know whether site2 allows use of Method="Post" of Cfhttp, How can i achive this?? Thank inadvance. Appretiate it Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
quering sites??
Hello all, I am wondering, if its possible to query other sites for information and update a database with the information. Can this be done in a batch mode? what would be the code ? Appretiate it Thanks Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
nesting queries??
Hello all, I would like to know how you guys are nesting queries? i have to "Nest" multiple queries like cfoutput query="query1" cfoutput query="query2" --- cfoutput query="query3" -- /cfoutput /cfoutput /cfoutput How can i do this? Thanks inadvance Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
getting fields of a table(sql)
Hello All, Is there a way/sql statement that would get me all the fields in the table? and store it in a variable ? something like cfset x=Select Field_Names from Table_Name so now x will have the values of the fields in the table. Appretiate all comments, thanks inadvance! Joe This message has been scanned for viruses using Sophos. The opinions stated in this message do not necessarily represent the opinions of e-MDs, its management or staff. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Table row formating???
Hello all, how are you all getting to display 3 records from the database at a time? Lets say the sql query returns 30 records, how can i display 3 in a row and have 10 rows? Appretiate it Thanks Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Check boxes! dynamic fields??
Hello all, I am using static check boxes, which are field names is the database, and according to what the user checks , they will see only those fields on the next page with data. I am having problem with displaying the data as it is in a single #Variable# , i tried this cfoutput query="Get_Distributors" CFLOOP INDEX="x" LIST=#Display_Fields# DELIMITERS="," startrow="1" #x# /CFLOOP /cfoutput but didnt work How can i do this? Appretiate it! Thanks Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
