After uploading the file to the server, use the CFHTTP tag to read it
into a query. You can then process a row at a time.
CF has no facility to read a file a line at a time.
HTH
Dick
At 11:02 AM +0530 11/29/00, [EMAIL PROTECTED] wrote:
>Hello,
> In my application, the user has to uploa
I have this query that I am passing form fields to and it keeps giving me
errors... It worked before but now it just crashed out from under me please
help here is the query and the error:
INSERT
INTO adoption
(
date_placed, dept_course, crn, estima
--=_297852799==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
For the cute off time, type typing:
Where posting_time> ###cut_off_time###
The reason is because Dates in SQL need to be entered like: #10/10/2000#,
however with coldfusion, variables are surr
Thansk everyone for the help!
At 10:48 AM 11/29/00 +1100, Andrew Scott you wrote:
>Yes they can, all you need to do is cfinclude the previous application.cfm
>from the root dir and the child will be able to use any variable scope...
>
>
>
>-Original Message-
>From: Anthony Geoghegan [mai
Refer to the cgi variable cgi.auth_user. It will contain both the domain
name and the username as in: MYNTDOMAIN\bob
Jim
- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 5:43 PM
Subject: CF and IIS
> Hi,
>
> Does
Hello,
In my application, the user has to upload tabular data to the server
I tried the CFFILE tag but then I get all the data only in 1 variable. How
do I split the data so that I can read data from fields.
Also, how do I read 1 row at a time ?
Thanks,
Regards,
Sachin Malvadkar
~~
I'm trying to access an Allaire Forums application and receiving the
HTTP/1.0 404 Object Not Found Error. It indicates that it can't find the
template in an include statement in the application.cfm file. When looking
at that file, here is the code that it is choking on:
Is there suppose to
Hi!
I downloaded evaluation copy of CF enterprise and tried to do a clustering,
but ClusterCAT asked me about some licence. Doesn't mean that I cannot play
with clustering on evaluation version? What does it mean "licence" for
ClusterCAT. It looks like we have to buy a licence for every new clust
This is what happens when non
programmers pick up programming .. we miss some of the basics along the
way. I'm try to run a conditional select based on the age of the time the
entry was made into the dB (posting_time) .. specifically I plan to offer
the user a form to select all entries made afte
Does anyone know of an elegant way to detect if the client browser's
javascript and cookies are enabled? Preferably in one file...
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Simon Park Computer Systems Management, Inc.
Ph: 703-823-4300 x119 205 South Whiting Street #20
> >if there are 2 applications on a CF Server, is there one or two sets of
> >CFTOKEN/CFID cookies? is it possible to tell CF to create 2 separate
sets
> >of cookies?
>
> There will be a set for each domain name that has setclientcookies
> set to "yes" in a cfapplication tag.
what if both are i
Try
instead of
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Monday, 27 November 2000 11:41 PM
To: CF-Talk
Subject: Radio Buttons
Hi,
I have a number of Radio buttons that I need to use in conjunction with
on submitting the form, to determine their values, and
Do you have the full version, and if so whats the difference between the 2
Thanks
Michael
John Anderson wrote:
> There is an application that will generate your statements for you from the
> database.
> It is here:
> http://www.aloha-webdesign.com/sqlgen
>
> John
>
> -Original Message-
Does anyone know what the command line parameters to open a file in CFStudio
through a command line? Im thinking it's something like this at the command
prompt...
C:\Path to Studio\>cfstudio45.exe /f C:\path to file\file.cfm
Mainly I am looking for the the flag that is used to pass a file, I'm
a
Hi,
Does anyone know how to have CF query IIS in order to grab the login name of
someone who has logged into a website, via IIS? The alternative for me would
be to set up a webpage based log in screen that coldfusion controls and grab
the info that way, but I am exploring the IIS option first.
- Original Message -
From: "Daryl Fullerton" <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 8:18 PM
>
> I ask the same of discussion Forums Applications V Allaire Forums.
I am using CFForums 3.1 from ForumSpot.org, and I find it excellent - very
highly featured and very customisab
Yes they can, all you need to do is cfinclude the previous application.cfm
from the root dir and the child will be able to use any variable scope...
-Original Message-
From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]]
Sent: Monday, 27 November 2000 10:49 PM
To: CF-Talk
Subject: RE: App
I would be very suspicious about this, if you do a query and no records are
returned the recordcount will always hold 0 The only posssible solution
is that the query is not being called.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 28 November
I have a CF based events calendar I am modifying and need to delete events
older than 30 days from the Access database. What would be the simplest
way to set this up. Should be relatively simple but my brain is dim at the
moment.
Thanx in advance,
Chris
~
yeah it works. check out www.planetaccess.com. works fine.
-Original Message-
From: Jake Hileman - Patmos [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 12:29 PM
To: CF-Talk
Subject: Re: CFMAIL Fails to Send
Has anyone had any success getting the REPLYTO var to work and act
I am looking for a robust Cold Fusion based multi-user calendar that is easy
to customize and easy to integrate w/other custom features. It should run on
SQL Server. Cost is not as much of an issue as is the integrity of the code
and the company that produced the code. A new user should be able cr
This sounds like a stupid newbie question (is the newbie stupid or is it the
question?) but I'm bonking my head against my monitor right now...
Take a look at the code down below. Two CFMAIL things. The first sends an
email with no carriage returns -- everything's on one line (that wraps). The
se
For a forum, I find that cfforum 2000 is easy to set up and use.
http://www.cfcode.com or [EMAIL PROTECTED]
> Which CF Chat Room application is the best on the Market at the moment.
>
> I ask the same of discussion Forums Applications V Allaire Forums.
>
>
Actually no.. It's not set to load anything. Just takes forever. ;(
Lee
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 28, 2000 12:39 PM
> To: CF-Talk
> Subject: Re: CFStudio - Takes forever to load...
>
>
> On my P3-500 it takes abou
This may be too simple . . . getting started with VSS and trying to work
through some problems we are having with the admin tool, so I want to delete
the databases that have been created and start over. Is it as simple as
deleting the directories that were created? I can find nothing in the MS
d
> Anyone know why this is? We're using the latest 4.5.1, and it simply
takes
>about 3-4 minutes to load up. Hmm...
Just a thought, but do you have the 'Startup' folder set to an RDS location
or some mapped network drive?
Sincerely,
Rob Sherman
Allaire Certified Developer & Instructor
CFDud
I've found that if Studio defaults to a network drive on startup (I guess
that could also include a project on a network share), then it can take
forever to get going.
If it startsup local, it's quick.
Jeremy
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, No
On my P3-500 it takes about 10 seconds at most, and on my Athlon 550 it
takes slightly less. Maybe you have studio set up to open the last project
you were working on? Ever since Studio 4.5 the whole projects thing has been
horrendously slow. I have projects that take longer than 4-5 minutes to lo
Anyone know why this is? We're using the latest 4.5.1, and it simply takes
about 3-4 minutes to load up. Hmm...
Lee
+-+
Leaving list: Mailto:[EMAIL PROTECTED]
Message BODY: leave website-talk
Problems: Help file Mailto:[EMAIL PROTECTED]
F
The only time I've had recordcount undefined is when 1) the query was
somehow invalid OR
2) the CFQUERY didn't contain a SELECT but instead did an INSERT or UPDATE.
I suggest you look more closely at your query to ensure it has no "hidden"
problems.
-Original Message-
From: [EMAIL PROTE
Has anyone had any success getting the REPLYTO var to work and actually put
the replyto email address in it as it's value?
I wrote a webmail program.. and I can't make a reply page because I can't
grab the replyto address.
I'm using CF 4.5.1 SP2 on RH 6.2 Linux and CF Pro.
Any help?!
jake
This is a multi-part message in MIME format.
--=_NextPart_000_0065_01C05978.5013DB00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all.
We are developing a large discussion site for online mentoring mainly CF =
based
Which CF Chat Roo
> We had some similar problems with CF 4.5.0. as there are know bugs with
> CFMAIL in that version. Apparently Allaire re-wrote the CFMAIL tag from
> scratch and didn't catch all the bugs. Upgrading to 4.5.1 seemed to do fix
> the problems.
Dang it all. I've had this problem before too, but I was
Nope. CF doesn't return any error to the sender. Just chokes and throws
everything into undeliverable.
I wrote an app that scours the undeliverable folder for the culprit
messages. It's pretty effective if you'd like the code.
-Original Message-
From: ryo watanabe [mailto:[EMAIL PROTECTE
Are there spaces in your From address? I've known of a but where the mail
would fail to send in such cases. I do not know if this is supposed to have
been fixed yet... but you can put it on your list of possible culprits.
> -Original Message-
> From: Sean Daniels [mailto:[EMAIL PROTECTE
Would "from" adress get the error message when this happnes?
> Used to be, if someone tried to send one email to 40+ recipients, CF would
> barf. Unfortunately, it would stuff ALL subsequent mail sent through CF
into
> the undeliverable folder whether it was truly undeliverable or not.
~
We had some similar problems with CF 4.5.0. as there are know bugs with
CFMAIL in that version. Apparently Allaire re-wrote the CFMAIL tag from
scratch and didn't catch all the bugs. Upgrading to 4.5.1 seemed to do fix
the problems.
Simon Park
Sean Daniels [mailto:[EMAIL PROTECTED]] wrote:
> I a
What version of CF?
Used to be, if someone tried to send one email to 40+ recipients, CF would
barf. Unfortunately, it would stuff ALL subsequent mail sent through CF into
the undeliverable folder whether it was truly undeliverable or not.
-Original Message-
From: Sean Daniels [mailto:[
In a sendmail server the uid can be set
using an included comma.
frex;
uid = 'O,!!l?^"!+]o"!Iie"!
This ends up being transmitted to sendmail as
'O
The truncation must be happening within CFAS,
so ---
when using action = delete
how to escape (or otherwise convert)
these values so sendmail reco
I am using an SMTP service running on the local machine to send outgoing
mails. In the CFAdmin the server verifies fine. But when I send an email it
gets stuffed into Undeliverable folder and the mail.log says it was unable
to connect to the SMTP server.
Anyone have any suggestions? According to
I like Jan Harrington's "SQL Clearly Explained"
~Simon
> Simon Horwith
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
>
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sen
"Teach yourself SQL in 10 Minutes" by Ben Forta
http://www.forta.com/books/
It's a good introductory / reference book on SQL. It's very handy and
should help you. It's written for the developer.
Sincerely,
Rob Sherman
Allaire Certified Developer & Instructor
CFDude, Inc. http://www.cfdude.c
I'd recommend just a couple of good references.
Forta's SQL book is excellent; for an easy read try SQL for Dummies; SQL
for Smarties gets really deep, and is a must-have once you get the
basics down; if you're using SQL Server, my personal favorite is
Coffman's SQL Server 7: The Complete Referen
THanks a lot.
CF array should do it.
I will come back with more problems soon :-)
laszlo
Dylan Bromby wrote:
>
> WML does not support arrays.
>
> But why don't you store them in a CF array? WAP browsers choke on URLs that
> are too long so don't go that route.
>
> You could also use WDDX.
>
>
There is an application that will generate your statements for you from the
database.
It is here:
http://www.aloha-webdesign.com/sqlgen
John
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 10:47 AM
To: CF-Talk
Subject: SQL statements
Is th
Hi all
A friend who's not on cf-talk asked me to post this:
Thanks!
* john *
Hello everyone.
Has anybody experienced an issue with Microsoft Internet Explorer 5.5
locking up when trying to process a cookie established in your standard
application.cfm?
This error occurs consistently, even wit
Is there any good classes on SQL statements? Creating my CFQUERY's is
taking me way to long because i keep mistyping and formatting the SQL
statements incorrect
Any good books on the subject? Especially ones that deal directly with
CFQuerys?
Thanks
~
are you doing a cflocation after you set the cookie?
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 1:36 PM
To: CF-Talk
Subject: I'm too dumb to set a cookie!
Isn't it just
?
I can't make it set! My debugging data continues to s
Isn't it just
?
I can't make it set! My debugging data continues to show just cftoken and cfid for
cookies!
YEEARRRGH!
Are there any special settings in administrator that inhibit cookies? Something like
that?
Willy
~~
Structure you
I like your definition and would like to add it to the HoF info for the
mailing lists if I may.
As for this thread, while its a very important topic and one that we all
have to deal with, I'd like to move it over to the CF-Community list as it
is rather OT for CF-Talk. Thanks
I hope this is appr
you may need to turn off it's interact with desktop settings in the Windows
Services settings (in the control panel) and then recycle the services.
Also, make sure you're using the RC version as opposed to the original beta.
There were a lot of errors reported that were fixed by this. Of course,
What is the "" bug?
- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 1:23 PM
Subject: Re: CF SP2 ?
> Noticed high memory usage, but that sure beats the people killing the
entire
> server with the "" Bug!
>
> Neil
Tried what you said below and I keep on getting an error that says it cannot start the
internet service and number
3 next to it.
Dave Watts wrote:
> > I want the Inetpub directory to be on another drive other
> > then C:, when attempting to do this we crash or it just
> > wont work at all. Do
CFAS 4.5.1sp2 didn't update CFDOCS completely.
No info on the new tag attributes or functions.
Is this oversight on Allaire's part or is there some
voo-doo I've yet to doo-doo?
Specifically:
Though mentioned in the release notes
the following weren't updated in the
docs.
Docs don't reflect fix
None at all. I do have some problems with the docs and the new struct
functions, but I'll just write my own anyway. :)
> Anyone having problems with the Cold Fusion Service Pack 2 (specifically
> Enterprise)?
>
>
> Sincerely,
>
> Rob Sherman
> Allaire Certified Developer & Instructor
> CFDude, I
Noticed high memory usage, but that sure beats the people killing the entire
server with the "" Bug!
Neil
- Original Message -
From: "Rob Sherman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 3:20 PM
Subject: CF SP2 ?
> Anyone having problems w
> I am not completely understanding. Would you mind giving an
> example of the behavior that no longer works?
Well, if you don't understand it, you're probably not using it!
Anyway, though, here's an example of using CFCONTENT with and without "fake"
URLs:
http://www.figleaf.com/demo/mimetest/
I am not completely understanding. Would you mind giving an example of
the behavior that no longer works?
Much appreciated,
Kevin
>>> Dave Watts <[EMAIL PROTECTED]> 11/28/00 10:07AM >>>
> Are there still issues with CF and NT Service Pack 6a?
The problem with SP6 is that it changed how URLs
Anyone having problems with the Cold Fusion Service Pack 2 (specifically
Enterprise)?
Sincerely,
Rob Sherman
Allaire Certified Developer & Instructor
CFDude, Inc. http://www.cfdude.com
(310) 543-1622 (310) 543-0512
~~
Structure your ColdFusi
You have to make a project. That's the only way to do searches over rds...
> -Original Message-
> From: j p [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 28, 2000 1:05 PM
> To: CF-Talk
> Subject: Studio: am I missing something
>
>
> doing a find and replace on a remote server (r
There's a CF-Talk news server mirror at fuseware.com. I've just put a news
server into place a House of Fusion, but its limited to Fusebox at the
moment due to 'live testing'. It'll be up for the CF-Talk and all other
lists within the week.
Please note that this is not a replacement for the fusewa
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01C05966.8660D670
Content-Type: text/plain;
charset="iso-8859-1"
Is there a news server address i can point a reader at instead of
if you can ru both servers on one machine (SQL Server 6.5 or 7, AND sybase)
or on machines that can talk to each other, you should be able to do an
import from SQL Server. Right click on the server or databases folder in
SQL Server, go to all tasks, then import data. select the sybase driver
fro
doing a find and replace on a remote server (remote RDS or FTP)
is it possible?
_
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
~~
Str
> Are there still issues with CF and NT Service Pack 6a?
The problem with SP6 is that it changed how URLs are processed by IIS, which
will affect your use of the CFCONTENT tag if you're using "fake" URLs to
prompt the user to save a file with a specific name other than the name of
the script whic
I hope this is appropriate use of bandwidth. Every "enterprise" must carry
some overhead as a cost of remaining oriented towards their objective (like
accounting systems or annual meetings). So it is with mailing lists as well.
While Michael as list owner makes the final decision, I suspect he
Tried it, but they don't seem to be compatible. Thanks for the suggestion
though.
Rick
-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 11:30 AM
To: CF-Talk
Subject: RE: Dat files
I know SQL Server 6.5 did it's database backups with dat
> I want the Inetpub directory to be on another drive other
> then C:, when attempting to do this we crash or it just
> wont work at all. Does anyone know of a fix, or workaround?
> If someone has a site with some directions I would
> appreciate it if they could pass this along.
There isn't to
Are there still issues with CF and NT Service Pack 6a?
We are implementing a new production server, and it would be much easier to implement
6a rather than 5 and all the hot fixes.
Thanks,
Kevin
~~
Structure your ColdFusion code with Fusebox.
Sure. Do it in your query
SELECT Name AS FName + LName (use syntax for your DB here)
best, paul
At 12:23 PM 11/28/00 -0500, you wrote:
>Okay, pretty simple question here:
>
>I have a cfselect form field that is being populated by the LName column in
>my Contacts table:
>
>display="LName">
>
My InetPub is on my D drive. I'm running Win2K Pro and havn't have any
trouble at all.
When you say it crashes .. what do you mean? Does Windows crash?
Todd Ashworth
- Original Message -
From: "Michael Barnum" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: "CF-Talk" <[EMAIL PROTECTED]>
S
I usually do so in the sql select statement. By adding something like:
Select *, LNAME + ', ' + FNAME AS FULLNAME order by FULLNAME
Then I use the column FULLNAME in the cfselect.
Athelene Gieseman
[EMAIL PROTECTED]
-Original Message-
From: .elizabeth. [mailto:[EMAIL PROTECTED]]
S
I know SQL Server 6.5 did it's database backups with dat files. If you're
running SQL Server 7, go to the MS SQL Server - Switch entry in your start
menu and click on SQL Server 6.5. Then do a restore from SQL Server 6.5.
That's one option. I say all this, assuming SQL Server 7 won't already do
It's pretty close to SPAM when someone has a program grab every email address that
ever posts to a list and auto-sends an email trying to make you a customer of theirs.
Then pretends that you are somehow "special" (This special offer is just for you :-)
), and that is the only reason you are ge
I want the Inetpub directory to be on another drive other then C:,
when attempting to do this we crash or it just wont work at all. Does
anyone know of a fix, or workaround?If someone has a site with some
directions I would appreciate it if they could pass this along.
Thanks
Michael
I'm trying to move over a site that was once using a Sybase backend. They
sent me a .Dat file and I'm wondering how I can take this file and use it to
create a sql database. Anybody have any experience with converting from
Sybase to sql using a dat file? Thanks, for anyone who can help.
Rick
~~~
Okay, pretty simple question here:
I have a cfselect form field that is being populated by the LName column in
my Contacts table:
The code above works fine; my select box gets populated with all the last
names in the contacts table. BUT, I need to display the contact's first AND
last name (two
These guys harvested the email addresses off this list. The broadcasted (at
the time) that they were going to do this. They got blasted by folks here
but they did not listen.
Dave
=
"What we need is a list of specific unknown problems we will encounter"
David
CF will connect and interact well with relational databases. The more
widely used databases generally come with more user-friendly drivers, but
every database I can tink of, does come with some sort of native database
driver that can be installed and run from one or more of the platforms
supporte
One of the list rules which I hold rather sacred is that the list can not be
used to gather email addresses. If someone comes to the list, grabs peoples
addresses and emails them unsolicited off list, its considered spam. Sending
a post to the CF-Jobs list about a new job site is something totally
> Does anyone know of any issues with Cold Fusion and connecting
> to a relational database.
CF connects well with relational databases - that's it's primary use! There
are quite a few problems you might have when connecting to Oracle, but it's
not practical to list them all. If you're having a
Was it unsolicited?
Where did they get your e-mail address?
It's spam if someone takes your e-mail address somewhere off
the web (or a listserve, like this) and sends you an unsolicted
e-mail in an attempt to sell something.
Angél Stewart wrote:
>
> :-\
>
> You know I think onc
I don't mind if they sponsor the list, but any unsolicited email sent to
you because you contribute to a list is technically SPAM. I like to elect
to receive information, not have it forced down my throat.
The information is only useful if you are US based.
-Original Message-
From: A
Gettim Michael...Gettim.
I agree that this is spam.
Recruiters should not use lists for SPAM.
Its SPAM plain and simple.
I get fed up with these sort of people.
They even have their own Tag
CF_WannaJob...HaHa:)
Regards
D
Daryl Fullerton,
Managing Partner,
BizNet Solutions,
Allaire Premier
Does anyone know of any issues with Cold Fusion and connecting to a
relational database. Also, the situation is not a direct connection, they
go out over the internet.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http
:-\
You know I think once or twice people contacted me and stuff about possible
job oppurtunities with CF, they were Recruiters I believe. Is it generally a
bad thing to give them your info??
I don't understand how getting tips on possible job sites or oppurtunities
is Spam..I class Spam as the
His response is untrue as I've never received a message from him. Of course,
I'm just the list manager...
I've received a number of complaints about this and am sending him an email.
If I have to block him, I will.
> h wow, I feel honoured. So because I contribute to CF-Talk, I get more
> SP
h wow, I feel honoured. So because I contribute to CF-Talk, I get more
SPAM.
Will pass on this email to all people on CF-Talk minus the original SPAM.
See what they think :-)
-Original Message-
From: Christian Fea [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 28, 2000 4:10 PM
arin.net - whois
- Original Message -
From: "Adam Reynolds" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 1:08 AM
Subject: SPAM Alert
> Hi guys,
> I appear to be getting email from [EMAIL PROTECTED] about
> some crap job board.
>
> As I've only ju
i just ran into this, & it may be a wrong & dumb answer.
do you have a cfapplication?
is it passing session variables?
is that enabled on the server?
just dealing with that this mornning.
-paul
~~
Structure your ColdFusion code with Fusebox. Get t
How about something like this then ..
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2000 10:45 AM
Subject: RE: CFLOCK and isdefined
| > Get the value in a lock, then
1) Yes, DISTINCT works in all fields in your select statement; from that
comment, I assume you want more than just the person ID from the table. An
imperfect method would be:
SELECT personID, max(visitDate) as visitDate
FROM statsTable
WHERE date > DATEADD(d,-2,getDate())
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01C05955.21C23CA6
Content-Type: text/plain;
charset="iso-8859-1"
>I guess th elock would just timeout, but i'd prefer to know. In
At 10:51 AM 11/28/00 , you wrote:
Dave, Patricia, Justin,
Thanks for all your suggestions..
in other languages, i've gotten into the habit of not leaving any locks
"open". that's why the concern about a cfabort before the /cflock. I
guess th elock would just timeout, but i'd prefer to know
When you do an isdefined, CF is attempting a read of the variable name.
Yes. You do need a READ Lock around IsDefined Statements. I can't see why
a CFABORT inside of the CFLOCK would cause any kind of problem. I know
where your thought process is going... but I still sense no problem there.
Per
> Get the value in a lock, then test the value after closing
> the lock. A good technique for all locking to make the locked
> section as quick as possible.
>
> < cflock>
> < cfset variables.myvar = session.myvar>
> < /cflock>
>
> < cfif isdefined("variables.myvar")>
That won't help; if the
> There have been a number of discussions about cflock over the
> past few months, but i don't remember seeing anything about this
> combination. I'm locking my writes with type="Exclusive", and
> all my reads with type= "Readonly", but do i need a cflock
> around
Yes. It's a read.
> SInce
At 10:30 AM 11/28/00 , you wrote:
>Get the value in a lock, then test the value after closing the lock. A
>good technique for all locking to make the locked section as quick as possible.
>
>< cflock>
> < cfset variables.myvar = session.myvar>
>< /cflock>
>
>< cfif isdefined("variables.myvar")>
It's pretty great , but don't just take my opinion, join the mail list and
Ask the users.
Signup at [EMAIL PROTECTED] or http://www.coolfusion.com/index.htm
and the mail archive
http://www.mail-archive.com/infusion-email%40eoscape.com/
Also Howie (who is on this list) is very helpfull, quick t
Get the value in a lock, then test the value after closing the lock. A good technique
for all locking to make the locked section as quick as possible.
< cflock>
< cfset variables.myvar = session.myvar>
< /cflock>
< cfif isdefined("variables.myvar")>
...
At 10:11 AM 11/28/00 -0500, Brian L.
1 - 100 of 133 matches
Mail list logo
