RE: DATES!!!!!!!!!`

[Johan Coens]

try using single quote's:

WHERE creationdate >= '#dateA#' and creationdate <= '#dateB#'

Regards,
Johan

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: woensdag 26 juli 2000 14:20
To: [EMAIL PROTECTED]
Subject: Re: DATES!`


On 7/26/00, Jason Glaun penned:
>I have a problem with getting records out of an access database that have
>creation dates between dateA and dateB.   I just cant get the query to
work!
>Anyone got any suggestions

WHERE creationdate >= #dateA# and creationdate <= #dateB#

Always works for me.

As a side note. I have had problems in the past if I name a field
with an underscore in front of date. Like creation_date. I always
name them creationdate without the underscore.
--

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

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

RE: Surprising Results? [was] Re: Round down numbers

[Johan Coens]

Hello Dick,

As a mathemetics student all of these answers seem correct to me ...
Round(-4.5) indeed is -5
Int(-4.5) indeed is -5

Johan Coens

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: woensdag 26 juli 2000 15:55
To: [EMAIL PROTECTED]
Subject: Surprising Results? [was] Re: Round down numbers


Hmmm.

All this talk about rounding up/down... thought I'd experiment:



...Ceiling(4.5)Gives 5.Expect 5..|#Ceiling(4.5)#|
...Ceiling(4.4)Gives 5.Expect 5..|#Ceiling(4.4)#|
...Ceiling(-4.5)...Gives -4Expect -4.|#Ceiling(-4.5)#|
...Ceiling(-4.4)...Gives -4Expect -4.|#Ceiling(-4.4)#|
...Round(4.5)..Gives 5.Expect 5..|#Round(4.5)#|
...Round(4.4)..Gives 4.Expect 4..|#Round(4.4)#|
.*.Round(-4.5).Gives -5Expect -4.|#Round(-4.5)#|
.*.Round(-4.4).Gives -4Expect -5.|#Round(-4.4)#|
...Int(4.5)Gives 4.Expect 4..|#int(4.5)#|
...Int(4.4)Gives 4.Expect 4..|#int(4.4)#|
.*.Int(-4.5)...Gives -5Expect -4.|#int(-4.5)#|
.*.Int(-4.4)...Gives -5Expect -4.|#int(-4.4)#|
...Fix(4.5)Gives 4.Expect 4..|#Fix(4.5)#|
...Fix(4.4)Gives 4.Expect 4..|#Fix(4.4)#|
...Fix(-4.5)...Gives -4Expect -4.|#Fix(-4.5)#|
...Fix(-4.4)...Gives -4Expect -4.|#Fix(-4.4)#|



Gives the somewhat unexpected:

...Ceiling(4.5)Gives 5.Expect 5..|5|
...Ceiling(4.4)Gives 5.Expect 5..|5|
...Ceiling(-4.5)...Gives -4Expect -4.|-4|
...Ceiling(-4.4)...Gives -4Expect -4.|-4|
...Round(4.5)..Gives 5.Expect 5..|5|
...Round(4.4)..Gives 4.Expect 4..|4|
.*.Round(-4.5).Gives -5Expect -4.|-5|
.*.Round(-4.4).Gives -4Expect -5.|-4|
...Int(4.5)Gives 4.Expect 4..|4|
...Int(4.4)Gives 4.Expect 4..|4|
.*.Int(-4.5)...Gives -5Expect -4.|-5|
.*.Int(-4.4)...Gives -5Expect -4.|-5|
...Fix(4.5)Gives 4.Expect 4..|4|
...Fix(4.4)Gives 4.Expect 4..|4|
...Fix(-4.5)...Gives -4Expect -4.|-4|
...Fix(-4.4)...Gives -4Expect -4.|-4|



At 8:30 AM -0400 7/26/00, Bud wrote:
>On 7/26/00, wai-leng penned:
>>Hi all,
>>
>>I am using Round () to round numbers but I would like it to round down
>>ie 469.50 should be evaluated as 469 instead of 470.
>>
>>Any suggestions please
>
>Well, since round always rounds up or down accordingly, except .5
>which always rounds up, I presume you always want to round down, in
>which case int(number) will do it.
>--
>
>Bud Schneehagen - Tropical Web Creations
>
>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>ColdFusion Solutions / eCommerce Development
>[EMAIL PROTECTED]
>http://www.twcreations.com/
>954.721.3452
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k 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=lists&body=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=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: substituting variables in a variable

