OT: Form not posting.....help, please

2002-05-29 Thread Diana Nichols
title# (#writer#) TIA! ******** Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 __ Signup

CFHTTP and duplicate form fields

2002-05-22 Thread Diana Nichols
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

RE: automatically submit form - Sorry

2002-04-15 Thread Diana Nichols
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

RE: automatically submit form

2002-04-15 Thread Diana Nichols
?? 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

RE: automatically submit form

2002-04-15 Thread Diana Nichols
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

RE: automatically submit form - Sorry

2002-04-15 Thread Diana Nichols
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

RE: automatically submit form - Sorry

2002-04-15 Thread Diana Nichols
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

RE: automatically submit form - Sorry

2002-04-15 Thread Diana Nichols
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

automatically submit form

2002-04-15 Thread Diana Nichols
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

Search results refreshing

2002-04-10 Thread Diana Nichols
! 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

scheduled task

2002-04-01 Thread Diana Nichols
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

RE: SQL Update Increment Value

2002-04-01 Thread Diana Nichols
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-

RE: Getting field names, etc. from MSSQL 2000

2002-03-27 Thread Diana Nichols
_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

CFHTTP POST - authentication issue - Resolved - well, not quite

2002-03-21 Thread Diana Nichols
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

RE: CFHTTP POST - authentication issue - Resolved

2002-03-20 Thread Diana Nichols
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

RE: CFHTTP POST - authentication issue

2002-03-19 Thread Diana Nichols
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

CFHTTP POST - authentication issue

2002-03-19 Thread Diana Nichols
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

RE: SQL>>>HELP QUICK!

2002-03-19 Thread Diana Nichols
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

RE: How to find first letter of last name... solved

2002-02-21 Thread Diana Nichols
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

How to find first letter of last name...

2002-02-21 Thread Diana Nichols
.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

RE: Checkbox

2002-02-06 Thread Diana Nichols
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

RE: Display result pages menu

