Allaire Search

[KChapman]

I guess enough people complained about the verity errors they were getting.
   
 "We're sorry...due to some minor technical difficulties we have   
 taken our search functionality off line for a short period of 
 time. We will have this problem resolved shortly. We appreciate   
 your patience in this matter and apologize for any inconvenience  
 this may cause."  
   



--K


Katrina Chapman
Consultant
Ameriquest Mortgage

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFmail nesting outputs???

[KChapman]

You can't have more than one query per cfmail tag.  What you have to do is 
build your message body outside of the message then output it. 

Something like

cfquery name="Get_emails_Shipto" datasource="test"
select Shipto_id,email_addr from ShipToTable
/cfquery

cfquery Name="Get_Orders" datasource="test"
Select OrderPart, OrderQty from OrdersTable where
OrderId="#Get_emails_Shipto.ShipTo_id#"

cfloop query="Get_emails_ShipTo"

cfset message_body = #Shipto_id#,#email_addr#

cfoutput query="Get_Orders
cfset message_body = message_body  "#OrderPart#, #OrderQty#"
/cfoutput

Cfmail from="[EMAIL PROTECTED]" to="#Get_emails_ShipTo.email_addr#"
type="HTML" subject="test"

#message_body#

/cfmail
/cfloop

I'm not sure that's right but you get the idea.

--K


Katrina Chapman
Consultant 
Ameriquest Mortgage




[EMAIL PROTECTED]
07/24/00 08:40 AM
Please respond to cf-talk

 
To: [EMAIL PROTECTED]
cc: 
Subject:CFmail nesting outputs???



Hello all,
  I am not able to nest queries in a CFMail, how do you
have more than one query in a CFmail, i cant group it either,
some like

cfquery name="Get_emails_Shipto" datasource="test"
select Shipto_id,email_addr from ShipToTable
/cfquery

cfquery Name="Get_Orders" datasource="test"
Select OrderPart, OrderQty from OrdersTable where
OrderId="#Get_emails_Shipto.ShipTo_id#"

cfloop query="Get_emails_ShipTo"
Cfmail from="[EMAIL PROTECTED]" to="#Get_emails_ShipTo.email_addr#"
type="HTML" subject="test" query=

Cfoutput
#Shipto_id#,#email_addr#
/cfoutput

!---*** this is not working ***---
cfoutput query="Get_Orders
#OrderPart#, #OrderQty#
/cfoutput

/cfmail
/cfloop

What am i doing wrong here???
Appretiate any help 

Thanks
Joe

-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' 
in the body.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: How Eliminate blank spaces between words ??

[KChapman]

I wouldn't use a regular expression for something so simple at removing 
spaces.  In my experience regular expressions have a tendency to eat up 
the server.  For something this simple I'd use

cfset phone_number = Replace(phone_number, " ", "", "ALL")


Katrina Chapman
Consultant 
Ameriquest Mortgage




"Erki Esken" [EMAIL PROTECTED]
07/21/00 07:28 AM
Please respond to cf-talk

 
To: [EMAIL PROTECTED]
cc: 
Subject:Re: How Eliminate blank spaces between words ??

 I need to eliminate the blank spaces between numbers in phone
 numbers so that 07 987 635 can be converted to 07987635
 
 the code needs to read the value in the phone variable from
 the database table and then remove the blank spaces as
 indicated above

Use this RegExp:

cfset phoneNumber = ReReplace(phoneNumber, "[[:space:]]", "", "ALL")


Erki

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' 
in the body.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

test please ignore.

[KChapman]

Didn't you read the subject line?

:)
--K


Katrina Chapman
Consultant
Ameriquest Mortgage


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Form.Fieldnames Missing

[KChapman]

That's what we're running as well.

--K


Katrina Chapman
Consultant 
Ameriquest Mortgage




"Dave Watts" [EMAIL PROTECTED]
07/11/00 08:37 PM
Please respond to cf-talk

 
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:RE: Form.Fieldnames Missing

 Is there a reason why the form.fieldnames field would not be
 passed in a form?

I vaguely seem to recall that in some versions of CF prior to 4.5.x, if 
the
ENCTYPE attribute of the form is set to "multipart/form-data", which is 
what
you'd use for file uploads, FORM.FIELDNAMES wouldn't appear. 
Unfortunately,
I can't test that theory, since I'm running 4.5.1.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' 
in the body.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Form.Fieldnames Missing

[KChapman]

While the form isn't only checkboxes or radio buttons this helps.

Thanks,
--Kat


Katrina Chapman
Consultant 
Ameriquest Mortgage




Dan Haley [EMAIL PROTECTED]
07/12/00 08:51 AM
Please respond to cf-talk

 
To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED]
cc: 
Subject:RE: Form.Fieldnames Missing

I can recreate the error if the only form elements that are named are
checkboxes and radio buttons, and none of them have been checked or
selected.  At that point form.fieldnames is not defined in the action 
page.
Any chance your form only has checkboxes and radio buttons?

Dan

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 11, 2000 8:37 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Form.Fieldnames Missing


 Is there a reason why the form.fieldnames field would not be
 passed in a form?

I vaguely seem to recall that in some versions of CF prior to 4.5.x, if 
the
ENCTYPE attribute of the form is set to "multipart/form-data", which is 
what
you'd use for file uploads, FORM.FIELDNAMES wouldn't appear. 
Unfortunately,
I can't test that theory, since I'm running 4.5.1.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' 
in the body.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: You know what would be really cool?

[KChapman]

Actually it's

The future's so bright, I gotta wear shades!

Just an FYI.

--K


Katrina Chapman
Consultant 
Ameriquest Mortgage




Greg Creedon [EMAIL PROTECTED]
07/12/00 08:54 AM
Please respond to cf-talk

 
To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED]
cc: 
Subject:RE: You know what would be really cool?

I see! What a great idea. All of the tech staff and admins would have
their Allaire Secret Decoder Rings(tm), available in Personal or
Enterprise versions. Error says ODBC error? A quick flick of the dial and
it's actually a syntax error! Zounds! a misplaced  sign.

The future is so bright, I need shades!

Greg Creedon

On Wed, 12 Jul 2000, Bryan Batchelder wrote:

 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_01BFEC13.BA40F1D0
 Content-Type: text/plain
 
 Or they have deliberately misinformed you in the error message :-)  Not 
that
 the error is deliberate...but the information it is giving you could be
 deliberately wrong.
 
 I have done this in past systems I have worked on.and set up most of 
my
 UNIX boxes to give wrong profiling information (including information in
 errors).
 
 Just a thought.  Its fun watching people try linux exploits on a solaris
 box...or vice versa - or making a linux box look like an NT box.
 
 
 Bryan D. Batchelder   Work: 813-935-7100
 Palm/Internet Developer   Home: 727-547-1322
 
 ConnectWise, Inc. (www.ConnectWise.com)
 2803 West Busch Blvd, Suite 204
 Tampa, FL 33618
 
 
 -Original Message-
 From: Steve Bernard [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 12, 2000 11:03 AM
 To: [EMAIL PROTECTED]
 Subject: RE: You know what would be really cool?
 
 
 It is truly a sad state of affairs isn't it? This sort of thing has been
 happening on a regular basis since Allaire first started hosting a 
website.
 All three of their main components, Corporate, Forums, and Beta sites, 
have
 gone down or produced errors that really make them look bad. The two 
general
 types that I have seen the most, and that speak volumes about their
 infrastructure/administration in my opinion, are related to 
performance/load
 and database management. Ironically enough, these are two of tenants of 
the
 Allaire Performance Tuning class, optimizing your code and your 
database.
 Another problem that this exposes is Allaire's attention to detail and
 security. You can learn a lot about a system by getting such error 
messages.
 It may seem innocent enough but from this error message you know:
 
 1) Using IIS
 2) .. therefore, using NT
 3) Web root is on D:, seperate from the system root
 4) Exact path to the customtags directory
 5) Template name
 6) Exact line of offending code
 7) 'CustomTagsV65' may indicate that they have multiple versions in one
 tree. This may provide further opportunity
if the system is breached.
 8) Allaire doesn't monitor it's servers effectively
 9) Allaire doesn't seem to take it's web presence seriously enough even
 though the product it sells is made for
developing high-end, robust, data-driven, web sites (enought buzz 
words
 there?).
 
 All this provides is information, not vulnerabilities, but, it is a 
