RE: Verity problem

2001-07-27 Thread Stuart Miller
Try This: 1) Remove all punctuation from the string using regular expressions. 2) Strip out any extra spaces from the string so that you are left with only single spaces separating words. 3) Treat the string as a space separated list and loop around it. 4) In the loop, append to a new space

RE: Verity problem

2001-07-27 Thread Craig Dudley
Dont replace and and not etc replace and , ornot with the space at each side, works for me -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 26 July 2001 17:18 To: CF-Talk Subject: Verity problem I'm new to this so go easy on me. I'm using verity to

RE: Regular Expression Help

2001-07-27 Thread Thomas Chiverton
Dain, thank you very much. Is it safe to assume then that anything else i want to search for can be added by placing the definition inside another pair of brackets? Yeah, square brackets define a class to match against, and clasess are or'ed together. [^ ] would match everything that

RE: microsoft and Java advice

2001-07-27 Thread Thomas Chiverton
I know there's applets and servlets, are both going to be useless in the future? maybe I should learn Microsoft's version of Java? It means IE wont run Java applets by default ('microsoft virtual machine'). Nothing stopping applications prompting you to download a VM-plugin or something,

RE: Netscape / CF4.0 / Apache / CFLOCATION

2001-07-27 Thread Thomas Chiverton
Use something like cfhtmlhead text=meta http-equiv=Refresh content=0; URL=edit.cfm cfabort Instead of cflocation - it also doesnt break cookies that's because CFLOCATION essentially sends a 302 header. ~~ Structure your ColdFusion code with

RE: forcing downloads

2001-07-27 Thread Thomas Chiverton
There is no way to force a download in HTTP. You can only imply the suggestion of a download by setting the type to application/octet-stream in your cfcontent tag. Although myself and a few others have had some good success (off list) using hidden frames, and some cunningness. All - I

Re: forcing downloads

2001-07-27 Thread Cold Fusion
thanks Jochem, seems to be closer. weirdly though it doesn't work the first time I run the cfm file, it only returns the correct response when I try a second time. Any ideas on why that is / how to correct ? ta. .jez Cold Fusion wrote: What we want to do is have the user click a link to a

Re: forcing downloads

2001-07-27 Thread Jochem van Dieten
Thomas Chiverton wrote: There is no way to force a download in HTTP. You can only imply the suggestion of a download by setting the type to application/octet-stream in your cfcontent tag. Although myself and a few others have had some good success (off list) using hidden frames, and some

Re: forcing downloads

2001-07-27 Thread Jochem van Dieten
Cold Fusion wrote: thanks Jochem, seems to be closer. weirdly though it doesn't work the first time I run the cfm file, it only returns the correct response when I try a second time. Any ideas on why that is / how to correct ? Can you reproduce this with different browsers and if so, with

RE: forcing downloads

2001-07-27 Thread Thomas Chiverton
Based on what mechanism? the great Kludge :-) for sure it works with future browsers unless you base it on the HTP spec? I don't - but we can filter them out and deal with them seperetly. ~~ Structure your ColdFusion code with Fusebox. Get

RE: forcing downloads

2001-07-27 Thread Craig Dudley
Try this. Link --- a href=dload.cfm/#file#?filename=#file# target=_new#name#/a Dload.cfm -- cfcontent file=#request.docstoreroot#\#url.filename# deletefile=No type=unknown That's the official work around from about 2 years ago, probably still works. -Original

pro or ent?? Double post

2001-07-27 Thread Will Swain
Hi gang, just a quick one. CF 5 Server pro or ent?? What is the difference? When should you look at ent over pro? Cheers Will Swain Hot Horse Ltd http://www.hothorse.com e: [EMAIL PROTECTED] t: 01273 675375 ~~ Structure your ColdFusion code

RE: forcing downloads

2001-07-27 Thread Dick Applebaum
Hi folks.. can anyone help us out with this one, it should be so simple and I just can't accept all the hassle we've been having to try and figure it out. What we want to do is have the user click a link to a cfm file, that cfm file then returns a file (for arguements sake a .xls file) which

Re: Current CF Hosting Leaders?

