Are you putting single quotes around the dates in the WHERE CLAUSE?
If so try removing them it shouldnt need quotes I have run into this before.
Kelly
-Original Message-
From: Marcus [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 5:04 PM
To: [EMAIL PROTECTED]
Subject:
yes cold fusion was made to integrate with crystal reports very easily.
-Original Message-
From: sam komolafe [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 11:04 AM
To: [EMAIL PROTECTED]
Subject: LOOKING FOR A REPORTING TOOL FOR COLDFUSION
Hi,
Thus anyone know a
Ok I must be missing something I have not had to do this before
so never really had to worry about it. I want to output a report
that does a couple things 1 is it takes 2 fields (field a and field b)
and divides them. I know how to do it in the SQL statement but I dont want
to I would rather do
Ok i figured it out, use the evaluate tag...
Kelly
-Original Message-
From: Kelly Matthews [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 2:11 PM
To: '[EMAIL PROTECTED]'
Subject: Am I missing something? Calculations...
Ok I must be missing something I have not had
H
Dick
At 2:23 PM -0400 5/16/2000, Kelly Matthews wrote:
Ok i figured it out, use the evaluate tag...
Kelly
-Original Message-
From: Kelly Matthews [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 2:11 PM
To: '[EMAIL PROTECTED]'
Subject: Am I missing
e evaluate...
Look at the CF math functions (Functions, not Tags!)
cfset A = 3
cfset B = 7
cfset C = A / B
cfoutput
br A / B = #C#
/cfoutput
HTH
Dick
At 2:23 PM -0400 5/16/2000, Kelly Matthews wrote:
Ok i figured it out, use the evaluate tag.
probably even easier to just put it in an HTML (not CF) comment tag !-- --
not !--- ---
those will show up when viewing source.
-Original Message-
From: Howell, Katie [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 18, 2000 8:59 AM
To: [EMAIL PROTECTED]
Subject: RE: How not to
Well i know when ever we bring down our exchange server or make changes to
it
it cuts the connection between CF and the mail server and I have to RESTART
CF Services in order
for it to connect again. Try stopping and starting your CF services and then
send a test mail and see if it goes thru. The
we are using it where we are. but arent really doing it to the extent that
you want.
Whos product are you using? We are using the VPN product
that comes with Firewall1.
-Original Message-
From: Jason Egan [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 19, 2000 9:36 AM
To: Cf-Talk
to get leading zeros the data type can NOT be integer I had the same problem
had
to change the data type in the database to text in order for the zeros to
remain.
-Original Message-
From: Gordon Burns [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 19, 2000 1:58 PM
To: [EMAIL
WDDX is a great way to do this type of thing, CF and WDDX work well together
and there
is a ton of info out there about it.
Kelly
-Original Message-
From: stäs [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 12:16 PM
To: [EMAIL PROTECTED]
Subject: serving data
Let's
anyone find it weird that i have a webdiva domain and my name is kelly
too...
ok i know its time to go home now :-P
http://www.webdiva.org
-Original Message-
From: [ W E B D i V A ] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 3:04 PM
To: [EMAIL PROTECTED]
Subject:
Home site is great i made it the standard at our location.
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From
Ok can this be done. Say I have small database of news stories and
on the front page of the website we want to include say the first
sentence or 2 of the story which then links to the full story. How
do I, for the front page, limit it to only pull and display the first
so many characters of
Ok here's the deal. I run a TON of Cold Fusion apps on our site, and running
SQL Server 7.0.
I am still learning SQL Server but here is whats happening. Over time the
RAM usage
for SQL Server goes up and up, and continues to until I stop and restart the
service then
it drops back down.
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Adrian Cooper [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 26, 2000 3
Actually I just found the Fuse Ads info you can go here:
http://www.e-zonemedia.com/fuseads
It was VERY easy to install I use SQL 7 as the back end. We run banners
on every page of a very high traffic site and it seems to work well.
Kelly
---
Kelly Matthews
I installed 5.0 and now ALL my datasources fail. Nothing has changed.
Has this happened to anyone else?
Kelly
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
No one has gotten any since mid last week!
-Original Message-
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 11:38 AM
To: CF-Talk
Subject: CF-talk (Michael Dinowitz)
Mike
I am still not getting emails and was wondering if there was a way
to search
Sure seemed to be for a LONG time! are there any other active lists out
there??
-Original Message-
From: Erika L. Walker [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 11:53 AM
To: CF-Talk
Subject: RE: is this list dead?
I'm getting posts, but not as many as we used to get.
yep netscape doesn't forgive forgetting /td tags... geeezzz
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 3:17 PM
To: CF-Talk
Subject: OT: HTML Question with Netscape 4 and 6
Can someone please tell me why these pages completely
It's possible takes a bit of programming though... I have
a site that pulls all .msg files via cold fusion throws
them in a verity collection, then sucks some additional information
into a SQL database. Completely different from what you are
trying to do but thought I would mention it
Folks he already apologized how about we just DROP IT.
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 5:43 AM
To: CF-Talk
Subject: Kill the President
Sorry if I ruffle anyone's feathers here not a CF topic, but
I watched the 9 0'clock
table bordercolor=yourcolor
can you send the code so we can see what you are doing?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 2:46 PM
To: CF-Talk
Subject: table troubles
I have been having problems trying to change the color
well what does your action page do? Are you using CFUPLOAD
so it will actually upload?
Otherwise the file has no where to go.
-Original Message-
From: Billy Ng [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 5:58 PM
To: CF-Talk
Subject: File Upload
Hi all.
This isn't a CF
DUH!!! Don't know what I was thinking! I have only used the
tag a MILLION times. Ok Rephrase are you using
CFFILE action=upload on your action page?
would look something like:
CFFILE ACTION=UPLOAD
FILEFIELD=FileContents
DESTINATION=#request.filepath#
NAMECONFLICT=OVERWRITE
:10 PM
To: CF-Talk
Subject: RE: File Upload
The problem isn't on whether or not the file is being uploaded.
It's simplier than that.
It's not going to the action page at all
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: July 18, 2001 6:01 PM
To: CF-Talk
Yep I would do javascript to go back one page also, that's what I do
and it works well.
Kelly
-Original Message-
From: John Paitel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 4:24 PM
To: CF-Talk
Subject: Intro and questions...what else?
Hey all...
I am new to the list,
Justin even... :)
-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 6:13 PM
To: CF-Talk
Subject: RE: File Upload
Could it be just a
missing right here |
|
\ /
good catch justing :)
-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 6:13 PM
To: CF-Talk
Subject: RE: File Upload
Could it be just a
missing right here |
|
\ /
Maybe he processes his .htms as CF files i do. Not .html but
I do with .htm then people don't even know I am running cf.
Kelly
-Original Message-
From: Rich Tretola [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 6:27 PM
To: CF-Talk
Subject: RE: File Upload
The form action
Sure you can I do it all the time all my CF files are .htm files.
Easy tweak in IIS he could be doing the same. However if he is
not I am sure that is the problem. But it definitely works. :)
Kelly
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18,
PM
To: CF-Talk
Subject: RE: File Upload
that's great...but that way the CF engine is invoked for every .htm
call,
even for pages that have no CFML code. it can cause unnecessary
overhead if
you have a large amount of static .htm pages.
-Original Message-
From: Kelly Matthews [mailto
Not the way i do it, .html i use for non cf, i only use .htm where
i would use .cfm.
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 8:05 PM
To: CF-Talk
Subject: RE: File Upload
On 7/18/01, Kelly Matthews penned:
Sure you can I do it all the time
would have.
Kelly
-Original Message-
From: Rich Tretola [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 9:32 AM
To: CF-Talk
Subject: RE: File Upload
Why not just use .cfm?
Rich
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19
Ok folks I know what's goin on. It happened to me all day. I use
black ice on my server. At first every time i was getting hit
it was being recorded at an HTTP OVERFLOW and shutting my web service
down. I updated black ice and it now records it as an ISAPI
index extension overflow. My updated
yes but download the patch to be safe
http://www.microsoft.com/technet/security/bulletin/MS01-033.asp
-Original Message-
From: admin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 5:17 PM
To: CF-Talk
Subject: Re: IIS and the Code Red Worm
at least blackics is seeing it and
by the way that message was old i realize there is a patch now was
just a temporary fix :)
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 5:33 PM
To: CF-Talk
Subject: IIS 4 Stopping Unexpectedly: I KNOW WHAT THE PROBLEM IS!!!
Ok folks I
hits to UDP port 1296.
Anyone konw what this port is for - or why the worm is searcing there ?
Richard
Y2K Internet Technologies
- Original Message -
From: Kelly Matthews [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 2:32 PM
Subject: IIS 4 Stopping
LOCK LOCK LOCK is all i can say!
-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:11 AM
To: CF-Talk
Subject: Any horror stories from not locking session vars?
I have been asked to do a code review of a site and I have found that the
hahahahahhahaha my cats don't seem to mind they have a limited vocabulary
too! :)
-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 5:24 PM
To: CF-Talk
Subject: RE: Any horror stories from not locking session vars?
At 04:44 PM 8/6/2001 -0400,
Just out of curiosity? Why go through all that why not make the changes in
SQL?
Kelly
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 3:12 PM
To: CF-Talk
Subject: OT: MS SQL DB to MS Access
Hi all,
I have a DB in MS SQL and want to export
it really probably depends on location as well
I have had 4 web development jobs in 8 years in 3 of them
I was NOT the only female in IT, or web development. Granted I
was the best just not the only one *evil grin*
Kelly
-Original Message-
From: Costas Piliotis [mailto:[EMAIL
I would guess YES. I think men will always dominate simply because more men
tend to LIKE this field then women. I know many more women that hate
computers,
math, science than men, that I doubt will change. But I do see more in the
field
then 8 years ago when I started out.
-Original
A hell of a lot better than MAM! Oh how I hate that word.
I mean do the guys really like called sir? lol most i know hate it too!
-Original Message-
From: Schlosser, JoAnn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 3:58 PM
To: CF-Talk
Subject: RE: Cold Fusion Developer -
Well or at least installed the Code Red patch. I can't believe how many
people
still haven't installed the patch, and fail to realize the worm will not die
until all servers are patched... *grrr*
-Original Message-
From: Mahmut Basaran [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24,
Ok here is the deal.
I have a program I have written where we want a document to be created (in
whatever format necessary for the fax program) and then faxed to a certain
number.
Obviously we would prefer to use our in house Fax Server which is Right Fax.
Has anyone ever done anything with CF
with ProtoFax about a year ago. The tag is free and
you can download from http://www.protonet.com/efax/cf_fax.htm
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 8:46 AM
To: CF-Talk
Subject: Cold Fusion and Faxing
Ok here is the deal.
I have
via CFMAIL.
--- Ben
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 8:46 AM
To: CF-Talk
Subject: Cold Fusion and Faxing
Ok here is the deal.
I have a program I have written where we want a document to be created (in
whatever format
kludgy
at the moment. I'd either do a cfexecute or just write the faxes to be
sent into a spool directory with cffile then run the fax script at a
scheduled interval which would read the files and send any faxes.
jon
Kelly Matthews wrote:
Ok here is the deal.
I have a program I have written where we
I thought they went w/ Netscape...
-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 9:04 AM
To: CF-Talk
Subject: Under the hood of AOL 6
All,
Can anyone tell me what browser is used by AOL 6. Is it IE 5.5? I am
getting reports of
Oops error on that URL
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 5:55 PM
To: CF-Talk
Subject: URL varliables
http://www.forta.com/cf/tips/index.cfm?age=H
Oops.
CC
~~
Structure
.
-Kelly
~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http://www.allsoldout.net
703.387.4000 x 35
~~
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB
they are. Anyway I know there are a few CyberCash tags out there
for CF. However,
I have never used one myself so thought I would ask for some recommendations
on the best
one out there. Preferably a FREE one. :)
-Kelly
~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http
with Verisign, they will ONLY be able
to get PayFlowPro as Cybercash is being phased out.
~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http://www.allsoldout.net
703.387.4000 x 35
will not have to change a thing, all
their cyber
cash settings will still work with the merged service. Just an FYI.
-Kelly
~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http://www.allsoldout.net
703.387.4000 x 35
Yep in is much better, quicker too!
[EMAIL PROTECTED] writes:
cfquery datasoure=xxx name=listsQuery
SELECT this, that, theotherthing
FROM tblName
WHERE ID IN (#id#)
/cfquery
cfoutput query=listsQuery
#this#br#that#br#theotherthing#brbr
/cfoutput
~~
Kelly Matthews
Senior
Does anyone know of an unencrypted tag that will do next/previous start/end
type navigation.
The type that outputs like
Anyone?
-Kelly
~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http://www.allsoldout.net
703.387.4000 x 35
Maybe I am missing something but the help on this is SERIOUSLY lacking
[EMAIL PROTECTED] writes:
search dev-exchange for CF_recordcount it is very nice and
unencrypted.
~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http://www.allsoldout.net
703.387.4000 x 35
MyStartRow + MyMaxRows lt MyQuery.RecordCount
cfoutput
a href=MyPage.cfm?MyStartRow=#Evaluate(MyStartRow +
MyMaxRows)#Next #MyMaxRows#/a
/cfoutput
/cfif
~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http://www.allsoldout.net
703.387.4000 x
Ok here's the scenario.
We have to place a file into a directory structure.
The end result would be
D:\FILES\SONNUMBER\TODAYSDATE\SOCIALSECURITYNUMBER\ACTUALFILE.TXT
These folders SONNUMBER, TODAYSDATE, and SOCIALSECURITYNUMBER would be
created on the fly if they aren't already there.
Most of
makes sense and I didn't even know there was a DirectoryExists() shows you
how much I deal with directory stuff. :)
I will try both although it still is odd that the cftry/cfcatchs were
working
that way.
Thanks!
Kelly
-Original Message-
From: Richard Fantini [mailto:[EMAIL PROTECTED]]
Thanks Richard. DirectoryExists works great. :)
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
Has anyone ever had a SQL 7 or 2000 database that wasn't that large.
Have one that's about 9 megs. Where the transaction log was HUGE?
My transaction log is 231 megs right now and rapidly growing. There is
not that much update, insert, delete activity against the database so
I am confused as to
To: CF-Talk
Subject: Re: SQL Transaction Logs...?
On 12/12/01, Kelly Matthews penned:
Has anyone ever had a SQL 7 or 2000 database that wasn't that large.
Have one that's about 9 megs. Where the transaction log was HUGE? My
transaction log is 231 megs right now and rapidly growing
Ok here is the deal. I have an excel file. I can query through it no
problem. I have
to take results and update a SQL database. Again no problem. Except some of
the field
names in the excel file have spaces. We receive this file from another
party so we
can't remove the spaces from the file.
Ok I tried that but it threw an error let me show you all the code so it may
help. You will see for the FLAG field I used your code that threw an error
saying it didn't know what CURROW was. before it was throwing an error
because of the space.
Kelly
CFQUERY datasource=faastatus name=info
Worked like a charm you rock! :) Thanks!
Kelly
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 3:16 PM
To: CF-Talk
Subject: RE: EXCEL Question Spaces in Field names
Sorry. I should have been more clear.
I used curRow as a generic
Ok have a question. We have a license that allows 4 people/logins to be
connected
to the SQL server at one time. Via Enterprise manager or whatever. Well it
keeps
telling us there are 4 connected yet there are only 2 of us using it. Is
there a place
I can go to see who the current USERS are that
.
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 5:32 PM
To: CF-Talk
Subject: SQL Licensing/User Question
Ok have a question. We have a license that allows 4 people/logins to be
connected to the SQL server at one time. Via Enterprise
: SQL Licensing/User Question
I think yur right :-) not sure though... Im just guessing
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 5:40 PM
To: CF-Talk
Subject: RE: SQL Licensing/User Question
could it be cold fusion
Ok I have this file, which we will receive automatically.
The first part of the file is hex code data, which can be read easily,
even manipulated etc. The 2nd part of the file is binary data.
When I use CFFILE to READ the file it reads it fine comes back
with no errors, but when I output what it
Using CFFILE to read a file. The file has a couple of null characters in the
middle of the file.
When it reaches the NULL characters it assumes it has reached the end and
stops. Is there
a way to read the file (I have to make some modifications to it as well) and
get around
or parse out the null
know that
every time you get a file, you have to modify it.
After the file was modified on the back-end, we were free to call the file
anyway we wanted. I.E. cffile, cfcontent, cflocation, etc.
Hope that helps.
Mark
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED
Pull an ID or whatever record identifier you have in your first query.
Not just the date.
Then in the update statement you need a where ID = #ID# or
whatever your record identifier is called. It has no idea what
row you want to update the way you wrote it.
Kelly
-Original Message-
From:
as far as I know it's not something that can be done. CFLOCK is strictly for
sessions, etc.
CFFILE doesn't allow you to add a system level lock on a file nor release a
lock. Would
be nice though. :) I could be wrong but I don't think it has that
capability.
-Original Message-
From: Jim
it's down they have reached their max transfer load for the day, that's a
free site for ya
-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 11:39 AM
To: CF-Talk
Subject: RE: Better Javascript/DHTML Calender!
That link doesn't
Well I usually query the database first to see if the name/email combo
exists before
inserting it, if so I don't allow it to enter again. So if they do refresh
it would prevent that.
-Original Message-
From: PHP [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 7:57 PM
To:
Ok I should probably know this but basically I am letting people
choose their own passwords, each password must contain at least ONE
number and one alpha character. What's the best way to verify this?
They are creating the password themselves, I am not creating random
passwords for them.
christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 2:05 PM
To: CF-Talk
Subject: Verify password is alpha numeric?
Ok I should
Ok we have a survey where we have to rate each person in 3 categories.
We have 50 people to rate.
I set a comma delimited list of names and then create a loop to create 3
questions
for each person, so we can rate each of the 50 people in the 3 categories.
Looks like this:
cfloop index=Surname
]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: Kelly Matthews [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3
Associate Partner
www.macromedia.com
- Original Message -
From: Kelly Matthews [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3 categories.
We
-
From: Kelly Matthews [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3 categories.
We have 50 people to rate. I set a comma delimited list of names
with resolving a variable...
I believe it would be one of these
CFSET surnamecomm = #Evaluate(surname_#Comm#)#
or
CFSET surnamecomm = #Evaluate(#surname#_Comm)#
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:09 PM
To: CF-Talk
You go into enterprise manager depending if you have 2000 or 7.0 it may
differ but:
right click on the table in question
Click Design Table
Depending if you have 7.0 or 2000 will depend on where this is located.
If you have 2000 it should be at the bottom of the screen you should see
something
Ok here is what i am doing and I am just trying to find out if 1. there is a
better way and 2. if it can be done on the SQL side (as a stored proc)
instaed of the CF side. Just not all that familiar with looping outside of
CF.
ANyway I have one table that is a dictionary with about 1500 words.
No you were correct I only want to pull the dictionary words that were found
in the dream. The code you gave me worked great the only issue i see now for
example let's say the word is FEEL then it pulls EEL out of the dictionary.
IS there a way to avoid that?
I'm not a SQL wizard and am
awesome thanks :)))
From: S. Isaac Dealey [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Is there a Better Way to do this?
Date: Thu, 19 Dec 2002 13:26:40 -0500
Yea, there's a couple things you can do ...
Make sure that every word in the dream is
ok right now i am doing this
cfset dreamtext = REReplace(dream.dream,([[:alpha:]])([^ [:alpha:]]),\1
\2,ALL)
cfset dreamtext = REReplace(dream.dream,([^ [:alpha:]])([[:alpha:]]),\1
\2,ALL)
CFQUERY datasource=#request.dsn# name=dictionary
SELECT DISTINCT DJ_Dictionary.Word
FROM
this works
OR '#dreamtext#' LIKE '% ' + DJ_Dictionary.Word2 + 's %'
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
for now im not going to do verity BUT it is full text indexed would using
CONTAIN instead of like make any difference?
Well, the easy way is to just add 'bats' to your words table -- this also
will help with plurals for which the trailing s doesn't necessarily apply,
i.e. gooss, octopuss or
Ok I have a CF Insert statement (its a long one) and then below the
statement I will paste the error i am getting.
Its appearing that there is a size limit ont he CF Insert statement? Is this
true? All of my inserts except the first
few are just 1 character.
CFQUERY datasource="#DSN#"
Sure enough, DOH! :)
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent
OK i have a appl. on one page i am doing 3 calculations here is what they
look like:
CFSET hold="#Evaluate(TimeFormat(FIS_FirstI, 'H:mm')-Timeformat(FIS_Block,
'H:mm'))#"
CFSET api="#Evaluate(FIS_Pax_Num/FIS_API_Num)#"
CFSET process="#Evaluate(TimeFormat(FIS_LastI,
'H:mm')-Timeformat(FIS_FirstI,
Thanks so much I will try that! :)
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Deanna L. Schneider [SMTP
worked like a charm my brain just wasnt able to think this morning, havent
had enough caffine... :)
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
Ok I run these 2 queries:
CFQUERY datasource="#dsn#" name="qgetrunways"
SELECT *
FROM Runways
/CFQUERY
CFQUERY datasource="#dsn#" name="qgetrunwaydetail"
SELECT *
FROM Runway_Detail
WHERE O_Report_Num = #qgetops.O_Report_Num#
/CFQUERY
The first just pulls all the runways.
The 2nd pulls any
y="qgetrunways"
cfif ListFind(ValueList(qgetrunwaydetail.runway_ID), runway_id)
input type="checkbox" name="runway_id#runway_id#" CFIF runway_id IS
qgetrunwaydetail.runways.runway_idCHECKED/CFIF
value="#runway_id#"#runway# nbsp;nbsp;nbsp;/CFIF
/CFOUTPUT
Ok I figured it out DUH:
input type="checkbox" name="runway_id#runway_id#" cfif
ListFind(ValueList(qgetrunwaydetail.runway_ID), runway_id)CHECKED/CFIF
value="#runway_id#"#runway#
Thanks Dave!
-------
Kelly Matthews
Interne
101 - 200 of 288 matches
Mail list logo