definite
 start in profiling the system, and all without having to send a single
 suspicious packet their way. Anyone who has spent time profiling systems
 will understand this. So if Allaire is this shoddy in 
protecting/maintaining
 their corporate site what's going on with the areas of the site that 
manage
 customer information?
 
 Steve
 
 p.s. I don't have anything against Allaire, I'm just calling it like I 
see
 it.
 
 
  -Original Message-
  From: Sean Renet [mailto:[EMAIL PROTECTED]]
 
  I think it would be really cool if you went to Allaire's website, 
searched
  for something and didn't get this:
 
Error Diagnostic Information
Error occurred in tag CFSEARCH
 
Collection failed to open: AllaireWeb6SiteSearch
 
 
The error occurred while processing an element with a general
  identifier of (CFSEARCH), occupying document position (28:1) to 
(31:57) in
  the template file
  D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESE
  ARCH.CFM.
 
 
Date/Time: 07/11/00 22:55:58
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 63.203.119.82
HTTP Referer: http://www.allaire.com/search/index.cfm
 
 
 
  How do these guys expect to have people buy into this language when 
thier
  own site is constantly breaking?
 
 

 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 

Re: How to Count? or Record Count?

[KChapman]

I could be totally wrong here but I'm assuming that tbl_SignUp.CreateDate is the time 
that they signed up.  Am I right?

If I am you could just do this

cfquery name="rsSignedUP" datasource="practice"  
SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName,
tbl_Employee.FirstName, tbl_Employee.Email, tbl_Class.ClassID,
tbl_Class.ClassName, tbl_Class.ClassDate, tbl_SignUp.SignUpID,
tbl_SignUp.SU_DateOfferdID, tbl_SignUp.SU_EmployeeID, 
tbl_SignUp.Completed,
tbl_SignUp.CreateDate 
FROM tbl_Employee, tbl_Class, tbl_SignUp 
WHERE EmployeeID = SU_EmployeeID
AND ClassID = SU_DateOfferdID 
AND ClassName = 'Human Resource Mgmt'
ORDER BY tbl_Class.ClassDate, tbl_SignUp.CreateDate, #DefOrder#
/cfquery

This sort order would put the classes together, then put them in order by 
who signed up when, then whatever #DefOrder# is.

Is that what you wanted?

--K


Katrina Chapman
Consultant 
Ameriquest Mortgage




Paul Ihrig [EMAIL PROTECTED]
07/12/00 09:13 AM
Please respond to cf-talk

 
To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED]
cc: 
Subject:How to Count? or Record Count?

Ok this is going to sound a bit odd since i am not sure how to word it.

i have my little query: [in my admin page for viewing who has signed up 
for
the class]

[[from dataview01.cfm]]

cfquery name="rsSignedUP" datasource="practice"  
SELECT tbl_Employee.EmployeeID, tbl_Employee.LastName,
tbl_Employee.FirstName, tbl_Employee.Email, tbl_Class.ClassID,
tbl_Class.ClassName, tbl_Class.ClassDate, tbl_SignUp.SignUpID,
tbl_SignUp.SU_DateOfferdID, tbl_SignUp.SU_EmployeeID, 
tbl_SignUp.Completed,
tbl_SignUp.CreateDate 
FROM tbl_Employee, tbl_Class, tbl_SignUp 
WHERE EmployeeID = SU_EmployeeID
AND ClassID = SU_DateOfferdID 
AND ClassName = 'Human Resource Mgmt'
ORDER BY #DefOrder#
/cfquery

Which is grabbing a list of employees which could have signed up for 1
class, given on 2 differnt dates.

My problem is, that the class size needs to be limited to 25 people.
This is stated on my main form.

it also shows how many people are currently singed up for class 01  class
02.
[[from signup01.cfm]]

cfquery name="rsDate01" datasource="practice"  
SELECT SignUpID, SU_DateOfferdID 
FROM tbl_SignUp 
WHERE SU_DateOfferdID = 1
/cfquery

cfquery name="rsDate02" datasource="practice"  
SELECT SU_DateOfferdID 
FROM tbl_SignUp 
WHERE SU_DateOfferdID = 2
/cfquery

[[the display]]

A limit of 25 spaces are available per class per day.
You will be notified if you are selected for the class  time.
.   cfoutput#rsDate01_total#/cfoutput  people have signed up so 
far
for 
cfoutput# LSDateFormat(rsDisplayDate01.ClassDate, ', 
   DD, ') #/cfoutput.br
 
bcfoutput#rsDate02_total#/cfoutputnbsp/b 
people for cfoutput# LSDateFormat(rsDisplayDate02.ClassDate,
', 
   DD, ') #/cfoutput

So, on the form i show how many have signed up.

But on the admin page, i cant figure out how to show who has signed up in
sequential order.
Because on one admin page i have 2 seperate date/times they could sign up.

Its not really abig deal.
i would just like to know how to get the number of the last insert Total + 
1
as the number that realates to the student who signed up.??
I know i should have used a sepereate table for each Class/time.

mabey i will redo it from the ground up.
But since it is 10 different classes with 2 times each, spread out over 
the
next year.
I wanted to be able to track Student/employees progress through this
"Practice Manegment" class.

lol
no one will read this!

Thanks if you do!

-paul

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' 
in the body.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: why is this happening?

[KChapman]

It shouldn't matter what kind of field it is in the database.  You need to 
escape your comma's.

Try this.

cfset message_body = Replace(query.BODY, ",", "Chr(44)", "ALL")

cfquery datasource="datasourcename"
 insert into emails(SUBJECT,
 FROMX,
 TO,
 DATEX,
 BODY,
 ATTACHMENTS,
 CC,
 MESSAGENUMBER,
 ATTACHMENTFILES,
 REPLYTO,
 HEADER,
 TIMEx)
 
  values ( '#query.SUBJECT#',
  '#FROMX#',
  '#query.TO#',
  #DATEy#,
  '#message_body#',
  '#ATTACHMENTSX#',
  '#query.CC#',
  '#query.MESSAGENUMBER#',
  '#ATTACHMENTFILESX#',
  '#query.REPLYTO#',
  '#query.HEADER#',
  '#TIMEx#');
 
 /cfquery


Then when you output it you do the opposite.

--K


Katrina Chapman
Consultant 
Ameriquest Mortgage




Douglas Jordon [EMAIL PROTECTED]
07/12/00 09:49 AM
Please respond to cf-talk

 
To: [EMAIL PROTECTED]
cc: 
Subject:Re: why is this happening?

That's interesting, because I had narrowed the fields down to one: the
body field which of course contains commas(the data is email). How do I
get around this? It's an Access database memo field.

DJ

"Dempsey, Timothy F." wrote:
 
 Doug,
 
 Could one of you values have a comma in it? That might make the database
 think it has more values than you intend.
 
 -- Tim Dempsey
 
 -Original Message-
 From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 12, 2000 11:06 AM
 To: Cold Fusion List
 Subject: why is this happening?
 
 Why would this query:
 
 cfquery datasource="datasourcename"
 insert into emails(SUBJECT,
 FROMX,
 TO,
 DATEX,
 BODY,
 ATTACHMENTS,
 CC,
 MESSAGENUMBER,
 ATTACHMENTFILES,
 REPLYTO,
 HEADER,
 TIMEx)
 
  values ( '#query.SUBJECT#',
  '#FROMX#',
  '#query.TO#',
  #DATEy#,
  '#query.BODY#',
  '#ATTACHMENTSX#',
  '#query.CC#',
  '#query.MESSAGENUMBER#',
  '#ATTACHMENTFILESX#',
  '#query.REPLYTO#',
  '#query.HEADER#',
  '#TIMEx#');
 
 /cfquery
 
 return this error?:
 
 ODBC Error Code = 21S01 (Insert value list does not
 match column list)
 
  [Microsoft][ODBC Microsoft Access 97 Driver] Number
 of query values and destination fields aren't the
 same.
 
 What's also odd is that the data is being saved to the table.
 
 TIA,
 
 Doug Jordon
 

 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' 
in
 the body.
 
--
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' 
in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' 
in the body.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: saving queries

[KChapman]

cfquery name="session.myquery" ...

Will load it into a session variable.

--K


Katrina Chapman
Consultant 
Ameriquest Mortgage




"Eli Shechter" [EMAIL PROTECTED]
07/12/00 11:32 AM
Please respond to cf-talk

 
To: [EMAIL PROTECTED]
cc: 
Subject:saving queries

Hi

