RE: What does this error mean?

2001-03-28 Thread Kevan . Windle
I got it once when the server was screwed and once when a duff sql query swallowed all server resources. -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: 27 March 2001 20:05 To: CF-Talk Subject: What does this error mean? I do not understand nor can I

RE: multilanguage site

2001-03-28 Thread DeVoil, Nick
Chad There have been 1 or 2 good threads on this, try starting at http://www.mail-archive.com/cf-talk@houseoffusion.com/msg16575.html -Original Message- From: chad jackson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:22 AM To: CF-Talk Subject: multilanguage site Hi

RE: Weird CFFile behaviour with Mac IE5 upload

2001-03-28 Thread Alex Skinner - Digital Dreams
Why not check the form field for the existance of a \ even if the form field is not "" is shouldn't contain a \ unless a file has been selected In addition check that the form field length is greater than 5 i.e valid 3 letter extenstion + the . + at least one \ HTH Alex -Original

RE: session variable storage

2001-03-28 Thread mahmad
can we use session variables without passing any information through URL ?when browser cookies are disabled on client side. waitnig for response ok Mumtaz

RE: session variable storage

2001-03-28 Thread Andy Ewings
You have to pass them through as hidden form variablesI think this is the only way. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net

RE: OT Network weirdness

2001-03-28 Thread Ian Tait
I guess you've looked at the routing tables on the NT box? Ian -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: 27 March 2001 17:04 To: CF-Talk Subject: RE: OT Network weirdness I would check the subnet mask to make sure it 'thinks' it can get to the other

Form Variables not being passed on selected machines

2001-03-28 Thread Craig . Wilson
All of a sudden, I have a situation where form variables are not being passed to the action template of a fairly basic form. Out of 300 users, I guess a handful of them get an error when the action template tries to evaluate the variables. I've checked the security settings in Explorer and they

RE: Form Variables not being passed on selected machines

2001-03-28 Thread Jason Lees (National Express)
Have you Checked that the form method is set to post? Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 March 2001 11:57 To: CF-Talk Subject: Form Variables not being passed on selected machines All

RE: Textbox validation

2001-03-28 Thread Kevan . Windle
Why not use the like operator as in SELECT A FROM B WHERE (((A) Like "*GUITAR*")); which would give any string with guitar in it. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 13:30 To: CF-Talk Subject: Re: Textbox validation Thanks for all the

RE: Form Variables not being passed on selected machines

2001-03-28 Thread Craig . Wilson
Yes, it works on the majority of the client machines. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: 28 March 2001 12:01 To: CF-Talk Subject: RE: Form Variables not being passed on selected machines Have you Checked that the form method is set

RE: session variable storage

2001-03-28 Thread mahmad
Sir If we are not using a form ,then what we will do for it. Best Regards Mumtaz Ahmad Andy Ewings

RE: session variable storage

2001-03-28 Thread Andy Ewings
You either have to put a form on the page with hidden fieds holding the cfid and token and submit the form via Javascript or pass the CFID and Token through the url. I don't know any other way -- Andrew Ewings Project Manager

RE: Form Variables not being passed on selected machines

2001-03-28 Thread JustinMacCarthy
Are you sure the field names are all legal ? You should log what you are getting as input if there is an error, at least then you can figure out the problem. Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 11:57 AM To:

RE: Weird CFFile behaviour with Mac IE5 upload

2001-03-28 Thread Daniel Lancelot
Problem is caused by MAC putting space in instead of an empty field - try using trim() when checking the field to see if it has been filled. -Original Message- From: Alex Skinner - Digital Dreams [mailto:[EMAIL PROTECTED]] Sent: 28 March 2001 10:46 To: CF-Talk Subject: RE: Weird CFFile

RE: What does this error mean?

2001-03-28 Thread Mary_Baotic
You can also get PCODE errors when you don't cflock variables. Especially session variables. Mary Kevan.Windle@

Special cahracters in replacelist

2001-03-28 Thread Ed Brown
I'm trying to carry our a replace of li and /li in a CFMAIL message so the web content is split by line breaks at the li and /li. I can carry out a replace using replacelist with normal characters such as a - but can't find a way to place a replacement of a newline character in the list. Is

