title#
(#writer#)
TIA!
********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
__
Signup
m.
I could have the client deal with it on the other end, but that's not a good
solution.
Anyone have any other ideas (other than upgrading to 5.0, which is a few
weeks away.)??
TIA!
D
********
Diana Nichols
Webmistress
http://www.lavende
ahathat has possibilitiesif I can get my client to agree. (They
historically take 3-5 working days to make any decision above the level of
correcting spelling.)
Thanks, I'll look into this!
D
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434
??
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 12:57 PM
To: CF-Talk
Subject: Re: automatically submit form
RUNAT=Server
On Mon, 15 Apr 2002
No problem...I just assumed a typo :)
D
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 1:33 PM
To: CF-Talk
Subject: Re: automatically submit
Good thought...unfortunately the form has about 300 fields, and could well
exceed the url size limit.
D
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday
unately, not so with
CFHTTP. (Nor does using the username and password parameters of the tag.)
D
********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2
Sorry...I forgot to mention that I can't use CFHTTP - we scrapped that idea
so long ago I'd forgotten about it - but the client has challenge/response
security on their serverso it doesn't work.
D
********
Diana Nichols
Webmistress
http://www.lave
f?
TIA!
D
********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionaut
!
D
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http
I need to schedule a call to a .cfm page (which triggers a query and
subsequent form submission to a remote server) every 5 minutes. What is the
most reliable way to do this?
I am running Win2K, IIS, SQL 2000 and CF 4.5.
TIA!
D
Diana Nichols
Webmistress
http
How about this:
update Table
set IntField = (select IntField from Table where ID=Whatever) +1
where ID=Whatever
--Not tested, but it's where I would start.
HTH
D
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
_maximum_length#
HTH
D
********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 11:20 AM
To: CF-Talk
Subject: Getting field names, etc. from MSS
eceiving sideany ideas on
what to ask them to check?
Again, here's my tag:
https://theirserver.com/theirscript.asp"; METHOD="post"
THROWONERROR="Yes" TIMEOUT="30" COLUMNS="#get.columnlist#" PORT="443"
USERNAME="username" P
chas gracias!
D
********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 11:55 AM
To: CF-Talk
Subject: RE: CFHTTP POST - authentication issue
It's time to do some e
ETHOD="post"
THROWONERROR="Yes" TIMEOUT="30" COLUMNS="#get.columnlist#" PORT="443"
USERNAME="username" PASSWORD="password">
Ideas??
D
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434
their server.)
TIA!
D
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cf
If athID is your primary key, have you set Identity to 'yes'? (This will
"autonumber" your records.)
HTH
D
********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
From: CF_JONNY [mailto:[EMAIL PROTECTED]]
Se
tarts with E
select * from playerinfo
where (select substring( reverse(playername) , (charindex(char(32),
reverse(playername))-1) , 1 ) ) = 'E'
D
****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
From: Sicular, Alex
.ideas?
TIA!
D
********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Fr
You could make it a checked radio button. With no other alternative, the
user couldn't uncheck it.
D
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Februa
(#startrow# - #lastrecord# shown)
********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 2:44 PM
To: CF-Talk
Subject: Display result pages menu
Hi,
I'm sure someone h
o you need not have unnecessary access to
their db.
This is more complicated to explain than it is to implement.
I use a similar scheme all the time to manipulate clients' databases
on sites remote to me.
HTH
Dick
At 8:57 AM -0500 11/14/01, Diana Nichols wrote:
>I have a more complica
critical?
TIA!!
~D
********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Get the mailserver that powers this list at http://www.cool
companyID# and leftno <> 0
update userroles set rightno = #newright#, leftno=#newleft#
where userID = #getall.userID#
HTH
D
Diana Nichols
Webmistress
http://www.salesthreads.com
Selling...Simplified
-Origi
tter#%'
HTH
D
*********
Diana Nichols
webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering" --Lazarus Long
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 25, 2001 1:00 PM
To: CF
(#startrow# - #lastrecord# shown)
HTH
D
Diana Nichols
Webmistress
http://www.salesthreads.com
Selling...Simplified
-Original Message-
From: nyon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 9:04 AM
To: CF-Talk
Subject: Re: PREVIOUS 1 2 3 ... NEXT page codes
Hi,
I ma
Check your or statement that determines the query
carefully...chances are there is some combination of circumstances - maybe
rare - that will not run either query.
D
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 28, 2001 9:02 AM
To: CF-Talk
Subject: How do
try this in your query: cast(testnumber as varchar)
HTH
D
___
Diana Nichols
Webmistress
SalesThreads - Selling Simplified
http://www.salesthreads.com
'One man's magic is another man's engineering' --Lazarus Long
-Original Message-
From: Will
Really don't want to complain, because I found out how painful it was when
the list was down, but, just to share my experience:
some messages come as they should - some come with 3-5 copies (easily
deleted) - and somewhere around noon most days, messages stop coming at
all - only to dump into my
That's one of the things I was consideringbut I was hoping for a
"shortcut" to counting the "groups"because I'm also using a "previous 1
2 3 4 5 ... next" routine to allow for navigation through the recordset, and
can't figure out any way to calculate page startrows except for rowcount...
ing
scheme is thrown off all down the line
currentrow counts ALL the returned rowsis there a reasonably easy way to
tell how many of the *group* records there areand figure maxrows and
startrows from that?
TIA!!
D
_______
Diana Nichols
Webmistress
SalesThreads - Selling
Outstanding!!!
I hope the fact that I just got three messages means that I'm back in the
loop...haven't seen a post from this list in over a week.
D
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.
ame, child.rightno
(DB is currently in Access, but will move to SQL 2000 within a week -
assuming I get it to work - so any wrinkles that differ between them would
also be a great help.)
I'm lostany help would be greatly appreciated!
D
*
Diana Nichols
Webmistress
http://ww
ery with this syntax)
I still don't know why this happenedonly that it did, and I had to
re-write the queries as: select fname, lname
This may not be your problembut it's one thing to check.
Perhaps someone more knowledgeable on this list can explain the why of this
scenario
This will give you a list of the tables within a SQL database:
select table_name from information_schema.tables
#table_name#
You should then be able to combine the data from both queries in whatever
way you want.
HTH
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
Try this:
#whatever.theStuff#
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: Tony Gruen [mailto:[EM
try this:
etc
select month,day,year,who
from on_callmic
where year = #year(now()# and
( (#month = month(dayone)# and day=#day(dayone)#)
or (#month = month(daytwo)# and day=#day(daytwo)#)
or (#month = month(daythree)# and day=#day(daythree)#) )
etc.
HTH
D
-Orig
I use this:
#memberName#
then, on the action page:
Member ID = #listfirst(form.memberinfo)#
Member Name = #listlast(form.memberinfo)#
of course, if you might end up with commas inside your values, you'll want
to specify another dleimiter for the list.
HTH
D
-Original Message-
From: M
You need to use OR instead of AND...you are asking it to find a row where
Part_ID is both 751 AND 752...
You could also say WHERE part_ID IN (751,752)
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineeri
hrough the names as strings, etcbut am
wondering if there's a faster way.
TIA!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
~~
d within
a CFtransaction block.
Sorry for the confusion.
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: Semrau, Steven L Mr SRA
[mailto:[EM
with
@@identity in the same query.
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: G [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 1:
Honestly, I'm not sure, but the @@identity won't work without it. I can't
find it in the SQL docs, but pulled it from a message on this list at one
point.
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is
set nocount on
insert into table ()
values ()
select @@identity as newID
set nocount off
HTH
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message
If it's always going to be only two variables, use
ListFirst(cookie.chocolate) and ListLast(cookie.chocolate)and, if you
use a separator other than a comma, be sure to define the delimiter.
HTH
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"
.total#
and shipto >= #session.total#
HTH
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 200
see
below. (The loop runs fine, too)
The loop seems to delete the value of the query (???)
#valuelist(prod.productID)#
#valuelist(prod.productID)#
TIA!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's ma
try this:
then, in your query..
where facility = 'Atlanta' and rcvd_date < #firstdate# and audit_date = NULL
HTH
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---La
when saving dollar amounts, I always use: REReplace('#thelist#', '[^0-9.]',
'', 'ALL' ), and then dollarformat() or lscurrencyformat() when I display.
HTH
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"
try looking at the source for the pagesometimes the page will blank when
it throws a CF error inside a table, but you will be able to see the error
in the source.
HTH
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is ano
It's no elegant, and I'm sure there's a better way, but I finally go what I
wanted by setting another variable:
#userID# (#thisuser#,#getm.userID#)
Thanks everyone for your help!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One ma
t: Re: cfloop help!
The results that you are getting is correct to the code you showed us. Can
you tell us what you are 'trying' to get and maybe we can help.
Thanks,
Clint
-- Original Message ------
From: "Diana Nichols" <[EMAIL PROTECTED]
EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 3:56 PM
To: CF-Talk
Subject: Re: cfloop help!
get rid of "getusers" in getusers.userID
#getusers.userID# (#userID#,#getm.userID#)
Todd
- Original Message -
From: "Diana Nichols" <[EMAIL PROTECTED]>
To: "CF-Talk&q
(1,1) (1,4) (1,19) (1,22) (1,23)
22 (1,1) (1,4) (1,19) (1,22) (1,23)
23 (1,1) (1,4) (1,19) (1,22) (1,23)
I don't have a clue what I've done wronghelp, please!
TIA!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magi
Or, another solution is to reference #evaluate(qn)#, which will give you the
query result.
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
ue;
thetotal = thetotal + (theamount * theprice);
}
document.calculatethis.result.value = thetotal;
}
TIA!!
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
is there a JavaScript equivalent to "dollarformat()"?
TIA!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
~~
Sorry if this has been asked before
Can I join two queries from two different datasources (SQL 2000)?
I need to relate the username/userID from source 1 to userID from source 2.
(If it's too difficult, I'll just copy the username into source 2).
TIA!
D
*****
Dia
;p=1
GoodLuck!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 12:50 PM
To:
Try this:
select *
from products
where product_id IN(#valuelist(qGetSpecials.product_id)#)
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-
m. Now the form is
able to submit to two
places
including all of the form field variables.
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---L
#thisproductID#
will give you a list of the values in the product_id field.
HTH
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: Tony
substitute "default" for "value".params are essentially empty
variablesso they don't have a value.
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---
You need to do one of two things.set the properties on the field to
"allow Zero Length" = yes
or
change your if statement to:
and move it outside the insert query
It's much easier to change the field property :)
HTH
D
*****
Diana Nichols
W
Wouldn't it be easier to name the images with the day ( 20010427.gif)
and then call them as src=/images/#dateformat(now(),'mmdd')#.gif?
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's
the "&", and chopping off the
filename.
is this a bug?? Is there a way around it?
TIA!!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man
The cookie you created called user can be used just like any other
variable - from anywhere within your application just call #cookie.user#.
HTH
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering.&q
lways chokes on the first item in
the list)
Thanks!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Se
Wish it was that easy.that was my first guess, though. (See the code I
posted in another message).
Thanks anyway!
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-
I'm not sure what you mean by "build up a sql string in SQL and execute it
using
EXEC(sqlstring)" .. (Recent convert from Access to SQL - and still
learning the tools)
??
Thanks!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
&quo
pr-01','budget','yes','11-Apr-01','deadline','yes','16-Ap
r-01', 84, 1, '67', 'New Opportunity', '4/25/2001', 'active', 'magazine ad',
0.30)
D
*
Diana Nichols
Webmistress
take the output data and manually
insert it into the query, it works fine - eliminating the possibility of
data type errors.
I've tried this with 4 different queries, with the same results.
I've now run out of things to try..Ideas?
TIA!
D
*
Diana Nichols
Webmist
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 7:10 AM
To: CF-Talk
Su
Perhaps the problem lies in the outputwhat does that code look like?
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: Jay Patton [mai
why not try sorting by dayofyear?
e.g.:
WHERE datepart('dy', dateofbirth) > #dayofyear(now())#
Haven't tested, so am not sure how the order by would work, but this should
give you the recordset you're looking for.
HTH
D
-Original Message-
From: Carlo van Wyk [mailto:[EMAIL PROTECTED]]
S
You cannot use cflocation on the same page where you set cookies.
Try this instead:
<!--
parent.location="/login.cfm"
// -->
HTH
*********
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering.&
A.TABLES
> WHERE TABLE_NAME = 'events0301'
>
> HTH,
> P.
>
> -Original Message-
> From: Diana Nichols [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 12, 2001 11:07 AM
> To: CF-Talk
> Subject: existence of table
>
>
> Is there a way to che
good idea! thanks!
D
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:38 AM
To: CF-Talk
Subject: RE: existence of table
> Is there a way to check for the existence of a database table (SQL 2000)?
>
> I have a calendar which stores
-----
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:07 AM
To: CF-Talk
Subject: existence of table
Is there a way to check for the existence of a database table (SQL 2000)?
I have a calendar which stores each month's events in a separate table
(events0301), and i
y table doesn't exist.
Insights, suggestions?
as always, TIA!!
Diana
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
~~
-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:26 PM
To: CF-Talk
Subject: pull numbers from a string...
Hi all..
is there a funcion that wil strip everything out of a string except numbers?
ie. The width of the box is 54"
and I wan
#evaluate(collist)# will give you what you're looking for.
D
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 4:04 PM
To: CF-Talk
Subject: Getting the value of a variable, once removed
I have this:
tall it here at least for the help.
Thanks!
D
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: Hayes, David [mailto:[EMAIL PROTECTED]]
Sent: Tue
CFmail works just like .line breaks, tabs, etc will appear in the
email as you type them
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
s
TIA!!
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
~~
Structure your ColdFusion code with Fusebox.
#dateformat(newdate,'mm/dd/')#
*****
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent:
It's a simple , where #form.member# is a list of email addresses
from checkboxes on the form page:
Dear Member:
#form.message#
HTH
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another ma
.
To add steps or edit titles, descriptions or probabilitites, CLICK HERE./tr>
#evaluate(title)#
(#prob#%)
selected>#thisno#
TIA!!!
*
Diana Nichols
Webmistress
http://www.lav
89 matches
Mail list logo