i know there is a way to do this, i just dont know the syntax.

i would like to save a query result into a variable

cfset var = query.resultset

can anyone help me with the proper way to do this??

Thanx
-Eli-

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' 
in the body.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: cf query::

[KChapman]

cfquery datasource="#odbc#" name="getcategoryData"
SELECT *
from Items
WHERE Category LIKE '%#categoryVar#%'
AND (sub1 LIKE '%#url.sub1#%'
OR sub2 LIKE '%#url.sub1#%')
/cfquery

Should Work.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Chip  
 
Sigourney"   To: "Cf-Talk@Houseoffusion. Com" 
[EMAIL PROTECTED]   
gators1@fgi.cc:   
 
net Subject: cf query::   
 
   
 
07/11/00   
 
01:51 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



My problem is that it doesn't narrow down the products at all because it is
only passing the category and
the sub1. I need it to pass the category, the sub1 and the sub2 and then
the
Query on Cat2.cfm needs to select only those products. Do you know how I
can
do that?


cfquery datasource="#odbc#" name="getcategoryData"
SELECT * from Items WHERE Category LIKE '%#categoryVar#%'  AND sub1 LIKE
'%#url.sub1#%' or Category LIKE '%#categoryVar#%' AND sub2 LIKE
'%#url.sub1#%'
/cfquery

thanks

--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Stored Procedure Help

[KChapman]

This is my first time working with a stored procedure and I'm not sure that
I'm doing it right.

I can get the procedure to run but I can't get the values to display.  What
am I missing

!-- cfcode --

CFSTOREDPROC PROCEDURE="p_pricing_pipeline"
DATASOURCE="#application.datasource#"

 CFPROCPARAM TYPE="IN"
VARIABLE="broker_id"
DBVARNAME="@broker_id"
VALUE="112"
CFSQLTYPE="CF_SQL_INTEGER"

 CFPROCRESULT NAME="test"

/cfstoredproc

cfoutput
!#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - !
#comment_exists#!br
/cfoutput

!--Stored Procedure--

SET QUOTED_IDENTIFIER  OFFSET ANSI_NULLS  ON
GO


--
-- Given a broker, find data for its most recent 5 prequals.
--
-- DateAuthor Change
-- 07/07/00 D Noble Created.
--
create procedure dbo.p_Pricing_Pipeline (
 @broker_id int
)
as

set nocount on

create table #prequal (
 prequal_num int not null
,borrower_lastname varchar(96) null
)

insert #prequal
select top 5
 prequal_num
,borrower_lastname
from prequal
where broker_id = @broker_id
order by prequal_num desc

create table #half_results (
 prequal_num int not null
,borrower_lastname varchar(96) null
,loan_status_rank tinyint null
,number_of_comments int null
)

insert #half_results
select
 p.prequal_num
,p.borrower_lastname
,min(ls.loan_status_rank)
--,sum(isnull(c.prequal_num,0))
,sum(
 case
 when c.prequal_num is null then 0
 else 1 end
)

from
#prequal p
join scenario s on p.prequal_num = s.prequal_num
join loanstatus ls on s.loan_status_id = ls.loan_status_id
left join comment c on p.prequal_num = c.prequal_num

group by
 p.prequal_num
,p.borrower_lastname

select
 prequal_num as prequal_num
,borrower_lastname as borrower_lastname
,loan_status_rank as highest_status
,case number_of_comments
 when 0 then 0
 else 1 end as comment_exists
from #half_results

drop table #prequal
drop table #half_results

return 0


GO
SET QUOTED_IDENTIFIER  OFFSET ANSI_NULLS  ON
GO

TIA,
--K


Katrina Chapman
Consultant
Ameriquest Mortgage

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Stored Procedure Help

[KChapman]

Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank
you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!
Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank
you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!
Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank
you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!
Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank
you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!
Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank
you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!
Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank
you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!

I don't think I said that enough.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
  
[EMAIL PROTECTED] 
  
tate.ky.usTo: [EMAIL PROTECTED]
  
  cc:  
  
07/10/00 12:03Subject: RE: Stored Procedure Help   
  
PM 
  
Please respond 
  
to cf-talk 
  
   
  
   
  



Just like a cfquery, you need to reference the query:

cfoutput query="test"
!#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - !
#comment_exists#!br
/cfoutput

or

cfoutput
!#test.prequal_num#! - !#test.borrower_lastname#! - !#test.highest_status#!
- !
#test.comment_exists#!br
/cfoutput


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 10, 2000 2:07 PM
To: [EMAIL PROTECTED]
Subject: Stored Procedure Help


This is my first time working with a stored procedure and I'm not sure that
I'm doing it right.

I can get the procedure to run but I can't get the values to display.  What
am I missing

!-- cfcode --

CFSTOREDPROC PROCEDURE="p_pricing_pipeline"
DATASOURCE="#application.datasource#"

 CFPROCPARAM TYPE="IN"
VARIABLE="broker_id"
DBVARNAME="@broker_id"
VALUE="112"
CFSQLTYPE="CF_SQL_INTEGER"

 CFPROCRESULT NAME="test"

/cfstoredproc

cfoutput
!#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - !
#comment_exists#!br
/cfoutput

!--Stored Procedure--

SET QUOTED_IDENTIFIER  OFFSET ANSI_NULLS  ON
GO




--
-- Given a broker, find data for its most recent 5 prequals.
--
-- DateAuthor Change
-- 07/07/00 D Noble Created.


--
create procedure dbo.p_Pricing_Pipeline (
 @broker_id int
)
as

set nocount on

create table #prequal (
 prequal_num int not null
,borrower_lastname varchar(96) null
)

insert #prequal
select top 5
 prequal_num
,borrower_lastname
from prequal
where broker_id = @broker_id
order by prequal_num desc

create table #half_results (
 prequal_num int not null
,borrower_lastname varchar(96) null
,loan_status_rank tinyint null
,number_of_comments int null
)

insert #half_results
select
 p.prequal_num
,p.borrower_lastname
,min(ls.loan_status_rank)
--,sum(isnull(c.prequal_num,0))
,sum(
 case
 when c.prequal_num is null then 0
 else 1 end
)

from
#prequal p
join scenario s on p.prequal_num = s.prequal_num
join loanstatus ls on s.loan_status_id = ls.loan_status_id
left join comment c on p.prequal_num = c.prequal_num

group by
 p.prequal_num
,p.borrower_lastname

select
 prequal_num as prequal_num
,borrower_lastname as borrower_lastname
,loan_status_rank as highest_status
,case number_of_comments
 when 0 then 0
 else 1 end as comment_exists
from #half_results

drop table #prequal
drop table #half_results

return 0


GO
SET QUOTED_IDENTIFIER  OFFSET ANSI_NULLS  ON
GO

TIA,
--K


Katrina Chapman
Consultant
Ameriquest 

Form.Fieldnames Missing

[KChapman]

Is there a reason why the form.fieldnames field would not be passed in a
form?

--K


Katrina Chapman
Consultant
Ameriquest Mortgage

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Form.Fieldnames Missing

[KChapman]

I dont' think that's it because the it's missing on several different
forms.  Here's the debugging info.

1st form

BROKER_POINTS=0
BROKERPYA=0
CALCULATE_FOR=BrokerPYA
CALCVIAJS=
CATEGORY=
CLTV=0
COMMENTS=
CONFIRMPASS=
CREDIT_RISK=
EMAIL=
FAX=
FIRST=
HOW_HEAR=
LAST=
LOAN_AMOUNT=0
LTV=0
NEWPASS=
OC=
OTHER_CATEGORY=
OTHER_FINANCING=No
OTHER_FINANCING_AMOUNT=
PHONE=
PREPAYMENT_TERM=
PREPAYMENT_TERM_ID=1
SAVE_SCENARIO_NUM=1
STATE=1


2nd form

BANKRUPTCY=NO
BANKRUPTCYDATE=mm/dd/yy
BANKRUPTCYTYPE=
BROKER_POINTS=0
BROKERPYA=0
CALCULATE_FOR=BrokerPYA
CALCULATED=1
CALCVIAJS=
CATEGORY=
CLTV=0
COMMENTS=
CONFIRMPASS=
CREDIT_RISK=
CREDITSCORE=670
DEBTRATIO=35
EMAIL=
FAX=
FIELDNAMES=CREDITSCORE,DEBTRATIO,THIRTYDAYS,SIXTYDAYS,NINETYDAYS,ONETWENTYDAYS,NOD,RESCINDDATE,BANKRUPTCY,BANKRUPTCYDATE,BANKRUPTCYTYPE,CALCULATED,SUBMIT

