A way to NOT send empty form fields

2002-10-13 Thread Stephen Kellogg
. This would help reduce my processing time on the next page as I would have fewer fields to process. The processing times are manageable now just looking for ways to improve them. Thanks Stephen Stephen Kellogg CC Intelligent Solutions, Inc. 3301 Woman's Club Drive, Suite 150 Raleigh, North Carolina

RE: A way to NOT send empty form fields

2002-10-13 Thread Stephen Kellogg
. Thanks Stephen Stephen Kellogg CC Intelligent Solutions, Inc. 3301 Woman's Club Drive, Suite 150 Raleigh, North Carolina 27612 (336) 260-7308 Cell (best number to use) (919) 785-9655 Office (919) 785-0360 Fax email: mailto:[EMAIL PROTECTED] www.CCIntelligentSolutions.com

RE: Default Julian date in SQL Server

2002-10-11 Thread Stephen Kellogg
Neil, FYI you can also store it as an normal date and then switch it in the CF code with: dayofyear(date) This is the calendar Julian date vs. the true Julian date. Also, HOF has a CF-Server and a SQL list where you might get better responses for these questions. HTH Stephen -Original

RE: Fastest way to convert a csv file to cf array/query?

2002-10-05 Thread Stephen Kellogg
This might be a long shot but if Text is the actual name of your datasource you might try to name it something else. Text MIGHT be a reserved word and somehow messing the whole thing up. HTH Stephen -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04,

RE: ArcIMS and Cold Fusion

2002-09-20 Thread Stephen Kellogg
Y'all are showing the typical ESRI and ESRI User there can be only one... stance. HOWEVER, no idea what you mean but AutoCAD's not GIS. Note that I didn't mention AutoCAD, as it is not GIS, I mentioned AutoDesk's MAPGUIDE product. For many years it actually bundled CF with it. That's how I got

RE: ArcIMS and Cold Fusion

