Spaces

2000-07-07 Thread Parker, Kevin
I'm trying to strip blank spaces from inside a string but am having no luck. I tried this but no joy. #Replace(CompanyName, " ", "")# Any clues please? Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61

Re: cfparam depreciated?

2000-07-07 Thread paul smith
And the better replacement for CFPARAM is? best, paul At 10:14 AM 7/6/00 -0400, you wrote: In the case of the term being discussed, a better replacement has been provided. -- Archives:

RE: USPS calculator?

2000-07-07 Thread Mike Sheldon
Try CF_InterShipper http://www.desertraven.com/intershipper.php InterShipper provides quotes for several shipping companies, including UPS, USPS, FedEx, etc... Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request

Pay for Chat

2000-07-07 Thread Chris Montgomery
Howdy, A client wants to add chat to her site (done in CF). There needs to be a "pay before you participate" system set up for both moderated chats and private chats (she's a psychologist). Right now, we're looking at using a third party chat service to do this. I can handle the payment

OT: VMware and CF Studio

2000-07-07 Thread stäs
Hello, Has anybody tried running CF Studio with VMware under Linux host. I have a new Dell workstation pre-loaded with Linux, and I am deciding between dual-boot vs. buying VMWare. Thanks. -- Archives:

file security/authentication using CF in a novell environment

2000-07-07 Thread Kurt Lieber
I have a client who has a Novell environment. I, myself, have very little exposure to Novell. They would like to assign file-level permissions to various files on their Cold Fusion/IIS/NT 4.0 server. In NT, this is no problem, I simply set up the ACLs on the specific files and the clients can

Re: Why does blank dates default to 1899-12-30?

2000-07-07 Thread Michael Smith
--106E292EBC4B30F10F8DC269 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I had the same problem with FoxPro 2.0 data. The workaround I came up with was to not display dates older than 1901: cfif year(followup) gt

Re: forums.allaire.com

2000-07-07 Thread Paige Chandler
Hello, Yes, I also cannot connect to Allair forums. The site mentioned that part of the site might be unavailable until after the July 4th weekend/holiday due to a loacation move. Have a nice day. Regards, Paige - Original Message - From: lsellers [EMAIL PROTECTED] To: [EMAIL

RE: Session Management

2000-07-07 Thread Peter Tilbrook
eg: cfcookie name="whatever" expires="Now()" I think :) -Original Message- From: Steve DeWitt [mailto:[EMAIL PROTECTED]] Sent: Friday, 7 July 2000 8:43 AM To: '[EMAIL PROTECTED]' Subject: RE: Session Management expire the cookie immediately -Original Message- From: Matt

RE: forums.allaire.com

2000-07-07 Thread Peter Tilbrook
Allaire have moved/in the process of moving so certain systems might be affected. This was announced on their home page. I know that beta.allaire.com was down yesterday. Hopefully things will improve as they bring their other systems online. -Original Message- From: lsellers

Newbie: SELECT Question

2000-07-07 Thread Olson, Kelly
Is it possible to move several fields form a form select. I have a database of two fields: CatagoryID and CatagoryDesc. I am building a select as follows: SELECT NAME="CatagoryID" SIZE="7" CFOUTPUT QUERY="GetCatagory" option value='#CatagoryID#' #CatagoryDescription# #CatagoryID#

Query within a select

2000-07-07 Thread Olson, Kelly
Is something like this possible: SELECT NAME="ScenarioDetailID" SIZE="7" CFOUTPUT QUERY="GetCatagoryLIST" option value=#ScenarioDetailID# #ScenarioID# CFOUTPUT QUERY="GetCompany"#CompanyName# /CFOUTPUT /CFOUTPUT /SELECT Or better yet, how could something like this be done, where you

Re: REPOST: Submitting a page with a cftree

2000-07-07 Thread David Shadovitz
It didn't slip by, it's just not clear what you want. Double-clicking a CFTREEITEM isn't supposed to submit the form. The form should have a submit button. If you want some action to occur without submitting the form, you can set the CFTREEITEM's HREF attribute. If double-clicking did in fact

Re: Session Management

2000-07-07 Thread rkeniger
Is it possible to terminate a session when a user closes their browser?? Its easy when a user logs out, or the session times out, it would be nice if you could also do it when the browser is closed. Not really, AFAIK. There is no javascript "onQuit" event or similar - although there is an

Re: forums.allaire.com

2000-07-07 Thread Tom Nunamaker
I've noticed the same problem Tom lsellers wrote: Anyone else have trouble with the forums? The last few days it keeps reseting the connection before it can get more than a few threads down the list. --min --

RE: Session Management

2000-07-07 Thread rkeniger
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

CFUN-2K on prnewswire.com

2000-07-07 Thread Michael Smith
This is a multi-part message in MIME format. --93D5E86DF814213B2559B1C7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit FYI CFUN-2K is on prnewswire.com... http://www.prnewswire.com/cgi-bin/stories.pl?ACCT=104STORY=/www/story/06-28-2000/0001254835EDATE=

OT: How hard is it to set up a SQL7 data exchange?

2000-07-07 Thread Michael Kear
In the next few weeks I'm going to have to set up a data exchange with another organisation, whereby our SQL7 databases will connect daily and send tables to each other. I know this is possible, and reliable, but I've never done it. Is this something I can learn how to do quickly and undertake

RE: still not working

2000-07-07 Thread James
It looks as though you are missing a single quote around the #emailaddress# and a comma after #phone #. Try this for the first query. cfquery Datasource="vhc" insert into memberlist(firstname,lastname, boat, boatyear, address, city, phone, state, zip, emailaddress, ) values(

CFloop question? Can't get desired output

2000-07-07 Thread Olson, Kelly
--02EDDFCBC443DB118DB040CB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sorry about all the detail. I just thought it would make it easy to explain my problem. I am doin g two queries in a loop 1 to get main items and one to get item details. I am

RE: Rounding of numbers

2000-07-07 Thread Stewart McGowan
Thanks guys, got it sorted, (and purchased a whole load of pain killers) Stew -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: 06 July 2000 22:01 To: [EMAIL PROTECTED] Subject: RE: Rounding of numbers You can use the ROUND() function. (Go figure) There are many

RE: International Search Pack for Verity

2000-07-07 Thread Francisco Montes; Spain on Line
Still sounds like it is not worth the money then... :-) Hmmm -Mensaje original- De: Frank Mamone [EMAIL PROTECTED] Para: [EMAIL PROTECTED] [EMAIL PROTECTED] Fecha: jueves 6 de julio de 2000 23:31 Asunto: Re: International Search Pack for Verity Basically, it handles special

