RE: what is better varchar or char

2000-08-01 Thread Johan Coens
Hello, I allways use varchar. Not because of better performance but because of the following: If I insert into the database the value 'xyz' in a char(5) field, the value of it in the dBase will be 'xyz '. It automaticly puts spaces behind to fill up the empty space. This means you always have

How to release cached data source connection via CF template ?

2000-08-01 Thread Jablonski, Adam, MTC-CEC
Hello, the subject is THE question. I need to replace database files (Access) in automated way. In connection to this all those files have to be released (unlocked) by CF server. Does anyone of you know such a custom tag or any other solution to solve this problem? I need exactly the

Re: How to release cached data source connection via CF template ?

2000-08-01 Thread Erki Esken
Wasn't it that undocumented CFusion_Disable_DBConnections() funtion? PS: TeraTech's Tag and Function Quick Reference rocks! :) Erki Hello, the subject is THE question. I need to replace database files (Access) in automated way. In connection to this all those files have to be released

Re: How to release cached data source connection via CF template ?

2000-08-01 Thread Erki Esken
Sorry, it was CFUSION_DBCONNECTIONS_FLUSH() Read also Allaire Security Bulletin ASB99-10: http://www.allaire.com/handlers/index.cfm?ID=11714Method=Full Erki Wasn't it that undocumented CFusion_Disable_DBConnections() funtion? PS: TeraTech's Tag and Function Quick Reference rocks! :)

RE: Problem Handling Sessions

2000-08-01 Thread Steve Martin
I have two questions about sessions. 1) I have an application that opens a pop-up javascript window with a form. This on the javascript window submits itself back to the template that opened it. It seemed to be working fine, but suddenly I am loosing my session when the form is

RE: Determining Datasources (CFX_DATASOURCES)

