Re: drop down form

2001-03-10 Thread Dick Applebaum
Can be done with Flash, DHTML, Java HTH Dick At 7:50 PM -0500 3/9/01, Jones, Becky wrote: this may not be the right forum for this...but everyone seems to be pretty knowledgable here... i have a form on a page. i want to be able to have like a "minimize" "maximize" button on the form. so

Re: Query crashes server?

2001-03-10 Thread W Luke
The update I did also included adding a new table to the DB. Usually, I add a "Site being updated" message and cfabort to the application.cfm file - but I forgot this time, and when I was uploading the DB I think it probably became corrupt as CF tried to write to it. Initially it was working

Re: Reseller Recommendations???

2001-03-10 Thread net_man
Check out www.atswebnet.com you can host domains for as low as $4.95 and resell all you want. Robert - Original Message - From: "ibtoad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 11:20 PM Subject: Reseller Recommendations??? I am intersted in

RE: CFCOOKIE

2001-03-10 Thread Philip Arnold - ASP
Philip, can we get hold of the CF5 documentation without actually installing the beta? I've not come across it on Allaire's site and was wondering if it was available in advance of the product Not as far as I know - in fact, the Docs that installed with my CF5 Beta are pretty non-existant -

RE: Warning: Page has Expired... How do I get around that??

2001-03-10 Thread Philip Arnold - ASP
Something you might think about is putting the variables passed into hidden form fields and put a "Back" button on the page itself instead of having your user/visitor use the browser's buttons. This would work as long as they didn't mind printing the "Back" button I know I just mentioned

RE: how can I preiodically refresh cfgrid?

2001-03-10 Thread Philip Arnold - ASP
I have to refresh a cfgrid from a database in every 10 seconds or so. If I reload the whole page, it's kind of ungly (flickering too). Any better way? (I know I could use an applet, but...) Wouldn't that mean that it wouldn't be updatable? If that's your intention (only displaying data) then

RE: Sorting an Array

2001-03-10 Thread Philip Arnold - ASP
Been trying to sort a 2 dimensional array and am having trouble. The fisrt element is numeric, the 2nd is text. I'm trying to sort in numeric order on the 1st item and can't get it to work. OK, please tell me you're not using ArraySort() - this only sorts one dimensional arrays You'd have to

Examples of Password protection

2001-03-10 Thread Michael
Looking for some examples of password protection of certain pages or view's Thanks Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

Re: Finding the CF Administrator password

2001-03-10 Thread CF
Yeah .. someone sent me the key a little earlier and it worked like a charm. Actually, this other peson also showed me how to find the key to begin with ... it's amazingly simple. I don't see why you should be flamed .. people should not have CFRegistry active on a machine where they wouldn't

RE: Finding the CF Administrator password

2001-03-10 Thread John Fix 3rd
How does one disable CFRegistry? Thanks! John -Original Message- From: CF [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 10, 2001 10:48 AM To: CF-Talk Subject: Re: Finding the CF Administrator password Yeah .. someone sent me the key a little earlier and it worked like a charm.

RE: Finding the CF Administrator password

2001-03-10 Thread Philip Arnold - ASP
How does one disable CFRegistry? In the Administrator - Basic Security Along with CFDirectory, CFFile, CFExecute Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world"

Re: Finding the CF Administrator password

2001-03-10 Thread CF
It's in the CFAdministrator under Basic Security. Scroll down to the bottom and uncheck what you don't need. I would uncheck them all unless you have a speciffic need for one of them. Todd Ashworth Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill,

RE: Finding the CF Administrator password

2001-03-10 Thread Raymond B.
Go to the CF Admin, under 'Basic Security' is a list of tags you can disable. That's of course just the first step towards securing the server. If you're running a shared environ make sure to grab the Allaire path to disable the CF Admin undocumented tags/functions as you can do all sorts of fun

RE: drop down form

2001-03-10 Thread Jones, Becky
do you have any examples?? -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 10, 2001 4:31 AM To: CF-Talk Subject: Re: drop down form Can be done with Flash, DHTML, Java HTH Dick At 7:50 PM -0500 3/9/01, Jones, Becky wrote: this may not be the

Re: Examples of Password protection

2001-03-10 Thread sebastian palmigiani
on 3/10/01 9:35 AM, Michael at [EMAIL PROTECTED] wrote: Looking for some examples of password protection of certain pages or view's Near the end of chhapter 17 of the book Mastering ColdFusion 4.5 by Danesh and Motlagh has a nice section on this. Sebastian

RE: Finding the CF Administrator password

2001-03-10 Thread Philip Arnold - ASP
Just a note on template encrypting: It's scarcly worth it as the server obviously needs a fixed key (as shown below) to make it portable and has to be an easy scheme to make the template run w/o much decryption overhead. Anyone w/ even basic knowledge of DES encryption and programming can

wddx server to server

2001-03-10 Thread nizam
Hi, What I can see the example coding is browser to server or server to browser. How if I want to get the data from other server and save it in my server. I want to create a page that will retrieve the data from SQL database from other server and insert in my SQL database in my server using

Dealing with Large Queries

2001-03-10 Thread Avrom
Hi! I've got a simple guestbook application that holds 250 guestbooks so far. Some of the guestbooks are have up to 13000 records. I am returning the entire recordset and looping through it 20 records at a time (I didn't think that it would get to be so big), but the query times out on 13000