[Johan Coens]

Try putting all between cfoutput tags.

Johan Coens

-Original Message-
From: Neil Peaslee [mailto:[EMAIL PROTECTED]]
Sent: woensdag 26 juli 2000 16:17
To: cf-talk
Subject: substituting variables in a variable


I am trying to set up a mail system that can grab text from a database and
insert it into a mail message. I also need to customize the text of the
message (e.g. Dear #first_name# evaluates to Dear John). The problem arises
when I insert the mail text variable into the  tag. The variables
that are contained in the text message are not evaluated.

#mail_message#

This will output "Dear #first_name#, ..."

How do I get the sub variable to be evaluated?

Thanks in advance,
Neil


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

RE: Dates!!!!! (code)

[Johan Coens]

Hello,

I also used date comparison in Access, and expirienced the same. You have to
use date comparison in queries like this:

SELECT  *
FROM  Reference
WHERE Archive_Date > #CreateODBCDateTime(date1)# AND Archive_Date <
#CreateODBCDateTime(date2)#

That should work.

Regards,
Johan

--> Ben said this before:
You should use:

WHERE creationdate >= #CreateODBCDate(dateA)# AND creationdate <=
#CreateODBCDate(dateB)#. You should never use dates directly (in a WHERE
clause or any other part of a SQL statement) without using one of
CreateODBCDate() CreateODBCTime() or CreateODBCDateTime(). That's the only
safe way to use dates consistently.

Also, you can use the BETWEEN clause.

--- Ben

-Original Message-
From: Jason Glaun [mailto:[EMAIL PROTECTED]]
Sent: donderdag 27 juli 2000 10:21
To: [EMAIL PROTECTED]
Subject: Dates! (code)


This is a multi-part message in MIME format.

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


If you have a chance could you just have a glance at this for me?   =
thanks.
I am having trouble with something that I can't seem to get righ and was
wondering if you had any advice for me.   It's a SQL problem.   I'm =
trying
to get the dates from the database which lie between date_A and date_B =
but
it won't give me any!!!

here is my query..

Version 1

SELECT  *
FROMReference
WHERE Archive_Date BETWEEN #variables.date_A# AND #variables.date_B#



Version 2

SELECT  *
FROMReference
WHERE Archive_Date > #variables.date_A# AND Archive_Date <
#variables.date_B#


it just won't seem to work!  I get 2 errors depending on '' around the
variables.