2001-07-27 Thread Tim Painter
I like crystaltech.com. Never had a problem and response is quick. Tim P. - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 12:46 PM Subject: Current CF Hosting Leaders? I know this topic comes up over and over

Re: Regular Expression Help

2001-07-27 Thread Dain Anderson
John, Your assumption is correct. The part that may have confused you originally is that POSIX-style character classes (ie, [:punct:]) are surrounded by brackets and colons, in addition to the bracket set that defines the entire character class, such as [[:alpha:][:punct:][:cntrl:]] etc...

Re: Practice

2001-07-27 Thread Sammy
I agree, examples are a good way to learn ( observation - a manditory attribute for any scientest) Sometimes looking at someone elses code, correctly written, can impart knowledge very quickly. For example, what kind of code will you find in the application.cfm file of a in production site,

RE: forcing downloads

2001-07-27 Thread eric . laney
Opera 5.12 on Windows 2000 Pro through paranoid corporate firewall reports Connection closed by remote server. |--+--| |Eric A. Laney |Happiness:| |Systems Engineer |An agreeable

RE: Practice

2001-07-27 Thread Tangorre, Mike
True. I am finding that during this internship, I am learning best by jumping right into the code, and reading up on things when I get stuck and what not. I must say this list is a great source, like someone already mentioned, for information. Its fun to read about others issues and think about

Multi part email :: html / plain text :: how?

2001-07-27 Thread Paul Ihrig
ok i have looked in my books the help in cf stu. i cant find any good reference on how to create multi part email using html. if you could just point me in the right direction, i would appreciate it. thanks guys. -paul ~~ Structure your

Re: Regular Expression Help

2001-07-27 Thread eric . laney
Being a Perl programmer also, this is one of the things that really frustrates me about CF's regular expressions. Okay, so back in the day, Allaire decided to go with POSIX-style character classes. That still doesn't explain to me why you have to put the extra square brackets in there, and it

cfreport and crystal reports

2001-07-27 Thread Todd Ashworth
Is there a way to dynamicly pass the name of the database file that you want the crystal reports report you are calling to use? I have one report, but I want it to be able to pull from any number of different databases. So far, I haven't been able to figure out how to do this. Does anyone

RE: pro or ent?? Double post

2001-07-27 Thread Thomas Chiverton
When should you look at ent over pro? If your doing Really Heavy Shit, and / or need clustering, you should look at enterprise. There's a comparison matrix on Allaire's site, but tbh I've about summed it up :-) ~~ Structure your ColdFusion code

Hooking to Lotus Notes.

2001-07-27 Thread Angél Stewart
Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? And can this be done remotely if the CF Server and the Lotus Notes database do not reside on the same machine? I've never used this darn thing before, but apparently a client has this as one of their requirements,

Silly errors

2001-07-27 Thread Stuart Miller
Any one seen this error? An unknown attribute 'ImageID' has been encountered at document position (34:10) to (34:16) while processing tag CFSET. This tag can only take the following attributes: INSIDETEXT The last successfully parsed CFML construct was a CFSET tag occupying document

Re: Regular Expression Help

2001-07-27 Thread Dick Applebaum
I find that: [0-9] is clearer and easier to type than: [:digit:] of course, I'd rather have: \d I do very well without ever using the posix-style. Dick At 8:56 AM -0400 7/27/01, [EMAIL PROTECTED] wrote: Being a Perl programmer also, this is one of the things that really

RE: Geek Cruises

2001-07-27 Thread Mark Smyth
If anyone manages to get their boss to let them put a cruise on their expenses, i'd love to hear about it! -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 26 July 2001 23:00 To: CF-Talk Subject: RE: Geek Cruises I don't know about you...but if I go on a

RE: Hooking to Lotus Notes.

2001-07-27 Thread A . Little
Yes you can use ODBC to link to a Notes db. I'm not so sure about linking to a remote Notes db though. I know for Notes 4.5 to get the ODBC working you needed to have a Notes client installed, so you may need to install a Notes client on your CF server. This may of course be different for Notes

Re: Silly errors