2000-08-01 Thread Reynolds, Adam
Do you mean CFX_DATASOURCES? This works, but only returns the ODBC datasources. It was written by Ben Forta. If Ben reads this, have you done an update that also returns the Native databases set up on a server? Thanks Adam Reynolds -- From: David Shadovitz[SMTP:[EMAIL

RE: Date subtraction

2000-08-01 Thread Reynolds, Adam
Fair enough... Not much that can be done there really. Adam -- From: Kevin Langevin[SMTP:[EMAIL PROTECTED]] Sent: 31 July 2000 17:52 To: [EMAIL PROTECTED] Subject: RE: Date subtraction I replied to this thread when there were no other replies, but my

Clustered server - keeping code insync

2000-08-01 Thread JustinMacCarthy
Hi all , Has anyone got any recommendations for keeping the code on several production servers in a clustered setup in sync??? Thanks ~Justin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

Re: Clustered server - keeping code insync

2000-08-01 Thread Erki Esken
Read "Deploying Projects" and "Deploying to Multiple Servers" help files in CF Studio: Help » Using ColdFusion Studio » 11. Deploying Projects Erki Hi all , Has anyone got any recommendations for keeping the code on several production servers in a clustered setup in sync??? Thanks

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Philip Arnold - ASP
I am colocating an NT 4 server running coldfusion and SQL 7 for a web site. I need to know which version of sql 7 I should purchase for unlimited internet connections/not developer connections I seem to recall that it's different than the true UNLIMITED client version which retails for

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Andy Ewings
I think this is a 'hazy' area. It's the same as CF. If you are running a multi-processor server you are supposed to have a special CF license for each processor but I heard that Allaire have sold very few of these. Every company that I have worked for have bought a normal SQL license (£1400)

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Stephen Moretti
I think this is a 'hazy' area. It's the same as CF. If you are running a multi-processor server you are supposed to have a special CF license for each processor but I heard that Allaire have sold very few of these. Every company that I have worked for have bought a normal SQL license

RE: Looping through lists

2000-08-01 Thread Anthony Geoghegan
Hi Jon, Jon Wrote: |Hey, I need to figure out how to loop though a list and |perform a query for |each value returned in the list. Any ideas? You can get a query to select all the records with an entry contained in a comma delimited list so: cfquery name="select_text" SELECT stuff FROM

RE: CFLOOP'ing FORM Field Names Problem

2000-08-01 Thread Paul Sinclair
Jeff, Thanks for the note. I must be really dense or something. I tried this: cfset loopnumber = (#URL.PersonsAttending# - 1) cfloop index="PersonsAttending" from="1" to="#loopnumber#" step="1" cfset tempvar='full_name_''#PersonsAttending#' NAME = #Evaluate("tempvar")#br /cfloop When I

RE: RE: what is better varchar or char

2000-08-01 Thread joeug
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: CFLOOP'ing FORM Field Names Problem

2000-08-01 Thread Steve Martin
Instead of: NAME = #Evaluate("tempvar")#br Remove the quotes: NAME = #Evaluate(tempvar)#br The first line is evaluating the string expression "tempvar" which returns the field names. By removing the quotes you are telling the Evaluate function to evaluate the contents of the variable Tempvar,

RE: RE: Problem Handling Sessions

2000-08-01 Thread joeug
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

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Philip Arnold - ASP
I think this is a 'hazy' area. It's the same as CF. If you are running a multi-processor server you are supposed to have a special CF license for each processor but I heard that Allaire have sold very few of these. Every company that I have worked for have bought a normal SQL license

Re: cflock - BAH! and CF 4.51 question

2000-08-01 Thread Bud
On 7/31/00, Brian L. Wolfsohn penned: Was the conclusion here that the two versions are code incompatible with regards to cflocking ?? i.e. i must have the same version of cf on our test machines as our live machines ?? You MUST specify the scope when using cflock in 4.5. You CANNOT specify

Ben Forta's Quick Store Application

2000-08-01 Thread Chad
I can't get this program to work! It is driving me nuts! It is the Quick Store Application in Ben Forta's CF book. Exactly how am i suppose to setup the custom tags? Because that must be what is wrong. I am copying the entire CF file into the C:\CFUSION\CustomTags folder. When i goto

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Benjamin S. Rogers
SQL Server w/ as many client licenses as servers/workstations will be connecting to it (including the server SQL Server is running on) and the Internet Connector License (about $3000). -Original Message- From: PC [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 6:05 PM To: [EMAIL

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Sean Daniels
I am colocating an NT 4 server running coldfusion and SQL 7 for a web site. I need to know which version of sql 7 I should purchase for unlimited internet connections/not developer connections I seem to recall that it's different than the true UNLIMITED client version which retails for

RE: CFLOOP'ing FORM Field Names Problem

2000-08-01 Thread Paul Sinclair
Steve, That's got it. Thanks. I forgot about getting rid of the quotes in the #Evaluate("tempvar")# thing. When I changed it to #Evaluate(tempvar)#, it gives me the value I need. Paul Sinclair -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August

Re: appropriate SQL 7 licensing for CF website

2000-08-01 Thread JustinMacCarthy
FYI new pricing model from microsoft http://www.microsoft.com/sql/productinfo/pricing.htm ~Justin - Original Message - From: "Benjamin S. Rogers" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 01, 2000 2:20 PM Subject: RE: appropriate SQL 7 licensing for CF website

new certification program questions

2000-08-01 Thread Mike Amburn
for those of you that have taken the CF certification exam: 1. are there any questions regarding CF custom HTML tags like CFFORM and CFINPUT? 2. are there any advanced security questions such as CFAUTHENTICATE or CFIMPERSONATE? thanx! mike

Re: Determining Datasources (CFX_DATASOURCES)

2000-08-01 Thread David Shadovitz
No, I meant OracleDBInfo; see http://devex.allaire.com/developer/gallery/info.cfm?ID=D33BAD72-59F8-11D4 -83E000508B94F85Amethod=Full But a quick look at the code shows that it first checks the Registry for ODBC data sources and then uses the Oracle data dictionary. -David On Tue, 1 Aug 2000

RE: what is better varchar or char

2000-08-01 Thread Jeremy Allen
It depends on your situation really.. If you know for a fact every time that the item you insert is going to be 35 characters then there is less overhead associated with the char datatype and it is more effecient to use. If the data is more random in its length then a varchar will take up less

RE: new certification program questions

2000-08-01 Thread Stephen Moretti
for those of you that have taken the CF certification exam: 1. are there any questions regarding CF custom HTML tags like CFFORM and CFINPUT? 2. are there any advanced security questions such as CFAUTHENTICATE or CFIMPERSONATE? To tell you that would be cheating. ;o) Regards

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread paul smith
Nope. Not so. You only need as many CALs as you have simultaneous connections. Of course, if you have a lot of connections, the Internet Connector is less expensive than CALs. Even Steve Balmer, President of M$, mentioned this option in his introduction of W2000 (and its licensing similar to

RE: new certification program questions

2000-08-01 Thread Jeremy Allen
Hows this... Allaire has a link at their site telling you more or less what to review for. Its multiple guess anyways.. So its not like the test proves to much :P http://www.allaire.com/services/training/certification/faq.cfm :) Jeremy Allen [EMAIL PROTECTED] [Insert cool title here]

Net Present Value NPV()

2000-08-01 Thread Johnson, Dana
does anybody have a workaround for the VB function NPV() for use in cold fusion. Dana E. Johnson Sr. Web Developer CIT VTF/Technology Financing Services [EMAIL PROTECTED] (904) 620-7458 -- Archives:

I've been asked to evaluate Spectra and Enterprise (and have no experience with any such program)

2000-08-01 Thread Wayne, Kurt
I appreciate the help from anyone who can provide advice: My company just acquired another company whose web site dwarfs our own, but which we'll still be assimilating. Our site runs ASP connecting to SQL Server, while theirs is Cold Fusion connecting to Oracle. The combined site will be Cold

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Benjamin S. Rogers
It sounds like the only thing that changed is that the server on which SQL Server is installed now needs its own special license, a "Server License." The CALs for workstations and ancillary servers are still necessary, as well as the Internet Connector for Internet users. Could they make this

RE: new certification program questions

2000-08-01 Thread Robert Everland
How does the Brainbench test compare to the Allaire test? Anyone done both? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 9:55 AM To: [EMAIL PROTECTED] Subject: RE: new certification

RE: Net Present Value NPV()

2000-08-01 Thread Robert Everland
I don't have a VB manual in fron of me, what does NPV do? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Johnson, Dana [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 9:43 AM To: '[EMAIL PROTECTED]' Subject: Net Present Value NPV() does anybody

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread paul smith
Note that the Internet Connector License does not cover users in an Intranet (only the Internet). best, paul At 09:20 AM 8/1/00 -0400, you wrote: SQL Server w/ as many client licenses as servers/workstations will be connecting to it (including the server SQL Server is running on) and the

Re: Looping through lists

2000-08-01 Thread Jon Tillman
On Tue, 01 Aug 2000, peter spewed forth into the void: CFLOOP LIST="#myListOfValues#" INDEX="currItemInList" CFQUERY NAME="performTrivialFunctionInLife" DATASOURCE="..." select * from stillAtWork where somevalue = #currItemInList# and salary #peanuts# order by

Re: RE: Problem Handling Sessions

2000-08-01 Thread Eron Cohen
Joeug, Thank you! The idea about manually setting the cookies worked. Eron - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 01, 2000 8:49 AM Subject: RE: RE: Problem Handling Sessions You are refreshing the page by submitting the form,

RE: Net Present Value NPV()

2000-08-01 Thread Johnson, Dana
Visual Basic for Applications Reference NPV Function Returns a Double specifying the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate. Syntax NPV(rate, values()) The NPV function has these named arguments: Part

Single quote being replace in Query. Why? (Troy)

2000-08-01 Thread Troy Simpson
I am creating a dynamic string to be included in the WHERE clause of a SELECT statement. I need to include single quotes in the string. Here is the literal select statement: SELECT rowid, desc FROM table WHERE rowid IN ( 'AAAESKEK34K', 'AAAEE64D8D' ) I create my string like

RE: Putting CF into RT files (smil files)

2000-08-01 Thread Andrea Wasik(CancerSource)
Richard - thanks...I think I have come across both of those pages in my searches for info - nowhere does anyone seem to talk about how you put cf into a .rt file...so it's frustrating! We have a bunch of video clips (encoded into real and wmf) that I'd like to convert from boring standalone

Re: Net Present Value NPV()

2000-08-01 Thread Dick Applebaum
According to my Excel book NPV(.15,A1:D1) Degrades to (A1/(1+.15))+(B1/(1+.15)^2)+(C1/(1+.15)^3)+(D1/(1+.15)^4) HTH Dick At 9:43 AM -0400 8/1/00, Johnson, Dana wrote: does anybody have a workaround for the VB function NPV() for use in cold fusion. Dana E. Johnson Sr. Web

RE: Clustered server - keeping code insync

2000-08-01 Thread Steve Pierce
Use a central file server. - Steve -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 5:47 AM To: [cftalk] Subject: Clustered server - keeping code insync Hi all , Has anyone got any recommendations for keeping the code on several

Verity on shared host

2000-08-01 Thread Jeff Epstein
I am about strongly considering Interland as a shared hostif anybody has any cautions please let me know. One thing: Is there anything special about using Verity cfsearch in a shared host environment? Any questions I should be asking? Jeff Epstein Web Producer

RE: Single quote being replace in Query. Why? (Troy)

2000-08-01 Thread Jeremy Allen
try the "PreservSingleQuotes" CF Function.. such as... !- SELECT rowid, desc FROM table WHERE rowid IN (PreserveSingleQuotes(Key)) !- that is it :) Jeremy Allen [EMAIL PROTECTED] [Insert cool title

Re: Net Present Value NPV()

2000-08-01 Thread JustinMacCarthy
NPV = C0 + C1 / (1+r) + C2 / (1+r)2 + ... + Cn / (1+r)n so something like if: values is an array of rates and rate is the rate then: cfset NPV = values[1] cfloop from=2 to=#ArrayLen(values)# index=C cfset temp =0 cfset temp = Value[c]/(1+rate) ^ c cfset NPV + temp /cfloop

Help with OUTPUT of some Querys

2000-08-01 Thread Kelly Matthews
Ok I have 2 tables One called SI_Categories it has SI_Category_ID and SI_Category_Name The other called SI_Items it has SI_Item_ID SI_Item_NAme SI_Category_ID So basically SI_Items has the category ID for each item to show what category it belongs to. All Good... I want the output however to

4.51 Ready for Prime Time ?

2000-08-01 Thread Brian L. Wolfsohn
At 09:16 AM 8/1/00 , you wrote: Hadn't gotten much response to this question as part of the cflock threads, but here it is separately.. Is 4.51 stable enough for production environments ?? Are there any gotchas in moving from 4.01 to 4.51 we should know about in advance ?? Brian L.

RE: Clustered server - keeping code insync

2000-08-01 Thread mherbene
When I tried this the performance hit was significant, ~ 1 second per request. Have you found a way to do it that doesn't have that impact? -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 10:49 AM To: [EMAIL PROTECTED] Subject: RE:

RE: Commenting Text in Studio

2000-08-01 Thread Paul Ihrig
If you have your Quick Bar open. Just click on the CFML Basic Tab you will see the !--- Icon. If you do not see the Quick Bar. Go to View, Quick Bar or Control H. -paul -Original Message- From: Paige Chandler [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 1:24 AM To:

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Philip Arnold - ASP
To run SQL Server legally on the internet, you NEED the Internet Connection License - this is not a cheap thing. Nope. Not so. You only need as many CALs as you have simultaneous connections. Of course, if you have a lot of connections, the Internet Connector is less expensive than

RE: Help with OUTPUT of some Querys

2000-08-01 Thread Olive, Christopher M Mr NMR
why not just do a joined query? SELECT c.SI_Category_name, i.si_item_name FROM SI_categories c, si_items i WHERE c.category_id = i.category_id ORDER BY c.si_category_name, i.si_item_name then, when you output, do a TABLE CFOUTPUT QUERY="qname"

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Rich Wild
if you want to break the licencing laws, then sure, don't buy the license... Yay! Let's all be pirates!! Pieces o' 8! -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place

RE: Help with OUTPUT of some Querys

2000-08-01 Thread Stephen Moretti
Hi Kelly, So basically SI_Items has the category ID for each item to show what category it belongs to. All Good... I want the output however to look like so. [snip] I seem to be having trouble. Obviously something has to loop and maybe even group (ooo a rhyme) because once I pull all

Re: ACESS to Oracle

2000-08-01 Thread David Green
First of am New to CF. But I had to go to Access to SQL 6.5 and did not have the upsizing wizard. What I did was create database in on the SQL server then created an ODBC connection to the database. I then openned the DB in access and the exported it to the ODBC database which was an option in

Functions in Cold Fusion

2000-08-01 Thread Brandon Behrens
This is a multi-part message in MIME format. --=_NextPart_000_0016_01BFFBA4.BF744660 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by bastion.theidf.com id e71FbrJ27627 Hello everyone,

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Benjamin S. Rogers
One thing to note when pricing these products is that Microsoft's site only lists the suggested retail price. I just saw a site that listed the Internet Connector for $1500. SQL Server itself (and its CAL packs) didn't have quite the same price reduction. -Original Message- From: Philip

Missing form fields - from only one network?

2000-08-01 Thread Leighton Tebay
I'm doing a little CYA research. One of our clients is experiencing a cf error on their intranet app. They go to do a report, they select a person to do the report on in a select box, click submit, and they get a form field not found error. Sometimes it works, sometimes it doesn't. I can't

Re: [Re: ACESS to Oracle ]

2000-08-01 Thread double-down
use oracle's wizard. "David Green" [EMAIL PROTECTED] wrote: First of am New to CF. But I had to go to Access to SQL 6.5 and did not have the upsizing wizard. What I did was create database in on the SQL server then created an ODBC connection to the database. I then openned the DB in access

RE: Looping through lists

2000-08-01 Thread Jon Tillman
So, what if I wanted to do the following: create a loop that would take two lists, perform the query on all the values in one of them, output the formatted results of those queries, but insert the values from the second list, one for each query returned? On Tue, 01 Aug 2000, Anthony Geoghegan

RE: Functions in Cold Fusion

2000-08-01 Thread Jeremy Allen
Currently.. as a language that is one of ColdFusions weaknesses. There are pretty much two ways to get functions out of ColdFusion.. The first is to encapsulate all the code in a Template and then just CFINCLUDE the template.. the disadvantage is the page does not have its own scope and can

RE: Help with OUTPUT of some Querys

2000-08-01 Thread Kelly Matthews
WOrked like a charm thanks! I am still kinda news at doing anything beyond the simple query. WHen i look at what you did it makes total sense, just couldn't seem to get the ole brain to figure it out! :) Looks like what you need to do is : SELECT SI_Categories.SI_Category_ID,

How do I include a carriage return into my string? (Troy)

2000-08-01 Thread Troy Simpson
I want to include a carriage return in my coldfusion string ( Not the html br tag ). Is this the correct way? cfset str = "Hello World" Chr(13) Chr(10) Is their not a C style like '\n'? Thanks, Troy P.S. Thanks for the help with the "PreserveSingleQuote" problem. I was looking in the

Re: Functions in Cold Fusion

2000-08-01 Thread Sharon DiOrio
Cold Fusion doesn't have functions as you'd know them in Java. It has the built-in functions, of course. Cold Fusion achieves "function functionality" through custom tags. Sharon At 10:39 AM 8/1/2000 -0700, you wrote: This is a multi-part message in MIME format.

Re: Looping through lists

2000-08-01 Thread JustinMacCarthy
Assuming you have namelist = "tom,dick,harry" IDlist = "1,2,3" and you want to select id, some_col from table where id in (#idlist#) output is id some_col 2 textorsomething 3 textorsomething then you chould do cfoutput #listgetat(namelist,listfind(idlist,id,))# #some_col#

Re: Verity on shared host

2000-08-01 Thread Judith Campbell
At 10:48 AM 8/1/00 , you wrote: I am about strongly considering Interland as a shared hostif anybody has any cautions please let me know. One thing: Is there anything special about using Verity cfsearch in a shared host environment? Any questions I should be asking? Jeff Epstein Web

Re: Functions in Cold Fusion

2000-08-01 Thread Michael Dinowitz
I'm currently writing an article for the next Fusion Authority (out in the next day) on how to write and use custom functions in CF. This is not using modules or any CF tags but is actually using function calls. It's a bit of a hack and can look ugly in places, but it works. The result is that I

RE: Functions in Cold Fusion

2000-08-01 Thread Brandon Behrens
Is there any way you could send me this article when you complete it? Thanks, Brandon Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 9:42

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Philip Arnold - ASP
One thing to note when pricing these products is that Microsoft's site only lists the suggested retail price. I just saw a site that listed the Internet Connector for $1500. SQL Server itself (and its CAL packs) didn't have quite the same price reduction. Check the version - I saw the same

RE: How do I include a carriage return into my string? (Troy)

2000-08-01 Thread Philip Arnold - ASP
I want to include a carriage return in my coldfusion string ( Not the html br tag ). Is this the correct way? cfset str = "Hello World" Chr(13) Chr(10) Is their not a C style like '\n'? You have to put the exact character in, so Chr(13) chr(10) would be the correct way. Philip Arnold

Re: Looping through lists

2000-08-01 Thread Jon Tillman
On Tue, 01 Aug 2000, JustinMacCarthy spewed forth into the void: Assuming you have namelist = "tom,dick,harry" IDlist = "1,2,3" and you want to select id, some_col from table where id in (#idlist#) output is id some_col 2 textorsomething 3 textorsomething

RE: How do I include a carriage return into my string? (Troy)

2000-08-01 Thread Miguel
If you want obtain a carriage return in your page output, remember you're programming Html...so I think it's a good idea to use p/p tags. -Mensaje original- De: Troy Simpson [mailto:[EMAIL PROTECTED]] Enviado el: martes 1 de agosto de 2000 18:05 Para: cf-talk Asunto: How do I

Re: Functions in Cold Fusion

2000-08-01 Thread Michael Dinowitz
Fusion Authority is sent by email to all subscribers and is archived on the FA site. Signup and past issues can be seen at www.fusionauthority.com/alert. You'll be able to get it from there (probably tonight). I'm testing out the code and techniques now and I've got to say its very cool. Is

RE: ACESS to Oracle

2000-08-01 Thread Dan Haley
Search oracle.com (not the easiest thing) and look for their Access to Oracle conversion tool. It has been quite awhile since I got it, so no clue now as to where it is. It worked fairly well after getting past a few gotchas . . . biggest problem was each Access database creates a new user and

Use of CF Logo

2000-08-01 Thread Paige Chandler
This is a multi-part message in MIME format. --=_NextPart_000_001C_01BFFBB8.186B4260 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, What is the legal criteria for placing the CF logo on a web page/site? = TIA. Regards, Paige

Re: Clustered server - keeping code insync

2000-08-01 Thread Mooner Ent
Justin, Win 2000 Server has Dfs, which replicates your files from the parent server folder to the child for you. Rick - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "[cftalk]" [EMAIL PROTECTED] Sent: Tuesday, August 01, 2000 2:47 AM Subject: Clustered server -

Re: Functions in Cold Fusion

2000-08-01 Thread Michael Dinowitz
OK, I need some community input here. For my article on custom functions, I've written one for IsEmail and IsPhone. Can people send me a few others to 'add in'. I'd like the article to have a few pre-built functions that can be used right off the bat. The only limits are that they must be built

Re: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Mooner Ent
Andy, An Allaire reseller says there are no cpu charges until you pass four processors. Rick - Original Message - From: "Andy Ewings" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 01, 2000 3:32 AM Subject: RE: appropriate SQL 7 licensing for CF website I think this

Further to Carriage Return Question

2000-08-01 Thread AustralianAccommodation.com Pty. Ltd.
I have an input field where the user is able to enter in up to 12 lines of text. Considering that those entering the text via the website have no html knowledge is there some way to execute carriage returns by them as they require to separate paragraphs or do I need to instruct them to use the br

Re: Looping through lists

2000-08-01 Thread JustinMacCarthy
I have: productlist = "1,2,3,4" quantitylist = "2,1,1,1" and i want to SELECT tblProduct.*, tblProductSize.productsizeSize, tblProductWeight.productweightWeight, tblProductColor.productcolorColor FROM((tblProduct

RE: Functions in Cold Fusion

2000-08-01 Thread Brandon Behrens
How about isSocial, isZip Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 10:10 AM To: [EMAIL PROTECTED] Subject: Re: Functions in Cold

RE: Oracle and the sign

2000-08-01 Thread Dan Haley
Duane, Works fine through both ODBC and the native drivers. If you are running the query through something like SQLPlus, there should be an environment variable for scanning for substitution variables (or something like that). Or at least I would assume there is. Dan -Original

Killing COM

2000-08-01 Thread Dave Wilson
Hi all, How can I, manually or otherwise, kill the connection to a COM object after I'm done with it ? Dave Wilson Internet Technology Manager, BizNet Solutions Allaire Premier Partner Co-Founder CFUG Ireland http://www.cfug.ie 224, Lisburn Road Belfast BT9 6GE Tel: 02890 225 776 Fax: 02890

Re: Verity on shared host

2000-08-01 Thread Sean Renet
I do a LOT of freelance work that ends up on shared hosts. To date, I have not worked with a host better than Interland. Depending on what you are doing, their set up can be a bit trying. However, with the exception of whatever Sprint thing happened in Atlanta a couple of weeks ago, I can't

IMS Email Server

2000-08-01 Thread Duane Boudreau
Hi All, Can anyone tell me what the web address is for the folks who demoed their email server at CFUN-2K Thanks, Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax:

OT: Rackmount Monitor/Keyboard/Mouse Switches

2000-08-01 Thread Benjamin S. Rogers
My apologies for the off topic post, but I rarely receive responses off the CF-Community list. Anyway, on to the question. What's everyone using for rack mount monitor/keyboard/mouse switches? We're a little dissatisfied with our current solution. We're looking for a piece of hardware that: 1.

RE: Further to Carriage Return Question

2000-08-01 Thread Rick Osborne
Why not just translate it all after you've got it from the user? Then you don't have to train the user on anything. CFSET NewText=ParagraphFormat(IncomingText) Or, if that's just too limiting, do it manually: CFSET CrLf=Chr(13) Chr(10) CFSET NewText=Replace(Replace(IncomingText,CrLf

Re: Functions in Cold Fusion

2000-08-01 Thread Ken Wilson
functions in CF. No tags. For example, IsPhone uses this code: REFindNoCase('([0-9]{3}[-_. /]?)?[0-9]{3}[-_. /]?[0-9]{4}', number) Should that be named "IsUSAPhone" so as not to offend our illustrious international friends? Ken

Re: Functions in Cold Fusion

2000-08-01 Thread Jennifer
How about IsURL? At 01:10 PM 8/1/00 -0400, you wrote: OK, I need some community input here. For my article on custom functions, I've written one for IsEmail and IsPhone. Can people send me a few others to 'add in'. I'd like the article to have a few pre-built functions that can be used right off

RE: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Cary Gordon
FWIW, the wholesale price of the Internet Connector at the best available volume license program level (that is, available to me) is over $2100. This means that, essentially, the end user has to purchase at least five licenses for their own use to qualify. AFAIK, the Internet Connector is

RE: Rackmount Monitor/Keyboard/Mouse Switches

2000-08-01 Thread Duane Boudreau
Check out: http://www.pcconnection.com/scripts/productdetail.asp?product_id=140247 Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 -Original

Re: IMS Email Server

2000-08-01 Thread JustinMacCarthy
www.coolfusion.com you can sign up for the mailing list there .. It's a great product ~Justin MacCarthy - Original Message - From: "Duane Boudreau" [EMAIL PROTECTED] To: "CFTalk" [EMAIL PROTECTED] Sent: Tuesday, August 01, 2000 6:20 PM Subject: IMS Email Server Hi All,

Re: OT: Rackmount Monitor/Keyboard/Mouse Switches

2000-08-01 Thread Kevin Miller
Give the Cybex AutoView a try. 16 port, 1U model. Kevin [EMAIL PROTECTED] 08/01/00 10:21AM My apologies for the off topic post, but I rarely receive responses off the CF-Community list. Anyway, on to the question. What's everyone using for rack mount monitor/keyboard/mouse switches? We're

Re: IMS Email Server

2000-08-01 Thread David Fauth
www.coolfusion.com -- Original Message -- From: "Duane Boudreau" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 1 Aug 2000 13:20:08 -0400 Hi All, Can anyone tell me what the web address is for the folks who demoed their email server at

Re: Functions in Cold Fusion

2000-08-01 Thread Michael Dinowitz
Very true. I've got a version that covers all phone numbers, but I was giving a simple example. The point is, if you've got some snippets or code that you would like in a custom function, send it to me off list. functions in CF. No tags. For example, IsPhone uses this code:

Re: Functions in Cold Fusion

2000-08-01 Thread Nick Call
Another one, IsCreditCard Nick - Original Message - From: "Brandon Behrens" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 01, 2000 1:00 PM Subject: RE: Functions in Cold Fusion How about isSocial, isZip Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL

RE: Forcing Upper Case

2000-08-01 Thread Rick Osborne
If you mean on the client-side, the answer is "not all the time". You'd need some sort of JavaScript code akin to: !-- this is off the top of my head -- don't quote me on it -- INPUT TYPE="TEXT" NAME="foo" ONCHANGE="this.value=this.value.toUpperCase();" Since this requires JavaScript it isn't

RE: Functions in Cold Fusion

2000-08-01 Thread Rick Osborne
(A bit tongue-in-cheek for a second, here.) Have you seen a good regex for validating URLs lately? It's *nasty*. See: http://www.foad.org/~abigail/Perl/url2.html Or, if you're the type of person who skips to the end, the regex can be found here: http://www.foad.org/~abigail/Perl/url3.regex

Re: OT: Rackmount Monitor/Keyboard/Mouse Switches

2000-08-01 Thread Cary Gordon
We use the Belkin OmniPro line and they work great. They are much less than Raritan or Cybex. One note, some of the current stock of these switches do not work properly with Dell servers . Belkin is upgrading the firmware for these at no charge. At 01:21 PM 8/1/2000 -0400, you wrote: My

RE: IMS Email Server

2000-08-01 Thread Robert Forsyth
IMS can be found at: http://www.coolfusion.com WE LOVE OURS!! ( you owe me $1 Howie!) Robert Forsyth -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 1:20 PM To: CFTalk Subject: IMS Email Server Hi All, Can anyone tell me what the

  1   2   >