error 1(without #variable#  )
[Microsoft][ODBC Microsoft Access 97 Driver]Division by zero (null)


error2 (with'#variable#'   )
Data type mismatch in criteria expression

can't I do a greater or lessthan calculation on a date?


Thanks.

--=_NextPart_000_0026_01BFF7AB.F1534DE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








If you have a chance =
could you just=20
have a glance at this for me?   thanks.I am having trouble =
with=20
something that I can't seem to get righ and waswondering if you had =
any=20
advice for me.   It's a SQL problem.   I'm =
tryingto get=20
the dates from the database which lie between date_A and date_B =
butit won't=20
give me any!!!here is my query..Version 1SELECT&nb=
sp;=20
*FROM    ReferenceWHERE=20
Archive_Date BETWEEN #variables.date_A# AND=20
#variables.date_B#Version =
2SELECT&nb=
sp;=20
*FROM    ReferenceWHERE=20
Archive_Date > #variables.date_A# AND Archive_Date=20
<#variables.date_B#it just won't seem =
to=20
work!  I get 2 errors depending on '' around =
thevariables.error=20
1(without #variable#  )[Microsoft][ODBC Microsoft Access 97=20
Driver]Division by zero (null)error2 (with    =

'#variable#'   )Data type mismatch in criteria=20
expressioncan't I do a greater or lessthan calculation on a=20
date?
 
Thanks.

--=_NextPart_000_0026_01BFF7AB.F1534DE0--

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

RE: How to release cached data source connection via CF template ?

[Johan Coens]

Helle Adam,

I hope this is what you ment:

Use a false query like

SELECT NOTHING
FROM SOMETHING


This generates a dbError which you can catch using 
Then your datasource will be released.

Regards,
Johan

-Original Message-
From: Jablonski, Adam, MTC-CEC [mailto:[EMAIL PROTECTED]]
Sent: donderdag 27 juli 2000 12:10
To: [EMAIL PROTECTED]
Subject: How to release cached data source connection via CF template ?


Hello,

the subject is THE question. I need to copy database files in automated way.
In connection to this all those files have to be released by CF server.
Does anyone of you know such a custom tag or any other solution to solve
this problem?
I need exactly the same functionality as the CF server administrator on
DataSources/VerifyDataSource page but regarding only one given cached data
source connection to release.

Thanks in advance,
Adam

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

RE: Need help from a pro

[Johan Coens]

Try CreateODBCDate(Now()) Like:
...
WHERE StartDate <= CreateODBCDate(Now())
AND EndDate >= CreateODBCDate(Now())

R. Johan


-Original Message-
From: Mike Weaver [mailto:[EMAIL PROTECTED]]
Sent: zondag 30 juli 2000 8:08
To: [EMAIL PROTECTED]
Subject: Need help from a pro


This is a multi-part message in MIME format.

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

Hello,
   I am in need of guidance on dates. I  am using an Access db.  and =
have a query which generates records between 2 dates you enter in a =
form.  The date input for each record is the automatic access db =
function.

I can't seem to get the #DateFormat(Now())# to work in single or double =
quotes so I used the auto function.  When I run the query I get an error =
of division by zero.

Any assistance is greatly appreciated.

Mike

--=_NextPart_000_0028_01BFF9B1.CB80B280
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hello,
   I am in need of guidance =
on=20
dates. I  am using an Access db.  and have a query =
which=20
generates records between 2 dates you enter in a form.  The date =
input for=20
each record is the automatic access db function.
 
I can't seem to get the =
#DateFormat(Now())# to=20
work in single or double quotes so I used the auto function.  When =
I run=20
the query I get an error of division by zero.
 
Any assistance is greatly=20
appreciated.
 
Mike

--=_NextPart_000_0028_01BFF9B1.CB80B280--


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

RE: Desperately need help - sorting a QueryNew()

[Johan Coens]

Hello,

When you sort on mathematical expressions like SUM() you need to use GROUP
BY. ORDER BY cannot contain mathematical expressions.

R.
Johan Coens

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: maandag 31 juli 2000 11:27
To: '[EMAIL PROTECTED]'
Subject: RE: Desperately need help - sorting a QueryNew()


> See
> http://www.mail-archive.com/cf-talk@houseoffusion.com/msg14920
> .html for
> sorting queries

Thanks - I'll take a look at the tag.



--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

RE: Help with CFLocation and Frames

[Johan Coens]

Hello,

You have to use Javascript when changing the location of other frames.

R.
Johan Coens

-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: maandag 31 juli 2000 11:58
To: [EMAIL PROTECTED]
Subject: Help with CFLocation and Frames


I am using the cf location tag however I need to be able to control which
frame the tag refreshes in most cases I need to  refresh the entire window
that being the entire frame set as at the moment it will only refresh the
frame that displays the page containing cflocation tag

or else under these circumstances should I be using something other than
cflocation and if so your advice would be greatly appreciated




Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]


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

RE: Desperately need help - sorting a QueryNew()

[Johan Coens]

I think i need to do something about my db-knowledge ...
Thanks,
Johan


-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: maandag 31 juli 2000 12:52
To: '[EMAIL PROTECTED]'
Subject: RE: Desperately need help - sorting a QueryNew()


> When you sort on mathematical expressions like SUM() you need to use GROUP
> BY. ORDER BY cannot contain mathematical expressions.

That's a bit misleading.

1. In most RDBMS, including Access which is what we're talking about, if you
can SELECT BY it, you can ORDER BY it.
2. SUM() is an aggregate function, rather than just a mathematical
expression.
3. GROUP BY and ORDER BY serve completely different purposes.

Nick


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**

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

RE: A knotty evaluate problem....

[Johan Coens]

I had the same problem. What i did was a replace of all minus signs by an
underscore.

R.
Johan Coens

-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: maandag 31 juli 2000 13:14
To: Cf-Talk@Houseoffusion. Com
Subject: A knotty evaluate problem


Morning all

I have a little problem.

I have a form that has a number of items for which you can change the
quantity for each item. The Quantity field is called Quantity_ and then has
the item ID appended to this.

In the update page I know the item ids for all the items on the previous
page, so I loop through them and build up the variable and check to see
whether the content has changed.

No problem there