Re: Query crashes server?

2001-03-10 Thread W Luke
Initially it was working (including the new update) - so I'm going to try the old DB file to see if that helps :( Well, the old DB works fine. I also tried a "newly uploaded" version of the new DB, but that crashes cfserver immediately. Could it be the Memo field I put in the new table?

RE: Dealing with Large Queries

2001-03-10 Thread Al Musella, DPM
Have an autoincrement field in the database. use it as the key to get each group. For example, on the first round, you would do: select whatever from whatever, where ID N1 and ID N2 Pass N1 and N2 back and forth between templates, and have a next group, previous group manipulate N1 and

RE: Dealing with Large Queries

2001-03-10 Thread Avrom
Al, Thanks for the quick response, but I can't count on the identity column being contiguous because entries have been deleted. -- Brett A 12:33 PM 3/10/2001 -0500, you wrote: Have an autoincrement field in the database. use it as the key to get each group. For example, on the first

Re: Dealing with Large Queries

2001-03-10 Thread Jeffry Houser
To elaborate a little more on what Philip just said (I was about to say the same thing): CFPARAM lownum = 0 CFPARAM highnum = 20 CFQUERY select top 20 * from mytable where mytableID #lownum# and mytableID #highnum# /CFQUERY FORM blahblahblah INPUT type="hidden" name="lownum"

RE: Dealing with Large Queries

2001-03-10 Thread Philip Arnold - ASP
Thanks for the quick response, but I can't count on the identity column being contiguous because entries have been deleted. Pass the highest entry through and do Select top 20 * from myTable where ID #passedID# As long as ID's are in chronological order (which they should be) Philip Arnold

RE: Dealing with Large Queries

2001-03-10 Thread Jeffry Houser
Allow me to modify my previous post then... CFPARAM lownum = 0 CFQUERY select top 20 * from mytable where mytableID #lownum# /CFQUERY CFSET highID = lownum CFOUTPUT query=myquery CFSET highID = myquery.mytableID /CFOUTPUT FORM blahblahblah INPUT type="hidden" name="lownum"

RE: Dealing with Large Queries

2001-03-10 Thread Philip Arnold - ASP
Allow me to modify my previous post then... CFPARAM lownum = 0 CFQUERY select top 20 * from mytable where mytableID #lownum# /CFQUERY CFSET highID = lownum CFOUTPUT query=myquery CFSET highID = myquery.mytableID /CFOUTPUT FORM blahblahblah INPUT type="hidden"

Re: wddx server to server

2001-03-10 Thread Stephen M Aylor
www.wddx.org Steve - Original Message - From: "nizam" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, March 11, 2001 12:43 AM Subject: wddx server to server Hi, What I can see the example coding is browser to server or server to browser. How if I want to get the data

RE: Dealing with Large Queries

2001-03-10 Thread Jeffry Houser
At 06:14 PM 03/10/2001 +, you wrote: Allow me to modify my previous post then... CFPARAM lownum = 0 CFQUERY select top 20 * from mytable where mytableID #lownum# /CFQUERY CFSET highID = lownum CFOUTPUT query=myquery CFSET highID = myquery.mytableID /CFOUTPUT

Dates in OLEDB

2001-03-10 Thread Richard Meredith-Hardy
I'm experimenting with a migration from ODBC to OLEDB -- access 2000 This query works fine with an ODBC datasource: (STORYDT is a datetime field) CFQUERY NAME="getnews" Datasource="#application.mydsn#" SELECT SREF, STORYSUBJ, STORYDT FROM news WHERE (STORYDT

