RE: Need a good dynamic bar pie chart app...

2000-09-05 Thread Roberts, Jesse D
The pricing is pretty good. You can view it all on their site http://www.corda.com/pricing.cfm. The standard server costs about 2k and the pro version about 5k. The builder/development software is $250. To talk to someone from Corda, call Wenlock Free. His number is 801-802-0800 x.113. He

RE: Query Help - Using 'GROUP'

2000-08-29 Thread Roberts, Jesse D
Sure. Something like this should do the trick. CFQUERY DATASOURCE="#DB#" NAME="QueryOne" SELECT a.SalesRep b.Territory_ID c.Territory_Name FROMTableA a, TableB b, TableC c WHERE a.SalesRep =

RE: Allaire security problem - anyone know solution?

2000-08-03 Thread Roberts, Jesse D
I can't reproduce your results on any of the 3 systems I tried, including Allaire's site. Do you have any more information? -Original Message- From: Dave Wilson [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 03, 2000 9:27 AM To: [EMAIL PROTECTED] Subject: Allaire security

Best method for quantifying query elements

2000-08-03 Thread Roberts, Jesse D
The subject line isn't clear, but I hope this is. Looking for the best method to do the following: I have a standard query returning something like the following: NAMESCHEDULE_DATE REQUEST_ID Doe Aug 1, 2000 28

RE: Time add

2000-07-31 Thread Roberts, Jesse D
DateAdd works with any Date/Time object. To use DateAdd with time, just use the appropriate time specifier where you're used to using the date specifier. For example, DateAdd("H", 1, Now()). Jesse D. Roberts Business Process Analyst Procurement Quality Assurance Boeing - Huntington Beach, CA

RE: SQL

2000-07-10 Thread Roberts, Jesse D
Yeah. You can use the NOT IN operator. SELECT * FROMTABLE WHERE Blah NOT IN ('blah', 'blah1', 'blah2') Jesse D. Roberts Business Process Analyst Procurement Quality Assurance Boeing - Huntington Beach, CA -Original Message- From: Adrian Cesana [SMTP:[EMAIL

RE: How do I read a list of employee IDs returned from a form,with checkboxes??

2000-07-05 Thread Roberts, Jesse D
To create the form page, and inside the FORM tages, simply loop through each employee returned from your query to create a separate line for each one. In side the LOOP for each query line returned, include either a checkbox, radio button, or a SELECT list by which the user can "select" an

RE: How to set a future date?

2000-07-05 Thread Roberts, Jesse D
Sure. Look up the date functions in Cold Fusion. I would use the following syntax: CreateDateTime(year, month, day, hour, minute, second) then embed the DateAdd function for each element. #CreateDateTime(DateAdd('', 1, Now()), DateAdd('M', 1, Now()), DateAdd('D', 1, Now()), DateAdd('H',

RE: shorter lines

2000-07-05 Thread Roberts, Jesse D
Sure, use the Left, Mid, and Right functions. You should find info on them in your documentation. Jesse D. Roberts Business Process Analyst Procurement Quality Assurance Boeing - Huntington Beach, CA [EMAIL PROTECTED] Ph. 714-896-3462 Fx. 714-896-3303 -Original Message- From:

RE: my pre-selected select box - why won't this work?

2000-07-03 Thread Roberts, Jesse D
Just a guess, but you might try putting using Trim in your SELECTED varaible. If your db state value has a space character, it would prevent it from working. Jesse D. Roberts Business Process Analyst Procurement Quality Assurance Boeing - Huntington Beach, CA [EMAIL PROTECTED] Ph.

RE: HELP: CF Server not working

2000-06-30 Thread Roberts, Jesse D
In the CF Administrator, under the Server Settings section, change or uncheck the Timeout Requests after... setting. You can either increase it or turn it off. However, I would also investigate what is causing a request to take longer than 30 minutes! I mean, has your database gone out to

RE: Drawing a blank...

2000-06-30 Thread Roberts, Jesse D
Unless you're using an Array to store the shopping cart values. In that case, you're probably looking for ArrayLen. If it's a structure, I'm thinking StructCount is your function. Jesse D. Roberts Business Process Analyst Procurement Quality Assurance Boeing - Huntington Beach, CA [EMAIL

RE: Selecting a value in a dropdown.

2000-06-27 Thread Roberts, Jesse D
Embed a CFIF statement inside the loop that determines whether or not the database value matches the OPTION value. Then, if it does match, include the SELECTED parameter inside the option tag. select name="parked" option value="" cfloop index=i from="1"

RE: Can CF generate a Pop-up Window w/o Javascript?????

2000-06-08 Thread Roberts, Jesse D
No can do. In order to get the pop-up window, you need a Server-side language of which JavaScript is probably the best for your purposes. ColdFusion is a server-side technology meaning that all of it's code is executed on the server before a page is sent to a user. Because of this, ColdFusion

RE: writing to a database error

2000-06-06 Thread Roberts, Jesse D
Your criteria expression is the problem (i.e., the WHERE ID='#Session.TradeID#' clause) My guess is that the TradeID field isn't a text field in which case there shouldn't be any quote marks around it. Remove them and see what you get. Jesse D. Roberts Business Process Analyst Procurement

RE: Update Query

2000-06-03 Thread Roberts, Jesse D
Something like this should work: UPDATE TableName SET Field1 = #FORM.Field1#, Field2 = #FORM.Field2# WHERE Field1 = #Current value of Field1# The WHERE clause applies to the existing value. AFTER the update, the value will reflect the change the user

RE: Slightly OT

2000-06-03 Thread Roberts, Jesse D
Yeah. Homesite is basically ColdFusion repackaged. It has a few different features, but it is NOT wysiwyg. If you're looking for simple editor besides FrontPage, you could of course use either the Composer part of Netscape, or Front Page express. If you don't like that option, what's wrong