2001-07-27 Thread Jochem van Dieten
Stuart Miller wrote: Any one seen this error? An unknown attribute 'ImageID' has been encountered at document position (34:10) to (34:16) while processing tag CFSET. This tag can only take the following attributes: INSIDETEXT The last successfully parsed CFML construct was a CFSET

RE: Battle of the Gurus (Re: Blatant advertising (you have been warned))

2001-07-27 Thread Kristin Aileen Motlagh
So, hmand I wonder which book that was Ben??? Was that a hidden compliment? (: -- Kristin Aileen Motlagh Co-Author, Mastering ColdFusion 5 Macromedia Certified ColdFusion Developer mailto:[EMAIL PROTECTED] Phone/Fax: 877.525.3304 Date: Thu, 26 Jul 2001 15:07:52 -0400 From: Ben Forta

RE: Hooking to Lotus Notes.

2001-07-27 Thread Tony Garrido
I've never tried to use the Notes ODBC drivers with Cold Fusion before, however, they can be downloaded from: http://www.lotus.com/home.nsf/welcome/downloads. Look for Notes SQL ODBC Drivers, the latest version is 3.0. tg :) -Original Message- From: Angél Stewart [mailto:[EMAIL

RE: Geek Cruises

2001-07-27 Thread Marcus
Does the cruise to Mexico the Boss paid for me and my wife to go on last month count? Marcus -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 2:47 AM To: CF-Talk Subject: RE: Geek Cruises If anyone manages to get their boss to let them

Friday Afternoon Macromedia Styleee

2001-07-27 Thread John McCosker
I thought that since we are all now Macromedia customers we could do a spot the best Dynamic flash site. (does not have to be CF driven, not sure what this one is to be honest) Thought I'd start the ball rolling with http://www.2advanced.com This site grabbed me by the short and curlys, well

RE: Silly errors

2001-07-27 Thread Stuart Miller
OK. Here is the whole story... We have a problem on one of our development machines I wrote a quick application for testing: application.cfm cfset Var = A String that's the whole app, and I get Just in time compilation error An unknown attribute 'Var1' has been encountered at

RE: Hooking to Lotus Notes.

2001-07-27 Thread eric . laney
I'm using Notes 5.0.8, there are no Notes ODBC drivers on my workstation. Unless I missed something in the client install. I know that you can get to Notes via COM, but for hard-core web applications that's a pretty unreliable access method. If I find out anything more, I'll definitely let

RE: Friday Afternoon Macromedia Styleee

2001-07-27 Thread Tangorre, Mike
Awesome Flash site. www.xdude.com -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:39 AM To: CF-Talk Subject: Friday Afternoon Macromedia Styleee I thought that since we are all now Macromedia customers we could do a spot the best Dynamic

RE: Friday Afternoon Macromedia Styleee

2001-07-27 Thread Edward Chanter
This one has some really funky music Make sure you turn it up LOUD! http://www.urbantakeover.co.uk/ -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 2:39 PM To: CF-Talk Subject: Friday Afternoon Macromedia Styleee I thought that

RE: Silly errors

2001-07-27 Thread Thomas Chiverton
cfset Var = A String You know 'var' is a reserved word in CF5 ? For UDF's ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:

RE: Friday Afternoon Macromedia Styleee

2001-07-27 Thread Dylan Bromby
you can start and stop there. i've seen all their work before and it's simply amazing. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 6:39 AM To: CF-Talk Subject: Friday Afternoon Macromedia Styleee I thought that since we are all now

Re: Hooking to Lotus Notes.- SOLUTION

2001-07-27 Thread eric . laney
Found it! http://www.lotus.com/download_kits.nsf/ You want to use the Select Product dropdown to download the Notes SQL 3.0 ODBC drivers. This package will install an ODBC driver for .nsf databases. You'll have to jump through Lotus' inane registration and login process, but what's a little

RE: Silly errors

2001-07-27 Thread Stuart Miller
cfset Var = A String You know 'var' is a reserved word in CF5 ? For UDF's ? No matter... cfset SomeVar = Hi doesn't work either. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: Friday Afternoon Macromedia Styleee

2001-07-27 Thread Philip Arnold - ASP
I thought that since we are all now Macromedia customers we could do a spot the best Dynamic flash site. (does not have to be CF driven, not sure what this one is to be honest) Thought I'd start the ball rolling with http://www.2advanced.com This site grabbed me by the short and curlys,

RE: Friday Afternoon Macromedia Styleee

2001-07-27 Thread Mark Smyth
That is a great site try this for interactivity with a capitol I http://www.dubit.co.uk -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 15:25 To: CF-Talk Subject: RE: Friday Afternoon Macromedia Styleee I thought that since we are all now

RE: Hooking to Lotus Notes.- SOLUTION

2001-07-27 Thread Angél Stewart
Yes thats it! Thank you ! I've been scouring the Lotus Notes site but apparently wasn't looking in the right place heh heh. It's interesting that no one seems to have actually USED the ODBC driver to hook to notes for an application though.. :) *wiggles happily* -Gel -Original

Re: Friday Afternoon Macromedia Styleee

2001-07-27 Thread Tim Painter
Just saw this one today: http://www.electrotank.com/games/playGames.cfm?gameID=31 Great little putt-putt golf game and the site is in CF! Tim P. - Original Message - From: John McCosker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 27, 2001 9:39 AM Subject: Friday

RE: Friday Afternoon Macromedia Styleee

2001-07-27 Thread John McCosker
I conceed :)(: -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 3:46 PM To: CF-Talk Subject: RE: Friday Afternoon Macromedia Styleee That is a great site try this for interactivity with a capitol I http://www.dubit.co.uk -Original

CF 5.0 Installation Problems...

2001-07-27 Thread Neil H.
When attempting to install CF 5.0 nothing happens! Let me explain: It does mention that CF 4.5 is installed and that it will be upgraded. That is fine. But then nothing. I watch Ikernel.exe, which is Install Shield, just consume memory. The only way to kill it is to end the task in task

RE: Hooking to Lotus Notes.- SOLUTION

2001-07-27 Thread eric . laney
Well, don't get excited just yet... I installed the drivers and attempted to connect to my local address book using CF and Notes SQL. I was able to set up the ODBC connection, and I even reverse-engineered the database structure using Visio 2002's Database Model template, but when I created a

Service Pack 2 Problems?

2001-07-27 Thread Tim Painter
We are about to install windows 2000 service pack 2. Anyone have any problems with this on their CF servers? I haven't heard of any, but just wanted to be sure. Tim P. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: CF 5.0 Installation Problems...

2001-07-27 Thread Bruce Sorge
I ran into the same issue. What I did was remove my old version (all your sites are still there as well as DSN's), and then ran the install. IF you are using an Upgrade version, be sure to have the original CD Key handy because you will be asked. - Original Message - From: Neil H. [EMAIL

RE: Multi part email :: html / plain text :: how?

2001-07-27 Thread Marlon Moyer
One more experienced than I posted this once: I believe his name is Seth Bienek Here's the commented code -- !--- Create a unique ID for the message boundary. --- cfset boundary = CreateUUID() !--- Standard CFMAIL.. Note that the TYPE attribute is not set. --- cfmail to=[EMAIL PROTECTED]

RE: CF 5.0 Installation Problems...

2001-07-27 Thread Philip Arnold - ASP
I ran into the same issue. What I did was remove my old version (all your sites are still there as well as DSN's), and then ran the install. IF you are using an Upgrade version, be sure to have the original CD Key handy because you will be asked. The new upgrade is a great improvement - you

Re: Friday Afternoon Macromedia Styleee

2001-07-27 Thread Bill Davidson
Good call Philip, I can list about 200 amazing Flash sites (from memory at least...). This thread could quite possibly NEVER end. Just go to http://www.coolhomepages.com and you're need for amazing Flash sites will be fulfilled and your productivity will halt (for a few hours, probably). -Bill

Re: Service Pack 2 Problems?

2001-07-27 Thread Bill Davidson
Been running Spack2 for awhile on several CF servers - both 4.x 5.0... no problems. -Bill brainbox - Original Message - From: Tim Painter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 27, 2001 11:08 AM Subject: Service Pack 2 Problems? We are about to install

RE: Service Pack 2 Problems?

2001-07-27 Thread Dylan Bromby
None here. -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:09 AM To: CF-Talk Subject: Service Pack 2 Problems? We are about to install windows 2000 service pack 2. Anyone have any problems with this on their CF servers? I haven't heard of

SQL 7.0

2001-07-27 Thread Andrew Scott
What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:

RE: CF 5.0 Installation Problems...

2001-07-27 Thread Jay Sudowski - Handy Networks LLC
Hi Neil, This happened when we tried to upgrade as well. I'm not precisely sure what I did, but finally the installer did open up. I believe I rebooted, stopped all CF services, all IIS services, launched the installer, and then just waited about 5 minutes until it finally came up. The RAM

RE: SQL 7.0

2001-07-27 Thread Stuart Miller
Try ntext -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 4:28 PM To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one!

RE: SQL 7.0

2001-07-27 Thread Simon Horwith
text Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27,

double post - JavaScript and windows

2001-07-27 Thread Will Swain
Hi, Just a quick one. I have a window that is opened through clicking on a a href in another window. There is a link in this second window, which when clicked I want to open a page in the first window. Any ideas? Will Swain Hot Horse Ltd http://www.hothorse.com e: [EMAIL PROTECTED] t: 01273

RE: SQL 7.0

2001-07-27 Thread Bruce Sorge
Text ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

RE: SQL 7.0

2001-07-27 Thread Craig Dudley
ntext but I prefer to use varchar(8000) -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 16:28 To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one!

RE: pro or ent?? Double post

2001-07-27 Thread Will Swain
Yup...thats what I thought! :) Thanks Thomas Will -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 14:15 To: CF-Talk Subject: RE: pro or ent?? Double post When should you look at ent over pro? If your doing Really Heavy Shit, and / or need

RE: SQL 7.0

2001-07-27 Thread Alistair Davidson
text (or ntext if you need unicode support) -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 16:28 To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one!

RE: SQL 7.0

2001-07-27 Thread Mark Warrick
I believe that's NTEXT (16). You can verify that by exporting an Access database with a memo field into SQL. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax:

Opening a new Window

2001-07-27 Thread ronmyers
HI I am a newbie at Using CF and HTML in general, But I am having fun learning. My problem is I am opening a new window. I know how to set the size How do I set the location where it opens. Thanks Ron ~~ Structure your ColdFusion code with

RE: double post - JavaScript and windows

2001-07-27 Thread Steve Drucker
From the second window... A HREF=javascript:window.opener.location.href='foobar.cfm'Click here/A Regards, Steve Drucker CEO Fig Leaf Software -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 11:47 AM To: CF-Talk Subject: double post -

Re: Hooking to Lotus Notes.

2001-07-27 Thread Jeffry Houser
At 09:18 AM 07/27/2001 -0400, you wrote: Can you connect to a Lotus Notes database file..a .nsf file I believe, via ODBC? Yes, Notes databases are .nsf files. And yes, you can connect to them via ODBC. I think Lotus used to have drivers downloadable from their site. And can this be done

RE: SQL 7.0

2001-07-27 Thread Andrew Scott
Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ Structure

RE: double post - JavaScript and windows

2001-07-27 Thread Tangorre, Mike
try looking at the parent.refresh Michael T. Tangorre Web Applications Developer Office Phone: 703-558-4746 Cellular Phone: 607-426-9277 AIM: CrazyFlash4 Personal Email: [EMAIL PROTECTED] Work Email: [EMAIL PROTECTED] School Email: [EMAIL PROTECTED]

Re: double post - JavaScript and windows

2001-07-27 Thread Don Vawter
a href=# onclick=opener.location='whatever';return false;click/a - Original Message - From: Will Swain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 27, 2001 9:47 AM Subject: double post - JavaScript and windows Hi, Just a quick one. I have a window that is

RE: SQL 7.0

2001-07-27 Thread Andrew Scott
I need something bigger than 8000, more like double this... I have tried all these!! -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:46 AM To: CF-Talk Subject: RE: SQL 7.0 ntext but I prefer to use varchar(8000) -Original

Re: double post - JavaScript and windows

2001-07-27 Thread eric . laney
I'm a little fuzzy on my JavaScript DOM, but I think you can use opener.location.href = 'x'; |---+-| |Eric A. Laney |You now have Asian Flu. | |Systems Engineer |

RE: double post - JavaScript and windows

2001-07-27 Thread Jordan Saardchit
window.opener.location.href = URL; -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:47 AM To: CF-Talk Subject: double post - JavaScript and windows Hi, Just a quick one. I have a window that is opened through clicking on a a href in another

CFTry/CFCatch

2001-07-27 Thread John Paitel
Hey all... I have a page that loops to produce an identical table five times, using the loop index to assign unique names to all fields. On the handling page, I use a loop to recreate all the params that might be coming from the first page. Once those are created, I loop a third time to

RE: SQL 7.0

2001-07-27 Thread Philip Arnold - ASP
What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! Try ntext ntext is UNICODE, and since CF45 aren't UNICODE compatible, this won't do anything for you apart from eat twice the hard disk space Until CF6/Neo comes out, it's easier

RE: SQL 7.0

2001-07-27 Thread Andrew Scott
I have this now and there is a field of text I need to place into this field and it complains that the size is to small!!! -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 2:02 AM To: CF-Talk Subject: RE: SQL 7.0 I believe that's

RE: SQL 7.0

2001-07-27 Thread Philip Arnold - ASP
ntext but I prefer to use varchar(8000) 2 problems with this 1) You're limiting the user to 8,000 characters - if it's a HTML page, then it can break this easily 2) SQL 7 has a row limit of just over 8Kb - you can only use this and 1 or 2 other fields before you start getting errors I'd