The problem come when the seconf cfset above is executed.  ID is a UUID
generated by CreateUUID().  When CF tried to evalute it I get an error.  The
minus signs in the ID make CF try to subtract bits of the form field name
from other bits eg.

Form variable : OrderQuantity_B7935872-11DD-4FCB-887089EEAE37432C
CF tries to subtract 11DD from OrderQuantity_B7935872 and gets its knickers
in a twist when it sees the DD on the end of the number.

Does any one have any ideas how I can stop it from doing this and get the
contents of the variable?


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

RE: A knotty evaluate problem....

[Johan Coens]

That's indeed what you do. You collect the value like
Evaluate("FORM.OrderQuantity_#Replace(url.id, "-", "_", "ALL")#")

Good luck,
Johan

-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: maandag 31 juli 2000 13:34
To: [EMAIL PROTECTED]
Subject: RE: A knotty evaluate problem



>
> I had the same problem. What i did was a replace of all minus signs by an
> underscore.
>
[snip]
>
> Form variable : OrderQuantity_B7935872-11DD-4FCB-887089EEAE37432C
> CF tries to subtract 11DD from OrderQuantity_B7935872 and gets
> its knickers
> in a twist when it sees the DD on the end of the number.
>
> Does any one have any ideas how I can stop it from doing this and get the
> contents of the variable?
>

A

So for everyone else's benefit and mine for clarification.

You replace the minus signs on the form and do the same when you build up
the variables on the "update" page.

Cheers Johan.

Regards

Stephen


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

RE: what is better varchar or char

[Johan Coens]

Hello,

I allways use varchar. Not because of better performance but because of the
following:
If I insert into the database the value 'xyz' in a char(5) field, the value
of it in the dBase will be 'xyz  '. It automaticly puts spaces behind to
fill up the empty space. This means you always have to trim you're values
before u use them ... Maybe there's a setting in the dbServer, but i'm not
such a dbWizard.

Best Regards,
Johan Coens

-Original Message-
From: Art Broussard [mailto:[EMAIL PROTECTED]]
Sent: maandag 31 juli 2000 20:52
To: cf-talk
Subject: OT: what is better varchar or char


This is a multi-part message in MIME format.

--=_NextPart_000_001B_01BFFAF6.7FFB2ED0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I was told that char is better than varchar. Is this right?
=20
I am going to have fields that are set to be either 25  50 100 or 150 =
characters long. Is there a reason any of these fields should be char or =
varchar? I have allways used varchar but I would like to know what is =
best.
=20
Feel free to respond directly to me since it is OT ;-)

Art
=20
=20

--=_NextPart_000_001B_01BFFAF6.7FFB2ED0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








I was told that char is better than =
varchar. Is=20
this right? I am going to have fields that are set to be =
either=20
25  50 100 or 150 characters long. Is there a reason any of these =
fields=20
should be char or varchar? I have allways used varchar but I would like =
to know=20
what is best. Feel free to respond directly to me since it =
is OT=20
;-)
 
Art  

--=_NextPart_000_001B_01BFFAF6.7FFB2ED0--

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

RE: Help!

[Johan Coens]

Maybe:

Step 1: SELECT DISTINCT ... (all colums), name it qryAllRecords
Step 2: DELETE FROM , now you're table is empty
Step 3: LOOP over qryAllRecords and insert them into the database.

Make sure you have a backup and use CFTRANSACTION!

Best Regards,
Johan Coens

-Original Message-
From: aslam bajaria [mailto:[EMAIL PROTECTED]]
Sent: woensdag 2 augustus 2000 6:30
To: [EMAIL PROTECTED]
Subject: Help!


Hello All,
There is a very seriuous problem I am facing. Please
help. The problem is as follows:

Somehow I have created duplicate records in SQL Server
7.0 table.

I have to remove the duplicate the records. It all
happened because there is no primary key when the
record was created.

If it were a few records, I could have manually
deleted them. Now the records are in thousands. Can
someone suggest me a code that would check for
duplicate values in a table and delete them.

Please help.

A.B.

__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

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

RE: CFIF and CFMAIL

[Johan Coens]

Hello Jim,

I think you have to specify a valid email address in the FROM attribute,
otherwise it will not be sent. Also check your mail-logs, most of the time
you can see inthere what went wrong.

Also:




is the same as
,
or if blairsville is a variable

and



Best Regards,
Johan Coens

-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: woensdag 2 augustus 2000 13:55
To: [EMAIL PROTECTED]
Subject: CFIF and CFMAIL