Re: Error:No Error ....with CFFILE

2000-07-07 Thread mcardini
Hi to all ML, Dear friend, you wrote: I don't think that CF lets you (and quite rightly) interact with a users desktop for security reasons. This is the reason why Internet providers don't allow using CFFILE tag on their servers(in the Administrator disabling CFFILE tag) but I am using

Re: cf 4.5 cfmail problems

2000-07-07 Thread Erki Esken
I have an email being sent out with cfmail on a coldfusion 4.5 server. The content is being pulled from a database. The copy in the database is perfect. However once the email is received by the user the copy has problems. This is the copy as it sites in the database: "security at the

RE: How hard is it to set up a SQL7 data exchange?

2000-07-07 Thread Ben Lowndes @ CW
What you are talking about is Replication. A search of the SQL books online for the keyword replication should give you plenty to read up on. Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Kear Sent: 07 July 2000 07:42 To: [EMAIL PROTECTED]

Re: Query within a select

2000-07-07 Thread Dick Applebaum
It is done within the SQL query itself, before the select is generated by the program... Something like CFQUERY NAME=MyQuery... SELECT Salesman.NameAS SName, , Salesan. SalesmanID AS SID , Vendor.Name AS VName FROM

Tell a friend

2000-07-07 Thread Smad
How do I create a "tell a friend" feature in CF? TIA Smad -- Archives:

