Re: Checking URL validity

2000-10-16 Thread Campbell Morton
On Sun, 15 Oct 2000, Peter Theobald spake thusly: Geez.. you guys with your NT-only CFX's are almost enough to make me switch from Linux to NT... Be strong in the force, and turn not to the dark side... Since you're a penguin hugger, perhaps you should gain another alliance with the PHP open

manipulating variables

2000-10-16 Thread Dominic J. Doucet-Lorang
This is a multi-part message in MIME format. --=_NextPart_000_000D_01C03760.71E05810 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am at an impass on how to take a series of variables and create a single variable composed of them. I have a 15

url variables

2000-10-16 Thread Jon Hall
This is a multi-part message in MIME format. --=_NextPart_000_0011_01C03731.8F6351F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Anyone know how I can get a list of all URL variables? I know the #query_string# variable gives all the

RE: url variables

2000-10-16 Thread Steve Martin
StructKeyList(URL) Steve -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 10:26 To: CF-Talk Subject: url variables This is a multi-part message in MIME format. --=_NextPart_000_0011_01C03731.8F6351F0 Content-Type: text/plain;

RE: Cookies and CFLOCATION

2000-10-16 Thread Paul Johnston
Done both to be on the safe side! I wish they'd document this. I suppose it makes sense if you think about it, but it's not clear that you can't set a cookie like any other CF variable and expect it to work. Oh well, we all know now! Thanks Paul -Original Message- From: Rob

CF Nuke

2000-10-16 Thread Juan Andres Alvarez Valenzuela
This is a multi-part message in MIME format. --=_NextPart_000_0097_01C03772.94D59A80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi guys, I'm looking for open source CF software to set a news driven site but I = can't found nothing.

RE: manipulating variables

2000-10-16 Thread Paul Johnston
try Cfset A = B C D E F Putting the quotes round treats them as a string not a variable. Paul -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED]] Sent: 16 October 2000 10:02 To: CF-Talk Subject: manipulating variables This is a multi-part message

Re: url variables

2000-10-16 Thread Jon Hall
Thanks Steve. The only problem is that this only seems to work on 4.5 servers. On my 4.0 server I get an Error resolving parameter URL, error. Seems to me that the URL structure is either named something else or there is a totally different way of getting it. hmmm jon - Original Message

never mind...got a solution Re: url variables

2000-10-16 Thread Jon Hall
cfloop index="u" list="#cgi.QUERY_STRING#" delimiters="" #u# /cfloop jon - Original Message - From: "Steve Martin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 16, 2000 5:36 AM Subject: RE: url variables StructKeyList(URL) Steve -Original

RE: url variables

2000-10-16 Thread Dennis Grady
If I'm not mistaken there is no url structure in 4.0. URL variables weren't dropped into a structure until 4.5. __ Dennis P. Grady Fig Leaf Software Senior Developer/Team Leader Certified Allaire Trainer W: 202.797.5450 F: 202.797.5444 -Original Message- From:

RE: SQL Server - MS Access Autonumber?

2000-10-16 Thread Aaron Johnson
Hey Andy, Leave the datatype as "int" check the box for "identity"... that'll do the trick. AJ -Original Message- From: cf kaizen [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 9:27 AM To: CF-Talk Subject: OT: SQL Server - MS Access "Autonumber"? Hi, Forgive my

RE: SQL Server - MS Access Autonumber?