RE: SQL 7.0

2001-07-27 Thread Stuart Miller
HOW BIG IS IT?! text = 2,147,483,647 chars ntext = 1,073,741,823 chars I could store the contents * 10 of my SQL Server 7.0 book in that field. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 5:05 PM To: CF-Talk Subject: RE: SQL 7.0 Sorry

RE: SQL 7.0

2001-07-27 Thread Duane Boudreau
What are you storing? Text will hold up to up to 2GB of data. Duane -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:05 PM To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!!

RE: SQL 7.0

2001-07-27 Thread Jay Sudowski - Handy Networks LLC
Just how big do you need to go? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:05 PM To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce

More RegEx Help

2001-07-27 Thread John Barleycorn
I seem to be having a problem searching for a space using RegEx. This is what i'm using: cfif REFindNoCase([[:Alpha:][:Punct:][ ]], myString) bad chars found /cfif but it doesn't find any of the chars i'm looking for if i include [ ]. If i remove that part, it finds what i'm looking for.

RE: SQL 7.0

2001-07-27 Thread Clint Tredway
If this is the case then you will need to chop up your text and insert it into multiple rows in the database. I had to do this once to make legal documents insert into an Access database(Client insisted on Access)... It was a pain but it did the job.. HTH Clint -- Original Message