RE: controlling print page break

2000-07-07 Thread Philip Arnold - ASP
Just tried table width="600" align="center" style="page-break-inside: never" That seems to have no affect. Just so as you know, CSS2 definition of page-break-inside has values of either "auto" or "avoid" BUT - CSS2 isn't in most of the current browsers, only CSS1. I think IE5.5 is meant to

MOVCFUG

2000-07-07 Thread Dave Hannum
Just a reminder to any who are in SE Ohio and Western West Virginia. The inaugural meeting of the Mid-Ohio Valley ColdFusion Users Group will be Thursday, July 20 at 6:30pm. The location is 3 Presidents Street (Ohio University Computer Services Center) Room 114, Athens, OH 45701. Admission is

Re: [talk-cf] MOVCFUG

2000-07-07 Thread Dave Hannum
P.S. - You can sign up at our web site www.movcfug.org - see a map there too! 8-) Dave - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: talk-cf [EMAIL PROTECTED]; CF-Talk [EMAIL PROTECTED] Sent: Friday, July 07, 2000 7:31 AM Subject: [talk-cf] MOVCFUG Just a reminder to

RE: oracle timestamps

2000-07-07 Thread mherbene
I would guess that the default Oracle date format on the two machines is set differently. Unfortunately a cursory search did not turn up info on how/where this is set. -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 6:56 PM To: Cf-Talk

RE: file security/authentication using CF in a novell environment

2000-07-07 Thread mherbene
Short answer: Possibly, but not trivial. Long answer: "Gateway Services for Netware" (GSNW) is the MS-approved way of letting an application on an NT server work with a Netware file server. The expected use of GSNW works more or less like this: 1) set up an account on the Netware server or in

Re: Query within a select

2000-07-07 Thread netman
I would usually place the Query at the top of the HTML page and then just place the output in the select area. example: This goes above header--- cfquery name="categorylisting" datasource="business" SELECT Category FROM tbl_category /cfquery This is my select form statement---

RE: Spaces

2000-07-07 Thread Larry Juncker
Kevin; I believe that you have to type all inside your last pair of quotes in order to replace ALL of the spaces. Your code should like this: #Replace(CompanyName, " ", "ALL")# Hope this helps H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group

RE: Spaces

2000-07-07 Thread Melanie Gann
No I had this same problem even with the "ALL". I'm stumped to. Regards, Melanie At 07:41 AM 7/7/00 -0500, Larry Juncker wrote: Kevin; I believe that you have to type all inside your last pair of quotes in order to replace ALL of the spaces. Your code should like this:

Re: oracle timestamps

2000-07-07 Thread Scott Williams
Try SYSDATE. Works for me. Mike Amburn wrote: does anyone know why oracle would not accept timestamps? when i try to insert Now() into a date/time field, oracle returns with the error "illegal character". FYI, Now() outputs a timestamp like: {ts '/mm/dd hh24/mi/ss'} stranger

RE: Spaces

2000-07-07 Thread Conrad, Christopher
Should be cfset CompanyName = Replace(CompanyName, " ", "", "ALL") right ? Chris Christopher Conrad Victoria's Secret Catalogue http://www.VictoriasSecret.com Senior.Programmer.Analyst 614.337.5653 [EMAIL PROTECTED] -Original Message- From: Melanie Gann [SMTP:[EMAIL PROTECTED]]

Re: Upgrading CF server 4.0 to 4.5.1 on Solaris

2000-07-07 Thread James Taavon
In case you dont know, I found this out at last week's CFUG in Baltimore, CF versions 4.x and CF 4.5 utilize RAM differently. Previous versions of CF (4.x) took the RAM it needed at the time to perform the operation and then released it. With 4.5.x and up CF holds on to RAM and keeps grabbing

Re: line break as delimiter

2000-07-07 Thread Brandon Whitaker
-Original Message- From: Chris Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, July 06, 2000 5:06 PM Subject: RE: line break as delimiter You'll need #CHR(10)# as your delimiter. Why incur the extra overhead of converting the list to an array, and then