2000-10-16 Thread Simon Horwith
IDENTITY datatype... NO NULLS -Original Message- From: cf kaizen [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 9:27 AM To: CF-Talk Subject: OT: SQL Server - MS Access "Autonumber"? Hi, Forgive my newbiness. Is there an SQL equivalent to MS Access' AutoNumber type field? I

RE: SQL Server - MS Access Autonumber?

2000-10-16 Thread Mike Connolly
I believe autonumbering is bad practice in world of data-integrity. You will find that when creating tables in SQL there is not an equivalent to Autonumbering for a field. However I'm pretty sure you can replicate this using a stored procedure or trigger? -Original Message- From: cf

RE: SQL Server - MS Access Autonumber?

2000-10-16 Thread Simon Horwith
I must disagree. There are obvious advantages to using auto numbering fields. In fact, I rarely create a table without an auto number (IDENTITY) column. ~Simon -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 9:36 AM To: CF-Talk Subject:

RE: SQL Server - MS Access Autonumber?

2000-10-16 Thread Andy Ewings
I second that. Mike - I'd be very interested in hearing your reasons as to why you think it is bad practice to use Autonumbers. Have you had some bad experiences with them? -- Andrew Ewings Project Manager Thoughtbubble Ltd

CF Resources

2000-10-16 Thread Peter Benoit
Boy what a hard time I had this weekend trying to find some resources on Cold Fusion. Basically I was trying to write a few scripts, but I couldn't find any decent examples online. Much different from the PHP community out there. The examples I could find were done as CFX, which I can't use on

Re: bulk data administration

2000-10-16 Thread Peter Theobald
That would be a great (easy) way to do it. I don't think I can set up an xls datasource on Linux, can I? At 08:08 AM 10/16/00 -0500, Billy Cravens wrote: I like setting up an xls datasource. The user uploads the file, the filename is changed to your xls datasource file name, and you then query

RE: SQL Server - MS Access Autonumber?

2000-10-16 Thread Patricia Lee
Oh my. Here we go again. There was an extended discussion on this just a few months ago, back in July: "What are you using instead of @@IDENTITY". Primary contributors to the discussion: Dave Watts, Dick Applebaum, Stephen Garrett and others. Check it out if you can, or if you like, email me

RE: url variables

2000-10-16 Thread Steve Martin
That is correct. The following should allow you to access the URL structure in 4.0 and above by creating a structure called URL for versions which don't automatically provide the URL vars in a struct. CFSET VersionA=ListGetAt(Server.ColdFusion.ProductVersion,1) CFSET

Re: SQL Server - MS Access Autonumber?

2000-10-16 Thread tom muck
I second that. Mike - I'd be very interested in hearing your reasons as to why you think it is bad practice to use Autonumbers. Have you had some bad experiences with them? -- Andrew Ewings It depends where you use them.

Re: CF Resources

2000-10-16 Thread JustinMacCarthy
You will find a load of stuff like this at http://devex.allaire.com/developer/gallery/ Also there are lots of CF resources out there www.cfadvisor.com www.houseoffusion.com www.defusion.com Also check out your local CFUG http://devex.allaire.com/developer/usergroups/ JustinMacCarthy -

RE: SQL Server - MS Access Autonumber?

2000-10-16 Thread Andy Ewings
OK, but I'm not suggesting for one minute you pass the ID across in the URLI tend to store it as a Client variable in a DB. All I need to pass in the URL to maintain state is the CFID and CFTOKEN and only if the user has session level cookies turned off

RE: CF Resources

2000-10-16 Thread Doyle, Mike
What, specifically, are you looking for? Here are some helpful sites you might try: -cfm-resources.com -cfhub.com -houseoffusion.com -oacfug.org -Allaire's CF forum: http://forums.allaire.com/devconf/main.cfm Mike "Outside of a dog, a book is man's best friend. Inside of a dog it is too dark

RE: SQL Server - MS Access Autonumber?

2000-10-16 Thread Mike Connolly
CF_IGNORE User="Mike Connolly" CFX_TALKINGARSE User="Mike Connolly" CFABORT -Original Message- From: Mike Connolly [SMTP:[EMAIL PROTECTED]] Sent: 16 October 2000 14:36 To: CF-Talk Subject: RE: SQL Server - MS Access "Autonumber"? I believe autonumbering is bad practice

RE: CF Resources

2000-10-16 Thread Peter Benoit
Good sites, problem being that the majority of this stuff is encrypted so seeing how someone did something, then building upon it myself isn't an option. Just don't seem to be a wide variety of "source" sites out there, or at least I can't find em. :( * -Original Message- * From:

RE: CF Resources

2000-10-16 Thread Peter Benoit
Just examples of how some applications were made, the actual source not the application itself. I like to see how people think when they code things, and CF being vastly different than PHP makes me want to see how CF guys do it. For instance, I want to build an elaborate browser detection

Re: SQL Server - MS Access Autonumber?

2000-10-16 Thread Jacob
How about something like http://www.whatever.com/file.cfm?CustomerID=459CustLastName=LastmaneCustEmail=email Some customer must know all three to access some else's account. At 10:19 AM 10/16/00 -0400, you wrote: I second that. Mike - I'd be very interested in hearing your reasons as to

Extra records in CSV file generation

2000-10-16 Thread Rich Wild
Gents and Ladies... I am having a right old headache generating a CSV file from data in a database. The data is all returned fine, but at the end of every file there are seven blank fields, no matter what data is contained. I'm pulling my hair out trying to find out why these seven lines are

RE: CF Resources

2000-10-16 Thread Gavin Myers
http://www.cfvault.com/index.cfm/mode/ContentPage/Element/tutorials_full_ind ex http://hotwired.lycos.com/webmonkey/programming/coldfusion/ http://www.builder.com/Programming/ScriptMagic/ http://html.about.com/compute/html/library/weekly/aa080299.htm

Re: SQL Server - MS Access Autonumber?

2000-10-16 Thread tom muck
That's all I was saying. . .they have their uses, but don't use them where the data could be at risk. For instance as a hidden form field with an OrderID for a shopping cart. Any time there is sensitive data accessible to the user via URL, cookie, view source, etc -- autonumbers shouldn't be

RE: CF Resources

2000-10-16 Thread Doyle, Mike
Peter, The best advice I can give you (and I think others here would concur) for general application architecture matters is to pick up Ben Forta's "The ColdFusion 4.0 Web Application Construction Kit" (Ret. 39.99). I saw one at half.com for $21.03. It is the consumate guide and it has several

RE: Extra records in CSV file generation

2000-10-16 Thread Aaron Johnson
hey rich, Maybe wrap the entire thing in cfsetting enablecfoutpuonly="1"cfsettingenablecfoutputonly="0" so your code would look like this: cfsetting enablecfoutpuonly="1" CFHEADER NAME="Content-Disposition" VALUE="inline; filename=#dateformat(now(), "mmdd")#_#timeformat(now(),

Re: Extra records in CSV file generation

2000-10-16 Thread tom muck
Gents and Ladies... I am having a right old headache generating a CSV file from data in a database. The data is all returned fine, but at the end of every file there are seven blank fields, no matter what data is contained. I'm pulling my hair out trying to find out why these seven lines

RE: SQL Server - MS Access Autonumber?

2000-10-16 Thread Robert Everland
The reason I like to use autonumber is because being a numeric id I don't have to worry about someone appending any extra SQL commands to my query. So I do an isnumeric before my query and if it is it does the query and if not it doesn't. No fuss no muss. Robert Everland III Web Developer Dixon

RE: CF Resources

2000-10-16 Thread Peter Benoit
excellant! Thanks ;) * -Original Message- * From: Gavin Myers [mailto:[EMAIL PROTECTED]] * Sent: Monday, October 16, 2000 11:05 AM * To: CF-Talk * Subject: RE: CF Resources * * * * http://www.cfvault.com/index.cfm/mode/ContentPage/Element/tut * orials_full_ind * ex * *

