RE: Re: cffileACCEPT attribute

2000-06-01 Thread Dave Watts
Will this work? cffile action="upload" destnation="c:\temp" accept="GIF,JPG" I did try it but again it was allowing file of any type to be uploaded. You have to specify the MIME types exactly. You might want to get a list of MIME types, if you don't already know them. I've included a

Jumping Sessions??

2000-06-01 Thread Michael Grundvig
I have a very interesting issue I would like to ask you all about. At work, we recently released a "poll" program that allows people to choose what type of job they would like to get. Sort of like pre-applying for either a new/your current job (hey, I dont come up with these ideas, I just

Strange CF Error Message

2000-06-01 Thread Eldo Lukman - Monitor
Hi CFers, We're running an e-commerce site on 2 Dell PowerEdge servers using Cold Fusion, VB COM Objects, Microsoft Transaction Server, and SQL Server 7. The site is now in live-testing phase, and we get this error message every now and then, most frequently when the site is accessed for

TEST

2000-06-01 Thread Les Mizzell
Sorry, Previous mail did not go through. Testing. Les Mizzell *** Who needs Intel? Athlon Inside!!! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit

Re-setting frames/pdf files

2000-06-01 Thread Elizabeth Marcotte KJ
This is a multi-part message in MIME format. --Boundary_(ID_pi7mAtNrV68mOSn3aPqKfQ) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: QUOTED-PRINTABLE Hello everyone, I have a multi-part problem/question to you gurus out there: We have a template with 2 frames which

CF Training?

2000-06-01 Thread Christine Kelley
This is a multi-part message in MIME format. --=_NextPart_000_0009_01BFCB33.E53B42A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all! I have read CFWACK4.0 cover to cover (along with doing all the = exercises) and am starting on

Re: [Re: personal oracle 8i]

2000-06-01 Thread Irwan Sampurna
Thanks. So you are saying that I must install the personal oracle server and personal oracle client in the same machine, and configure the CF server to connect to the database using sql net from oracle personal client? Irwan "Larry Meadors" [EMAIL PROTECTED] wrote: I got it working. Did you

Re: I want my #$# on the first of the month.

2000-06-01 Thread Nick Slay
From memory... CreateODBCDate( CreateDate(Year(Now(), Month(DateAdd("m", 1, Now())), 1)) At 16:32 31/05/00 -0400, you wrote: I have been on a 23 hour coding spree to finish up a project. How do you create an odbc date value for the first of next month? I thought i had it but something

Re: I want my #$# on the first of the month.

2000-06-01 Thread Jim McAtee
Find the current month, create a date for the first of this month, then add one month to that date. #CreateODBCDate(DateAdd("m", 1, CreateDate(Year(Now()), DatePart("m", Now()), 1)))# Jim -Original Message- From: Timothy C. Hill [EMAIL PROTECTED] To: [EMAIL PROTECTED]

RE: I want my #$# on the first of the month.

2000-06-01 Thread Elizabeth Marcotte Selphcotte
I am not guru - but try this - cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput hope that does the trick. Elizabeth -Original Message- From: Timothy C. Hill [mailto:[EMAIL

Re: open window (JS)

2000-06-01 Thread David Hannum
In the A HREF tag do this: A HREF="Javascript:void()" onClick="function()"" Dave - Original Message - From: Jason Egan [EMAIL PROTECTED] To: Cf-Talk [EMAIL PROTECTED] Sent: Wednesday, May 31, 2000 2:08 PM Subject: open window (JS) I am trying to open a image preview

RE: I want my #$# on the first of the month.

2000-06-01 Thread Elizabeth Marcotte Selphcotte
I am not guru - but try this - cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput hope that does the trick. Elizabeth -Original Message- From: Timothy C. Hill [mailto:[EMAIL

pdf and frameset

2000-06-01 Thread Elizabeth Marcotte Selphcotte
This is a multi-part message in MIME format. --Boundary_(ID_zEdQwEwGCXBXy1lOfLDriA) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: QUOTED-PRINTABLE Hello everyone, I have a multi-part problem/question to you gurus out there: We have a template with 2 frames which

Re: I want my #$# on the first of the month.

2000-06-01 Thread Kevin Marshall
Tim, jeez, I hope you figured this out by now but if not... cfset thismonth = Now() cfset nextmonth = DateAdd("m", 1, thismonth) cfset NMyear = DatePart("", nextmonth) cfset NMmonth = DatePart("m", nextmonth) cfset NMday = 1 cfset finalval = CreateODBCDate(CreateDate(NMyear, NMmonth,

Query Question

2000-06-01 Thread Olson, Kelly
Hi All, I am having a heck of a time conceptualizing this query. I basically have two tables I am working with one is a Company Database with beside address and contact have a check box field that is labeled PRIVATE (YES/NO). I also have a database of records that have an items of which there

Re: I want my #$# on the first of the month.

2000-06-01 Thread Eric Dawson
note sure of the syntax exactly. date(year(date) + (month(date)=12), mod(month(date),12)+1,1) From: "Timothy C. Hill" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: I want my #$# on the first of the month. Date: Wed, 31 May 2000 16:32:45 -0400 I have been on a

Re: I want my #$# on the first of the month.

2000-06-01 Thread Judah McAuley
Not very elegant, but here it is... cfset new_date = #CreateODBCDate(Evaluate(Month(Now())+1)'/1/'Year(Now()))# Currently outputs: {d '2000-06-01'} Good luck. Judah At 04:32 PM 5/31/00 -0400, Timothy C. Hill wrote: I have been on a 23 hour coding spree to finish up a project. How do you

browser detection

2000-06-01 Thread Britta Wingenroth
Anyone know of a way to write a statement like this that works? This is the idea: I need to write an "if" statement based on if netscape is being used. I would like to use the HTTP_USER_AGENT like this: cfif HTTP_USER_AGENT IS NOT "" cfif HTTP_USER_AGENT LIKE '%netscape%' put netscape

Re: OT: Sql for selecting date ranges

2000-06-01 Thread Kevin Marshall
Shawn, Sounds like BETWEEN should work for you: SELECT foo... FROM bar... WHERE adatefield BETWEEN #firstdateval# AND #seconddateval# You'll want to be careful if your adatefield contains time data - not sure how that would affect query results - though the query will run. hth, Kevin At

Forcing a page to refresh on back-up

2000-06-01 Thread Erika Foster
I sure hope someone's still awake! I'd like a page to refresh if a user uses his/her "back" button to get to it. I don't want the previous form information filled in once they've submitted, then backed up. I searched for an easy solution tonight, but must have been looking in the wrong places,

Gold Points CF site

2000-06-01 Thread Scott Beach
Hey gang- I'm trying to get hold of anyone currently working on the Goldpoints.com site. Thanks. Scott Beach [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit

CFSCRIPT

2000-06-01 Thread Nick Slay
Is it more efficient to use CFML scripting rather than tags? For example, I have some code that loops and does some calculations. At the moment I have this using lots of CFSET and CFLOOP tags... would it be quicker to put all this inside a CFSCRIPT tag. Thanks

RE: Lost Data

2000-06-01 Thread Frank Priest
This does not sound good You probably truncated your tables. At this point my only hope of recovery would be advice from Dave Watts:-) -Original Message- From: ldang {Lily Dang} [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 12:18 To: '[EMAIL PROTECTED]' Subject: RE:

Re: Another question on performance

2000-06-01 Thread Dick Applebaum
If the "extra fields" are computed from other fields in the SQL query and/or external data (known at the time of the query), you might consider computing these fields as part of the SQL query itself... using scalar functions or T/SQL statements (SQL Server). From what I have

Testing - Delete Me!!

2000-06-01 Thread Kevin Queen
Last one did not make it this is a test Sorry ;-} -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL

RE: Forcing a page to refresh on back-up

2000-06-01 Thread Rob Sherman
Someone passed this along to me and it seems to work: CFSET Offset="-12" CFHEADER NAME="Expires" VALUE="#DateFormat(DateAdd('h',offset,Now()), 'dd mmm ')# #TimeFormat(DateAdd('h',offset,Now()), 'hh:mm:ss')# GMT" CFHEADER NAME="Pragma" VALUE="no-cache" CFHEADER NAME="cache-control"

RE: CFSCRIPT

2000-06-01 Thread Philip Arnold - ASP
Is it more efficient to use CFML scripting rather than tags? For example, I have some code that loops and does some calculations. At the moment I have this using lots of CFSET and CFLOOP tags... would it be quicker to put all this inside a CFSCRIPT tag. OK, here's how CFScript works speed

RE: CFSILENT not working?

2000-06-01 Thread Philip Arnold - ASP
I tried using cfsilent to suppress the output of an ArrayAppend() function, and CF server yelled at me. =) Apparently it doesn't recognize the tag, which sort of goes along with the fact that CF Studio doesn't try to autocomplete when I type cfsil Anyone else have this problem? Both

RE: Query Cache Limit Question

2000-06-01 Thread Ken Wilson
Finally, I'd like to point out that many kinds of "what if" questions, commonly asked on the list, are best answered with five minutes of testing. Perhaps Allaire could also take this approach when writing their docs? :) From the current v4.5.1 Online Docs regarding Cache Settings in CF

RE: pdf and frameset

2000-06-01 Thread Don Cuniff
Elizabeth; If I understand your objective correctly, one option would be to make the original frameset into two frames ("top" and "bottom"). Write a separate 2-frame frameset (your columns) "left" and "right" and load it, by default, into "bottom." When running your HREF out of "right", you

RE: I want my #$# on the first of the month.

2000-06-01 Thread Mary Jo Sminkey
I love threads like this, always interesting to see what people come up with. Just wanted to correct this one (and at least one other person that did something similar). cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)#

RE: Query Question

2000-06-01 Thread mherbene
select company, item fromcompanies, items where companies.company = items.company and companies.private = 'NO' and items.item = 600 i think.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 11:06 PM To: [EMAIL

stats

2000-06-01 Thread vinicius
Hi there! I'd like to create an application to generate stats of my site. First (to count the number of visits) I thought I could do something like this: In the application.cfm I increment a DB column everytime, but, within this I'll increment that number for every page request, I'd like to

Re: I want my #$# on the first of the month.

2000-06-01 Thread Tom Nunamaker
cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput You can't just add 1 to the current month...what happens when it is December? You do indeed need to use the DateAdd function to do

stats

2000-06-01 Thread vinicius
Hi there! I'd like to create an application to generate stats of my site. First (to count the number of visits) I thought I could do something like this: In the application.cfm I increment a DB column everytime, but, within this I'll increment that number for every page request, I'd like to

shopping cart?

2000-06-01 Thread jmentzer
Hi I'm looking to do my first shopping cart w/ CF. As the merchant for whom the site is being built doesn't accept credit cards, "submit order" is simply going to send a few emails and store some records in the database. Can anyone give me a few pointers on the best way to do this? Would

Creating PDF

2000-06-01 Thread Olson, Kelly
This may have been asked, or even easy to do but; Can you create a pdf file and have it created with cf data? What does it take to to do this? Kelly -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe

RE: browser detection

2000-06-01 Thread Lon Lentz
From: Britta Wingenroth [mailto:[EMAIL PROTECTED]] This is the idea: I need to write an "if" statement based on if netscape is being used. I would like to use the HTTP_USER_AGENT like this: cfif HTTP_USER_AGENT IS NOT "" cfif HTTP_USER_AGENT LIKE '%netscape%' This is IE: Browser

RE: I want my #$# on the first of the month.

2000-06-01 Thread Robert Everland
Or you could try this, maybe I'm crazy just seems easier FirstDayOfMonth( date). Love the old 4.0 documentation, bookmarks anyone remember those, is Allaire ever gonna give em back in the 4.5 documentation. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From:

Re: Jumping Sessions??

2000-06-01 Thread Deanna L. Schneider
The one time I've seen this happen was when the server admin didn't do a complete uninstall of an earlier version of cf server before upgrading. Somehow, there were two sets of session variables, and the variables didn't _really_ get set until the second time. (So, people had to double log in,

RE: browser detection

2000-06-01 Thread Chris Evans
[en] stand for English. I think the (compatible;) is what differentiates. You may want to look into CFX_Browserhawk from the developers exchange. That is a custom tag to determine browser versions. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Lon

Re: CFParam and radiobutton array validation

2000-06-01 Thread Sima Lee
Hi Troy, I am not sure that my experience with a checkbox column in a query will give you some idea. The query could have any number of records so every column is like array of fields. I had a query which dynamically created using the information from a user submitted form. In that form there

Re: [Re: personal oracle 8i]

2000-06-01 Thread Larry Meadors
Exactly! ;-) [EMAIL PROTECTED] 06/01/00 09:11AM Thanks. So you are saying that I must install the personal oracle server and personal oracle client in the same machine, and configure the CF server to connect to the database using sql net from oracle personal client? Irwan "Larry Meadors"

RE: CF Training?

2000-06-01 Thread Kevin Langevin
You've already got a great set of technologies under your belt. That's a good start. I've taken the FT course already, and I strongly advise taking it if you're serious about ColdFusion as a career. A fair amount of what the course covers is stuff that you've already done throughout the book

SQL7 + CF studio pb !

2000-06-01 Thread Francis NART
I'm brand new to SQL server 7 and I have a little pb. Each time I want to access my tables through CF studio in the database Tab, I only get the system tables and not the one I created manually. I get an error when I try to access those newly created tables. Using the SQL server query analyser

JS ListFind

2000-06-01 Thread Duane Boudreau
Hi All, Does anyone here know of a JavaScript function to similar to ListFind? Duane Boudreau, Project/Beta Manager, eMPower Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 Fax: 603-594-0258

RE: Jumping Sessions??

2000-06-01 Thread Dan G. Switzer, II
Mike, Are you running a cluster of servers by any chance? If so, you'll have to use sticky sessions in order to ensure the user doesn't get delegated to a server other then the one they started off being connected to. If you're using a cluster, you should be able to use Client variables w/a

Re: Forcing a page to refresh on back-up

2000-06-01 Thread Joel Richards
Put these tags at the beginning of the file you don't want cached: CFHEADER name="expires" value="0" Cfheader name="Cache-Control" value="no-cache" cfheader name="Pragma" value="no-cache" At 11:59 PM 5/31/00, you wrote: I sure hope someone's still awake! I'd like a page to refresh if a user

Re: CF Training?

2000-06-01 Thread John Westerlund
Join a startup or any firm that will take you as a web developer (HTML, CFML, SQL, VB, etc). Ideally they will already have a senior CF developer that you can pick up a few things from. You'll want to get at least 12-18 months under your belt after which you can pick which company you want to

Re: shopping cart?

2000-06-01 Thread Ric Smith
CFTRANSACTION refers to database transactions not shopping transactions. Although the first time I saw it the first thing that popped into my head was credit card transactions. Sounds like what you're doing is pretty simple. A few CFMAIL's and an INSERT and your order is placed. The more

Re: Gold Points CF site

2000-06-01 Thread Ric Smith
If you get in touch with them tell them to make that image on the left a jpeg, that 93k gif is nasty. Sorry, i couldn't help myself. --Ric Smith - Original Message - From: Scott Beach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 01, 2000 1:20 AM Subject: Gold Points CF

RE: Another question on performance -- better than lists?

2000-06-01 Thread Mike Amburn
ok... so when it comes to performance, it's better to use strutctures than arrays and both of those are better than lists. i thought lists were always fastest. is this not true? when did this happen? mike --

RE: Debug info - can one limit it...

2000-06-01 Thread Dave Watts
1) Can you restrict it to a range of IPs in any way other than entering in each single IP? Unfortunately, no. 2) Can you, in the code in a particular page, instruct the server NOT to display debug info for that particular page? Yes. You can use the CFSETTING tag: CFSETTING

Re: Jumping Sessions??

2000-06-01 Thread Michael Grundvig
First off thanks for the responses and the suggestions thus far. To answer the questions: Is their a proxy server being used? 1. Not that I know of, but a proxy DOES reside on the intranet and I assume it could be possible all web requests are going through it or through our intranet firewall,

RE: Query Cache Limit Question

2000-06-01 Thread Dave Watts
Finally, I'd like to point out that many kinds of "what if" questions, commonly asked on the list, are best answered with five minutes of testing. Perhaps Allaire could also take this approach when writing their docs? :) From the current v4.5.1 Online Docs regarding Cache Settings in

Is there a typical cause for this error message?

2000-06-01 Thread Steve Weiner
Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of

Application Variables Questions

2000-06-01 Thread Bob Smith
I have two Applications "App1" and "App2" on my ColdFusion Server4.5 in separate directories. I have defined corresponding DSN's for these applications which are "App1DSN" and "App2DSN". The Appliction Names and corresponding DSN's are defined in their corresponding Application.cfm files in their

Replacing line breaks and paragraph breaks with HTML equivelents

2000-06-01 Thread Lee Moore
Hi all, I'm currently working on building a fully threaded message board. Progress is going well however I'm having a minor problem. I'm trying to replace user enter line breaks with br tags but I'm not having any luck. Here is what I've tried, ReplaceNoCase(strClean, "br", Chr(13),"ALL") What

Re: browser detection

2000-06-01 Thread Mike Hughes
Hello Britta, I use this code to detect the browser on the server side, it may work for you -- code CFSET ApprovedBrowsers = "IE,NS" CFSET BrowserOS = "" CFSET BrowserType = "NS" CFSET BrowserVersion = -1 CFSET BrowserVersionMajor = -1 CFSET

Re: SQL7 + CF studio pb !

2000-06-01 Thread Lee Moore
I'm not exactly a guru but it sounds like the login info specified in your ODBC connection being used in CF studio does not have the proper permissons set up to see those particar tables. You might try going into sql enterprise manager and double clicking on the table you want to see. There you

Webserver and ColdFusion mappings

2000-06-01 Thread Aidan Whitehall
Can anyone shed a little light on webserver and ColdFusion mappings? Whilst a site is being developed I set up a webserver and ColdFusion mapping on the PC such as /newsite/ which points to the d:\websites\newsite\website\ directory. Then, you can browse to

cfadminsecurity tag

2000-06-01 Thread Marcello Frutig
Hi! I've been playing with cfadminsecurity tag with some success. I'm still trying to define the realms, which maps to the resource types enabled for a security context. The information saved into the realm table of SiteMinder seems to be ok, but when I open the security context page from CF

CFMAIL Spooling Time..

2000-06-01 Thread Angél Stewart
Hello folks, Someone informed me of a new parameter for CFMAIL that would allow me to change the time that messages stayed in the Mail Spool on the server, enabling me to set this value. I've checked in the New Features for 4.5.1 CF Professional, and I haven't seen any mention made of this. Do

RE: open window (JS)

2000-06-01 Thread Jason Egan
Thank you, thank you, thank you... I didn't realize void() was an option... thanks! It works perfectly! Jason Egan Konnections, INC. -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 10:39 PM To: [EMAIL PROTECTED] Subject: Re: open window

MsSQL7 problem backing up on tape

2000-06-01 Thread Brian Silvers
hi everyone, I am running MsSQL 7 sp2 on a standalone box with a HP Colorado 8 Gig internal IDE tape drive. The scheduler w/MsSQL has been working but when I try to restore or do a manual backup to the tape drive I get this: Microsoft SQL-DMO (ODBC SQLState 42000) The media family on device

Re: Jumping Sessions??

2000-06-01 Thread GE
Hello, I had a very similar thing happen to me (I just started learning CF about 3 weeks ago so take this with some salt): I set debugging on for my IP address. After running the application a couple of times I found that my SQL queries were working with the wrong info ( I also had another

RE: Cflocation inside of a cftransaction

2000-06-01 Thread Dave Watts
In one of my pages I have a few insert queries that I run inside of a cftransaction. Depending on the results I did have a cflocation tag to redirect them to a outcome page. They would get redirected fine, but the insert queries would not run properly, as in they wouldn't write to the

recordset in string to INSERT query

2000-06-01 Thread Robert M. Saxon, Jr.
This is probably a no-brainer... Through CFHTTP, I acquired a list of Java Applet parameters. I parsed this string down to a recordset of over 100 records. How do I write this recordset (Each field is delimited by a TAB, each record by CRLF) to an existing database table with the same number

Slightly OT

2000-06-01 Thread Jeffrey Cohen
Does anyone have experience with homesite? I need to recommend a SIMPLE wysiwyg editor to a customer of mine. Is Homesite Wysywyg or an HTML editor?, and if it's html, can anyone recommend a simple wys...editor BESIDES front page? Thanks, Jeffrey Cohen ImageWorks

office COM

2000-06-01 Thread Jason Egan
I’ve seen mentioned earlier on the list using MS Office products as COM objects == can anyone point me towards more information on this? Is it server extensions only available in 2k? Thanks, je -- Archives:

Update Query

2000-06-01 Thread Miriam Hirschman
How can I specify which row in my table I want to update if the user has the ability to change every field. Is there any way besides making an autoNumber field? I have an Access DB. Thanks,   ---miriam -- Archives:

query help - find duplicates

2000-06-01 Thread Adrian Cesana
Im trying to create a primary key and cannot because I have a few duplicate entries. There should not be any so I am trying to find them. The key consists of 2 fields(po,line), Im trying to run a query that will only display the duplicates, this is what Im trying. SELECT po,line from table

Re: CFSILENT not working?

2000-06-01 Thread KChapman
What do you mean that the server yelled at you? Do you mean an error message was displayed? If so can we see it? --K Katrina Chapman Consultant Ameriquest Mortgage

OT: Post Time

2000-06-01 Thread Shane Pitts
Just curious, is it a known fact that when you post something to this list, it doesn't show up for about 5 hours? or is it something else. Seems like every time I have posted anything in the past that is a reply to someone else, it shows up about 5-6 hours later Shane

Re: I want my #$# on the first of the month.

2000-06-01 Thread Angél Stewart
Oh Geez! hee hee hee You're right..FirstDayOfMonth IS a function. ;-P Anyways..the code examples were nice all the same I guess ;-P -Gel - Original Message - From: Robert Everland [EMAIL PROTECTED] Or you could try this, maybe I'm crazy just seems easier FirstDayOfMonth( date).

CFHTTP

2000-06-01 Thread Allen G
Does a CFHTTP request work when the file is on the same exact server? TIA. == - == == - ==== - == Allen Graetz USI - Web Application Programmer 1-800-USINTERNET x241 612-253-3241 -- Archives:

Re: Another question on performance -- better than lists?

2000-06-01 Thread Seth Petry-Johnson
i thought lists were always fastest. is this not true? when did this happen? It is my understanding that lists are stored in memory as string values, and that looping through a list (or direct access of a specific list element) ultimately results in a character-by-character iteration through

RE: Is there a typical cause for this error message?

2000-06-01 Thread Olive, Christopher M Mr USACHPPM
yes. it's usually seen when you try to insert into a TEXT field in the DB that is too short for the value being insert. ex, inserting the string "Hello world" into a CHAR(4) field. Chris Olive, DOEHRS Website Administrator -Original Message- From: Steve Weiner [mailto:[EMAIL

RE: Is there a typical cause for this error message?

2000-06-01 Thread Robert Everland
Yeah your field name is too small for the data you want inserted in it. In other words check the size of your fields or maybe you switched a couple variables by accident that happened to me one time, spent an hour trying to figure out why it was giving me this message when all the sizes were

Re: Is there a typical cause for this error message?

2000-06-01 Thread Jennifer
At 10:43 AM 6/1/00 -0400, you wrote: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an

RE: Replacing line breaks and paragraph breaks with HTML equivelents

2000-06-01 Thread Dave Watts
I'm currently working on building a fully threaded message board. Progress is going well however I'm having a minor problem. I'm trying to replace user enter line breaks with br tags but I'm not having any luck. Here is what I've tried, ReplaceNoCase(strClean, "br", Chr(13),"ALL") If

RE: Replacing line breaks and paragraph breaks with HTML equivelents

2000-06-01 Thread Perez, Bismark
switch around the position of the br and Char(13) -Original Message- From: Lee Moore [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 11:03 AM To: ColdFusion Discussion List Subject: Replacing line breaks and paragraph breaks with HTML equivelents Hi all, I'm currently

RE: Is there a typical cause for this error message?

2000-06-01 Thread Robert Forsyth
the string you are trying to insert/update is larger than the column allows. -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 10:43 AM To: '[EMAIL PROTECTED]' Subject: Is there a typical cause for this error message? Error Occurred While

RE: Replacing line breaks and paragraph breaks with HTML equivelents

2000-06-01 Thread Pablo Nevares
Here's an option from the Docs: - ParagraphFormat Returns string with converted single newline characters (CR/LF sequences) into spaces and double newline characters into HTML paragraph markers (P). - I wish they'd do one that replaces single newline characters with BR, but maybe that's

Re: Is there a typical cause for this error message?

2000-06-01 Thread Joel Richards
You are trying to insert data that has too many characters for the database field. Increase the allowable size of the field in the Database, or else limit the number of characters allowed to insert into the field by using the "Maxlength" attribute in your form field (assuming it is a text

Re: Is there a typical cause for this error message?

2000-06-01 Thread Lee Surma
ODBC Error Code = 22001 (String data right truncation) You may have single quotes around a number or a date. -- Lee Surma Public Radio International [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk

Re: Jumping Sessions??

2000-06-01 Thread Greg Saunders
At 07:55 PM 5/31/00 -0500, Michael Grundvig wrote: ... Now here is the problem; We released this to the public yesterday. It seems to work great, but early this morning the errors rolled in. LOTS OF EM. After some diagnosing, we determined all the errors we related to one problem, session

RE: Replacing line breaks and paragraph breaks with HTML equivalents

2000-06-01 Thread Duane Boudreau
Try: ReplaceNoCase(strClean, Chr(13), "br", "ALL") From CF Docs: ReplaceNoCase(string, substring1, substring2 [, scope ]) string Any string. substring1 String to be replaced. substring2 String that should replace occurrences of substring1. scope Defines how to complete the replace operation:

RE: Is there a typical cause for this error message?

2000-06-01 Thread Chris
Yes. Your input data is too long for the database column. You should really validate inputs for length (and type, too). E.g. if you had a varchar(64) column called Title, do this: ... cfif Len(Trim(form.title)) GT 64 ... output an error msg to the user ... cfelse

Re: Is there a typical cause for this error message?

2000-06-01 Thread KChapman
The data that you're trying to input into the field is too long. Either increase the size of the field or reduce the length of the data. --K Katrina Chapman Consultant Ameriquest Mortgage

RE: Is there a typical cause for this error message?

2000-06-01 Thread Aaron Johnson
The size of the form field or data field you are inserting is larger than the size of the field you have created in SQL server. Aaron -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 7:43 AM To: '[EMAIL PROTECTED]' Subject: Is there a

Re: Replacing line breaks and paragraph breaks with HTML equivelents

2000-06-01 Thread Lee Moore
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 01, 2000 1:03 PM Subject: RE: Replacing line breaks and paragraph breaks with HTML equivelents If you're trying to replace carriage returns with BR tags, you've got

RE: Replacing line breaks and paragraph breaks with HTML equivelents

2000-06-01 Thread Chris
You just have the arguments backwards. This is the fix: ReplaceNoCase(strClean, Chr(13), "BR", "ALL") -Original Message- From: Lee Moore [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 8:03 AM To: ColdFusion Discussion List Subject: Replacing line breaks and paragraph

RE: Another question on performance -- better than lists?

2000-06-01 Thread Chris Evans
I just ran some tests, and was surprised by the results. Caveats: 1) These are simple looping tests, and only give a general idea of speed. YMMV. 2) Use the most reasonable variable type for the job. Converting a list to an array to use array functions may negate any performance gains you

Re: Replacing line breaks and paragraph breaks with HTML equivelents

2000-06-01 Thread Serge Ohotin
I believe that you have the two strings mixed up. In your code, every "br" is replaced with Chr(13), not the other way around... Hope I'm reading it right... Serge - Original Message - From: Lee Moore [EMAIL PROTECTED] To: ColdFusion Discussion List [EMAIL PROTECTED] Sent: Thursday,

RE: Is there a typical cause for this error message?

2000-06-01 Thread Lon Lentz
From: Steve Weiner [mailto:[EMAIL PROTECTED]] Subject: Is there a typical cause for this error message? [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. Is the data you are inserting longer than your column width? Lon Lentz Applications

RE: Is there a typical cause for this error message?

2000-06-01 Thread Philip Arnold - ASP
Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. The error occurred while processing an element with a general identifier of

RE: Is there a typical cause for this error message?

2000-06-01 Thread Sean German
Yes, A typical cause is the data being inserted too long. Check the length of the column in the database and your data validation. HTH Sean -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 10:43 AM To: '[EMAIL PROTECTED]' Subject: Is

Re: shopping cart?

2000-06-01 Thread Jeff W
Look at Web monkey, they have a nice tutorial on how its done; http://hotwired.lycos.com/webmonkey/99/49/index4a.html?tw=programming Ben Fortas book has another example in it. There are a couple others floating around that I can't remember, and there might even be an app on Allaires developers

Re: CF logins, authenticate against Novell NDS???how?

2000-06-01 Thread Lanny R. Udey
Don't forget LDAP with NDS. With NDS8 and CF 4.5 it is blazingly fast and 4.5 supports SLDAP for security. Lanny Larry Meadors [EMAIL PROTECTED] Wednesday, May 31, 2000 We've used NDS for NT and basic authentication. That works pretty well because the NDS users get replicated as NT users.

  1   2   >