RE: Spaces

2000-07-07 Thread Chris Terrebonne
Replace(CompanyName, " ", "", "ALL") Specify the space, then the null (""), then ALL. Chris -- Original Message From: "Larry Juncker"[EMAIL PROTECTED] Subject: RE: Spaces Date: Fri, 7 Jul 2000 07:41:01 -0500 Kevin; I believe that you have to type

Re: line break as delimiter

2000-07-07 Thread Brandon Whitaker
You'll need #CHR(10)# as your delimiter. It's in there. Look closely. Why incur the extra overhead of converting the list to an array, and then looping over the array? I do it because the NOAA historical data returns I commonly work with are comma-separated columns of variables. Break into

Re: Session Management

2000-07-07 Thread Michael P. Morris
From the teamallaire tutuorials. http://www.teamallaire.com/tutorials/ How do I kill all session variables when a user closes their browser? The Situation: You want to make sure that when a user closes their browser, any session variables that have been established die. The Solution: Place this

RE: RE: Session Management

2000-07-07 Thread joeug
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: sssssssssssssssssssssssssssssssssssssssssssssssssssssss

2000-07-07 Thread Chris Evans
CFSET CutLength=30 CFSET MyString="sss" CFLOOP Condition="Len(MyString) GT CutLength" CFOUTPUT#Left(MYString,CutLength)#/CFOUTPUT CFSET MyString = Right(MyString,Len(MyString)-CutLength)) /CFLOOP Or something like that. Chris

Re: Why does blank dates default to 1899-12-30?

2000-07-07 Thread Paige Chandler
Hi Michael, Thanks for the suggestion. This is very bad news. My app displays the status of a list of insurance policies for a particular piece of property: Date Issued, Date Canceled, Date Expired. Most of the time the last two are blank. And there may be from 1 to 9 policies listed for a

Re: REPOST: Submitting a page with a cftree

2000-07-07 Thread David Shadovitz
Michael, Can you base your test on the existence of CFTREEITEMKEY rather than the value of HTTP_REFERER? That is, use cfif isDefined("CFTREEITEMKEY") rather than Cfif FindNocase("finduserby",#HTTP.HTTP_REFERER#) NEQ 0 -David On Fri, 7 Jul 2000 11:57:27 +0100 Michael O Reilly [EMAIL

RE: DB normalization rules and multi-select

2000-07-07 Thread Philip Arnold - ASP
1. Create a list of current categories assigned to the locale 2. query all the categories 3. output the query, and select the category if its in the list cfoutput query="GetCategories" cfif CurrentCategories contains GetCategories.Category_ID option value="#Category_ID#"

Re: Pay for Chat

2000-07-07 Thread Billy Cravens
Probably the best solution considering your client's requirements would be to stick any chat room (take your pick) software in it's own directory on the server, and protect that directory (either through cf based system, or os security). Seems a little too simple, but it should fit her needs.

contained in a list

2000-07-07 Thread Gilles Ratte
I need know if a number is one of a list item. let me explain let's say.. mynumber = 2 ans mylist = 2,67,34,52 I thought this would do .. cfif #listcontains(mylist, mynumber)# is 0 ... cfelse ... /cfif but it does not act like I want ... It compare the same whay as of strings and will find 2

Re: oracle timestamps

2000-07-07 Thread Jennifer
At 06:56 PM 7/6/00 -0400, you wrote: does anyone know why oracle would not accept timestamps? when i try to insert Now() into a date/time field, oracle returns with the error "illegal character". FYI, Now() outputs a timestamp like: {ts '/mm/dd hh24/mi/ss'} stranger yet... all my

Is this an MDAC problem?

2000-07-07 Thread KungFusion
I just installed W2K IIS5 CF4.5.1 on a server and I was testing a current asp app. running on a NT4 IIS4 CF 4.0.1 server and I am getting this error: Error Type: (0x800401F9) Error in the DLL /cowpersontack/Default.asp, line 16 Line 16 is a ASP database connect.. the database is registered in

Know where I can find Chr(*) definitions?

2000-07-07 Thread Ric Smith
Anyone know of anywhere I can find the definition for the Chr(*) stuff online? Only ones I know are Chr(10) and Chr(13). Just curious, thanks. Ric Smith -- Archives:

RE: Session Management

2000-07-07 Thread Dave Watts
expire the cookie immediately ... eg: cfcookie name="whatever" expires="Now()" I think :) You can create "session cookies", which will expire when the browser is closed, by leaving off the EXPIRES parameter: cfcookie name="foo" value="fooval" Dave Watts, CTO, Fig Leaf Software