RE: Dates in OLEDB

2001-03-10 Thread Philip Arnold - ASP
I'm experimenting with a migration from ODBC to OLEDB -- access 2000 This query works fine with an ODBC datasource: (STORYDT is a datetime field) CFQUERY NAME="getnews" Datasource="#application.mydsn#" SELECT SREF, STORYSUBJ, STORYDT FROM news WHERE (STORYDT

CFHTTP Problem

2001-03-10 Thread Kurt Ward
Maybe you guys can help me out. On our production server and dev server (both running Apache and CF 4.5.1 SP2)I call an application on an external server via CFHTTP with POST as the method and one form variable that contains XML. I get the results back and take care of them accordingly. No

RE: Examples of Password protection

2001-03-10 Thread Arden Weiss
Agreed.. I lifted the entire application.cfm code dealing with session management and password/login from that chapter and embeded it into my first big app -- worked untouched like a charm. Also, good stuff on error handling in chapter 18. ^ / \__ (@\___ / O /

Replacement for Replace

2001-03-10 Thread Duane Boudreau
Hi all, I have a list that I am working on that is 4000+ items plus. The list unfortunately contains several "empty" items. Is there a way, other than using Replace() to replace the empty items with a 0? This is what I have to deal with, but it is talking 1200 ms to process and there is two

RE: Query crashes server?

2001-03-10 Thread Arden Weiss
I may be having the same problem. The system I have includes an Access database with Memo fields (went to access because of problems hanlding memo fields via the ODBC driver for FoxPro). Queries and updates work fine on my local machine and a staging site (commercial host), but on my

RE: CFHTTP Problem

2001-03-10 Thread Philip Arnold - ASP
On our production server and dev server (both running Apache and CF 4.5.1 SP2) I call an application on an external server via CFHTTP with POST as the method and one form variable that contains XML. I get the results back and take care of them accordingly. No problems. Here is the problem:

RE: Query crashes server?

2001-03-10 Thread Philip Arnold - ASP
I may be having the same problem. The other "solution" that I use when it's not in Identity order is to pass a complete list of the IDs through in a form field (yes, I know this gets big when it hits the thousands) and then pull out the block I'm looking at, the ID list must be in the correct

RE: cfhttpparam results in a popup window

2001-03-10 Thread Hayes, David
The html 4.0 FORM element allows a "target" attribute; if you set it to "_blank", the action page will open in a new window. At the top of the new page, include SCRIPT language="javascript" opener.location.href = "successpage name"; /SCRIPT -Original Message- From: Mark Smeets

RE: cfhttpparam results in a popup window

2001-03-10 Thread Philip Arnold - ASP
At the top of the new page, include SCRIPT language="javascript" opener.location.href = "successpage name"; /SCRIPT Actually, to be 100% correct on this (when dealing with older browsers) script language="javascript" !-- opener.location.href="myPage.cfm"; //-- /script Philip

Re: Linux/CF and MYSQL vs. Win2k/CF and SQL2k

2001-03-10 Thread Peter Theobald
Cold Fusion on Linux is great. We use it exclusively. We find NT to be less reliable, and difficult to remotely administer (especially a large server farm of them). We have no experience with Win2K. MySQL is very very fast, but is not a full featured RDBMs. For a heavily trafficked site or a

Re: rs6000 - AS 400

2001-03-10 Thread chris.white
I have used Client Access Express. The advantage is that you can call a stored procedure (RPG or Cobol program) and have the results returned as a record set. You can't do that with DB2 Connect. As for Screensurfer, it works but it is expensive. We choose Client Access Express. Chris White

Re: CF Generator applications

2001-03-10 Thread Peter Theobald
I'm dying to try out CommerceBlocks but they don't support Sybase yet. Everyone who is using Sybase please send them a note asking them to make that first on their list! :-) At 05:40 AM 3/9/01 -0500, Tony Schreiber wrote: http://www.commerceblocks.com/ Anyone knows a program that generates CF

Re: CF and Interland Price Increase

2001-03-10 Thread chris.white
I have been using Digi-wave for over a year. Their cheapest ColdFusion plan is $22.95 and corp. account is $49.95. For more info: http://www.digi-wave.com/webhostingplans.html Ask for Phalon and tell him that I sent you. ~~~ Chris White Experienced Designs [EMAIL

RE: stored procedure and resultset