FIRST=
HOW_HEAR=
LAST=
LOAN_AMOUNT=0
LTV=0
NEWPASS=
NINETYDAYS=0
NOD=NO
OC=
ONETWENTYDAYS=0
OTHER_CATEGORY=
OTHER_FINANCING=No
OTHER_FINANCING_AMOUNT=
PHONE=
PREPAYMENT_TERM=
PREPAYMENT_TERM_ID=1
RESCINDDATE=mm/dd/yy
SAVE_SCENARIO_NUM=1
SIXTYDAYS=0
STATE=1
SUBMIT=Calculate
THIRTYDAYS=0

3rd form

BANKRUPTCY_TYPE_ID=0
BORROWER_LASTNAME=
BROKER_ID=112
BROKER_POINTS= .000
BROKER_PYA=
BROKERPYA=0
CALCULATE_FOR=Broker PYA
CALCVIAJS=
CATEGORY=
CLTV=0
CLTV_OTHER_FINANCING_AMT=
COMMENTS=
CONFIRMPASS=
CREDIT_RISK=AAA
EMAIL=
FAX=
FIRST=
HOW_HEAR=
INCOME_DOCUMENTATION=
INCOME_DOCUMENTATION_ID=
LAST=
LOAN=
LOAN_AMOUNT=0
LOAN_AMT=0
LOAN_PURPOSE_ID=
LOAN_STATUS_ID=6
LTV=0
NEWPASS=
OC=
OCCUPANCY=
OCCUPANCY_ID=
OTHER_CATEGORY=
OTHER_FINANCING=No
OTHER_FINANCING_AMOUNT=
OWNERS_ID=11
PHONE=
PREPAYMENT_PENALTY=0
PREPAYMENT_TERM=
PREPAYMENT_TERM_ID=
PREQUAL_NUM=000407
PRODUCT=
PRODUCT_ID=
PROPERTY_LOCATION=
PROPERTY_LOCATION_ID=
PROPERTY_TYPE=
PROPERTY_TYPE_ID=
PROPERTY_VALUE=
PURCHASE_PRICE=0
REQ_START_RATE=
RISK_CODE=A
RISKBANKRUPTCYDATE=
RISKBANKRUPTCYTYPE=
RISKBANKRUPTCYTYPEID=0
RISKCREDITSCORE=670
RISKDEBTRATIO=35
RISKNINETYDAYS=0
RISKNODRESCINDDATE=
RISKONETWENTYDAYS=0
RISKSIXTYDAYS=0
RISKTHIRTYDAYS=0
SALES_PRICE=
SAVE=Save
SAVE_SCENARIO_NUM=1
SCENE_LTV=0
SCENE_UW_TIME={ts '2000-07-10 15:40:45'}
START_RATE=0
STATE=1
STATE_ID=1
UW_BANKRUPTCY_RELEASE_DATE=NULL
UW_CREDIT_SCORE=670
UW_DEBT_RATIO=35
UW_MORTGAGE_HIST_120=0
UW_MORTGAGE_HIST_30=0
UW_MORTGAGE_HIST_60=0
UW_MORTGAGE_HIST_90=0
UW_NOD_RESCIND_DATE=NULL
YOUR_NAME=


If you notice only the second form sends the field.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
   
"Gregory   
   
Harris"To: [EMAIL PROTECTED] 
   
[EMAIL PROTECTED]cc: 
   
.la.ca.us Subject: Re: Form.Fieldnames Missing
   
   
   
07/10/00 03:10 
   
PM 
   
Please respond 
   
to cf-talk 
   
   
   
   
   



There is a default field in EVERY form passed via coldfusion called
fieldnames, this contains a comma spliced list of all the fieldnames in the
form.  Your code could be causing a conflict with this default field.
Would advise checking and renaming.

Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 07/10 3:01 PM 
Is there a reason why the form.fieldnames field would not be passed in a
form?

--K


Katrina Chapman
Consultant
Ameriquest Mortgage

--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--

Archives: 

Re: Form.Fieldnames Missing

[KChapman]

No because it's not a URL variable.  It's a Form variable.  And even if
that were the case it would be there just truncated.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
Judah McAuley  
 
judah@alphasTo: [EMAIL PROTECTED] 
 
hop.com cc:   
 
 Subject: Re: Form.Fieldnames Missing  
 
07/10/00   
 
04:07 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



At 03:53 PM 7/10/00 -0700, you wrote:
Dunno at this point, my next advice might be to check your HTML on the
forms that are sending it, I've seen some unpredictable behaviors due to
bad HTML on the forms.  However I doubt this is the only issue, any other
ideas from the crowd please?

Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]

I believe that there is a maximum character length allowed for
URL's.  Could that be the case for form fields?  And could these examples
be bumping up against that limit?

Got me stumped, otherwise.

Judah

--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Snooping CFDOCS directory?

[KChapman]

You can do what we do here.

Put the cfdocs and cfide directories in a directory other than wwwroot(or
what ever your root directory is) and then map them virtually.  That way
you can still access them through the browser but you don't have the same
security problems.  You can also add ip restrictions so that only people
that you know have access.

Email me off list and I can tell you how to do this.  That is of course if
you're running MS's IIS.

--K

Katrina Chapman
Consultant
Ameriquest Mortgage


   

"Ric Smith"

rickyfusion@fusionsTo: [EMAIL PROTECTED]

erver.com  cc:

Subject: Re: Snooping CFDOCS 
directory?
07/05/00 01:56 PM  

Please respond to  

cf-talk

   

   




Thanks. Yeah, I've got the fix that only allows localhost access
I just got real nervous and wanted to make sure I wasn't missing
something.

I think I'll go ahead and remove the CFDOCS completely. Should
I also move the CFIDE directory to something obscure?

