-- Topica Digest --
RE: CLIENT variables in Layout Pages
By [EMAIL PROTECTED]
Re: Global EXit FuseActions
By [EMAIL PROTECTED]
RE: Importing text files--follow Up
By [EMAIL PROTECTED]
RE: Using ThisTag.HasEndTag with CFMODULE
By [EMAIL PROTECTED]
Random Loop OT for Newbie
By [EMAIL PROTECTED]
Re: Random Loop OT for Newbie
By [EMAIL PROTECTED]
Re: Random Loop OT for Newbie
By [EMAIL PROTECTED]
RE: Random Loop OT for Newbie
By [EMAIL PROTECTED]
Re: Random Loop OT for Newbie
By [EMAIL PROTECTED]
RE: Random Loop OT for Newbie
By [EMAIL PROTECTED]
------------------------------------------------------------
Date: Fri, 11 Oct 2002 11:51:54 +0000
From: Matthew C. Parks <[EMAIL PROTECTED]>
Subject: RE: CLIENT variables in Layout Pages
I am sorry I left that out didn't I. The CLIENT variable in the
fbx_Layoutpage is getting ERROR resolving. I do a if statement on the
value to determine which side and top navagation needs to be included
for the user based on the Client.side variable.
Douglas Smith wrote:
> So, what are these "intermittent" issues?
>
> At 08:57 PM 10/10/02 +0000, Matthew C. Parks wrote:
> >I keep on getting intermittent issues with a CLIENT variable that is
> >getting set within my application. The variable gets set in the
> >fbx_switch and the fbx_layout pages are using that CLIENT variable to
> >determine which side of the application the user is to view (dynamic
> >links to other pages). They can switch from one to the other if they
> >have access to do so.
> >
> >It only happens some of the time. Not all users are experiencing this
> >issue, more and more users running XP with IE 6, but not all.
> >
> >I am running NT 4 server with CF 4.5 SP2. Client variables are stored
> >in the database.
> >
> >
> >Matthew C. Parks
> >
> >
> >__________________________________________/Fusebox Conference!
> >
> > Sign up for the Fusebox Conference today!
> > October 26th & 27th: Orlando, FL, just before MACR DevCon.
> > 2 jam-packed days, 15 speakers in three tracks, World Fuseball
> > Championship
> > http://www.fusebox.org/index.cfm?fuseaction=conference.main
> >
>
>
>
Matthew C. Parks
------------------------------
Date: Fri, 11 Oct 2002 09:11:40 -0400
From: "John Farrar" <[EMAIL PROTECTED]>
Subject: Re: Global EXit FuseActions
You could create a common alias that you use to set the common XFA's... then you could
edit the common XFA in one place. This would be my best guess... this would still
allow another developer reading your code (or you once you forget in three months) to
see what is going on.
John
>>> [EMAIL PROTECTED] 10/10/02 06:02PM >>>
If an XFA is used by several fuses in a circuit, is it okay to set it's
value outside of the fbx_Switch.cfm case switch? Is this a common practice?
--
This fallen angel could stitch a wing
With a shoe string
Prime directive selective reflective aviation
Bathed in mood Swing
__________________________________________/Fusebox Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
http://www.fusebox.org/index.cfm?fuseaction=conference.main
------------------------------
Date: Fri, 11 Oct 2002 09:03:46 -0400
From: Daniel Daugherty <[EMAIL PROTECTED]>
Subject: RE: Importing text files--follow Up
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_01C27126.A232F660
Content-Type: text/plain;
charset="iso-8859-1"
With access the fastest way to do what you want is to create a
linked table in access to the csv file. With this link you can then do a
append query
INSERT INTO Table1 ( Field1 )
SELECT [linktable].Field1 AS Expr1
FROM [linktable];
Just use cffile to write the uploaded file to the server then run the append
query. This will be your fastest method and also the simplist with code.
But will only work correctly if one person at a time uses it. So I recomend
putting a CFLOCK around the cffile and query to prevent multiple access
problems. If you want I can send you a access file with an example of a
linked file. Email me off list if you would like one.
Daniel D.
-----Original Message-----
From: Nev [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 1:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Importing text files--follow Up
Or if you're on cf5, try Patrick's http://www.cflib.org/udf.cfm?ID=507
<http://www.cflib.org/udf.cfm?ID=507>
Nev
>>> [EMAIL PROTECTED] 10/11/02 12:37pm >>>
The simplest, most mindless, workaround is to do a global replace before you
parse the data. Replace Tab-Tab with Tab-N/A-Tab or similar. That will let
CF
parse the data, and you just have to deal with the N/A fields after parsing.
Apologies to all for the non-Fusebox topic.
See ya later,
LeeBB
----- Original Message -----
From: Terry Hogan <[EMAIL PROTECTED]>
Yes, there are blank fields. I think that's the problem. How do I handle
them?
*********** REPLY SEPARATOR ***********
On 10/11/2002 at 1:25 PM Lee Borkman wrote:
>Hi Terry,
>
>Any blank fields in your tab-delimited file? CF's list functions treat two
>consecutive delimiters as a single delimiter. In other words, if you have
>blank
>items, then the subsequent items get shunted forward and your list gets
>shorter.
>
>just a thought.
__________________________________________/Fusebox Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
http://www.fusebox.org/index.cfm?fuseaction=conference.main
<http://www.fusebox.org/index.cfm?fuseaction=conference.main >
--=_065A90AF.D0B1D230--
------=_NextPartTM-000-615b9555-dccf-11d6-9544-00105a68c8ef-- ${list_footer}
${list_promo} ${list_footer} ${list_promo}
------_=_NextPart_001_01C27126.A232F660
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4919.2200" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt Tahoma; MARGIN-LEFT: 2px">
<DIV><SPAN class=930500113-11102002>
With access the fastest way to do what you want is to create a linked table in
access to the csv file. With this link you can then do a append query
</SPAN></DIV>
<DIV><SPAN class=930500113-11102002></SPAN> </DIV>
<DIV><SPAN class=930500113-11102002>INSERT INTO Table1 ( Field1 )<BR>SELECT
[linktable].Field1 AS Expr1<BR>FROM [linktable];</SPAN></DIV>
<DIV><SPAN class=930500113-11102002></SPAN> </DIV>
<DIV><SPAN class=930500113-11102002>Just use cffile to write the uploaded file
to the server then run the append query. This will be your fastest method
and also the </SPAN><SPAN class=930500113-11102002>simplist with
code. But will only work correctly if one person at a time uses it.
So I recomend putting a CFLOCK around the cffile and query to prevent multiple
access problems. If you want I can send you a access file with an example
of a linked file. Email me off list if you would like one.</SPAN></DIV>
<DIV><SPAN class=930500113-11102002></SPAN> </DIV>
<DIV><SPAN class=930500113-11102002>Daniel D. </SPAN></DIV>
<DIV><SPAN class=930500113-11102002></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left>-----Original
Message-----<BR><B>From:</B> Nev [mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B>
Friday, October 11, 2002 1:05 AM<BR><B>To:</B>
[EMAIL PROTECTED]<BR><B>Subject:</B> Re: Importing text files--follow
Up<BR><BR></DIV>
<DIV> </DIV>
<DIV>Or if you're on cf5, try Patrick's <A
href="http://www.cflib.org/udf.cfm?ID=507";>http://www.cflib.org/udf.cfm?ID=507</A><BR><BR>Nev</DIV>
<DIV> </DIV>
<DIV>>>> [EMAIL PROTECTED] 10/11/02 12:37pm >>><BR>The
simplest, most mindless, workaround is to do a global replace before
you<BR>parse the data. Replace Tab-Tab with Tab-N/A-Tab or
similar. That will let CF<BR>parse the data, and you just have to deal
with the N/A fields after parsing.<BR><BR>Apologies to all for the non-Fusebox
topic.<BR><BR>See ya later,<BR>LeeBB<BR><BR><BR>----- Original Message
-----<BR>From: Terry Hogan <[EMAIL PROTECTED]><BR><BR>Yes, there
are blank fields. I think that's the problem. How do I handle
them?<BR><BR>*********** REPLY SEPARATOR ***********<BR><BR>On
10/11/2002 at 1:25 PM Lee Borkman wrote:<BR><BR>>Hi
Terry,<BR>><BR>>Any blank fields in your tab-delimited file? CF's
list functions treat two<BR>>consecutive delimiters as a single
delimiter. In other words, if you have<BR>>blank<BR>>items, then
the subsequent items get shunted forward and your list
gets<BR>>shorter.<BR>><BR>>just a
thought.<BR><BR><BR>__________________________________________/Fusebox
Conference!<BR><BR>Sign up for the Fusebox Conference
today!
<BR>October 26th & 27th: Orlando, FL, just before MACR
DevCon. <BR>2 jam-packed days, 15 speakers
in three tracks, World Fuseball
<BR>Championship
<BR><A
href="http://www.fusebox.org/index.cfm?fuseaction=conference.main ";>http://www.fusebox.org/index.cfm?fuseaction=conference.main </A>
--=_065A90AF.D0B1D230--
------=_NextPartTM-000-615b9555-dccf-11d6-9544-00105a68c8ef-- ${list_footer}
${list_promo} ${list_footer} ${list_promo} </DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C27126.A232F660--
</BODY></HTML>
------------------------------
Date: Fri, 11 Oct 2002 10:17:09 -0400
From: "Derrick Rapley" <[EMAIL PROTECTED]>
Subject: RE: Using ThisTag.HasEndTag with CFMODULE
Doug,
Like you and Ajay, I do prefer to use CFMODULE as opposed to the standard
CF_ call, mainly b/c i don't have to dump the templates in every single
folder.
I actually new about the error and should have brought it up at the meeting
the other night. CFMODULE behaves a little differently than the CF_ call
when dealing with nested tags.
While
<cf_dataValidate>
<cf_dataValidateItem>
</cf_dataValidate>
works fine, using CFMODULE doesn't
<cfmodule template="dataValidate.cfm"
<cfmodule template="dataValidateItem.cfm">
</cfmodule template="dataValidate.cfm">
In the closing </CFMODULE>, any attributes that are passed are actually
ignored by ColdFusion. ColdFusion associates the closing </CFMODULE> to the
most recent call to <CFMODULE> (in this case <cfmodule
template="dataValidateItem.cfm">). This is why you got the "Must have End
Tag" error b/c CF didn't see a closing </cfmodule> for the opening call to
the parent tag.
Although I haven't tried it, it seems that Bert Dawson's advice should work
and you may want to try it:
<cfmodule template="dataValidate.cfm">
<cfmodule template="dataValidateItem.cfm"></cfmodule>
<cfmodule template="dataValidateItem.cfm"></cfmodule>
</cfmodule>
Hope this helps.
-Derrick
------------------------------
Date: Fri, 11 Oct 2002 11:14:38 -0400
From: "Mike Elmalem" <[EMAIL PROTECTED]>
Subject: Random Loop OT for Newbie
This is a multi-part message in MIME format.
------=_NextPart_000_0011_01C27117.638014C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Hello All,
I was wondering if some one could help me offlist with something I think is simple I
just can't get it.
I need to create a database with fictional data. I need to create a column with
random numbers between 50 and 1000 and need to create this for 365 rows.
It seems simple enough I just can figure out how to do it after looking at the docs on
the web.
Thanks in advance and sorry for being off topic.
Mike
------=_NextPart_000_0011_01C27117.638014C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello All,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I was wondering if some one could help me
offlist with something I think is simple I just can't get it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I need to create a database with fictional
data. I need to create a column with random numbers between 50 and 1000
and need to create this for 365 rows.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It seems simple enough I just can figure out how to
do it after looking at the docs on the web.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance and sorry for being off
topic.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Mike</FONT></DIV>
</BODY></HTML>
------=_NextPart_000_0011_01C27117.638014C0--
------------------------------
Date: Fri, 11 Oct 2002 11:55:46 -0500
From: Chris Corwin <[EMAIL PROTECTED]>
Subject: Re: Random Loop OT for Newbie
On 10/11/02 10:14 AM, "Mike Elmalem" <[EMAIL PROTECTED]> wrote:
> I need to create a database with fictional data. I need to create a column
> with random numbers between 50 and 1000 and need to create this for 365 rows.
>
> It seems simple enough I just can figure out how to do it after looking at the
> docs on the web.
>
> Thanks in advance and sorry for being off topic.
What language are you using?
I can tell you how to do it Lasso.
� - me
��������� me = chris corwin
������ title = usability czar
���� company = sonar studios
������ phone = 317.972.4210
============================================================================
"No no, Tom, you've got it all
wrong. If TV has taught me
nothing else, I am quite sure
you cannot be poor and feel good
about yourself at the same time."
-- Marc Garrett
webforums.macromedia.com/drk/messageview.cfm?catid=271&threadid=447026
------------------------------
Date: Fri, 11 Oct 2002 12:59:35 -0400
From: "Mike Elmalem" <[EMAIL PROTECTED]>
Subject: Re: Random Loop OT for Newbie
ColdFusion
----- Original Message -----
From: "BerberCarpet" <[EMAIL PROTECTED]>
To: "fusebox topica.com" <[EMAIL PROTECTED]>
Sent: Friday, October 11, 2002 12:55 PM
Subject: Re: Random Loop OT for Newbie
On 10/11/02 10:14 AM, "Mike Elmalem" <[EMAIL PROTECTED]> wrote:
> I need to create a database with fictional data. I need to create a
column
> with random numbers between 50 and 1000 and need to create this for 365
rows.
>
> It seems simple enough I just can figure out how to do it after looking at
the
> docs on the web.
>
> Thanks in advance and sorry for being off topic.
What language are you using?
I can tell you how to do it Lasso.
- me
me = chris corwin
title = usability czar
company = sonar studios
phone = 317.972.4210
============================================================================
"No no, Tom, you've got it all
wrong. If TV has taught me
nothing else, I am quite sure
you cannot be poor and feel good
about yourself at the same time."
-- Marc Garrett
webforums.macromedia.com/drk/messageview.cfm?catid=271&threadid=447026
__________________________________________/Fusebox Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
http://www.fusebox.org/index.cfm?fuseaction=conference.main
------------------------------
Date: Fri, 11 Oct 2002 10:16:26 -0700
From: "Barney Boisvert" <[EMAIL PROTECTED]>
Subject: RE: Random Loop OT for Newbie
This is a multi-part message in MIME format.
------=_NextPart_000_00B4_01C2710F.41F7EB50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
<cfloop from="1" to="365" index="i">
<cfquery datasource="#request.dsn#" name="insert#i#">
INSERT INTO myTable
(random,
...
)
VALUES
(#randRange(50, 1000)#,
...
)
</cfquery>
</cfloop>
That should do the trick. Just add in the rest of your fields
-----Original Message-----
From: Mike Elmalem [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 8:15 AM
To: [EMAIL PROTECTED]
Subject: Random Loop OT for Newbie
Hello All,
I was wondering if some one could help me offlist with something I think
is simple I just can't get it.
I need to create a database with fictional data. I need to create a
column with random numbers between 50 and 1000 and need to create this for
365 rows.
It seems simple enough I just can figure out how to do it after looking at
the docs on the web.
Thanks in advance and sorry for being off topic.
Mike
__________________________________________/Fusebox Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
http://www.fusebox.org/index.cfm?fuseaction=conference.main
==^==^=============================================================
This email was sent to: [EMAIL PROTECTED]
EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV9nN2
Or send an email to: [EMAIL PROTECTED]
T O P I C A -- Register now to manage your mail!
http://www.topica.com/partner/tag02/register
==^==^=============================================================
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.400 / Virus Database: 226 - Release Date: 10/9/2002
------=_NextPart_000_00B4_01C2710F.41F7EB50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4919.2200" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2><cfloop from="1" to="365" index="i"></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New"><FONT
color=#0000ff> <FONT size=2><cfquery
datasource="#request.dsn#"
name="insert#i#"></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2> INSERT INTO
myTable</FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><FONT face="Courier New"><FONT
color=#0000ff><SPAN class=032241317-11102002><FONT
size=2>
</FONT></SPAN>(random,</FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2>
...</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><FONT face="Courier New"
color=#0000ff
size=2>
)</FONT></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2> VALUES</FONT></SPAN></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><FONT face="Courier New"
color=#0000ff
size=2>
(#randRange(50, 1000)#,</FONT></SPAN></SPAN></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2>
...</FONT></SPAN></SPAN></SPAN></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><FONT face="Courier New"
color=#0000ff
size=2>
)</FONT></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2> </cfquery></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2></cfloop></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face=Arial color=#ff0000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=032241317-11102002><FONT face=Arial color=#ff0000 size=2>That
should do the trick. Just add in the rest of your
fields</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Mike Elmalem
[mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Friday, October 11, 2002 8:15
AM<BR><B>To:</B> [EMAIL PROTECTED]<BR><B>Subject:</B> Random Loop OT for
Newbie<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hello All,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I was wondering if some one could help me
offlist with something I think is simple I just can't get it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I need to create a database with fictional
data. I need to create a column with random numbers between 50 and 1000
and need to create this for 365 rows.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It seems simple enough I just can figure out how
to do it after looking at the docs on the web.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance and sorry for being off
topic.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>Mike</FONT></DIV><PRE>__________________________________________/Fusebox
Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
<A
href="http://www.fusebox.org/index.cfm?fuseaction=conference.main";>http://www.fusebox.org/index.cfm?fuseaction=conference.main</A>
</PRE></BLOCKQUOTE>
</BODY></HTML>
------=_NextPart_000_00B4_01C2710F.41F7EB50--
------------------------------
Date: Fri, 11 Oct 2002 13:22:24 -0400
From: "Mike Elmalem" <[EMAIL PROTECTED]>
Subject: Re: Random Loop OT for Newbie
This is a multi-part message in MIME format.
------=_NextPart_000_0058_01C27129.3CAE9F30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
thanks for the help.
----- Original Message -----
From: Barney Boisvert
To: [EMAIL PROTECTED]
Sent: Friday, October 11, 2002 1:16 PM
Subject: RE: Random Loop OT for Newbie
<cfloop from="1" to="365" index="i">
<cfquery datasource="#request.dsn#" name="insert#i#">
INSERT INTO myTable
(random,
...
)
VALUES
(#randRange(50, 1000)#,
...
)
</cfquery>
</cfloop>
That should do the trick. Just add in the rest of your fields
-----Original Message-----
From: Mike Elmalem [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 8:15 AM
To: [EMAIL PROTECTED]
Subject: Random Loop OT for Newbie
Hello All,
I was wondering if some one could help me offlist with something I think is simple
I just can't get it.
I need to create a database with fictional data. I need to create a column with
random numbers between 50 and 1000 and need to create this for 365 rows.
It seems simple enough I just can figure out how to do it after looking at the
docs on the web.
Thanks in advance and sorry for being off topic.
Mike
__________________________________________/Fusebox Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
http://www.fusebox.org/index.cfm?fuseaction=conference.main
__________________________________________/Fusebox Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
http://www.fusebox.org/index.cfm?fuseaction=conference.main
------=_NextPart_000_0058_01C27129.3CAE9F30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>thanks for the help. </FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000
2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]";>Barney
Boisvert</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A [EMAIL PROTECTED]
href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, October 11, 2002 1:16
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Random Loop OT for
Newbie</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2><cfloop from="1" to="365" index="i"></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New"><FONT
color=#0000ff> <FONT size=2><cfquery
datasource="#request.dsn#"
name="insert#i#"></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2> INSERT INTO
myTable</FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><FONT
face="Courier New"><FONT color=#0000ff><SPAN class=032241317-11102002><FONT
size=2>
</FONT></SPAN>(random,</FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2>
...</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><FONT
face="Courier New" color=#0000ff
size=2>
)</FONT></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2> VALUES</FONT></SPAN></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><FONT
face="Courier New" color=#0000ff
size=2>
(#randRange(50, 1000)#,</FONT></SPAN></SPAN></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2>
...</FONT></SPAN></SPAN></SPAN></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT size=2><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><SPAN
class=032241317-11102002><SPAN class=032241317-11102002><FONT
face="Courier New" color=#0000ff
size=2>
)</FONT></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2> </cfquery></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face="Courier New" color=#0000ff
size=2></cfloop></FONT></SPAN></DIV>
<DIV><SPAN class=032241317-11102002><FONT face=Arial color=#ff0000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=032241317-11102002><FONT face=Arial color=#ff0000 size=2>That
should do the trick. Just add in the rest of your
fields</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Mike Elmalem
[mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Friday, October 11, 2002 8:15
AM<BR><B>To:</B> [EMAIL PROTECTED]<BR><B>Subject:</B> Random Loop OT for
Newbie<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hello All,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I was wondering if some one could help me
offlist with something I think is simple I just can't get it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I need to create a database with fictional
data. I need to create a column with random numbers between 50 and
1000 and need to create this for 365 rows.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It seems simple enough I just can figure out
how to do it after looking at the docs on the web.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance and sorry for being off
topic.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>Mike</FONT></DIV><PRE>__________________________________________/Fusebox
Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
<A
href="http://www.fusebox.org/index.cfm?fuseaction=conference.main";>http://www.fusebox.org/index.cfm?fuseaction=conference.main</A>
</PRE></BLOCKQUOTE><PRE>__________________________________________/Fusebox
Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
<A
href="http://www.fusebox.org/index.cfm?fuseaction=conference.main";>http://www.fusebox.org/index.cfm?fuseaction=conference.main</A>
</PRE></BLOCKQUOTE>
</BODY></HTML>
------=_NextPart_000_0058_01C27129.3CAE9F30--
------------------------------
Date: Fri, 11 Oct 2002 14:32:47 -0600
From: "Richard" <[EMAIL PROTECTED]>
Subject: RE: Random Loop OT for Newbie
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C27133.118B2E40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
This builds a random list of non repeating numbers, The #sesssion.QNBR# is
set elsewhere (or you can do it here to your 365) and represents the max
value in this list. Loop condition maintains the randomization, not
original with me but works nicely. Then SQL it into your table
<CFSET session.RandList = "">
<CFSET RandomNum = "">
<CFLOOP from="1" to="#session.QNBR#" index="i">
<CFIF i IS 1>
<CFSET RandomNum = RandRange(1, #session.QNBR#)>
<CFELSE>
<CFLOOP CONDITION = "ListFind(session.RandList, RandomNum) IS
NOT 0">
<CFSET RandomNum = RandRange(1, #session.QNBR#)>
</CFLOOP>
</CFIF>
<CFSET session.RandList = ListAppend(session.RandList, RandomNum)>
</CFLOOP>
Best
Richard Kern
-----Original Message-----
From: Mike Elmalem [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 9:15 AM
To: [EMAIL PROTECTED]
Subject: Random Loop OT for Newbie
Hello All,
I was wondering if some one could help me offlist with something I think
is simple I just can't get it.
I need to create a database with fictional data. I need to create a
column with random numbers between 50 and 1000 and need to create this for
365 rows.
It seems simple enough I just can figure out how to do it after looking at
the docs on the web.
Thanks in advance and sorry for being off topic.
Mike
__________________________________________/Fusebox Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
http://www.fusebox.org/index.cfm?fuseaction=conference.main
==^==^=============================================================
This email was sent to: [EMAIL PROTECTED]
EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bWizDS
Or send an email to: [EMAIL PROTECTED]
T O P I C A -- Register now to manage your mail!
http://www.topica.com/partner/tag02/register
==^==^=============================================================
------=_NextPart_000_0000_01C27133.118B2E40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=125342820-11102002><FONT face=Arial color=#0000ff size=2>This
builds a random list of non repeating numbers, The #sesssion.QNBR# is set
elsewhere (or you can do it here to your 365) and represents the max value in
this list. Loop condition maintains the randomization, not original with
me but works nicely. Then SQL it into your table</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><CFSET session.RandList = ""><BR> <CFSET RandomNum =
""><BR><BR><CFLOOP from="1" to="#session.QNBR#"
index="i"><BR> <SPAN class=125342820-11102002>
</SPAN><CFIF i IS 1><BR> <SPAN
class=125342820-11102002>
</SPAN><CFSET RandomNum = RandRange(1,
#session.QNBR#)><BR> <SPAN
class=125342820-11102002>
</SPAN><CFELSE><BR> <SPAN
class=125342820-11102002>
</SPAN><CFLOOP CONDITION = "ListFind(session.RandList, RandomNum) IS NOT
0"><BR> <SPAN
class=125342820-11102002>
</SPAN><CFSET RandomNum = RandRange(1,
#session.QNBR#)><BR> <SPAN
class=125342820-11102002> </SPAN><SPAN
class=125342820-11102002>
</SPAN></CFLOOP><BR> <SPAN
class=125342820-11102002> </SPAN></CFIF></DIV>
<DIV> </DIV>
<DIV> <CFSET session.RandList = ListAppend(session.RandList,
RandomNum)><BR></CFLOOP><BR></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=125342820-11102002><FONT face=Arial color=#0000ff
size=2>Best</FONT></SPAN></DIV>
<DIV><SPAN class=125342820-11102002><FONT face=Arial color=#0000ff
size=2>Richard Kern</FONT></SPAN></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Mike Elmalem
[mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Friday, October 11, 2002 9:15
AM<BR><B>To:</B> [EMAIL PROTECTED]<BR><B>Subject:</B> Random Loop OT for
Newbie<BR><BR></DIV></BLOCKQUOTE></FONT>
<DIV><FONT face=Arial size=2>Hello All,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I was wondering if some one could help me
offlist with something I think is simple I just can't get it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I need to create a database with fictional
data. I need to create a column with random numbers between 50 and 1000
and need to create this for 365 rows.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It seems simple enough I just can figure out how
to do it after looking at the docs on the web.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance and sorry for being off
topic.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>Mike</FONT></DIV><PRE>__________________________________________/Fusebox
Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
<A
href="http://www.fusebox.org/index.cfm?fuseaction=conference.main";>http://www.fusebox.org/index.cfm?fuseaction=conference.main</A>
</PRE></BLOCKQUOTE>
</BODY></HTML>
------=_NextPart_000_0000_01C27133.118B2E40--
------------------------------
__________________________________________/Fusebox Conference!
Sign up for the Fusebox Conference today!
October 26th & 27th: Orlando, FL, just before MACR DevCon.
2 jam-packed days, 15 speakers in three tracks, World Fuseball
Championship
http://www.fusebox.org/index.cfm?fuseaction=conference.main
End of [EMAIL PROTECTED] digest, issue 969