2001-03-10 Thread Dave Watts
Did you use that in Oracle before? The reason I asked is that in ColdFusion knowledge base, for article # 8353, it said that "Oracle stored procedures do not return result sets in the traditional sense. Consequently, it is not possible to generate a query in ColdFusion using an Oracle

Re: Replacement for Replace

2001-03-10 Thread Dick Applebaum
Why not: cfset GetDiscountList.DiscountList = Replace(GetDiscountList. DiscountList, ";;", ;0; "ALL") HTH Dick At 3:38 PM -0500 3/10/01, Duane Boudreau wrote: Hi all, I have a list that I am working on that is 4000+ items plus. The list unfortunately contains several "empty"

oops was Re: Replacement for Replace

2001-03-10 Thread Dick Applebaum
Tag should be cfset GetDiscountList.DiscountList = Replace(GetDiscountList. DiscountList, ";;", ";0;", "ALL") I think that the speed of my brain speed of my fingers speed of my mouth At 3:52 PM -0700 3/10/01, Dick Applebaum wrote: Why not: cfset

RE: Replacement for Replace

2001-03-10 Thread Jason Aden
Why not try using a database function for it? Something like: cfquery name="GetDiscountList" datasource="datasource" select replace(discountList,NULL,0) AS discountList from discounts /cfquery That way the database can handle doing the replacement, which is a lot faster than

Re: CF Generator applications

2001-03-10 Thread net_man
I have seen Clint's app and it will be wanted by all and matched by none. Robert - Original Message - From: "Clint Tredway" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 8:54 PM Subject: RE: CF Generator applications I have used and it is very buggy

Re: Examples of Password protection

2001-03-10 Thread Michael
What I am looking for is if you have this password then you have access to all the information in the program/form/database, and if NOT, then you only see this much and thats IT.. Thanks "Michael" [EMAIL PROTECTED] wrote in message 3aaa4a87$[EMAIL PROTECTED]">news:3aaa4a87$[EMAIL

Re: Another FAQ:

2001-03-10 Thread Michael Dinowitz
Eventually I plan to absorb them all into mine. :) Just thought I would pass this along, for interst sake. http://developer.irt.org/script/fusion.htm I might just assimilate some of their better questions, in a Borg-like fashion... -- Aidan Whitehall [EMAIL PROTECTED] Netshopper

Re: rs6000 - AS 400

2001-03-10 Thread Joseph Eugene
Successful usage of DB2 connect also depends on the AS400 OS you are running. You should have the lastest version of the AS400 OS to run DB2 connect properly and the AS400 OS has to be confirgured to get DB2 Connect working properly. The lastest version of Client Access works good and IBM has

RE: Advanced ColdFusion, UK, March 12th

2001-03-10 Thread Hal Helms
Gavin, I'm working with some folks in UK to try to put together a Fusebox class. No dates yet, but I'll keep you informed. Hal Helms Team Allaire [ See ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training ] -Original Message- From: Gavin Lilley

RE: CFObjects vs. FuseBox vs. Good CFML Code and SmartObjects

2001-03-10 Thread Hal Helms
I've used CFObjects. It's intriguing, but ultimately I find it unsatisfying for exactly the reason Dave Watts gave. If you want to do OO development, why would you not use a language like Java or Ruby that support OO methodologies? Sure, you can roll your own with CF, but why? Still, if you

Re: Examples of Password protection

2001-03-10 Thread David Hannum
Try making a table in your database with a "level" field, username and pwd. Set the levels, then query the table with your login. Put your qualifiers in your scripts and set session vars based on the level in the login. Let them see what they can based on the level of privileges they have.

RE: Dates in OLEDB

2001-03-10 Thread Richard Meredith-Hardy
Hum This works. Thanks, what a pain! This immediately makes a migration to OLEDB a waste of time. (Might look at it for future apps) It also makes me think there should be a set of new functions in CF: createDBdate(mydate,"theDB") createDBdatetime(mydatetime,"theDB") Where theDB could be

RE: Replacement for Replace

2001-03-10 Thread David Shadovitz
Duane, Jason's advice is good. In MS Access, use IIF and IsNull, like this: IIF(IsNull(Department),'N/A',Department) where IIF's syntax is: IIF(expr, truepart, falsepart) -David On Saturday, March 10, 2001 3:12 PM, Jason Aden [SMTP:[EMAIL PROTECTED]] wrote: Why not try using a database