Ric Smith



 They were probably using a canned script which looks for the CF
 vulnerabilities. Either remove /CFDOCS/*, install the security fix, or
just
 remove the files in /expeval/. FYI, the security fix simply restricts
access
 to the localhost address for the files.

 Steve


 -Original Message-
 From: Ric Smith [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 05, 2000 4:12 PM
 To: [EMAIL PROTECTED]
 Subject: Snooping CFDOCS directory?


 I was looking through my logfile reports and found these
 entries which troubled me.

 http://www.kungfoo.com/cfdocs/expeval/displayopenedfile.cfm
 http://www.kungfoo.com/cfdocs/expeval/sendmail.cfm
 http://www.kungfoo.com/cfdocs/expeval/exprcalc.cfm
 http://www.kungfoo.com/cfdocs/expeval/openfile.cfm
 http://www.kungfoo.com/scripts/iisadmin/bdir.htr

 It appears someone was trying to do something they shouldn't
 have.

 I removed the /scripts/iisadmin directory long ago but the
 CFDOCS directory is still there. Is it safe to remove or rename
 this directory? What about the CFIDE directory, would it be
 safe to put NT Authentication on that directory?

 I was hoping someone could let me know if there's
 anything I need to worry about.

 Thanks.

 Ric Smith


--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: How to set a future date?

[KChapman]

Look at the DateAdd function

http://127.0.0.1/cfdocs/CFML_Language_Reference/3_ColdFusion_Functions/lr3_068.htm

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
  
aslam bajaria  
  
aslambajaria@To: [EMAIL PROTECTED]
  
yahoo.comcc:  
  
  Subject: How to set a future date?   
  
07/05/00 02:48 
  
PM 
  
Please respond 
  
to cf-talk 
  
   
  
   
  



Is there a way to fill in a future date in a column of
a table?

I am familiar with the function now(). Is there a way
of getting 1year, 1 month , 1 day, 1 hr, 1 min, 1 sec

from now and filling it in in a column of a table?

Appreciate.
A.B.

__
Do You Yahoo!?
Send instant messages  get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Changing default CF error for nonexistent templates

[KChapman]

If you're running IIS you can do it through the MMC.  Are you running IIS?
If so email me off list and I can walk you through it.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Duane 
 
Boudreau"To: "CFTalk" [EMAIL PROTECTED]  
 
dboudreau@ekcc:   
 
tron.comSubject: Changing default CF error for 
nonexistent templates   
   
 
06/28/00   
 
12:49 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



Hi All,

Is there a way to customize the default error that CF 4.01 generates when a
http request is generated for a template that does not exist?

(The solution is pretty easy for 4.5: there is a way with the admin to map
missing templates to a cfm template using its physical path. Unfortunately
I
can not upgrade to 4.5 at this time)

TIA,
Duane Boudreau,
Project/Beta Manager, eMPower
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249
Fax: 603-594-0258

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Textarea

[KChapman]

Textarea doesn't have a value attribute.  You have to do this.

textarea cols=50 rows=10 name="body" wrap="virtual" font="arial"
#body#/textarea

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
Gregg Kachel   
 
[EMAIL PROTECTED]To: [EMAIL PROTECTED] 
 
t   cc:   
 
 Subject: Textarea 
 
06/27/00   
 
10:26 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



Hi, I'm sort of a newbie with Cold fusion, so I'm probably doing some
simple mistake. I can't get my text to show up on a cfquery using
textarea tag. Here is my code:
textarea cols=50 rows=10 name="body" wrap="virtual" font="arial" value=
"#body#"/textarea
Wierd thing is if I change it to an imput type ="text" it works fine. So i
know it has to be something in my textarea code. Wierd part is, that same
exact code is used elsewhere and works. If anyone can help please do,
thanks.  The database is in access and is set for "memo" in that field.  It

wouldn't be so bad but, some of the articles are rather long for a normal
text field.

Gregg Kachel

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Inserting Multiple Values into One Database Field

[KChapman]

That should throw a SQL error.  What you need to do is create the list
outside of your query statement.

cfset keywords = name  'and'  address  'and'  phone

CFQUERY name="insert" datasource="search"
INSERT INTO search(keywords)
VALUES('#keywords#')
/CFQUERY

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
Anthony
 
Israel-Davis To: "'[EMAIL PROTECTED]'" 
[EMAIL PROTECTED]  
anthony@tripcc:   
 
wire.comSubject: RE: Inserting Multiple Values 
into One Database Field 
   
 
06/23/00   
 
03:06 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



Try this:

CFQUERY datasource="search"
INSERT INTO search(keywords)
VALUES('#name#,#address#,#phone#')
/CFQUERY

remove the "AND"s and wrap the whole thing in single quotes.  Hope that
helps

ant

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 1:56 PM
To: [EMAIL PROTECTED]
Subject: Inserting Multiple Values into One Database Field


Ok, what i am trying to do is add a column in my database that would
contain

"Keywords" for a search.

What i am trying to do is add values from the data entered in the form from

the previous page to one field in the database

I only get a value of "-1"  ?  is there something i am doing wrong???

CFQUERY datasource="search"
INSERT INTO search(keywords)
VALUES('#name#' AND '#address#' AND '#phone#')
/CFQUERY

Help?

-kev


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

(kinda OT) Memory Write Error/Browser Crash

[KChapman]

I have been getting reports of a very wierd error that I cannot recreate on
my machine.  When a user gets to a certain form on my site and then clicks
the back button they get a windows error that reads.

The intruction at "0x715c167a" referenced memory at "0X0100".  The
memory could not be written.

Click on OK to terminate the application
Click on CANCEL to debug the application

Any ideas as to what could be causing this.  The site is on a NT 4  SP6a
box, running cf 4.51 SQL 7.0.  It only happens in IE and not in Netscape.

TIA,
--K


Katrina Chapman
Consultant
Ameriquest Mortgage

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Need help with a SQL query

[KChapman]

If all you want is a comma seperated list of the categories for each item.
Why not just add a "categories" field to the item table?  Store the comma
seperated list there.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
   
"Seth  
   
Petry-Johnson" To: [EMAIL PROTECTED] 
   
seth@argoentercc: 
   
prise.com Subject: Re: Need help with a SQL query 
   
   
   
06/21/00 05:48 
   
AM 
   
Please respond 
   
to cf-talk 
   
   
   
   
   



 Right, I'm not gonna address the whole thing (no time at the moment), but
a
 quick word about sub-queries

 They should be used in 2 ways - one to return a single result;
 select * from myTable where myValue=(select myValue from myOtherTable
 where...)

 Or to return multiple values
 select * from myTable where myValue in (select myValue from myOtherTable
 where...)

 The second is a lot more useful for what you're looking for

Right, but I don't see how that helps me.  Neither of those two uses of
subqueries returns a LIST of values that can be used in a single field of
the parent query.

For example, if my mapping table looks like so:
ItemIDCategoryID
--
11
12
14
22
24

I would like the details query for ItemID 1 to have the following fields:
.Name - simply pulled from item table
.Desc - simply pulled from item table
.CategoryIDs - "1,2,4"

I've looked through a couple of my SQL books and haven't found an answer,
so
maybe this isn't possible (using SQL 6.5, BTW).  Its not THAT big of a deal
to run two queries.

Thanks for the help,
Seth Petry-Johnson
Argo Enterprise and Associates

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Client variable time out.

[KChapman]

I know that I shouldn't be using client.something variables but I inherited
this code and I dont' have the time to go through it and replace them.  Is
there somewhere that you can specify the timeout for client varaibles?

I know that you can control the application and session variable timeouts
with the cfapplication tag and in the administrator but I'm not sure about
client. variables.

TIA,
--K


Katrina Chapman
Consultant
Ameriquest Mortgage

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Fw: Funny

[KChapman]

Absolutely hilarious.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Nick Han" 
 
nhan@go2systTo: [EMAIL PROTECTED] 
 
ems.com cc:   
 
 Subject: Fw: Funny
 
06/19/00   
 
03:30 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 




This is a multi-part message in MIME format.

--=_NextPart_000_001D_01BFDA03.49CAD590
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

 The male and female stages of life.
--=_NextPart_000_001D_01BFDA03.49CAD590
Content-Type: application/octet-stream;
 name="LIFE_STAGES.TXT.SHS"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="LIFE_STAGES.TXT.SHS"

0M8R4KGxGuEAPgADAP7/CQAGAAABAQAA

EgEAAAD+AAD/













///9

BP7///87QgYHCAkKCwwNDg8A

AAAQEQAAABITFBUWFwAAABgZGgAAABscHQAA

AB4fICEiIwAAACQlJgAAACcoKQAAACor

LC0uLwAAADAxMgAAADM0NQAAADY3ODk6

/v///zw9PgAAAD8AAABAQQAAAEMAAAD+/v///0UAAABGRwAAAEgA

AABJSgAAAEsAAABM/v//





/1IA

bwBvAHQAIABFAG4AdAByAHkA

AAAWAAUA//8IAGBIIk91w78B

AwAAAIAQAwBJAFQARQBNADAAMAAw

ABIAAQH//wYMAAMAAMBGAAAR

wEh1w78BoGvySHXDvwEBAE8AbABl

CgACAf8D/wAA

AAAUAAEAQwBvAG0AcABPAGIAagAA

AAASAAIA

AQAAAFAA/v//

/wIAAAD+/v///wUGBwgJCgsMDQ4P

EBESEwAAABQVFgAAABcYGQAAABobHB0e

HwAAACAhIgAAACMkJQAAACYnKCkqKwAAACwA

AAAtLgAAAC8wMQAAADIzNDU2NwAAADg5OgAA

ADs8PQAAAP7///8//v7+







//8BAAAC

Re: CFSILENT not working?

[KChapman]

What do you mean that the server yelled at you?  Do you mean an error
message was displayed?  If so can we see it?

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Pablo 
 
Nevares" To: [EMAIL PROTECTED]   
 
pnevares@hpacc:   
 
pts.com Subject: CFSILENT not working?
 
   
 
05/31/00   
 
02:36 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



I tried using cfsilent to suppress the output of an ArrayAppend()
function, and CF server yelled at me. =) Apparently it doesn't recognize
the
tag, which sort of goes along with the fact that CF Studio doesn't try to
autocomplete when I type cfsil 

Anyone else have this problem? Both apps are v4.5.

Pablo Nevares
Information Technology
Hendricks  Partners
[EMAIL PROTECTED]

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Is there a typical cause for this error message?

[KChapman]

The data that you're trying to input into the field is too long.  Either
increase the size of the field or reduce the length of the data.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
Steve Weiner   
 
Steve@TeleImTo: "'[EMAIL PROTECTED]'" 
[EMAIL PROTECTED]  
age.com cc:   
 
 Subject: Is there a typical cause for 
this error message?  
06/01/00   
 
07:43 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22001 (String data right truncation)


[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (41:7) to (41:98).



--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Some beginner questions

[KChapman]

1. Don't Know.
2. As far as I know you should be able to use almost anything in  the data
except #'s.
3. Just use the name of the field you want.  IE:

If cfoutput#query_string#/cfoutput is ?cfid=1234cftoken=76323661

Then to access just the pieces you  would

cfoutput
cfid = #cfid#br
cftoken = #cftoken#
/cfoutput

and you would get

cfid = 1234
cftoken = 76323661

HTH,
--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
  
"Cristi"   
  
bcristi@innovativTo: [EMAIL PROTECTED]  
  
e.west.rocc:  
  
  Subject: Some beginner questions 
  
05/31/00 07:50 AM  
  
Please respond to  
  
cf-talk
  
   
  
   
  



Hello there.
If anyone can find some time...

1) Can I call a JavaScript function from CF?
   Smth. like CFSET x = f(y)

   where f is a JavaScript function.

   I tried CFSET x = f(y), but it didn't work.

2) How do I manage strings containing special characters as dbl. quote
(i.e.
")
   Should I prefix them with something.

   I'd like to have an output like

   say "hello"
3) How can I get the value of each field in a query string?
   I know the #cgi.query_string# which returns the entire query
string, but I
want to access specific fields

Thanks in advance

Cristi

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: sending a server-file on a cf page

[KChapman]

What do you mean you want to send a file?  Do you mean you want to write to
a file on the d drive?  Or are your user's uploading a file? or do you mean
that you want to serve the file from the D drive while the wwwroot is on
the c drive?

If it's the last you can use cfcontent.  (maybe)

CFCONTENT TYPE="text\html"
DELETEFILE="No"
FILE="D:\whatever\nameoffile.html"
RESET="No"

This of course will only work if the cfcontent tag hasn't been disabled in
the administrator.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Daive"
 
dmailing@allTo: [EMAIL PROTECTED]   
 
iacom.net   cc:   
 
 Subject: sending a server-file on a cf 
page
05/31/00   
 
09:44 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



Hey all

i want to send a file on my drive D: when a user load a cfm file. is there
a
way to do that without virtual stuff on my web server? my webroot is on my
drive C: .. and i'm using cf server 4.5

daive


--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: [french] tres court : emploi

[KChapman]

Ce ne pas une intrusion.

Si vous êtes disposé à relocate (Comment dis donc relocate en Français?)
qq'n a Paris Nord.  J'irai.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
  
"Yannick Simon"
  
yannick.simon@rueducoTo: [EMAIL PROTECTED]  
  
mmerce.frcc:  
  
  Subject: [french] tres court : 
emploi  
05/26/00 10:04 AM  
  
Please respond to  
  
cf-talk
  
   
  
   
  



RE: Cold Fusion and NT PasswordsNous avons de gros projets en cours pour
faire une v2 du site Rue Du Commerce. Je ne souhaite pas polluer cette
liste
géniale, mais si vous etes interessé, je cherche un tres bon developpeur,
sur Paris Nord, un an d'experience cold fusion pour des projets dans une
boite super ... vous etes interessé, envoyez moi votre cv ... vous me
trouvez qq'un pour le poste ? je vous promets une prime de cooptation.

pardon de cette intrusion.

Yannick Simon


--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Bug report update 5/25/2000

[KChapman]

Is this possible?

--K


Katrina Chapman
Consultant
Ameriquest Mortgage
- Forwarded by Katrina Chapman/CORP/AMQ on 05/26/00 02:19 PM -
   
  
Tamara Kaplan  
  
 To: Katrina Chapman/CORP/AMQ@AMQ  
  
05/26/00 01:17   cc:   
  
PM   Subject: Re: Bug report update 
5/25/2000(Document link: Katrina Chapman)
   
  
   
  



Although I have never done this myself, this seems to work:

You specify the timeout like normal with something like this:

CFAPPLICATION NAME="WHATEVER" SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="
#CreateTimeSpan(0,1,30,0)#"

And then you specifically set cookie values.  By specifically naming these
variables, they will die when the browser is closed.

CFCOOKIE NAME="CFID" VALUE="#Session.CFID#"
CFCOOKIE NAME="CFTOKEN" VALUE="#Session.CFTOKEN#"

Please give it a try and see if it works.  Otherwise, I agree with you that
they are in opposition with each other, and no, we wouldn't want to rely on
JavaScript to do this.

Thanks.
Tamara



   
  
Katrina
  
Chapman  To: Tamara Kaplan/CORP/AMQ@AMQ
  
 cc:   
  
05/26/00 11:53   Subject: Re: Bug report update 
5/25/2000(Document link: Tamara Kaplan)  
AM 
  
   
  
   
  



#488 "Return to Broker Login results in lost data" has to do with the
session timeout.  I remember Kimberly saying that we would address this
issue when we have the users test the site.  My 2 cents: it's too short.  I
would suggest 30 minutes and then see if we need it bumped up during the
pilot.

New/Re-open: User info is not logged out upon closing the browser.  Tested
v.4.4.

These two are in direct opposition to each other.  You can't have a timeout
of 30 minutes and then be logged out as soon as the browser closes.  At
least not the way that we are currently maintianing state.  We're using
cookies.

The only way you could do it would be with a javascript:onClose event, but
that's unreliable.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage





--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: I've got the alternating table row color blues

[KChapman]

Actually he doesn't.

Look closer.

I'll help

tr bgcolor="#cfoutput#IIf(CurrentRow Mod 2, DE('ff'), DE('99ccff'))
#/cfoutput"

Would result in either

tr bgcolor="#ff"
Or
tr bgcolor="#99ccff"

Your's would do the same but without the leading #.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Larry C.  
 
Lyons"   To: [EMAIL PROTECTED] 
 
llyons@ebstocc:   
 
r.com   Subject: Re: I've got the alternating 
table row color blues
   
 
05/24/00   
 
08:24 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



Vance,

have a look at your output statements,
tr bgcolor="#cfoutput#IIf(CurrentRow Mod 2, DE('ff'), DE('99ccff'))
#/cfoutput"

You've got the open cfoutput tag in the wrong place it should be:
 TR bgcolor="cfoutput#IIf(CurrentRow Mod 2, DE('ff'), DE('C0C0C0'))
#/cfoutput"

HTH,
larry
--
Larry C. Lyons
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]
Chaos, panic, and disorder - my work here is done.
--

Vance Duke wrote:

 Agreed.  Here is what the code should look like.

 tr bgcolor="#cfoutput#IIf(CurrentRow Mod 2, DE('ff'),
 DE('99ccff'))#/cfoutput"

 I have been doing this successfully for a while now.

 Another way of doing it, is set a Counter and then loop.  Based on the
count
 you can set any color.  I have done it with up to 4 colored rows, but
4000
 colors would be no different (except a very long template).

 Vance Duke
 Applications Developer

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Shortcut for Getting Form Field

[KChapman]

CGI.fieldnames

I know because I'm using this right now for a form that is dynamically
generated.

   --K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
Steve Weiner   
 
Steve@TeleImTo: "'[EMAIL PROTECTED]'" 
[EMAIL PROTECTED]  
age.com cc:   
 
 Subject: Shortcut for Getting Form Field  
 
05/22/00   
 
10:42 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



I'm working on a project that has tons of form fields on a page.  I was
wondering if there was any cf tags or anything that I could take the form,
submit it, and get a list of all the form field names that are available to
me without having to go through and doing all the copying pasting...


Is there anything like that?

[EMAIL PROTECTED]
--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: All the Info on O'Reilly's ColdFusion Book

[KChapman]

If you notice it has a different ISBN.

--K

Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Levi  
 
Wallach" To: [EMAIL PROTECTED]   
 
lwallach@tidcc:   
 
g.com   Subject: RE: All the Info on O'Reilly's 
ColdFusion Book
   
 
05/22/00   
 
02:06 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



Hmmm, I just did a search on this title on Amazon and came up with a Wrox
book!

Professional Coldfusion 4.5
by Wrox Author Team
Our Price: $59.99
Paperback (October 2000)
Wrox Press Inc; ISBN: 1861004540



| Levi Wallach - [EMAIL PROTECTED]  P:(703) 237-0443 F: 703-237-3490|
| Senior Webmaster, Tran Interactive Design Group - http://www.tidg.com |

| Creator, DVDMON.com - http://www.dvdmon.com - [EMAIL PROTECTED] |
| DVD News, Views  Reviews, Music  Book Reviews, PDA Channel Content, |
| Contests, DVD Buying Guide and more!  |
-

 -Original Message-
 From: Kevin Merker [mailto:[EMAIL PROTECTED]]
 Sent: Monday, May 22, 2000 11:04 AM
 To: [EMAIL PROTECTED]
 Subject: All the Info on O'Reilly's ColdFusion Book



 Title: Programming ColdFusion
 Author: Rob Brooks-Bilson
 ISBN: 1-56592-698-6
 Price: $39.95
 Estimated Release: October 2000

 KM

 --
 
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.


--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Is this a bug?

[KChapman]

Try

cfquery name="qTest" datasource="foo"
   INSERT INTO TempTable(Identifier,Resource)
VALUES('#thisKey#','#PreserveSingleQuotes(stWestcar["#thisKey#"].Resource)
#');
/cfquery

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Sean Brown"   
 
sean@westcarTo: [EMAIL PROTECTED]   
 
.comcc:   
 
 Subject: Is this a bug?   
 
05/11/00   
 
04:01 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



I have a Struct "stWestcar". And stWestcar["#thisKey#"].Resource = "This is
Sean's test".
I'm doing a SQL Insert and I know that CF normally takes care of single
quotes inside of CFQUERY so I don't worry about it.

cfquery name="qTest" datasource="foo"
   INSERT INTO TempTable(Identifier,Resource)
VALUES('#thisKey#','#stWestcar["#thisKey#"].Resource#');
/cfquery

Well, I get the SQL Error, and it turns out the above SQL is being passed
off to SQL-Server as: "INSERT INTO TempTable(Identifier,Resource)
VALUES('test','This is Sean's test');" Which of course is an invalid SQL
Statement. I scratch my head, and recall how hard it usually is for me to
get single quotes into SQL statements when I need to, hence the need for
PreserveSingleQuotes()

So above the SQL Statement, I take the Struct Value out and put it into a
simple variable and use that simple variable in the SQL, and of course it
works.

cfset SafeText=stWestcar["#thisKey#"].Resource
cfquery name="qTest" datasource="foo"
   INSERT INTO TempTable(Identifier,Resource)
VALUES('#thisKey#','#SafeText#');
/cfquery

Now why is that? anyone have a pointer to where I was supposed to read
about
this behavior? I even tried using a StructFind(stWestcar["#thisKey#"],
"Resource") in the SQL, that didn't work either Why can it interpolate
the value of a simple variable and do the magic-single-quote-escape-trick
but can't interpolate a complex one. strange?...
/s

___

  Sean Brown[EMAIL PROTECTED]
  http://www.westcar.com/

  "Either way you get your dog back"
  -Anonymous
___


-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 11, 2000 1:29 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Client and session variables same thing different


Do some experiments. Set your session timeout to something ridiculously
low,
say 2 minutes - and hit pages at 1:30 a few times, see if your session
sticks around, and then wait 2+ min a few times, and see if it conks out :)

--Scott

 -Original Message-
 From: Ricq Pattay [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, May 11, 2000 8:57 AM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: Client and session variables same thing different


 Huh. That's now how it seems on my end, but I must be
 spending too much time
 testing this thing as a developer instead of as a
 pseudo-user. :-)  Thanks.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: 

Re: Slightly OT: Lighten things up a little

[KChapman]

Actually it's a Big red 95 Cougar XR7.

After having seen a 911 UNDER a Sedan DeVille I will never drive a small
car.

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   

"Steve Reich"  

steve.reich@bacTo: [EMAIL PROTECTED]

ksoft.com  cc:

Subject: Re: Slightly OT: Lighten 
things up a little   
05/11/00 09:09 

PM 

Please respond 

to cf-talk 

   

   




Since we're off the subject, I think it would be cool to have a site with
some sort of profile for each CF-Talk member. A short bio, maybe link to a
resume, and a picture. Then we could put faces to the names. I mean, is
Dave
Watts *really* 10 feet tall like I imagine? Does Katrina Chapman actually
drive a little red convertable Miata? Does Fred Sanders *really* wear a
cowboy hat and spurs? Ahhh, if only I had more time!!

:-)  Steve

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Slightly OT: Lighten things up a little

[KChapman]

What about CFCHICK?

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
Todd Ashworth  
 
todd@sabersiTo: [EMAIL PROTECTED] 
 
te.com  cc:   
 
 Subject: Re: Slightly OT: Lighten things 
up a little   
05/10/00   
 
03:46 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



When you have a license plate that says CFXLR8 .. hmmm .. I would give that
a geek-factor of about 9.2 ;)

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: How to secure PDF file? - The Flame goes on.

[KChapman]

You can restric permissions to that directory so that noone but the
cfserver has permission to access it.  That way when they try to access it
directly through the URL and IIS (or PWS whatever you have running) makes
the call they will get a permission denied error.

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage



   
 
"Dave Hannum"  
 
hannum@ohio.To: [EMAIL PROTECTED]   
 
edu cc:   
 
 Subject: Re: How to secure PDF file? - 
The Flame goes on.  
05/11/00   
 
06:55 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



I'm asking a related question for the System Admins of the group.  To do
something like this (have PDF's in a secure directory) can
you do on NT like you can on Unix/Linux and that is have a directory
secured that you cannot make calls to it directly from the web,
but any application you have running in a parent directory that is
accessable from the web can call it?  Let me be more specific.  I
work with an ISP that has this setup (Linux/Apache).  Any html or cgi you
want available to be called directly via URL, you set to
permission 755.  But, if you want to secure a directory or script, you
change the permissions to 700, and only another script in
your directory (or account above that directory) can call the file.  Can
you do this on NT?  If so, can you not put your PDF's in a
subdirectory and call them from a CF script?  This would prevent somebody
from sniffing the URL and gaining access to them.

Just a thought . . .

Dave


=
"Always Drink Upstream From The Herd!"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Slightly OT: Lighten things up a little

[KChapman]

I'm the only one in CA.  It generally works that way though.  Only one per
state.

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
Jennifer   
 
mr_urc@druleTo: [EMAIL PROTECTED] 
 
.orgcc:   
 
 Subject: Re: Slightly OT: Lighten things 
up a little   
05/11/00   
 
10:42 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



I bet I'd be the only person in Louisiana with that plate...

At 09:19 AM 5/11/00 -0700, you wrote:

What about CFCHICK?

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage



 
 Todd
Ashworth

 todd@sabersiTo: [EMAIL PROTECTED]


 te.com  cc:

  Subject: Re: Slightly OT:
Lighten things up a little
 05/10/00
 
 03:46
PM

 Please

 respond
to

 cf-talk








When you have a license plate that says CFXLR8 .. hmmm .. I would give
that
a geek-factor of about 9.2 ;)


--


Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.





--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or

send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: REVERSE QUESTION --- Is there anything that Cold Fusion can do that ASP can't do?

[KChapman]

Well I don't know how this compares to ASP but.

Cold Fusion can have a fairly complex site,  http://starwars.hasbro.com, up
in a month.

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   

"Alice and 

Harvey Backer   To: [EMAIL PROTECTED]

and Binder" cc:

ahbback@worldneSubject: REVERSE QUESTION --- Is there 
anything that Cold Fusion can do that ASP   
t.att.net  can't do?  

   

05/08/00 06:04 

PM 

Please respond 

to cf-talk 

   

   




Hi Cold Fusion Users,

Recently, someone asked if there is anything that ASP can do that COLD
FUSION can't do.

Many people responded with some extremely small things.

So, I would like to ask the opposite question:
Is there anything that COLD FUSION can do that ASP can't do?

Alice

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFML be gone!

[KChapman]

You can do a search on cf and change it to lt;cf

That should get rid of any CF code they may try to submit.

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"David 
 
Berger"  To: [EMAIL PROTECTED] 
 
djb194@hotmacc:   
 
il.com  Subject: Re: CFML be gone!
 
   
 
05/09/00   
 
07:45 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



You can right your own custom form validation with javascript.  Nothing
good
comes easy!


Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Slightly OT: Lighten things up a little

[KChapman]

It's in response to WWJD  What Would Jesus Do?

WWBFD  is What Would Ben Forta Do?

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Eric Dawson"  
 
cftalk@hotmaTo: [EMAIL PROTECTED] 
 
il.com  cc:   
 
 Subject: Re: Slightly OT: Lighten things 
up a little   
05/09/00   
 
09:42 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



in ignorance what does wwbfd stand for. I can have the stickers done in a
hour, and shipped in two if I had the artwork and the orders.


From: Kevin Marshall [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Slightly OT: Lighten things up a little
Date: Tue, 09 May 2000 08:43:06 -0500

I know, I know, cf-community...

Anyway, who's selling the WWBFD bumper stickers?  I'll buy one!

Kevin

At 06:58 AM 5/9/00 -0500, you wrote:
 - Have a bumper sticker reading 'WWBFD'.

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Imp Atten: New Virus Info

[KChapman]

Don't forget this one.

http://www.symantec.com/avcenter/venc/data/wobbler-hoax.html

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage



   
  
"Fred T. Sanders"  
  
webmaster@galvestongeTo: [EMAIL PROTECTED]  
  
taway.comcc:  
  
  Subject: Re: Imp Atten: New 
Virus Info 
05/08/00 09:09 AM  
  
Please respond to  
  
cf-talk
  
   
  
   
  



*sigh*..   anytime I see AOL, IBM, and Compaq mentioned
in a virus alert I think "oh great another virus hoax" and
I'm usually right.  This one is no different:

http://www.symantec.com/avcenter/venc/data/win.a.holiday.htm
l

I know with all the nifty new WORMS that have recently
plagued the list and millions of other computers, you might
be inclined to spread every freakin' email like this you
get, and thanks for the thought, but.

PLEASE actually research the warning before spaming it over
gods green earth and into our mailboxes.

Thanks :)

Fred



- Original Message -
From: "Kalyan Chakravarthy Modali" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 08, 2000 10:37 AM
Subject: Imp Atten: New Virus Info


 Don't now up to what extent it is true.
 But Prevention is better than Cure



 Subject: Virus!
 Author:  John Erickson at AIRSEA-POST-OFFICE
 Date:04/14/2000 11:42 AM


 1. There is a new virus - WOBBLER. It will arrive on
e-mail
 titled CALIFORNIA. IBM and AOL have announced that it is
very
 powerful, more so than Melissa, there is no remedy. It
will eat all your
 information on the hard drive and  also destroys Netscape
Navigator and
 Microsoft Internet Explorer. Do not open anything with
this title and
 please pass this message on  to all your contacts and
anyone who uses your
 e-mail facility. Not many people seem to know about this
yet so propagate
 it as fast as possible.

 2. If you receive an e-mail titled "Win A. Holiday" DO NOT
 open it. It will erase everything on your hard drive.
Forward this letter
 out to as many people as you can. This is a new, very
 malicious virus and not many people know about it. This
information was
 announced yesterday morning from  Microsoft.

 Thank You,
 Neil Ferrick
 Compaq Computer Corporation


 Andrew Lim
 www.goldquest.com.my/alimo2k


__
 Make A Buck Or Two @ TheMail.com - Free Internet Email
 Sign-up today at http://www.themail.com/ref.htm?ref=356934


 --

 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=li
sts/cf_talk or send a message to
[EMAIL PROTECTED] with 'unsubscribe' in the
body.

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Stupid question: How to handle $ values?

[KChapman]

Try Val(Replace("$23.12", "$", "", "ALL"))

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
Reuben King
 
reuben.king@To: [EMAIL PROTECTED] 
 
sbti.comcc:   
 
 Subject: Stupid question: How to handle $ 
values?  
05/08/00   
 
10:36 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



If I try to use val("$23.12"), it returns 0.  Other than doing a check
for the first character being a dollar sign, is there an easier way to
do this?

Thanks,
-RK
--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Phantom Form submissions

[KChapman]

Are you submitting the form yourself?  If not how do you know that it's
even being submitted at all?  Also can we see a URL or the code?

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
"Gregory Harris"   
 
mailinglist@codeTo: "Cold Fusion" 
[EMAIL PROTECTED]  
sweep.com   cc:   
 
 Subject: "Phantom" Form submissions   
 
05/08/00 03:08 PM  
 
Please respond to  
 
cf-talk
 
   
 
   
 



Hello everyone, for my website, I built a generic form feedback script.
Takes the form variables, submits to a database, then emails me the form
variables.  Nothing terribly fancy.  However every so often (approximately
1
in 4 submissions) a "phantom" submission occurs, where I get a positive
response from the server indicating no errors (I even checked the source
code from the output page), but nothing goes in the database, and no emails
are generated.  Any ideas as to what might be going on, anyone experienced
this?  Thanks!

Gregory Harris (tekiegreg)
[EMAIL PROTECTED]

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: odbc error

[KChapman]

Can we see the query that is causing this problem?

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   

"Shane Witbeck"

webmaster@digitalsaTo: [EMAIL PROTECTED]

nctum.com  cc:

Subject: odbc error

05/08/00 03:39 PM  

Please respond to  

cf-talk

   

   




Can anyone give suggestions why I am getting the following error when
selecting specific fields from an Access db, yet when I use a "select *"
everything is fine?

[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that
does not include the specified expression 'id' as part of an aggregate
function.

thanks.

Sincerely,

Shane Witbeck
Webmaster
[EMAIL PROTECTED]
www.digitalsanctum.com




--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: string to list???

[KChapman]

Can you give an example of what your trying to do?

Like: "I'm trying to turn 1,2,3 into 123"

--Katrina



Katrina Chapman
Consultant
Ameriquest Mortgage


   
  
Nagesh Kumar   
  
Deva  To: "Cold Fusion (E-mail)" 
[EMAIL PROTECTED] 
Nagesh@aptitucc:  
  
de.com.sgSubject: string to list???   
  
   
  
05/03/00 09:05 
  
AM 
  
Please respond 
  
to cf-talk 
  
   
  
   
  



hello everybody,

is there a way to convert a string into a list?? the delimeter in string 
list to be space. is this possible??

plzz help me, i am stuck with it.

thanx in advance

nag
--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Forcing a query refresh

[KChapman]

How do you know that it's not running the query again?  What browser are
you using.  If you hold control while you click refresh that will force it
to make the call back to your server for the latest information.

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
dford@midrangecom  
 
puting.com (Doug To: "'[EMAIL PROTECTED]'" 
[EMAIL PROTECTED]  
Ford)cc:   
 
 Subject: Forcing a query refresh  
 
05/03/00 09:33 AM  
 
Please respond to  
 
cf-talk
 
   
 
   
 



Hi Folks,

What's the best way of forcing a query to always
run instead of it being cached?

I am pulling a record from a DB and displaying it,
but when I do a refresh/reload it doesn't
run the query again.

What's the best way of doing that?

Thanks,

Doug
--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: javscript mouseovers don't cache in .cfm pages

[KChapman]

They work fine for me.


Katrina Chapman
Consultant
Ameriquest Mortgage



   
 
"guru.com" 
 
guru.com@sofTo: [EMAIL PROTECTED]   
 
thome.net   cc:   
 
 Subject: javscript mouseovers don't cache 
in .cfm pages
05/02/99   
 
09:35 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



This is a multi-part message in MIME format.

--=_NextPart_000_005C_01BE94FC.E091E600
Content-Type: text/plain;
   charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

For some reason, whenever I incorporate javascript mouseovers in a .cfm =
page, they won't cache, so every time I roll over them the browser has =
to download them before they display. The exact pages in question work =
fine if I save them with a .htm extension.

Here are a couple of example sites where this is happening:

http://www.prestigemb.com.au
http://cfm.rickhart.com.au/




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: OT: joining tables

[KChapman]

You need to join the tables.  There has to be a field in both tables that
has the same data like client id.  Is there such a field?

--Katrina


Katrina Chapman
Consultant
Ameriquest Mortgage



   
 
Shawn Regan
 
shawnr@pts1.To: "'[EMAIL PROTECTED]'" 
[EMAIL PROTECTED]  
com cc:   
 
 Subject: OT: joining tables   
 
05/02/00   
 
09:24 AM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



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_01BFB452.F8791E40
Content-Type: text/plain;
   charset="iso-8859-1"

hey people,

i'm doing a join in this query:

SELECT  CLIENTS.CLIENT_NAME, PRODUCTS.PRODUCT_NAME, CATEGORY.CAT_ID,
CATEGORY.CATEGORIES
FROM CLIENTS, PRODUCTS, CATEGORY
WHERE CLIENTS.CLIENT_NAME='#session.client#'

I have only one record in the database right now for testing. so there is
only one client. But this query keeps pull out the one client as two
different clients.

I can't figure it out.

Shawn Regan



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.