RE: CF Resources

2000-10-16 Thread Shane Witbeck
I have a section devoted to CF resources on my site, www.digitalsanctum.com *shameless plug* Shane Witbeck Webmaster -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 10:14 AM To: CF-Talk Subject: CF Resources Boy what a hard time I had

RE: cold fusion tools question..

2000-10-16 Thread Craig M. Rosenblum
Someone mentioned a tool called cfoptimize.exe -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Friday, October 13, 2000 3:58 PM To: CF-Talk Subject: RE: cold fusion tools question.. Steve Nelson wrote something that I believe does this...

RE: CF Resources

2000-10-16 Thread Gavin Lilley
I agree! This book really is the dogs, Big up Ben! -- Gavin Lilley Internet / Intranet Developer Halesowen College Tel: 0121 550 1451 Ext: 330 -Original Message- From: Doyle, Mike [mailto:[EMAIL PROTECTED]] Sent: 16 October 2000 16:03 To: CF-Talk Subject: RE: CF Resources Peter, The

RE: CF Resources

2000-10-16 Thread paul smith
You can download then entire CF site at www.fusebox.org 'course, a lot of it is fusebox-specific. But a lot is not. best, paul At 10:37 AM 10/16/00 -0400, you wrote: Good sites, problem being that the majority of this stuff is encrypted so seeing how someone did something, then building upon