Re: Newbie: SELECT Question

2000-07-07 Thread Jennifer
At 12:57 AM 7/7/00 -0400, you wrote: Is it possible to move several fields form a form select. I have a database of two fields: CatagoryID and CatagoryDesc. I am building a select as follows: SELECT NAME="CatagoryID" SIZE="7" CFOUTPUT QUERY="GetCatagory" option value='#CatagoryID#'

Re: onSessionEnd.cfm documentation

2000-07-07 Thread TDesimone
Thanks for the info ... but template 'onSessionEnd.cfm' was not listed. Does this mean the template is not an autoexecuted template as is 'onRequestEnd.cfm'? Or is there another source for information? Thanks. "Michael Dinowitz" [EMAIL PROTECTED] on 07/05/2000 05:55:35 PM Please respond to

RE: Session Management

2000-07-07 Thread Matt Rodosky
Thanks Michael, great resource. -Original Message- From: Michael P. Morris [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 8:03 AM To: [EMAIL PROTECTED] Subject: Re: Session Management From the teamallaire tutuorials. http://www.teamallaire.com/tutorials/ How do I kill all

RE: file security/authentication using CF in a novell environment

2000-07-07 Thread Steve Bernard
I have used CF's LDAP capabilities with NDS 5.x. It has an optional LDAP compliant "gateway" that you can use to authenticate against NDS. I never checked if the client is considered to be logged into the tree using this method. I was only using the functionality to authenticate clients. The

RE: When should I use CFLOCK?

2000-07-07 Thread Tom Nunamaker
Ben, After reading the Allaire KB article on locking, I put CFLOCK's around all instances of any session or server variables. The one place that seems a bit muddy is if the read is within a CFIF statement. I put the lock around the entire CFIF but is that required? I implied that it was from

Re: CFloop question? Can't get desired output

2000-07-07 Thread Jennifer
At 03:51 AM 7/7/00 -0400, you wrote: Sorry about all the detail. I just thought it would make it easy to explain my problem. Detail is our friend. I am doin g two queries in a loop 1 to get main items and one to get item details. I am trying to get them to match by the two fields

Re: Tell a friend

2000-07-07 Thread Jennifer
At 01:00 PM 7/7/00 +0300, you wrote: How do I create a "tell a friend" feature in CF? TIA Somebody's got a bad memory. ;) I pasted this from John Westerlund's response to this question: The link should go to a self-posting form with CFMAIL, body = #cgi.http_referrer# (or whichever

Forms and Foreign Languages

2000-07-07 Thread Jenny Anderson
Hello: This might be slightly off-topic, but I am hoping someone can help me out with this one. I need to create a Cold Fusion form where the user enters a greek term in one box and then enters the definition in another. When they click on submit it puts this record in the database. What

Re: RE: Session Management

2000-07-07 Thread Erki Esken
StructClear(Session) has never worked for me on CF4.5, just messes up the session. Any ideas? See Allaire Knowledge Base article #14143: http://www.allaire.com/handlers/index.cfm?ID=14143Method=Full Erki --

RE: REPOST: Submitting a page with a cftree

2000-07-07 Thread Michael O Reilly
David, I'll give it a try, but I'm not expecting it to work, because I think that when I click BACK from the DLL I go back to a URL with CFTREEITEMKEY=x in it. It must exist because input type="hidden" name="id" value="#CFTREEITEMKEY#" gets set again and the form is submitted. Regards Michael

RE: Allaire Certification Program

2000-07-07 Thread Steve DeWitt
I have done it and the questions are straightforward with a mix of html, sql, and cfml questions. If you go to http://www.allaire.com/certification you can get a rough idea of what the exam will cover and it is pretty acurate. Steve DeWitt -Original Message- From: Reynolds, Adam

WishList: ListServ interaction with Cold Fusion

2000-07-07 Thread Eric Dawson
- I need a method of handling listserv functions. - I need something that I can easily integrate with Cold Fusion driven sites. - ListBot etc. What I would like to be able to do is create Cold Fusion queries that get passed to the mail server, and the campaign is executed. I want to have the

Re: Pay for Chat

2000-07-07 Thread Dave Hannum
Yea, seems to me that you could have a shopping cart that processes payment, and in the process, allow them to pick a user name and password. Then, incorporate the chat app into a cf script that utilizes the username and password to access it. Dave - Original Message - From: Billy

Re: Why does blank dates default to 1899-12-30?

2000-07-07 Thread Jim McAtee
-Original Message- From: Paige Chandler [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, July 07, 2000 9:10 AM Subject: Re: Why does blank dates default to 1899-12-30? Hi Michael, Thanks for the suggestion. This is very bad news. My app displays the status of a

MySql ODBC Driver

2000-07-07 Thread Mike Sullivan
All, I am testing MySql (shareware-3.22.30) and MyODBC (2.50.31) on a win-95 development workstation with CF studio 4.5 and the single user enterprise server along with apache's win32 (1.3.12) http server. Q1. Has anyone had experience with "manually" installing the CF server since it doesn't

RE: contained in a list

2000-07-07 Thread Brian Peddle
cfif listfindnocase('#mylist#','#mynumber#',',') NEQ 0 Not in list /cfif -Original Message- From: Gilles Ratte [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 10:52 AM To: 'cftalk' Subject: contained in a list I need know if a number is one of a list item. let me explain let's

Re: contained in a list

2000-07-07 Thread Dick Applebaum
Try ListFind At 10:51 AM -0400 7/7/2000, Gilles Ratte wrote: I need know if a number is one of a list item. let me explain let's say.. mynumber = 2 ans mylist = 2,67,34,52 I thought this would do .. cfif #listcontains(mylist, mynumber)# is 0 .. cfelse .. /cfif but it does not act like I

RE: Slightly OT:Single Server vs. Cluster Comparison

2000-07-07 Thread paul smith
Anyone ever implement a SQL Server cluster that's controlled by CF? That is, CF can determine if a SQL Server is down and direct queries away from the failed server. best, paul At 06:20 PM 7/6/00 -0700, you wrote: Your assessment is essentially correct. In my opinion, every serious

RE: escaping apostrophes for database insertion.

2000-07-07 Thread James
Sean, Try using the PreserveSingleQuotes() function. cfquery name="myquery" ... insert into mytable(MESSAGE_MEM) values('#trim(PreserveSingleQuotes(Message))#') /cfquery -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 6:18 PM To:

Oracle on Windows?

2000-07-07 Thread Dana Larose
Are their Oracle drivers for CF 4.5.1 Windows? (I client asked me this morning, the chart I found on Allaire's website says their isn't, but I don't know how current it is) Dana Larose Database Design www.cdnwebdesign.com

lists and variable names

2000-07-07 Thread Adrian Cesana
Im having a problem linking a variable name to a list name, and cant figure out a way around this. Basically I have a List of Cities and each City in the Cities List has its own List. I have 2 loops, the outer loop processes one City at a time and the inner loop process's the list for the

RE: Why does blank dates default to 1899-12-30?

2000-07-07 Thread Adrian Cesana
Ive run into this problem as well (MSSQL7). I found that my INSERTS were placing a blank into the date field and it would result in this type of a date as a default. I changed my code check for the empty date fields and NOT insert anything if blank. I then did an UPDATE for all the bogus dates

SQL Question: Select a list of most recent records from a table that stores User Histories,for ALL users.

2000-07-07 Thread Angél Stewart
Okies you SQL gurus out there :-) I have a table called Employee Info. It contains Employee ID, Department ID, and Effective Date as well as other things. ANyways, I am allowing the user to select a list of employees by Department Date, from this table. However, I only want to return ONE

Re: Last post: How do I Optimize Win 2000 (IIS) for Warp speed with C old

2000-07-07 Thread Judah McAuley
At 04:47 PM 7/6/2000 -0400, you wrote: On Win2000, be forewarned that you'll experience about a 17-20% performance degradation over NT 4.0. This is with the ZDLabs ServerBench 4.1 CPU suite of tests in our labs. Any ideas why? I've been pondering moving some servers to W2K as I've like W2K

Re: Know where I can find Chr(*) definitions?

2000-07-07 Thread Vance_Duke
Here is one I found when I did a search at Infoseek for ASCII Character Map. http://pcscomp.com/asciitable.html Hope this helps. Vance Duke Application Developer

JavaScript and CF

2000-07-07 Thread aslam bajaria
Can someone plz let me know the best books and best website tutorials etc for learning JavaScript? Also, which versions are supported by CF and which are not? Appreciate. A.B. __ Do You Yahoo!? Send instant messages get email alerts with Yahoo!

RE: Why does blank dates default to 1899-12-30?

2000-07-07 Thread Christopher P. Maher
Paige, No reason to use CFTable. Just code the HTML for the table directly. You'll write more code but you'll have a lot more flexibility and you can format the dates any way you like. table CFLoop query="MyQuery CFoutputtrtd#DateFormat(mydate,"mm/dd/")#/td/tr/CFoutput /CFLoop

Re: Know where I can find Chr(*) definitions?

2000-07-07 Thread Brandon Whitaker
Anyone know of anywhere I can find the definition for the Chr(*) stuff online? Only ones I know are Chr(10) and Chr(13). http://www.jimprice.com/ascii-0-127.gif Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets."

RE: Tell a friend

2000-07-07 Thread Chris Montgomery
This is pretty easy to do: just create a form that when submitted emails a message to the person's "friend" using CFMail. Then link to the form (I put this at the top of every page). See an example here: http://www.sajobnet.com/misc/tell.cfm. Chris Montgomery [EMAIL PROTECTED] Web

Re:Know where I can find Chr(*) definitions?

2000-07-07 Thread Chris Terrebonne
Try here: http://www.gyldan.com/~cuspy/cuspy/escape.htm Chris -- Original Message From: "Ric Smith"[EMAIL PROTECTED] Subject: Know where I can find Chr(*) definitions? Date: Fri, 7 Jul 2000 11:13:31 -0400 Anyone know of anywhere I can find the

Re: contained in a list

2000-07-07 Thread Brandon Whitaker
let's say.. mynumber = 2 ans mylist = 2,67,34,52 cfIf listFind(myList,'2') = 0 ... You were very, very close. :) Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so

dedicated coldfusion hosting solutions

2000-07-07 Thread Chris Hamer
Does anyone know of inexpensive, reliable dedicated hosting solutions for coldfusion and ms sql server? I know about fusionfx and virtualscape, not interested in interland, but need to stay under $1500 per month Chris Hamer Web Development ImageServe, Inc. http://www.imageserve.com [EMAIL

RE: Session Management

2000-07-07 Thread Conrad, Christopher
Use the onUnload() event handler within the BODY tag to run a template with this code: CFLOOP COLLECTION="#session#" ITEM="ThisKey" CFSET tmpVar = StructDelete(session, ThisKey) /CFLOOP That will take care of it. Chris Christopher Conrad Victoria's Secret Catalogue

Search on Allaire Site

2000-07-07 Thread Dave Hannum
Has anybody tried to search the Allaire site lately. It's not a pretty site . . . . == Error Occurred While Processing Request Error Diagnostic Information Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -100

RE: Know where I can find Chr(*) definitions?

2000-07-07 Thread Brett Suwyn
http://www.acius.com/ACIDOC/V6U/V6U00057.HTM -Original Message- Anyone know of anywhere I can find the definition for the Chr(*) stuff online? Only ones I know are Chr(10) and Chr(13). -- Archives:

Re: Forms and Foreign Languages

2000-07-07 Thread Bradley Roberts
I'm just guessing, but the style attribute might work: input type="text" name="foo" value="bar" style="font-family: greekfont;" Again, just a guess, I've never done this before. Brad Roberts - Original Message - From: Jenny Anderson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

RE: Errors Errors

2000-07-07 Thread Philip Arnold - ASP
Does anyone know what a TID 756 error is? Or where I might look to find the answer? A custom cfx tag is bringing down the CF Server on a Solaris when invoked. All TID errors are Thread Errors - not very helpful as they tell you the current Thread ID in the OS. Since Threads are dynamic, you

RE: contained in a list

2000-07-07 Thread Conrad, Christopher
If I understand you - you would like to see if a value is in a list - right ? cfset myNbrToFind = "2" cfset myListToSearch = "2,3,4,5,6,52" cfif ListFind(myListToSearch,myNbrToFind, ",") !--- do something cool if I find it ... and return the element position--- cfelse !--- do nothing because

RE: LessWhiteSpace

2000-07-07 Thread Philip Arnold - ASP
I grabbed this tag off the gallery. Seems to work fine, but it still leaves half a page of blank lines above the html tag. Also, any way to know what kind of performance hit this may cause? Thanks. Erm, why not do it the proper way and remove your blank lines from the code? It takes a bit

RE: Why does blank dates default to 1899-12-30?

2000-07-07 Thread Philip Arnold - ASP
I'm "Selecting * From..." using a Visual FoxPro free table. Some of the = date fields (VFP date format) are blank. When displayed with CFTable or = CFGridCol they appear "1899-12-30". I must resolve this. Any = suggestions? TIA. OK, here's the real technical (sort of) reason that this

RE: contained in a list

2000-07-07 Thread Chris Evans
You need ListFind(mylist, mynumber). ListFind looks for a string within the list, ListContains looks for a substring. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Gilles Ratte [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 10:52 AM To: 'cftalk'

SELECT Question

2000-07-07 Thread Karl Simanonok
It's a little kludgy, but you can redo your logic on the called template a little bit and pass both variables to it at the same time like so: SELECT NAME="CatagoryID" SIZE="7" CFOUTPUT QUERY="GetCatagory" option value='#CatagoryID#_#CatagoryDescription#' #CatagoryDescription#

RE: contained in a list

2000-07-07 Thread Mark Warrick
Correct me if I'm wrong here people, but I believe that if the list contains actual numbers (like from a numeric data field) then this list function will work correctly, but if it's a text string it won't. It's been a while since I checked on this.

RE: oracle timestamps

2000-07-07 Thread Angél Stewart
Try wrapping the NOW() variable with a CREATEODBCDATETIME function. I've had a problem with Oracle throwing an error with dates unless this function was used. -Gel -- Archives:

Re: Know where I can find Chr(*) definitions?

2000-07-07 Thread GE
Hello Ric, What you are looking for is an ASCII table. A quick search should find one for you - or you could look it up in any refernce manual you have on programming (should be one in one of them). To be sure you have found what you are looking for just compare the table values of 10 and 13

CFX_CountryOfIP Tag

2000-07-07 Thread Eron Cohen
Hi Folks, I am having a problem with the CFX_CountryOfIP tag. It works for the most part, but for some reason, if someone is using IE 5.x and Windows 98 when they access our website, it doesn't seem to work properly. This doesn't make any sense to me at all. Can anyone offer any ideas or

RE: When should I use CFLOCK?

2000-07-07 Thread Raymond K. Camden
I believe it comes down to this, short and sweet: If you type session, application, or server, you use CFLOCK. Period. End of Story. So sayeth Ray, etc etc. As for your CFIF, yes, you would have: CFLOCK SCOPE="Session" TYPE="ReadOnly" TIMEOUT=30 CFIF

  1   2   >