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

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

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

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

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

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

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 (

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

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!

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

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 (

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

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]

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]

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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 (

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

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

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

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

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

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

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 ,

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

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"???

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

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

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

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"

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

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 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.

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

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

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

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 --

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