Re: SQL Server - MS Access Autonumber

2000-10-16 Thread Timothy C. Hill
When upgrading from an Access database, do you have to do anything other than click the identity field, or is there something else you need to do when you have records with a unique identity already in the table?? I am about to do the same thing, and I have always created my DB from scratch in

RE: Extra records in CSV file generation

2000-10-16 Thread Rich Wild
I had the same problem until I eliminated all blank lines in the cfm after the CFOUTPUT. Also, no /body or /html tags. Hi Tom, Yeah this would do the trick probably, but I already checked for that. :( --- Rich Wild Senior Web

RE: Extra records in CSV file generation

2000-10-16 Thread Rich Wild
Maybe wrap the entire thing in cfsetting enablecfoutpuonly="1"cfsettingenablecfoutputonly="0" [sic] Hi Aaron, Unfortunately that didn't work either. h I even tried putting the whole code on one line. Difficult to read in studio, and didn't work either!

SQL Date Error --Help Needed

2000-10-16 Thread Eric Hoffman
brain dead. I am attempting to insert a date into a datetime field in SQL. It is the correct ODBCdateformat...it is choking on the zeroed-out time stamp as only a date is used in the field. What am I forgetting to get it to insert properly? Change database datatype or some code? Thanks.

RE: Extra records in CSV file generation

2000-10-16 Thread Paul Johnston
Why not wrap it in a tag (see tag gallery) like cf_stripwhitespace or cf_lesswhitespace (see below) They take out all whitespace from a cf document after it's been processed. It may sort it out, it may not. Paul PS cf_lesswhitepace from http://www.bjork.net/taggallery/index.htm is my personal

RE: SQL Date Error --Help Needed

2000-10-16 Thread Daye, Marianne
I just put it to the test on my own application with datetime field in the database. #CreateODBCDate(Now())# seems to work just fine. Marianne Daye -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 11:50 AM To: CF-Talk Subject: SQL Date

RE: CACHING queries

2000-10-16 Thread Dave Watts
When using the following code: CFQUERY NAME="SEARCH" DATASOURCE="stylee" CACHEDWITHIN="#CreateTimeSpan(0,0,10,0)#" Will that cache for the user, or for the entire server? I want it to cache per user... That will cache that recordset for the server. It will be reused by any other query

Finding Specific Instances Using CFFile

2000-10-16 Thread Christopher S Martin
Hi all. I am wondering if it is possible to use CFFile to find particular instances of text in a file. I have the wonderful job of going through all the files on a website, and putting all the queries, fields, tables, and datasources into a database. We have about 439 separate files, and each

RE: Extra records in CSV file generation

2000-10-16 Thread Rich Wild
Why not wrap it in a tag (see tag gallery) like cf_stripwhitespace or cf_lesswhitespace (see below) Unfortunately that didn't help either.. :( I think the problem may lie elsewhere... thanks for the help though. --- Rich Wild

Re: SQL Server - MS Access Autonumber

2000-10-16 Thread paul smith
You need to tell SQL Server what number to start with so it exceeds your highest number in Access. best, paul At 11:25 AM 10/16/00 -0400, you wrote: When upgrading from an Access database, do you have to do anything other than click the identity field, or is there something else you need to

RE: Finding Specific Instances Using CFFile

2000-10-16 Thread Jason Powers
Chris: Just to get an idea of what you're dealing with, you could simply do an extended find on the entire site, looking for "cfquery". To do the dirty work, you could loop over cfdirectory calls, cffiling and pulling out the data you need with a RegEx. That's what I'd do. -Original

row # in database??

2000-10-16 Thread Ethan Rosch
This is a multi-part message in MIME format. --=_NextPart_000_0075_01C0376E.73531990 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I think this is a rather simple question How do I find the row # of a certain row of data in my

acess =

2000-10-16 Thread wpdd
This is a multi-part message in MIME format. --=_NextPart_000_0064_01C0376F.2C6B7030 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable cfquery name=3D"delete" datasource=3D"#application.dsn#" = dbtype=3D"ODBC" Delete from DealerAuditTable

last message was sent html by accident....

2000-10-16 Thread Ethan Rosch
This is a multi-part message in MIME format. --=_NextPart_000_00A2_01C03770.D14BE250 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I think this is a rather simple question How do I find the row # of a certain row of data in my

RE: row # in database??

2000-10-16 Thread Larry Juncker
Ethan; If you are looping through your query, you would have something like this: CFLOOP Query="TotalRecord" CFIF TotalRecord.ID EQ 4 CFOUTPUT#TotalRecord.CurrentRow#/cfoutput /cfif This would work if the row number and record number were not the same. Larry

RE: row # in database??

2000-10-16 Thread Aaron Johnson
#query.currentrow# AJ I think this is a rather simple question How do I find the row # of a certain row of data in my database? Such = that I can say "this is record 3 of 10". =20 I know the query.recordcount function to get the 10 as a seperate query = for all records in that

RE: row # in database??

2000-10-16 Thread Steve Martin
cf_madscrambletobethefirsttoanswerbutlikelythefourteenth #queryname.CurrentRow# -Original Message- From: Ethan Rosch [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 17:42 To: CF-Talk Subject: row # in database?? This is a multi-part message in MIME format.

RE: Extra records in CSV file generation

2000-10-16 Thread Paul Johnston
Well, have you checked there are no empty records in the db at all? Paul PS I assume you have, but it's only polite to ask! -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 16 October 2000 17:11 To: CF-Talk Subject: RE: Extra records in CSV file generation

delete records that are more than two days old

2000-10-16 Thread wpdd
This is a multi-part message in MIME format. --=_NextPart_000_0099_01C03774.3F11D080 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm trying to delete all records that are more than two days old=20 I'm using an access data base=20 It

RE: acess =

2000-10-16 Thread Chapman, Katrina
Yeah. Send the message again so that we don't have to spend time decoding your mime formatted message. --K -Original Message- From: wpdd [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 9:47 AM To: CF-Talk Subject: acess = This is a multi-part message in MIME format.

RE: Coldfusion FreeLance Work websites?

2000-10-16 Thread Chapman, Katrina
I think that Fred means fusioneers.com. Note the "s". Fusioneers not Fusioneer. Am I right Fred? --K -Original Message- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: Friday, October 13, 2000 4:21 PM To: CF-Talk Subject: Re: FreeLance

RE: delete records that are more than two days old

2000-10-16 Thread Simon Horwith
try: Delete from DealerAuditTable Where DateRecordAdded #DateAdd(d, -2, now()) ~Simon -Original Message- From: wpdd [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 1:23 PM To: CF-Talk Subject: delete records that are more than two days old This is a multi-part message

RE: delete records that are more than two days old

2000-10-16 Thread Larry Juncker
Try this: Delete from DealerAuditTable Where DateRecordAdded #DateAdd('D', -2, now())# Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: wpdd [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 12:23 PM To: CF-Talk

number of occurances in a string

2000-10-16 Thread Peter Benoit
if I have a string like: My favorite colors are blue, green, and yellow. Is there a function I can use to count the number of commas? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe

RE: delete records that are more than two days old

2000-10-16 Thread Mark Johnson
Here is another way to do what you are trying completely with SQL. DELETE FROM DealerAuditTable WHERE DATEDIFF(day, DateRecordAdded, DATEADD(day,2,GETDATE())) 2 Mark -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 6:32 PM To: CF-Talk

Cold fusion Ressouces

2000-10-16 Thread Capolinea
This is a multi-part message in MIME format. --=_NextPart_000_0021_01C037AA.2F482880 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi! Sorry for the MIME type...here is a link on a zip file...containing 80 = links on Cold Fusion

RE: number of occurances in a string

2000-10-16 Thread Jaime Garza
cfset cnt=ListLen("My favorite colors are blue, green, and yellow.")-1 Jaime/ -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 10:37 AM To: CF-Talk Subject: number of occurances in a string if I have a string like: My

Stripping Body of Mail

2000-10-16 Thread [EMAIL PROTECTED]
Hi! Does anyone know if there is a way to strip certain text out of the body of an email with Coldfusion? CFMAIL? CFPOP? CFWHATEVER? The concerned text is well defined with brackets. We use OReilly Webboard, and it has a great email digest function. But it sends out usernames and user email

Re: delete records that are more than two days old

2000-10-16 Thread wpdd
tried that it did not work - Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, October 16, 2000 1:30 PM Subject: RE: delete records that are more than two days old Try this: Delete from DealerAuditTable Where DateRecordAdded

RE: Stripping Body of Mail

2000-10-16 Thread Aaron Johnson
Hey Andrew, Look into regular expressions. There are some great books out there on the subject. You may also want to check the CF Tag Gallery, which has a couple tags specifically aimed at parsing out email addresses. Aaron -Original Message- From: Andrew@Home [mailto:[EMAIL

RE: number of occurances in a string

2000-10-16 Thread Peter Benoit
Ahh, doesn't work with Semicolons... thanks! * -Original Message- * From: Jaime Garza [mailto:[EMAIL PROTECTED]] * Sent: Monday, October 16, 2000 1:45 PM * To: CF-Talk * Subject: RE: number of occurances in a string * * * cfset cnt=ListLen("My favorite colors are blue, green,

Re: [RE: number of occurances in a string]

2000-10-16 Thread double-down
change the delimiter in listlen() Peter Benoit [EMAIL PROTECTED] wrote: Ahh, doesn't work with Semicolons... thanks! * -Original Message- * From: Jaime Garza [mailto:[EMAIL PROTECTED]] * Sent: Monday, October 16, 2000 1:45 PM * To: CF-Talk * Subject: RE: number of occurances in a

Good CF Multi-user calendar application?

2000-10-16 Thread Andrea Wasik(CancerSource)
I am looking for a robust Cold Fusion based multi-user calendar that is easy to customize and easy to integrate w/other custom features. It should run on SQL Server. Cost is not as much of an issue as is the integrity of the code and the company that produced the code. A new user should be able

Finding Current Row Number RE: last message was sent html by accident....

2000-10-16 Thread Jann VanOver
CurrentRow As in #queryname.CurrentRow# (very poorly documented - don't blame you for not finding it! -Original Message- From: Ethan Rosch [SMTP:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 9:59 AM To: CF-Talk Subject: last message was sent html by accident This

RE: OT javascripts question

2000-10-16 Thread Jann VanOver
I don't know the answer to your question, but please remember that Java is NOT Javascript. A Java-enabled browser is NOT the same as a browser with JavaScript turned off. -Original Message- From: Seamus Campbell [SMTP:[EMAIL PROTECTED]] Sent: Sunday, October 15, 2000 2:18 AM To:

OT: IIS 4 Management Console MDAC 2.6

2000-10-16 Thread Todd Ashworth
I have IIS 4 installed on a Win NT 4.0 machine. Whenever I try to open the MS Management Console, I get an error saying that "the selected file could not be found". Has anyone run into this? I looked on MS' support site, but didn't find what I was looking for. I am guessing that uninstalling

RE: number of occurances in a string

2000-10-16 Thread Patricia Lee
cfset cnt = ListLen("My favorite colors are three; I have a hard time choosing." , ";") - 1 -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 2:14 PM To: CF-Talk Subject: RE: number of occurances in a string Ahh, doesn't work with

Re: number of occurances in a string

2000-10-16 Thread Jim McAtee
Because of the way Allaire chose to implement the list functions, this also doesn't work correctly if any of the desired characters are back-to-back, or at the beginning or end of the string, as in: ListLen("abc;;def;ghi;jklmn;;opqrstuv;wxyz;", ";") You'd want it to count 8, but it returns 6.

RE: number of occurances in a string

2000-10-16 Thread Patricia Lee
In that case, ListLen("abc;;def;ghi;jklmn;;opqrstuv;wxyz;", ";,;;") Notice, in the delimiters parameter I've specified ; and ;;. This returns 6. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 2:50 PM To: CF-Talk Subject: Re: number of

RE: number of occurances in a string

2000-10-16 Thread Patricia Lee
sigh you'll have to exuse me. my last post was quite obviously wrong -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 2:50 PM To: CF-Talk Subject: Re: number of occurances in a string Because of the way Allaire chose to implement the

RE: number of occurances in a string

2000-10-16 Thread Peter Benoit
Well I've gotten to the point where I can pull out the text, where should I look to placing each in a variable? * -Original Message- * From: Patricia Lee [mailto:[EMAIL PROTECTED]] * Sent: Monday, October 16, 2000 3:06 PM * To: CF-Talk * Subject: RE: number of occurances in a string

RE: number of occurances in a string

2000-10-16 Thread Dave Watts
Because of the way Allaire chose to implement the list functions, this also doesn't work correctly if any of the desired characters are back-to-back, or at the beginning or end of the string, as in: ListLen("abc;;def;ghi;jklmn;;opqrstuv;wxyz;", ";") You'd want it to count 8,

Re: Good CF Multi-user calendar application?

2000-10-16 Thread Marius Milosav
Hi Andrea, We have something that my interest you. It contains Calendar, Contacts and Time Tracking. It is in beta testing now. We expect to have it finalized by November. If you want to see a demo let me know Marius Milosav www.scorpiosoft.com Virtual Help Desk Demo (VHD)

RE: Good CF Multi-user calendar application?

2000-10-16 Thread Andrea Wasik(CancerSource)
Yes Marius I would be interested in seeing your demo. Thank you. -Andrea -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 3:33 PM To: CF-Talk Subject: Re: Good CF Multi-user calendar application? Hi Andrea, We have something that my

Re: Good CF Multi-user calendar application?

2000-10-16 Thread richard ten barge
I would be intersted too Richard ten Barge 1MB At 15:33 16-10-2000 -0400, you wrote: Hi Andrea, We have something that my interest you. It contains Calendar, Contacts and Time Tracking. It is in beta testing now. We expect to have it finalized by November. If you want to see a demo let me

CF browser detection???

2000-10-16 Thread Jeff Fongemie
CFOUTPUT query="GetNews" STARTROW="#the_start#" MAXROWS="3" if Netscape stupid browser,MAXROWS="6" if IE Obviously the above won't work, but is there something like this that will?? CFIF?? I don't want to use a javascript detection and redirect to a whole new page. Jeff

RE: CF browser detection???

2000-10-16 Thread Raymond K. Camden
Check the CGI.USER_AGENT variable. Of course, it's about as clear as mud, but you can parse the string to determine if the browser is NS or IE. === Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com) Allaire

RE: CF browser detection???

2000-10-16 Thread Doug Powell
You can use cfif HTTP_USER_AGENT CONTAINS "MSIE" code cfelse code /cfif -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 3:38 PM To: CF-Talk Subject: CF browser detection??? CFOUTPUT query="GetNews"

RE: CF browser detection???

2000-10-16 Thread Raymond K. Camden
I remember writing a string parser for this a while back, don't some MS browsers spell out the whole name? I want to say maybe some Mac versions? Oh, and it's CGI.HTTP_USER_AGENT. I forgot the HTTP. === Raymond Camden, Cold

RE: CF browser detection???

2000-10-16 Thread Doyle, Mike
Or...there is always the handy-dandy custom tag, CF_BrowserCheck! Here: http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=BROWSE RCHECKsearch=search Mike -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 3:38 PM To:

Re: SQL Server - MS Access Autonumber

2000-10-16 Thread Andy Peterson
Tim, Recently asked the same question regarding memo fields - specifically what the equivalent was of an Access memo field in SQL Server. Here are two of the many useful responses I received: "It's TEXT. The Unicode version is NTEXT." -and- "text. Max storage per field is in the gigabytes.

CFBROWSER check. You guys are great!

2000-10-16 Thread Jeff Fongemie
Hey, you guys are great. Thanks. This mail list is so handy. I hope I get good enough to help others soon! Jeff -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

Upgraded to 4.01 - Cannot set default query, HELP!

2000-10-16 Thread Kelly Britt
We have finally upgraded from 3.x to 4.01 on one of our servers, and we are now facing an error in our code that we cannot track down: Cannot set default query QUERYNAME: We have a query referenced in a cfloop and then a second query, second cfloop. But after the 2nd cfloop finished, we get

RE: number of occurances in a string

2000-10-16 Thread Jaime Garza
a. cfloop index="item" list="My favorite colors are blue, green, and yellow." cfset wherever=item /cfloop b. cfloop index="i" from="1" to="#ListLen('My favorite colors are blue, green, and yellow.')# cfset wherever=ListGetAt(i) /cfloop c. cfset anArray=ListToArray("My favorite colors are

cfinclude + cfform

2000-10-16 Thread Ethan Rosch
This is a multi-part message in MIME format. --=_NextPart_000_0092_01C03792.99A898D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to cfinclude a cffform, however it works great in = everything except Mac/Netscape (go

RE: cfinclude + cfform

2000-10-16 Thread John Anderson
You have a tag that is not closed like a table column or in input type.some type of error in the html code. It probably is unrelated to using an include. Scour your html and look for something that is not closed like a td or anything that might be invalid html. When netscape sees this it

RE: How Feasable Is This?

2000-10-16 Thread dougn
If everything goes to one IP which is CF-enabled, you should be able to parse this and probably (depending on the server) can get the host hame from the CGI variable for the URL requested (i.e. [EMAIL PROTECTED]) to help re-direct the user to the right location. --Doug -Original

validating an empty field in enctype=multipart/form-data

2000-10-16 Thread sebastian palmigiani
I want to be able to check that the user did not press the submit button without first choosing a file. I've got: --- ChooseFile.cfm --- form action="index.cfm?go=BatchUpdate" method="post" enctype="multipart/form-data" name="myForm" trtdinput type="file" name="UpdateFile" size="36"/td/tr

Re: cfinclude + cfform

2000-10-16 Thread Ethan Rosch
One bit I forgot to mention was that the form.cfm works by itself and the Survey.cfm (with the include) works without the include. It is only when I put the two of them together that it ceases to work Perhaps this is the point where my html error occurs? I shall continue!!! ethan -

Re: OT javascripts question

2000-10-16 Thread Hong
And is it worth worrying about non-java browsers these days (or people who turn off javascript in Netscape)?? Unless your targeted audience is everyone, you shouldn't worry about people turn off javascript. Since they cannot really do much in today's cyber world without JavaScript being turned

Re: cfinclude + cfform

2000-10-16 Thread Ethan Rosch
cfform cfinclude are in a div tag, will this effect me? sorry to give this info piecemeal, but I am just scouring my brain and spitting out possibilites... Thank you, Ethan Rosch - Original Message - From: "Ethan Rosch" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday,

  1   2   >