The following will not work.  Exactly what do I need to do to change the
mail header based on a variable?  I sure would appreciate help on this :)









etc, etc,




Jim Watkins
http://www.clarkes.tec.ga.us/blairsville



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

RE: Allaire security problem - anyone know solution?

[Johan Coens]

One easy solution to do:
CFENCRYPT it



-Original Message-
From: Mooner Ent [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 4 augustus 2000 5:50
To: [EMAIL PROTECTED]
Subject: Re: Allaire security problem - anyone know solution?


Allaire security bulletin says

Originally Posted: May 22, 2000
Last Updated: May 22, 2000

Why are we just finding out that our entire Server side code can be read???
I check the security section often, did I over look it?

We found out about DATA much sooner.

Rick



Excuse the rant.
- Original Message -
From: "Daniel J. Cody" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 03, 2000 9:46 AM
Subject: Re: Allaire security problem - anyone know solution?


> Dave, I wasn't able to reproduce this on CF 4.5.1 on Linux+Apache. I
> think this might be more of an IIS issue than a CF one. Check out
> http://www.securityfocus.com/focus/microsoft/iis/iismain.html for more
> info on .htr issues.
>
> .djc.
>
> Dave Wilson wrote:
> >
> > Hi all,
> >
> > One of my hosting clients has just made me aware of this major security
> > problem and I'm wondering if anyone knows how to eliminate it?
> >
> > Try calling the application.cfm template on any CF site with +.htr
appended
> > to the end of the url. You'll first see a blank page. Now hit
refresh/reload
> > and you'll see the full code of said application.cfm
> >
> > e.g. http://www.support.alllaire.com/application.cfm+.htr
> >
> > Can someone please tell me there is a patch for this. It seems to happen
on
> > all CFserver versions 4.x + running IS4.0 with Service pack 5
> --

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


__
Do You Yahoo!?
Talk to your friends online 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=lists&body=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=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Allaire security problem - anyone know solution?

[Johan Coens]

What about CFENCODE .. I know it's not a solultion, but it is a way to
'protect' your code. This .htr invulnerability is one, but sure there will
come other.

-Johan

-Original Message-
From: Rick Osborne [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 4 augustus 2000 10:03
To: [EMAIL PROTECTED]
Subject: RE: Allaire security problem - anyone know solution?


You're kidding, right?

http://devex.allaire.com/developer/gallery/info.cfm?ID=B61C031D-2CE5-11D4-83
D700508B94F85A&method=Full
http://www.rixsoft.com/ColdFusion/CFX/CFMEncrypt/
http://packetstorm.securify.com/9907-exploits/cfdecrypt.txt
http://shroom.dv8.org/bmp/crypt.cgi
http://www.rewted.org/exploits/sorted-by-date/07-1999/cfdecrypt.c

CF Encryption is broken.  It'll keep honest people out of your code, but it
is by no means a "solution".

(Sorry, I'm not trying to be mean or anything, I just don't think it's good
that people put all their eggs in one basket.  Or, in this case, all of
their faith in a broken system.)

-Rick

-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 3:46 AM
To: [EMAIL PROTECTED]
Subject: RE: Allaire security problem - anyone know solution?


One easy solution to do:
CFENCRYPT it



-Original Message-
From: Mooner Ent [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 4 augustus 2000 5:50
To: [EMAIL PROTECTED]
Subject: Re: Allaire security problem - anyone know solution?


Allaire security bulletin says

Originally Posted: May 22, 2000
Last Updated: May 22, 2000

Why are we just finding out that our entire Server side code can be read???
I check the security section often, did I over look it?

We found out about DATA much sooner.

Rick



Excuse the rant.


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

RE: fuse box

[Johan Coens]

Try
http://www.fusebox.org/

-Original Message-
From: Jaffar Zaidi [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 4 augustus 2000 12:56
To: [EMAIL PROTECTED]
Subject: fuse box



 Hi every one
  Plz can any one tell me where can i get the
documentation about Fuse box methodology
Thankz
Jaffar

__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

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

Problem with IE and session management

[Johan Coens]

Hello all,

I've got a serious problem with IE and my applications. I've build a
maintenance system running on my server at a subdirectory located in the
wwwroot. The application which uses the content from the maintenancesystem
is located in another subdirectory in the wwwroot. Both applications use
sessionmanagement.

The situation is: I run the website in browser window 1, the maintenance
system in browser window 2. The problem is that as soon as I do something in
the website (I click on a link) my session disappears in my maintenance
system. This causes me to login.

This situation also happens when I am in the CFAdmin. When performing an
action in the CFAdmin (just click one of the links in the left) my session
disappears in my maintenance system.

This problem only occurs with Internet Explorer, Netscape is doing fine. I
don't want to pass the CFID and CFTOKEN all around my app. in the URL. I
know that solves the problem, but for that I have to rewrite all my code...

I passed the test with full lock checkings in the CFAdmin, so all my locking
is OK.

My question(s):
1. Has anyone experienced this behaviour of IE (and overcame the problem)
2. Why does my CFID and CFTOKEN get overwritten/replaced in IE and not in
Netscape
3. Why do my CFID and CFTOKEN only get overwritten in my maintenance system
and not in the CFAdmin (that's what I think because I don't have to login
again in the CFAdmin)
4. Does it have someting to do with including the application.cfm in
subdirectories of my application. example
/root/application.cfm (the root of my app)
/root/subdir/application.cfm (includes the root application.cfm)
etc.

Any help would be appreciated!

Kind regards,
Johan Coens

=
Ing. Johan Coens

Friesestraatweg 215a
P.o. Box 2010 9704 CA Groningen
The Netherlands
Tel: +31 (0)50 57 57 888
Fax: +31 (0)50 57 57 889
<http://www.thefactore.com>

Premium Partner for Allaire Cold Fusion
Multimedia development with Macromedia Director, Authorware, Flash.

"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world."
Albert Einstein
=


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Locking session variables in CF 4.0

[Johan Coens]

Don't locking your application, session and server vars means crashing your
cfserver, overwriting session and application information from other running
applications. You are messing up your shared memory. This is why locking is
that important.

-Original Message-
From: Barney Stevenson [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 19 december 2000 12:53
To: CF-Talk
Subject: Locking session variables in CF 4.0


I am confused by the knotty subject of locking session variables.

I know that it is recommended to lock all session variables in CF 4.5,
but should I be locking if I am developing for CF 4.0.  What will
happen if I don't implement locks?

Regards

Barney

=

Barney Stevenson
77 Church Street
Heaton Norris
Stockport
Cheshire
SK4 1JH
United Kingdom
+44(0)161 429 6675
Pager: +44(0)7654 248701
Fax: +44(0)870 831 0837

"We work to become, not to acquire".  Elbert Hubbard
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Refreshing images without refreshing page

[Johan Coens]

Hello Paul,

Maybe you can use Javascript with the setTimeout function. This way you can
refresh your images by setting the img.scr = 'abanner.gif' every ...
milliseconds. The banners must have the same height and width ofcourse.

Best regards,
Johan Coens

=
Ing. Johan Coens
Certified ColdFusion Developer

Friesestraatweg 215a
P.o. Box 2010 9704 CA Groningen
The Netherlands
Tel: +31 (0)50 57 57 888
Fax: +31 (0)50 57 57 889
<http://www.thefactore.com>

Premium Partner for Allaire Cold Fusion
Multimedia development with Macromedia Director, Authorware, Flash.

"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world."
Albert Einstein
=

-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: woensdag 20 december 2000 15:15
To: CF-Talk
Subject: Refreshing images without refreshing page


I'm putting together an application for a client that includes banner ads.
They are interested in setting it up so that an ad rotates every 30 or 45
seconds on a page while a viewer is reading it. So that in the span of 5
minutes or so, a banner would rotate 8 or 9 times without any refresh of the
entire page.

Anyone come up with a good way to handle this type of thing?

Thanks,
Paul Sinclair
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Duplicate supported in CF4.0

[Johan Coens]

Quick question
is the Duplicate function supported in CF4.0?

Best regards,
Johan Coens

=
Ing. Johan Coens
Certified ColdFusion Developer

Friesestraatweg 215a
P.o. Box 2010 9704 CA Groningen
The Netherlands
Tel: +31 (0)50 57 57 888
Fax: +31 (0)50 57 57 889
<http://www.thefactore.com>

Premium Partner for Allaire Cold Fusion
Multimedia development with Macromedia Director, Authorware, Flash.

"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world."
Albert Einstein
=


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Duplicate supported in CF4.0

[Johan Coens]

How do you duplicate a structure in CF4.0?

-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:40
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


No it's not!

Allan Pichler
Machine Dreams Inc.

-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:47 AM
To: CF-Talk
Subject: Duplicate supported in CF4.0


Quick question
is the Duplicate function supported in CF4.0?

Best regards,
Johan Coens

=
Ing. Johan Coens
Certified ColdFusion Developer

Friesestraatweg 215a
P.o. Box 2010 9704 CA Groningen
The Netherlands
Tel: +31 (0)50 57 57 888
Fax: +31 (0)50 57 57 889
<http://www.thefactore.com>

Premium Partner for Allaire Cold Fusion
Multimedia development with Macromedia Director, Authorware, Flash.

"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world."
Albert Einstein
=
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Duplicate supported in CF4.0

[Johan Coens]

Using StrucyCopy you still reference the original structure. So, when using
structCopy of an application or session variable you still have a pointer to
the shared memory


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:55
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0



StructCopy(structure)


-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:54 AM
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


How do you duplicate a structure in CF4.0?

-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:40
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


No it's not!

Allan Pichler
Machine Dreams Inc.

-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:47 AM
To: CF-Talk
Subject: Duplicate supported in CF4.0


Quick question
is the Duplicate function supported in CF4.0?

Best regards,
Johan Coens

=
Ing. Johan Coens
Certified ColdFusion Developer

Friesestraatweg 215a
P.o. Box 2010 9704 CA Groningen
The Netherlands
Tel: +31 (0)50 57 57 888
Fax: +31 (0)50 57 57 889
<http://www.thefactore.com>

Premium Partner for Allaire Cold Fusion
Multimedia development with Macromedia Director, Authorware, Flash.

"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world."
Albert Einstein
=
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Duplicate supported in CF4.0

[Johan Coens]

Thanks Nick,

I was afraid I had to do it that way, I hoped 4.0 had some mechanism to do
it, but unfortunattly I have to do it my own.
Just came up with an idea (from Spectra). In Spectra there is a customtag
called deepcopy. What it does:




This way you can easy dulpicate structs in CF4.0!

Regards,
Johan

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 11:25
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


Johan

I believe you have to do a structNew() then CFLOOP through the original
structure copying each element.

This is easy if you know up front what elements the structure contains.
Otherwise you have to use isStruct() and isArray() on each element to
see if it's a nested structure or array, & if so create a corresponding
new one in the target structure.

Nick

-Original Message-----
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 10:11 AM
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


Using StrucyCopy you still reference the original structure. So, when using
structCopy of an application or session variable you still have a pointer to
the shared memory


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:55
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0



StructCopy(structure)


-Original Message-----
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:54 AM
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


How do you duplicate a structure in CF4.0?

-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:40
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


No it's not!

Allan Pichler
Machine Dreams Inc.

-Original Message-----
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:47 AM
To: CF-Talk
Subject: Duplicate supported in CF4.0


Quick question
is the Duplicate function supported in CF4.0?

Best regards,
Johan Coens

=====
Ing. Johan Coens
Certified ColdFusion Developer

Friesestraatweg 215a
P.o. Box 2010 9704 CA Groningen
The Netherlands
Tel: +31 (0)50 57 57 888
Fax: +31 (0)50 57 57 889
<http://www.thefactore.com>

Premium Partner for Allaire Cold Fusion
Multimedia development with Macromedia Director, Authorware, Flash.

"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world."
Albert Einstein
=
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Duplicate supported in CF4.0

[Johan Coens]

But why doesn't allaire use StructCopy ... ;)

-Original Message-
From: Steve Martin [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 11:43
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


Not entirely true. Structcopy does actually duplicate the structure in
question. I think there's some confusion here over  which creates a pointer to the original. Structcopy
however only performs a shallow copy in that any embedded structures within
the structure that you are trying to duplicate aren't copied wholesale but
are referenced through pointers.

Steve

-Original Message-----
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: 21 December 2000 10:11
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


Using StrucyCopy you still reference the original structure. So, when using
structCopy of an application or session variable you still have a pointer to
the shared memory


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:55
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0



StructCopy(structure)


-Original Message-----
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:54 AM
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


How do you duplicate a structure in CF4.0?

-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:40
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


No it's not!

Allan Pichler
Machine Dreams Inc.

-Original Message-----
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:47 AM
To: CF-Talk
Subject: Duplicate supported in CF4.0


Quick question
is the Duplicate function supported in CF4.0?

Best regards,
Johan Coens

=====
Ing. Johan Coens
Certified ColdFusion Developer

Friesestraatweg 215a
P.o. Box 2010 9704 CA Groningen
The Netherlands
Tel: +31 (0)50 57 57 888
Fax: +31 (0)50 57 57 889
<http://www.thefactore.com>

Premium Partner for Allaire Cold Fusion
Multimedia development with Macromedia Director, Authorware, Flash.

"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world."
Albert Einstein
=
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Duplicate supported in CF4.0

[Johan Coens]

Isn't is than always the best to use WDDX serialize/deserialize when
duplicating structures? I think this ensures it that you always have a
unique copy, and are not referencing any shared memory. Maybe a slight
performance decrease, but you're sure your application works the way you
want.

Regards,
Johan

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 14:20
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


Be aware that there is a similar issue in Duplicate. If you duplicate a
structure that has an array that has an element that is a struct, you will
get a pointer. To see this, run this code:









The simple value is NOT a pointer, #A.Arr[1]#





B.Arr[2].Foo is a pointer. Here is the proof:
#A.Arr[2].Foo#


===
Raymond Camden, Principal Spectra Compliance Engineer for Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda

> -Original Message-
> From: Steve Martin [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 21, 2000 5:43 AM
> To: CF-Talk
> Subject: RE: Duplicate supported in CF4.0
>
>
> Not entirely true. Structcopy does actually duplicate the structure in
> question. I think there's some confusion here over  somenewvar=anoldstruct> which creates a pointer to the original.
> Structcopy
> however only performs a shallow copy in that any embedded
> structures within
> the structure that you are trying to duplicate aren't copied wholesale but
> are referenced through pointers.
>
> Steve
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: it wont loop back!....

[Johan Coens]

try


Back   |  &nbs
p;



Next 8


Best regards,
Johan Coens

-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: woensdag 27 december 2000 17:48
To: CF-Talk
Subject: it wont loop back!


here is my problem, when the code below gets ran it runs fine all accept
when it gets to the end of the list of images it keeps going with blank
pages with just a back and next button. my question is how do i get it to
loop back to the beginning of the list when it gets to the end or last
image? can anyone help? ive been stuck on this for some time now


Select *
>From ImageManager




Early Work




  
  Click Image to order and to view larger picture.
  



 
  

  #RealName#



  
Back   |  &nbs
p;Next 8


Thanks much,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: This is weird

[Johan Coens]

You forgot the quotes, so use
SQL = "INSERT INTO CommunityEvents (CommunityEventID, CommunityEventName,
> LastUpdate) VALUES('HPRO-12-28-2000', 'retreat', {ts '2000-12-28
18:42:56'})"

instead of

> SQL = "INSERT INTO CommunityEvents (CommunityEventID, CommunityEventName,
> LastUpdate) VALUES(HPRO-12-28-2000, retreat, {ts '2000-12-28 18:42:56'})"

Regrads,
Johan


~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Creating Datasources Using CF

[Johan Coens]

Check the CF Developer Gallery for creating datasources.

Regards,
Johan Coens

-Original Message-
From: Tan Siew Ling [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 2 januari 2001 5:01
To: CF-Talk
Subject: Creating Datasources Using CF


Hi All

Can i write CF codes to create datasources instead of using cold fusion
admin?

Thanks,
Siew Ling
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: record sets... arrays or structures?

[Johan Coens]

Try User[13].FullName, u can use that with recordsets.
Structures work the same, and you have a tool called QueryToStruct, which
converts your query to a structure.

Regards,
Johan Coens

-Original Message-
From: Mike Amburn [mailto:[EMAIL PROTECTED]]
Sent: donderdag 4 januari 2001 15:03
To: CF-Talk
Subject: record sets... arrays or structures?


subject says it all

let's say a have a record set of users and wanted to get the first name
of row #13. could i use something like:

 User.FirstName[13]

???
(except for the fact that this example doesnt seem to work)

--
Mike Amburn, Development
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Slightly OT

[Johan Coens]

UUNET, there not cheap but their support is good, sites are fast.

-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: vrijdag 5 januari 2001 11:00
To: CF-Talk
Subject: Slightly OT



Hi All,

Can anyone suggest an ISP (Perferably in the UK) that can host Cold fusion
sites.

TIA

Jason Lees
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609
6301
and delete all records of the message from your computer. Any form of
reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [EMAIL PROTECTED]

##
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists