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
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
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
can we use session variables without passing any information through URL
?when browser cookies are disabled on client side.
waitnig for response
ok
Mumtaz
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
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
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
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
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
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
Sir
If we are not using a form ,then what we will do for it.
Best Regards
Mumtaz Ahmad
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
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:
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
You can also get PCODE errors when you don't cflock variables. Especially
session variables.
Mary
Kevan.Windle@
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
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"
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
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:
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
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
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
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,
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/
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
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
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
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
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
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
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
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
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.
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
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
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
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
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:
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
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
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
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#
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()
{
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
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,
try this
script language="JavaScript"
function AddToBasket()
{
OrderBooks.TotalQty.value = 0;
OrderBooks.TotalQty.value = String(OrderBooks.SW.value) +
String(OrderBooks.SP.value);
}
/script
~~
Structure
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,
+ 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.
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.
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()
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,
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
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,
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
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/
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
++ 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-
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
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
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
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
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
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"
-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,
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
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
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()
{
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
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
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
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.
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
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
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
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
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"
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
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
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
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
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
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
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]
-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)
-
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
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"
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
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
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:
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
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
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
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
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
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
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
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
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
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
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 - 100 of 145 matches
Mail list logo