RE: force download cfcontent;cfheader

2001-03-28 Thread Thomas Chiverton
Theres a bug in IE ( http://support.microsoft.com/support/kb/articles/Q279/6/67.ASP?LN=EN-USSD=g nFR=0qry=force%20downloadrnk=8src=DHCS_MSPSS_gn_SRCHSPR=IEP) that breaks this horrably, I could only get round it by doing a window.open(get.cfm) and having get.cfm send cfheader name="Content-type"

layered security

2001-03-28 Thread Janine Jakim
I need to make a "layered"login to a secure site. We are using a SQL2000 database on Windows2000 machine. I assume that I will have the user authenicate through the active directory and be recognized as being part of a "group" and sent to a specialized menu. (am I correct in that

RE: Form Variables not being passed on selected machines

2001-03-28 Thread Adam Reynolds
They wouldn't be using IE5 and pasting text content in from Word? I had a problem with older versions of IE5 causing problems with Unicode pasted from Word. I wrote a javascript routine that looped through any text and removed certain unicode characters. Adam -Original Message- From:

Re: Special cahracters in replacelist

2001-03-28 Thread Mark Woods
use #chr(13)##chr(10)# This corresponds to Carriage-return line-feed, which is the new line sequence for SMTP At 12:51 PM 3/28/2001, you wrote: I'm trying to carry our a replace of li and /li in a CFMAIL message so the web content is split by line breaks at the li and /li. I can carry out a

RE: Weird CFFile behaviour with Mac IE5 upload

2001-03-28 Thread JustinMacCarthy
Actually IE5 on Mac adds a return char to every form fields... Justin -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 12:52 PM To: CF-Talk Subject: RE: Weird CFFile behaviour with Mac IE5 upload Problem is caused by MAC putting

RE: layered security

2001-03-28 Thread Lamon, Alec
Janine, It sounds like you won't need a second login. Since you know the teacher ID after the first login, can't you run a dynamic query that displays only those students that attached to a particular teacher ID? Perhaps I'm misunderstanding your scenario Alec -Original

RE: output

2001-03-28 Thread Larry Juncker
Becky wrote: cfoutput query="qryUpEquip" option value="#empID#"#lname# #fname# /cfoutput /select Becky, what about this? OPTION VALUE="#emp_ID#" CFIF empID = qryUpEquip.empIDselected/cfif#lname# #fname# I did not test it,

Re: Special cahracters in replacelist

2001-03-28 Thread Ed Brown
Mark, use #chr(13)##chr(10)# Thanks. Work - great. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

Re: multilanguage site

2001-03-28 Thread Kenneth Tyler
Hi guys, Our client has requested that we do our website in several languages... however I am unsure how to go about it regarding the database structure . What database are you using ? One thing to consider is that the way you store the data and the way you get it on your

RE: Form Variables not being passed on selected machines

2001-03-28 Thread Marian Dumitrascu
I had this problem once when I used CF4 with IIS4 with Integrated Windows Authentication and no Anonymous Access and for form using ENCTYPE="multipart/form-data". After i switched back to anonymous access everything worked fine. - Marian GYRATE Internet Solutions 242 West 30th Street 14th FL

CFCookies and the network

2001-03-28 Thread Smith, Daron
I use CFCOOKIE to set a cookie at logon for a member's only site, it has worked fine for a couple of years. Now it seems like people who are accessing the site from within the same network already have the cookie set for another person who accessed the page from the same network. These

RE: layered security

2001-03-28 Thread Mike Sullivan
Janine, This sounds like a design issue. If you have control of (or if you get work out) the relationships, then there won't be any need for a tiered login, just use the attributes of the teacher-class-student relationship to control access. Mike -Original Message- From: Janine

CFCONTENT in CF4 and CF4.5

2001-03-28 Thread Miriam Hirschman
Hi, Can someone please tell me the change in the way the CFCONTENT tag works in CF4 and CF 4.5. Meaning, in CF 4.0 the excel file that I am creating looks fine. The each field is in a separate cell. However, when running off a 4.5 server all the fields are attached and are displayed in one

RE: CFCookies and the network

2001-03-28 Thread Dave Watts
I use CFCOOKIE to set a cookie at logon for a member's only site, it has worked fine for a couple of years. Now it seems like people who are accessing the site from within the same network already have the cookie set for another person who accessed the page from the same network. These

Verity

2001-03-28 Thread Raley, Scott M (MIL)
Is there a good guide/doc out there about how Verity works? I need to explain to someone how Verity searches documents. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Re: CFCookies and the network

2001-03-28 Thread Jeffry Houser
What cookie values? Are you using the ColdFusion created CFID and CFTOKEN cookies? Did you change servers recently? I have heard of problems where the server was changed and people were accessing someone else's data, because the CFID / CFTOKEN from the old machine had also been

RE: layered security

2001-03-28 Thread Garza, Jeff
Take a look at using views. You can assign permissions to the view and have it select only those students that belong to that teacher. That way you won't have the added security on the second table. Is this what you were looking for??? Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc.

Re: Verity

2001-03-28 Thread Dave Hannum
Try our tutorial done by Judith Taylor at the MOVCFUG meeting earlier this month. She did a very fine job! www.movcfug.org Find the link down on the left. Dave - Original Message - From: "Raley, Scott M (MIL)" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March

Re: CPU 100%

2001-03-28 Thread W Luke
CFMAIL and Spooler have a bug We've had all sorts of problems with cfmail and high CPU usage levels - it's notoriously buggy :( Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your

EJB's and CFOBJECT.....

2001-03-28 Thread Richard Kuryk
Is anyone successfully using EJB's in a production environment. We have our cold fusion server setup to talk to a web logic server and it works great if only one user is accessing the page. When we refresh the page, we start to receive java exceptions. We have seen this under two different

cftry/cfcatch wrapper?

2001-03-28 Thread stas
Hello, Has anybody written a custom tag that makes using cftry/cfcatch less cumbersome while still providing good error reporting? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at

CFMAIL

2001-03-28 Thread Savan Thongvanh
any word of improvement on CFMAIL in CF5? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

RE: cftry/cfcatch wrapper?

2001-03-28 Thread Dave Watts
Has anybody written a custom tag that makes using cftry/cfcatch less cumbersome while still providing good error reporting? I'm not sure what this would entail. Personally, I don't think exception handling is especially cumbersome - although it is kind of verbose. Dave Watts, CTO, Fig Leaf

RE: CFCONTENT in CF4 and CF4.5

2001-03-28 Thread Dave Watts
Can someone please tell me the change in the way the CFCONTENT tag works in CF4 and CF 4.5. Meaning, in CF 4.0 the excel file that I am creating looks fine. The each field is in a separate cell. However, when running off a 4.5 server all the fields are attached and are displayed in one

RE: cftry/cfcatch wrapper?

2001-03-28 Thread mjones
attempted it long ago, i seem to remember that you couldn't seperate cftry and /cftry so, where you would place the try with the beginning of the tag, it would not find the ending try because it was processed with the ending of the custom tag -Original Message- From: Dave Watts

RE: CFCONTENT in CF4 and CF4.5

2001-03-28 Thread Miriam Hirschman
Why does it look fine on my hard drive?? And not when it is running off the CF 4.5 Server. Thnaks for your help. Here is my code: CFSETTING enablecfoutputonly="Yes" htmlbody bgcolor="White" cfquery name="qryGetSummary" datasource="csesdr" dbtype="ODBC" #Form.txtSql#

OT: javascript add problem

2001-03-28 Thread Bernd VanSkiver
Sorry about the OT question, but am stumped as to why this won't work. Trying to use JavaScript to add the numbers in form fields together, instead of adding them, it is appending them to each other. Here is my code: script language="JavaScript" function AddToBasket() {

Chat application

2001-03-28 Thread ychen
Additional Header Information: Received: from www.houseoffusion.com ([207.31.122.140]) by inside.pgi.com (Lotus SMTP MTA v4.6.6 (890.1 7-16-1999)) with SMTP id 85256A1D.0058ED2A; Wed, 28 Mar 2001 11:11:19 -0500 Received: from houseoffusion.com ([207.31.122.140]) by

RE: javascript add problem

2001-03-28 Thread DeVoil, Nick
Multiply each number by 1 first. Then the JS interpreter will know they're numbers not strings. Nick -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:13 PM To: CF-Talk Subject: OT: javascript add problem Sorry about the OT question,

Re: OT: javascript add problem

2001-03-28 Thread Savan Thongvanh
try this script language="JavaScript" function AddToBasket() { OrderBooks.TotalQty.value = 0; OrderBooks.TotalQty.value = String(OrderBooks.SW.value) + String(OrderBooks.SP.value); } /script ~~ Structure

RE: javascript add problem

2001-03-28 Thread Hayes, David
The form field values are text, so it's concatenating them. Try the javascript parseInt() function. -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 10:13 AM To: CF-Talk Subject: OT: javascript add problem Sorry about the OT question,

RE: javascript add problem

2001-03-28 Thread Craig Dudley
+ is for concatenating strings (spelling?) ++ will add them up i think. -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: 28 March 2001 17:13 To: CF-Talk Subject: OT: javascript add problem Sorry about the OT question, but am stumped as to why this won't work.

OT: applications or background services?

2001-03-28 Thread Jay Patton
Sorry for the OT, quick question, does anyone know if the programs that are running in the task bar (by the clock) are applications or are they running as background services? Thanks, Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e.

Re: OT: javascript add problem

2001-03-28 Thread Savan Thongvanh
duh. "Savan Thongvanh" [EMAIL PROTECTED] on 03/28/2001 10:21:37 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc:(bcc: Savan Thongvanh/DSM/Seabury) Subject: Re: OT: javascript add problem try this script language="JavaScript" function AddToBasket()

Re: [RE: javascript add problem]

2001-03-28 Thread Bernd VanSkiver
The parseInt() function works great for it, thanx! "Hayes, David" [EMAIL PROTECTED] wrote: The form field values are text, so it's concatenating them. Try the javascript parseInt() function. -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

VERITY TIPS ETC.

2001-03-28 Thread Robert Orlini
I know this may have been asked already, but does anyone know a good site (or URL) that has tips, tricks, and good info on setting up CF's Verity Search engine. Thanks. Robert O. ~~ Structure your ColdFusion code with Fusebox. Get the official

Replacing ALL url vars with ONE

2001-03-28 Thread James Maltby
I seem to remember about 6 months ago someone talking about "hiding" a range of variables by using one variable that linked to a data table holding the others. Something like replacing: template.cfm?id=xinclude=ymenu=zsound=on with template.cfm?var=1234 Where var called a table holding: id,

RE: cfugmay2000 :: VCalendar :: Outlook :: Help Needed

2001-03-28 Thread Paul Ihrig
ok i have been playing with the code. but i get an error every time i submit to my own app.. error in outlook Could not import Vcalendar File. any ideas. !--- Outlook Calendar Event Form Page --- fieldset legendMicrosoft Outlook Calendar Event Downloader/legend form

RE: applications or background services?

2001-03-28 Thread Dave Watts
does anyone know if the programs that are running in the task bar (by the clock) are applications or are they running as background services? They're applications, although those applications may be used as interfaces to services. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/

CF4.00 on Windows 200 Professional

2001-03-28 Thread Gordon Burns
I know that Allaire does not support CF4 or 4.1 W 2000 Prof but I think someone on this list mentioned that had it working. Can anyone assist with a fix. It is for development only on my new Dell Laptop. We have one server running 4.1 so I need this to work if possible. Thanks Gordon

RE: javascript add problem

2001-03-28 Thread Hayes, David
++ is the increment operator. -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 10:27 AM To: CF-Talk Subject: RE: javascript add problem + is for concatenating strings (spelling?) ++ will add them up i think. -Original Message-

Query boggle

2001-03-28 Thread John Wilker
Hey guys and gals, This is probably something I'm just not seeing clearly but the below query is supposed to bring my back a count of records grouped by sex. I've been staring at this query so long I'm not seeing anything. It finds the right records. The data I have has a male and a female

RE: CF4.00 on Windows 200 Professional

2001-03-28 Thread Dave Watts
I know that Allaire does not support CF4 or 4.1 W 2000 Prof but I think someone on this list mentioned that had it working. Can anyone assist with a fix. It is for development only on my new Dell Laptop. We have one server running 4.1 so I need this to work if possible. I had CF 4.0.1

Extract info from attachments of Outlook email

2001-03-28 Thread Larry Juncker
HELP I have written a template that will extract bad email addresses from returned emails from a CFMail mass send. My problem is that the divisions that are getting these emails returned to them are sending them to me as an attachment to a forwarded email. How can I (Or can I) open these

RE: Query boggle

2001-03-28 Thread Hayes, David
It's your FROM statement; you're not joining counties, districts, schools and histories in any way, so you're getting a cartesian product set. You need some join qualifiers along the likes of vv1_Counties INNER JOIN vv1_districts on vv1_districts.countyID = vv1_Counties.countyID (or whatever

RE: Query boggle

2001-03-28 Thread Bob Silverberg
With all those tables in there, you may be getting a lot more records than you expected. Your current syntax will return a count of the number of records in the joined structure, not a count of the number of unique ChildID's. If that's what you want, change it to COUNT(DISTINCT

RE: javascript add problem

2001-03-28 Thread dennis baldwin
It sounds like your values are being recognized as strings vs. expressions. if they are strings the + sign will concatenate them. if they are expressions then + will add the two together. cut and paste the following scripts into a page and run them: script language="JavaScript" fred="5"

query trouble

2001-03-28 Thread Jon Tillman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I cannot for the life of me figure out what is wrong with this query. I am getting a Syntax Error or Access Violation Error: cfquery name="setup" datasource="#application.dsn#" INSERT INTO tblClient (ClientTemplateID, ClientDomain,

see a problem with this code?

2001-03-28 Thread Tim
I have a pre-filled form for users to change a record. The form calls an action page to update the record. I keep getting the dreaded error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE

RE: One record query output

2001-03-28 Thread Philip Arnold - ASP
Hi, I'm trying to find out if it's possible to limit the output of a query to one record. I have a database that is sorted in decending order and I only want the top record (the one with the biggest total) to display. I can do a work-a-round by setting a variable to "on" before the query

RE: javascript add problem

2001-03-28 Thread Philip Arnold - ASP
Sorry about the OT question, but am stumped as to why this won't work. Trying to use JavaScript to add the numbers in form fields together, instead of adding them, it is appending them to each other. Here is my code: script language="JavaScript" function AddToBasket() {

(NROT) Dynamic Tournament Brackets

2001-03-28 Thread Eric Dawson
Not Really Off Topic, but kinda. I have been trying to figure out a way to dynamically generate tournament brackets. Any good reading on data structures for tournaments? Code? Examples? Bascially answer simple questions: number of teams, tournament format (eg single game elimination). 4

RE: Query boggle

2001-03-28 Thread Bryan Love
The problem is most likely that you are using an implicit cartesian join on these three tables: vvl_Counties , vvl_districts, vvl_schools, since they are not in the WHERE clause. Remove them and you should get the desired results

Re: CF4.00 on Windows 200 Professional

2001-03-28 Thread Howie Hamlin
Here's some information from Tom Bruser (Jan 14, 2000) === Apparentally this was an install issue and not a runtime issue. The CF installer (for 4.0) failed to enter the registry settings for the services. I put these in manually, and all appears to

CFLDAP and SSL

2001-03-28 Thread Frank Gragnano
Here's one for the truly gifted. So far I have had no response from any of the forums at Allaire or my local user group. I even spammed all the Team Allaire members about it and received no response. Anyone with any info at all, even if it's "I don't know", would be greatly appreciated.

Re: query trouble

2001-03-28 Thread Becky Brewer
What type of field is the "ClientNew" field? Some databases store "yes" values as 1's or 0's - maybe you are mixing data types. ~Becky Jon Tillman wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I cannot for the life of me figure out what is wrong with this query. I am getting a

Re: [see a problem with this code?]

2001-03-28 Thread Alex
the last comma Tim [EMAIL PROTECTED] wrote: I have a pre-filled form for users to change a record. The form calls an action page to update the record. I keep getting the dreaded error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC

RE: see a problem with this code?

2001-03-28 Thread Patricia Lee
Two things... It would help it you'd also post the SQL that the database is trying to read. You can get this from the debug output. Second thing... Your date should probably be formatted with the CREATEODBCDATETIME() function conf_date = #CreateOdbcDateTime(Form.conf_date)# |-Original

Re: see a problem with this code?

2001-03-28 Thread Daniel H
Take out the last , on your set (comments = '#form.comments#') HTH Dan CFQUERY NAME="qDoUpdate" DATASOURCE="teleconference" UPDATE data SET conf_name = '#Form.conf_name#', conf_purpose = '#Form.conf_purpose#', conf_date = #Form.conf_date#, occurance = '#Form.occurance#', begin_time

Re: see a problem with this code?

2001-03-28 Thread Marius Milosav
remove the , after the comments = '#Form.comments#', and it should work Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Tim" [EMAIL PROTECTED] To: "CF-Talk"

RE: Survey: Web-based WYSIWIG editing tool

2001-03-28 Thread Philip Arnold - ASP
If you use a web-based WYSYWIG editing tool, what do you use? OK, below are our opinions of the products; 1) ActiveEdit (www.cdev.com) Support is VERY patchy, they same something can't be done, but I've done it... I seem to know more about the product than they do on some matters - they

RE: see a problem with this code?

2001-03-28 Thread Robert Orlini
Not sure how you may have this worked out but, maybe #Form.conf_date# needs single quotes as well? RO -Original Message- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 12:50 PM To: CF-Talk Subject: see a problem with this code? I have a pre-filled form for

Re: see a problem with this code?

2001-03-28 Thread David E. Crawford
You have an extra comma after the '#form.comments#', just prior to the WHERE clause. DC - Original Message - From: "Tim" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 13:50 Subject: see a problem with this code? I have a pre-filled form for users

RE: see a problem with this code?

2001-03-28 Thread ron
I have looked backward and forward, checked spelling, quotes, etc., and can't figure out the problem. I figureed it was time for a new set of eyes. Is there something about this that I am missing: comments = '#Form.comments#', WHERE ID = #Form.ID# Remove the trailing comma before your

session management

2001-03-28 Thread Savan Thongvanh
anyone seen a good article online about session management? I've tried a few common places. had trouble finding one even on sys-con.com. sheesh. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: CFLDAP and SSL

2001-03-28 Thread Steve Bernard
What version of CFAS as you using? Secure LDAP, as well as HTTPS, have only been available since CFAS 4.5.x. Steve -Original Message- From: Frank Gragnano [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 2:00 PM To: CF-Talk Subject: CFLDAP and SSL Here's one for the truly

RE: cfugmay2000 :: VCalendar :: Outlook :: Help Needed

2001-03-28 Thread Paul Ihrig
ok i have got it down to my description being what throughs an error. if i remove it , it is fine. but i want it there. it is from a memo field? any ideas thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED]

Re: query trouble

2001-03-28 Thread Jon Tillman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 28 March 2001 02:05 pm, you wrote: What type of field is the "ClientNew" field? Some databases store "yes" values as 1's or 0's - maybe you are mixing data types. ~Becky tis a yes/no field using Access2000 if that helps (sigh) -

Re: applications or background services?

2001-03-28 Thread Jay Patton
thank you! Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 10:34

RE: CFLDAP and SSL

2001-03-28 Thread Steve Bernard
As per the docs ... "For CFSSL_BASIC, you must also specify the CFLDAP attributes USERNAME and PASSWORD to authenticate yourself. V2 then encrypts the password prior to transmission." These were missing from your query. " ... CFLDAP ACTION="QUERY" NAME="results" ATTRIBUTES="o,ou"

RE: see a problem with this code?

2001-03-28 Thread Philip Arnold - ASP
I have a pre-filled form for users to change a record. The form calls an action page to update the record. I keep getting the dreaded error: Another problem you might run into is apostrophies in your fields - if someone enters one in their entries, then your SQL will spit I'd personally

Statement Help!!

2001-03-28 Thread Jay Patton
what i am trying to accomplish here is to show ONLY those contestants that have 2 or more DIFFERANT EventID's in the ResultsManager (table in my SQL7 DB) (example: if they do the same event in every rodeo for the year they should NOT show up, but if they do 2 or more they should) the following

RE: see a problem with this code?

2001-03-28 Thread Peter J. MacDonald
The reason that should not be there is because that is how the SQL parser knows what the next Object is, a column or a command argument. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable:

RE: session management

2001-03-28 Thread Bryan Love
this mailing list is your absolute best source for information. Ask and learn :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Savan

cfstored procedure- NEWbie

2001-03-28 Thread Greenberg, Lisa
I am trying to get a result set back from SQLSERVER using the following stored procedure. I know I should get a recordcount 0 ( I checked this in Enter. Manager). However when I execute this stored procedure the rowcount I get a value of '0'. What am I doing wrong? CFSETTING

RE: CFLDAP and SSL

2001-03-28 Thread Frank Gragnano
What version of CFAS as you using? Secure LDAP, as well as HTTPS, have only been available since CFAS 4.5.x. Steve My second reply. (Something screwy with my mail). CF Server is 4.51 with SP2. Studio is 4.5 w SP2. I saw your previous comment about the user and pass. But I am connecting

RE: query trouble

2001-03-28 Thread Hayes, David
Here are my standard steps for dealing with tough query problems: 1) View the CF-generated SQL statement by turning on debugging (or by just cfoutput -ing the code instead of cfquery -ing it. 2) Look at the generated statement for obvious errors. 3) Try to run the generated SQL directly in

CF Job

2001-03-28 Thread flavia montezuma
Hey ALL; CF Developer available. Ft. Lauderdale, Boca Raton, Tampa . available to work telecommuting as well. tks --- Adam Reynolds [EMAIL PROTECTED] wrote: They wouldn't be using IE5 and pasting text content in from Word? I had a problem with older versions of IE5 causing problems

RE: see a problem with this code?

2001-03-28 Thread Andrew Tyrone
But Phil... In my experience, ColdFusion escapes the apostrophes automatically. Also, the one time I had a problem with apostrophes, was when I was using Evaluate() on some form fields (can't remember the reason -- it was quite a while ago!) which made ColdFusion NOT escape single quotes

RE: Statement Help!!

2001-03-28 Thread Hayes, David
What results are you getting? Take a look at the DISTINCT COUNT function, instead of the COUNT function. This should take care of the same eventID in different rodeos. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 2:09 PM To: CF-Talk

RE: Statement Help!!

2001-03-28 Thread Bob Silverberg
What happens if you change the COUNT(EventID) to COUNT(DISTINCT EventID)? Bob -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: March 28, 2001 3:09 PM To: CF-Talk Subject: Statement Help!! what i am trying to accomplish here is to show ONLY those contestants that

RE: cfugmay2000 :: VCalendar :: Outlook :: Help Needed

2001-03-28 Thread Paul Ihrig
got it. 250 character max on memo field for description. very nice example the dc cfug put together. !--- Add To MS CAlenddar - --- cfquery name="OutlookAdd" datasource="edu" SELECT * FROM tbl_Calendar, tbl_Class, tbl_Program, tbl_Room WHERE tbl_Calendar.CalendarID

RE: cfstored procedure- NEWbie

2001-03-28 Thread Bob Silverberg
I notice a few things (don't know if they are causing the problem, but I noticed them): 1. I don't think you should be putting the @ sign on the names of your variables in your cfprocparam tag. (Change dbvarname="@ZIP" to dbvarname="ZIP". 2. In one cfprocparam tag you are surrounding the value

RE: Weird CFFile behaviour with Mac IE5 upload

2001-03-28 Thread Cameron
The weird thing is that without doing any client side verification (Javascript), there's no way of stopping the file upload, AFAIK. It seems to me that CF sees that MacIE has sent a file along, which is saves as a tmp file, returns the tmp file in the form field. So even if the field is empty

  1   2   >