RE: SQL 7.0

2001-07-27 Thread Benjamin S. Rogers
Sorry I need something bigger than both of these ntext and text provide!! You may want to try again. A text datatype can hold as much as 2,147,483,647 bytes of data. I don't know what an Access memo field can hold, but I'm sure it isn't as big as that. Benjamin S. Rogers http://www.c4.net/

RE: Opening a new Window

2001-07-27 Thread Stephen Rojas
In your new window function there are three things you set, the URL, the window name and then the properties, which include window size, position, scrollbars(yes/no), and so on: newWindow = window.open([URL of new window], [Window object name], [Properties]) newWindow =

RE: SQL 7.0

2001-07-27 Thread Dave Watts
Sorry I need something bigger than both of these ntext and text provide!! It would be surprising if you really needed to store more than 2,147,483,647 characters, which is the maximum length of an SQL 7 text column. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202)

RE: SQL 7.0

2001-07-27 Thread Norman Elton
Text will hold something like 2 gigabytes (i don't have the docs in front of me)... If that's not big enough, storing it in SQL probably isn't a good idea. Try storing it in a file and storing the filename in SQL. As a side note... http://terraserver.microsoft.com stores satellite images of

RE: SQL 7.0

2001-07-27 Thread Daniel Lancelot
from BOL: text Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. You really need more than 2GB of data??? in one text field??? WOW... -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 17:05 To: CF-Talk

RE: Opening a new Window

2001-07-27 Thread Dunwiddie, Bruce
OnClick=window.open('somewhere.cfm', 'edit', config='height=600,width=800,top=1,left=1,scrollbars=yes') -Original Message- From: ronmyers [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 11:02 AM To: CF-Talk Subject: Opening a new Window HI I am a newbie at Using CF and HTML in

Re: Service Pack 2 Problems?

2001-07-27 Thread Steven A. del Sol
Originally there was a problem with the MDAC's in SP2. I think MM made changes in CF5 and in SP2 of CF 4.5. I can send more detail on this if needed. Steven A. del Sol I think the At 11:08 AM 7/27/2001 -0400, you wrote: We are about to install windows 2000 service pack 2. Anyone have

My header/footer inclusion scheme hinders Verity searches!

2001-07-27 Thread Jamie Jackson
I like to use custom tags for header/footer inclusion, because it is easy and elegant for our non-CFers to use: - cf_MyHeadFoot metaTitle=TitleToAppearAtTopOfBrowser pageTitle=TitleToAppearInHTML metaDescription=DescriptionToGoInDescriptionMetaTag

RE: SQL 7.0

2001-07-27 Thread Paris Lundis
Memo fields in Access hold 64k maximum I do believe. -paris -Original Message- From: Benjamin S. Rogers [EMAIL PROTECTED] Date: Fri, 27 Jul 2001 12:46:52 -0400 Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! You may want to try

RE: Opening a new Window

2001-07-27 Thread Mark Warrick
Are you taking about where on the screen it would open? If so, I believe that's a DHTML issue. Otherwise, you can read up on how to create windows at http://www.irt.org. I recommend searching the net for DHTML tutorials or buy a book. Someone else on this list might be able to tell you

RE: SQL 7.0

2001-07-27 Thread Mark Warrick
Andrew, NTEXT provides for a farily large amount of data (for example, an entire resume). If you want something bigger than what SQL can handle, you should just use CFFILE to create text files to store the data. ---mark = Mark Warrick - Fusioneers.com

RE: SQL 7.0

2001-07-27 Thread Mark Warrick
How is that field type incompatible with ColdFusion? I use it and it seems to be working fine. Am I missing something here? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386

RE: SQL 7.0

2001-07-27 Thread Mark Warrick
Have you counted the characters of whatever text it is you're trying to insert into the SQL field? And can you insert this same text into Access, but not a SQL ntext field? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED]

RE: come on Forta !

2001-07-27 Thread Costas Piliotis
Woah! Ansi 88 Syntax! Haven't seen that since Btrieve! Are you even allowed to use that in most current databases? By the way, your joins are all inner joins. Won't work for this guy. -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 4:38 PM

OT: MySQL Front

2001-07-27 Thread Chad Gray
Does anyone have a favorite MySQL GUI interface for a Win 2K box? I like MySQL-Front so far, but im wondering if there is something better to maintain and connect to a MySQL database on a IRIX server. Thanks, Chad ~~ Structure your ColdFusion

Vote on ColdFusion Enhancements!

2001-07-27 Thread Terry Ford
Hi cf-talk, We're deep in the middle of the design and development for the next major release of ColdFusion and are looking for some good input on ColdFusion enhancements. Below is a link to an enhancement-tracking application that we've put online temporarily. Inside you will find over 200

RE: More RegEx Help

2001-07-27 Thread Bryan Love
Regular expressions can be very confusing... that's why I don't use them :) If you just want to find a space then use FIND() like this foo = find(string, ); if( find(string, ) ) do whatever Bryan Love ACP Internet Application

RE: SQL 7.0

2001-07-27 Thread Benjamin S. Rogers
The difference between NTEXT and TEXT is that NTEXT supports Unicode data. The price for this is that it takes twice as much space on your server to store NTEXT data as it does to store TEXT data. Consequently, SQL Server will only let you store half as much NTEXT data as TEXT data. ColdFusion

  1   2   >