2001-11-14 Thread Diana Nichols
(#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

RE: SQL -> CFHTTP -> SQL

2001-11-14 Thread Diana Nichols
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

SQL -> CFHTTP -> SQL

2001-11-14 Thread Diana Nichols
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

RE: Hierarchy

2001-09-12 Thread Diana Nichols
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

RE: Quick query question (qqq)

2001-08-25 Thread Diana Nichols
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

RE: PREVIOUS 1 2 3 ... NEXT page codes

2001-08-08 Thread Diana Nichols
(#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

RE: How do these things happen?

2001-07-28 Thread Diana Nichols
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

RE: cross-posting: data type mismatch

2001-07-19 Thread Diana Nichols
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

RE: Dead ?

2001-07-13 Thread Diana Nichols
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

RE: currentrow with join query

2001-07-12 Thread Diana Nichols
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...

currentrow with join query

2001-07-12 Thread Diana Nichols
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

RE: is this list dead?

2001-07-02 Thread Diana Nichols
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.

OT - Access Count() question

2001-06-13 Thread Diana Nichols
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

RE: Repost: Unknown Parser Error

2001-06-08 Thread Diana Nichols
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

RE: How to get a list of all tables in a given datasource - and how to combine queries

2001-06-08 Thread Diana Nichols
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

RE: INSIGHT NEEDED: getting query results to output in a table with three rows

2001-06-07 Thread Diana Nichols
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

RE: Date Query problem.

2001-06-06 Thread Diana Nichols
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

RE: Challenging dillemma (double values?)

2001-06-06 Thread Diana Nichols
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

RE: Updating multiple rows!

2001-06-01 Thread Diana Nichols
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

filenames

2001-05-18 Thread Diana Nichols
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 ~~

RE: CFTRANSACTION

2001-05-17 Thread Diana Nichols
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

RE: CFTRANSACTION

2001-05-17 Thread Diana Nichols
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:

RE: @@identidy in sql server 7

2001-05-15 Thread Diana Nichols
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

RE: @@identidy in sql server 7

2001-05-15 Thread Diana Nichols
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

RE: Evaluating strung together variables

2001-05-14 Thread Diana Nichols
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 "

RE: Query Help!!

2001-05-11 Thread Diana Nichols
.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

loop puzzle....

2001-05-11 Thread Diana Nichols
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

RE: searching date ranges

2001-05-11 Thread Diana Nichols
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

RE: insert problem

2001-05-10 Thread Diana Nichols
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 "

RE: Problem with page showing blank

2001-05-06 Thread Diana Nichols
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

RE: cfloop help! -- solved!!

2001-05-04 Thread Diana Nichols
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

RE: cfloop help!

2001-05-04 Thread Diana Nichols
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]

RE: cfloop help!

2001-05-04 Thread Diana Nichols
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

cfloop help!

2001-05-04 Thread Diana Nichols
(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

RE: Dynamic Variable Names

2001-05-04 Thread Diana Nichols
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-

OT - JS format

2001-05-04 Thread Diana Nichols
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

OT: JS format

2001-05-03 Thread Diana Nichols
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 ~~

JOIN queries from two datasources

2001-05-01 Thread Diana Nichols
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

RE: OT but VIQ: Denial of Service Attacks

2001-04-30 Thread Diana Nichols
;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:

RE: CFLOOP? Query results in a new query

2001-04-29 Thread Diana Nichols
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 -

RE: One form, two submit buttons...

2001-04-29 Thread Diana Nichols
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

RE: CFLOOP? Query results in a new query

2001-04-29 Thread Diana Nichols
#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

RE: How can I get CF to ignore a form field with no data?

2001-04-29 Thread Diana Nichols
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." ---

RE: How can I get CF to ignore a form field with no data?

2001-04-29 Thread Diana Nichols
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

RE: Daily Image on Static Pages

2001-04-27 Thread Diana Nichols
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

urlencodedformat not working in IE

2001-04-25 Thread Diana Nichols
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

RE: cookies and keeping track of ID

2001-04-25 Thread Diana Nichols
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

RE: ' in SQL 2000

2001-04-25 Thread Diana Nichols
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

RE: ' in SQL 2000

2001-04-25 Thread Diana Nichols
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 -

RE: ' in SQL 2000

2001-04-25 Thread Diana Nichols
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

RE: ' in SQL 2000

2001-04-25 Thread Diana Nichols
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

' in SQL 2000

2001-04-25 Thread Diana Nichols
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

RE: data nonsense

2001-04-24 Thread Diana Nichols
* 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

RE: statement help...

2001-04-23 Thread Diana Nichols
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

RE: Event List

2001-04-18 Thread Diana Nichols
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

RE: cookies not being set

2001-04-16 Thread Diana Nichols
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.&

RE: existence of table

2001-04-12 Thread Diana Nichols
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

RE: existence of table

2001-04-12 Thread Diana Nichols
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

RE: existence of table

2001-04-12 Thread Diana Nichols
----- 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

existence of table

2001-04-12 Thread Diana Nichols
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 ~~

RE: pull numbers from a string...

2001-04-11 Thread Diana Nichols
-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

RE: Getting the value of a variable, once removed

2001-04-05 Thread Diana Nichols
#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:

RE: query dates

2001-04-03 Thread Diana Nichols
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

RE: Line Breaks

2001-04-03 Thread Diana Nichols
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-

query dates

2001-04-03 Thread Diana Nichols
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.

RE: Date Conversion

2001-03-22 Thread Diana Nichols
#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:

RE: CFMAIL Examples

2001-03-21 Thread Diana Nichols
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

Tracking two lists of numbers

2001-03-21 Thread Diana Nichols
. To add steps or edit titles, descriptions or probabilitites, CLICK HERE./tr> #evaluate(title)# (#prob#%) selected>#thisno# TIA!!! * Diana Nichols Webmistress http://www.lav