2002-09-19 Thread Stephen Kellogg
As an alternative to arcIMS you might take a look at AutoDesk's MapGuide product: http://usa.autodesk.com/adsk/section/0,,939487-123112,00.html Below is a site I did 3 or more years ago using MapGuide and CF. The site hasn't been fully maintained (I don't work there any more :-) and therefore

RE: Printing : Revisited

2002-07-23 Thread Stephen Kellogg
Dan, Are you use an IE only solution? I have done a similar app where the person could hit the server (via cf pages ;-) input some data (eg event, date etc.). When they submitted the form, the action page would automatically print registration forms (with dynamic info like user name, user stats

RE: OT javascript addition

2002-07-23 Thread Stephen Kellogg
Tim, try adding () around the addition part like so: if ((document.newBillingInfo.SCEPbilledAmount.value + document.newBillingInfo.SCEPpenaltyAmount.value + document.newBillingInfo.SCEPdelinquentAmount.value) != document.newBillingInfo.SCEPtotalAmount.value) This should force the addition to

RE: OT javascript addition

2002-07-23 Thread Stephen Kellogg
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 2:30 PM To: CF-Talk Subject: RE: OT javascript addition Thanks Stephen.. I tried that earlier but that only concatenates it -Original Message- From: Stephen Kellogg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 10:08 AM To: CF

RE: CF_Importing_into_Act

2001-10-04 Thread Stephen Kellogg
Another shot in the dark. Have you tried the MS DBase odbc driver? Or, can you create a linked data source to the Act.dbf file thru something like MS Access. Then use the ODBC for Access? Obviously, much testing would need to be done before using this in a production env. Not the most efficient

RE: Print without bringing print dialogue?

2001-07-10 Thread Stephen Kellogg
Here's my .02cents worth. I will point out that (at least in IE 5.5 not sure about NS or lower versions of IE) you can print directly to someone's printer when a page loads, without popping up a dialog box and without them having to click on anything. I have been doing this now for sometime

RE: CGI.variables list

2001-07-09 Thread Stephen Kellogg
Michael, In admin under miscellaneous click on debugging, put a check in the third box down which says Show variables. Add your ip and don't forget to hit apply. Run a .cfm page in your browser and look at the bottom of the page. You will see the following: Parameters CGI Variables:

RE: CFMail problems in CF 5

2001-07-06 Thread Stephen Kellogg
Michael, this is a problem that surfaced in 4.5.1 and is talked about here http://www.allaire.com/Handlers/index.cfm?ID=15821Method=Full I would have thought it would be fixed in 5.0 so it may not be the same problem but then again... At least it may point you in the right direction. HTH

To Join or not to join that is the question- and if so how

2001-05-25 Thread Stephen Kellogg
and an intCandIndYrs of both 2 and 3 which of course doesn't exist so no records show. How can I get around this? Thanks for your help Stephen Kellogg [EMAIL PROTECTED] Sales Recruitment Solutions, Inc. www.mysalescareer.com ~~ Structure your ColdFusion code

RE: To Join or not to join that is the question- and if so how

2001-05-25 Thread Stephen Kellogg
: Stephen Kellogg [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 11:31 AM To: CF-Talk Subject: To Join or not to join that is the question- and if so how Hi all, I hope everyone's having a great Friday. I have several tables. Table 1 intCandidateID intB2bSalesIDFK bunch of fields Table 2

RE: To Join or not to join that is the question- and if so how

2001-05-25 Thread Stephen Kellogg
, but you get the idea. Good luck :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Stephen Kellogg [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 2:05 PM To: CF-Talk Subject: RE: To Join or not to join that is the question- and if so how

RE: Printer ESCAPE codes

2001-05-06 Thread Stephen Kellogg
Not sure if it will have what you're looking for but take a look at the following link (watch the URL wrap): http://msdn.microsoft.com/workshop/browser/hosting/printpreview/beyondprintp review.asp#beyondprintpreview_topic6 I used to do this by running a batch file that either copied a file to

RE: Unusual Results, help

2001-05-03 Thread Stephen Kellogg
If I understand what you're saying, I had something similar to this a little while ago. Don't pull all your hair out ;-) The only way I found to work around my loop within a loop problem was to set a variable in the outer loop = to the value I needed to use in the inner loop. Then use this new

RE: RE: Password Encrypted?

2001-05-02 Thread Stephen Kellogg
Take a look at the following: watch for URL wrap http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34727C-2830-11D4-AA 9700508B94F380method=Full HTH Stephen -Original Message- From: Christine Kelley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 6:52 PM To: CF-Talk

RE: CF-Partners List

2001-04-30 Thread Stephen Kellogg
Dave, if you go to signup for the list you will see the following text: CF-Partners is a mailing list dealing with the relationship between the ColdFusion community and MacroMedia. We are all partners in the growth of ColdFusion and this is a central list for communication between these two

RE: CF-Partners List

2001-04-30 Thread Stephen Kellogg
Only 6000? Your post made me take a look at my CF-Talk folder. I've got over 12,000 and that's after archiving almost 5000 to a local DB. Guess you're right, it's time to archive again. Thx Stephen -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001

RE: Examples of Password protection

2001-03-11 Thread Stephen Kellogg
I agree with Dave. It sounded like your last explanation was headed towards one password for these 20 users another for these 5 etc. If that's not what you were saying, I apologies for the misunderstanding. If that is where you were headed, I would say that this is one of those "design for the

RE: CFMAIL problems on 4.51 SP 2

2001-03-07 Thread Stephen Kellogg
Bud, see if any of this applies to you: http://www.allaire.com/Handlers/index.cfm?ID=15821Method=Full HTH Stephen -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 6:08 PM To: CF-Talk Subject: CFMAIL problems on 4.51 SP 2 How can this possibly

RE: IIS Permissions/Rights Problem Accessing cfm templates on one site

2001-03-07 Thread Stephen Kellogg
Paul, kinda off the wall but... is there an application.cfm file in the directory (or up the directory tree)? If so what's it doing? Did you set scripting for that directory in IIS? Just some quick thoughts Stephen -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent:

RE: CFMAIL problems on 4.51 SP 2

2001-03-07 Thread Stephen Kellogg
: Wednesday, March 07, 2001 11:08 PM To: CF-Talk Subject: RE: CFMAIL problems on 4.51 SP 2 On 3/7/01, Stephen Kellogg penned: Bud, see if any of this applies to you: http://www.allaire.com/Handlers/index.cfm?ID=15821Method=Full Yes, actually it did. I didn't replace the dll because the one installed

RE: Help on CF bad_alloc error

2001-03-07 Thread Stephen Kellogg
Arden, try increasing the Page Timeout in the ODBC connection in CF Admin from 600 (the default) to 1200. HTH Stephen -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 12:07 AM To: CF-Talk Subject: Help on CF bad_alloc error Helpful hints

RE: unsorted QueryName.ColumnList?

2001-03-02 Thread Stephen Kellogg
cfx_QueryColumns http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347299-2830-11D4-AA 9700508B94F380method=Full That link was posted previously to a similar question... I haven't used it and am not sure if it will help. Stephen -Original Message- From: Boskovic, Ante

RE: Advanced Database Search Form

2001-03-02 Thread Stephen Kellogg
Try using one of the following in your query statements: 1. Where tableField1 = '#form.variable#' 2. Where tableField1 LIKE '#form.variable#%' The % is a "wild card" so bu would return anything that started with bu, ie bulb, bulbous but not xbulb 3. Get one of Uncle Ben's (or someone's) books

RE: How to remove a server data source name from the CFStudio Remote window?

2001-03-01 Thread Stephen Kellogg
If your asking about the data source itself, you'll have to use admin if your talking about the remote server, you can do that through Windows Explorer. Right click on the remote server and look at the options. HTH Stephen -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]]

RE: Stumped !

2001-02-28 Thread Stephen Kellogg
I think this is what you were looking for. I took out lots of code because I also do server side validation and if it fails, I color the "failed" info yada yada yada... On the for page: --- cfloop query="industry" cfif #isdefined("form.indExp#intIndustryID#")#

RE: SQL + time stamp

2001-02-28 Thread Stephen Kellogg
Some quick thoughts (not knowing your full situation) is to do a query looking for a match between say 4:10 and 4:20 (or what ever range would wrap the first entry without including the last entry from the previous e-mail). Get the unique id for that record, query the db again for the next 3

RE: Validating Checkboxes

2001-02-23 Thread Stephen Kellogg
The value is held in the value= portion of the cfinput tag and can be referenced after a submit as form.name where name is the name= portion of the cfinput tag. cfinput checked=#chk# type="Checkbox" NAME="location" VALUE=#intLocationID# #strLocationName#, #strStateAbvrIDFK# If you have several

RE: CFPop

2001-02-15 Thread Stephen Kellogg
This may help cfoutput query=#dataSource# cfset newString = Replace(emailBodyText, "#CHR(13)#", "br", "ALL") #newString# /cfoutput Stephen -Original Message- From: Michael Gribbin [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 2:54 AM To: CF-Talk Subject: CFPop Hi gang,

RE: how to launch a windows app from a web page?

2001-02-15 Thread Stephen Kellogg
One thing I've done is to create a link to a file. When the link is clicked, it will launch the associated file. I have done this with .csv and .xls not sure if this helps or if it works with apps other than m$. I haven't tried it. You could possibly open an empty document. HTH Stephen

RE: HumanClick

2001-02-15 Thread Stephen Kellogg
http://www.humanclick.com -Original Message- From: Hong, Tammy T [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 2:46 PM To: CF-Talk Subject: RE: HumanClick May I ask what HumanClick is?? T -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent:

RE: CFIF Conditional Code.

2001-02-14 Thread Stephen Kellogg
two thoughts 1. What about checking to see if they have already voted during the voting process and put up a message saying they have already voted. You could then show them their current vote and ask if they want to change it. 2. If you don't do option 1, can you use a SELECT DISTINCT in your

RE: Form validation without alert boxes

2001-02-12 Thread Stephen Kellogg
This may give you a simple starting point. Give me a shout off list if you want an example and some more help. http://hotwired.lycos.com/webmonkey/99/17/index1a.html?tw=programming -Original Message- From: James Birchler [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 12:45 PM

RE: Form validation without alert boxes

2001-02-12 Thread Stephen Kellogg
Not sure of your particular reasoning for staying away from alert boxes but... some don't like having 20 separate alert boxes (one for each field validated). If that's the reasoning, you can call a validation routine during the submit process that runs validation on all the fields and builds one

RE: User history..where are users coming from?

2001-02-09 Thread Stephen Kellogg
Tony wrote: I want to be able to ensure that visitors to certain parts of our site are actually arriving there by browsing our site. We have outside vendors linking to product manuals and downloading them from their site. When this happens I would like to bounce them to our home page and deter

RE: User history..where are users coming from?

2001-02-09 Thread Stephen Kellogg
Tony wrote: I want to be able to ensure that visitors to certain parts of our site are actually arriving there by browsing our site. We have outside vendors linking to product manuals and downloading them from their site. When this happens I would like to bounce them to our home page and deter

RE: CFFILE :: Multiple image uploads?

2001-02-08 Thread Stephen Kellogg
What about asking the user how many images they want to upload with the default of one. If they put in 7, reload the page with a loop for the input box(es) to dynamically generate 7 input boxes. Just a thought... Stephen -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]]

RE: case sensitivity in stored procedures

2001-01-24 Thread Stephen Kellogg
If you're talking about passwords, you may consider using CFX_HASH to create the passwords. Its hashes are case sensitive so "A" is not the same as "a" and it would probably end up being more secure. HTH Stephen -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent:

RE: stop reposting of form data

2001-01-19 Thread Stephen Kellogg
Just a quick thought, I'm sure I'll be told the pit falls if it's a bad idea but... Couldn't you, on successful insert etc., set a session or application variable? The existence of or value of this variable could be checked at the beginning of the action page and if isDefined or value =

RE: Invalid Token in IsDefined

2001-01-15 Thread Stephen Kellogg
If this is a actual copy of your code, you have cfelseif spelled incorrectly (cfeSLeif). Hope that's it... Stephen -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 10:17 AM To: CF-Talk Subject: Invalid Token in IsDefined OK .. I'm

RE: Dynamic state color

2001-01-15 Thread Stephen Kellogg
Autodesk makes a product called Mapguide. It connects to a DB and dynamically (thematically) colors the states (counties, symbols, predefined shapes etc.) based on data read from the DB. It can get expensive but, depending on what you want it for, it's worth it. It's made for high end, vector

RE: What Does OT Stand For?

2001-01-12 Thread Stephen Kellogg
Off Topic I know this has been answered a couple of times but... www.acronymfinder.com might be a useful resource. There's also www.dictionary.com etc... ps as an example... from acronymfinder ~~ Structure your ColdFusion code with Fusebox. Get

RE: CFContent to a network share

2001-01-12 Thread Stephen Kellogg
does it have to do with the ppp in application (appplication). Hope it helps Stephen -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 12:12 PM To: CF-Talk Subject: CFContent to a network share I have one server running CF which accesses