-- Topica Digest --
RE: something like this...
By [EMAIL PROTECTED]
RE: I need more data
By [EMAIL PROTECTED]
RE: something like this...
By [EMAIL PROTECTED]
RE: I need more data
By [EMAIL PROTECTED]
loop and query
By [EMAIL PROTECTED]
Re: loop and query
By [EMAIL PROTECTED]
Importing text files
By [EMAIL PROTECTED]
RE: Importing text files
By [EMAIL PROTECTED]
RE: Importing text files
By [EMAIL PROTECTED]
Using ThisTag.HasEndTag with CFMODULE
By [EMAIL PROTECTED]
CLIENT variables in Layout Pages
By [EMAIL PROTECTED]
Re: Using ThisTag.HasEndTag with CFMODULE
By [EMAIL PROTECTED]
Re: Using ThisTag.HasEndTag with CFMODULE
By [EMAIL PROTECTED]
Re: Using ThisTag.HasEndTag with CFMODULE
By [EMAIL PROTECTED]
RE: Using ThisTag.HasEndTag with CFMODULE
By [EMAIL PROTECTED]
Re: Using ThisTag.HasEndTag with CFMODULE
By [EMAIL PROTECTED]
Re: CLIENT variables in Layout Pages
By [EMAIL PROTECTED]
Re: CLIENT variables in Layout Pages
By [EMAIL PROTECTED]
PHP/Fusebox...MySQL applications???
By [EMAIL PROTECTED]
Re: PHP/Fusebox...MySQL applications???
By [EMAIL PROTECTED]
RE: Importing text files
By [EMAIL PROTECTED]
Re: PHP/Fusebox...MySQL applications???
By [EMAIL PROTECTED]
Global EXit FuseActions
By [EMAIL PROTECTED]
RE: Global EXit FuseActions
By [EMAIL PROTECTED]
Re: Global EXit FuseActions
By [EMAIL PROTECTED]
RE: Importing text files--follow Up
By [EMAIL PROTECTED]
Re: Importing text files--follow Up
By [EMAIL PROTECTED]
Re: Importing text files--follow Up
By [EMAIL PROTECTED]
Re: Importing text files--follow Up
By [EMAIL PROTECTED]
Re: Importing text files--follow Up
By [EMAIL PROTECTED]
------------------------------------------------------------
Date: Thu, 10 Oct 2002 10:12:55 -0400
From: "Douglas Smith" <[EMAIL PROTECTED]>
Subject: RE: something like this...
Since it is so different, and compiled to Java, I doubt that evaluate tag
has the same overhead in CFMX as it does in CF5 and below. But, I do like
the idea of using the structure/array notation for variables. That is a
good idea.
At 03:57 PM 10/9/02 +0100, Robertson-Ravo, Neil (REC) wrote:
>yeah but it has an overhead - its pretty slow. The general rule is avoid it
>wherever you can!
>
>-----Original Message-----
>From: Erki Esken [mailto:[EMAIL PROTECTED]]
>Sent: 09 October 2002 15:54
>To: [EMAIL PROTECTED]
>Subject: Re: something like this...
>
>
> > I will have a look, but not its doesnt have its place, its a
> > bastard off a tag and should be eliminated in CFMX 6.5 :-)
> >
>
>It does have some use. For example, sometimes I want to see
>what certain CF expression evaluates to and then I quickly
>try it out with my cf_eval.cfm template:
>
>---cf_eval.cfm---
><cfsetting enablecfoutputonly="Yes" showdebugoutput="No">
><cfparam name="form.expr" default="">
>
><cfoutput>
><form action="cf_eval.cfm" method="post">
> CF Expression:<br>
> <input type="text" size="80" name="expr" accesskey="e"
>value="#HTMLEditFormat(form.expr)#"><br>
> <input type="submit" value=" Evaluate ">
></form>
></cfoutput>
>
><cfif Len(form.expr)>
> <cftry>
> <cfoutput><hr size="1">#Evaluate(form.expr)#</cfoutput>
> <cfcatch>
> <cfdump var="#CFCATCH#">
> </cfcatch>
> </cftry>
></cfif>
>---cf_eval.cfm---
>
>.erki
>
>
>__________________________________________/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
>
------------------------------
Date: Thu, 10 Oct 2002 07:23:17 -0700
From: "Mike Brunt" <[EMAIL PROTECTED]>
Subject: RE: I need more data
Erik, do you just need us all to do one hit (submit) or multiples?
Mike Brunt - CTO
Webapper Services LLC
http://www.webapper.com
Downey CA Office
562.243.6255
"Making the NET Work"
-----Original Message-----
From: Erik Voldengen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 10:56 PM
To: [EMAIL PROTECTED]
Subject: I need more data
I'm about to release a new version of sesConverter, and I'd like
to make sure it works for as many web server/CF/OS configurations
as possible. So I'm looking for yet more test data.
The following URL will go to a download for a CFML template
you can run on your server. It's very simple - just download
the file, run it, click submit, and you're done.
http://www.fusium.com/go/sestest
Thanks in advance for the information.
Erik Voldengen
Senior Partner & Creative Director
Fusium, Inc.
503-646-9514
__________________________________________/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: Thu, 10 Oct 2002 09:35:00 -0500
From: "Matt Jones" <[EMAIL PROTECTED]>
Subject: RE: something like this...
I thought the same thing, so I Ran 100,000 iterations of each to test.
Essentially the evaluate took a little more than twice as long(cf MX,
IIS 5, Win 2k)
-----Original Message-----
From: Douglas Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 9:13 AM
To: [EMAIL PROTECTED]
Subject: RE: something like this...
Since it is so different, and compiled to Java, I doubt that evaluate
tag
has the same overhead in CFMX as it does in CF5 and below. But, I do
like
the idea of using the structure/array notation for variables. That is a
good idea.
------------------------------
Date: Thu, 10 Oct 2002 08:43:44 -0700
From: "Erik Voldengen" <[EMAIL PROTECTED]>
Subject: RE: I need more data
Oh just one hit, please.
I'd love to see some more submitions for alternate web servers
(ie other than IIS and Apache 1.x) and Nix boxes, too.
Thanks,
Erik
> Erik, do you just need us all to do one hit (submit) or multiples?
>
> Mike Brunt - CTO
> Webapper Services LLC
> http://www.webapper.com
> Downey CA Office
> 562.243.6255
>
> "Making the NET Work"
>
>> http://www.fusium.com/go/sestest
------------------------------
Date: Thu, 10 Oct 2002 15:59:56 -0300
From: Jorge Martin Bove <[EMAIL PROTECTED]>
Subject: loop and query
--=====================_24231763==_.ALT
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: 8bit
Hello to all!
This it is my first message in this list, I am new using fusebox, so I
request excuses to him if I make questions of novice.
What I want to know is as this code can be adapted, to separate the logic
of query. If it exists some way, or it would be necessary to do it of some
other way?
The code is this:
<CFLOOP query="Prioridad_list">
<CFQUERY name="List_task" datasource="#request.site.mainDSN#">
SELECT Tarea_id, User_id, Prioridad_id,
Tarea_nombre, Tarea_descripcion,
Tarea_fecha_alta, Tarea_fecha_fin, Tarea_act
FROM Tareas
WHERE
(User_id = #session.user_id#) AND (Tarea_act ='1') AND
(Prioridad_id = #Prioridad_list.Prioridad_id#)
ORDER BY Tarea_fecha_alta DESC;
</CFQUERY>
</CFLOOP>
In order to finish presenting to, my name is Mart�n I am 24 years old and
live in Argentina.
And sorry for my very bad english.
Thanks!
----------
Martin Bove - Webmaster -
<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED] -
http://www.bordeline.com.ar
Bordeline Internet Solutions - Macromedia Associate Partner
Tel: (54)-0341-4822847 Fax: (54)-0341-4818934
--=====================_24231763==_.ALT
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
<html>
Hello to all! <br>
This it is my first message in this list, I am new using fusebox, so I
request excuses to him if I make questions of novice. <br><br>
What I want to know is as this code can be adapted, to separate the logic
of query. If it exists some way, or it would be necessary to do it
of some other way?<br><br>
The code is this:<br>
<br>
<CFLOOP query="Prioridad_list"><br>
<CFQUERY
name="List_task"
datasource="#request.site.mainDSN#"><br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>SELECT
Tarea_id, User_id, Prioridad_id, Tarea_nombre, Tarea_descripcion, <br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>Tarea_fecha_alta,
Tarea_fecha_fin, Tarea_act <br>
FROM
Tareas <br>
WHERE
<br>
(User_id = #session.user_id#) AND (Tarea_act ='1') AND (Prioridad_id =
#Prioridad_list.Prioridad_id#) <br>
ORDER
BY Tarea_fecha_alta DESC; <br>
<x-tab> </x-tab></CFQUERY>
<br>
</CFLOOP><br><br>
In order to finish presenting to, my name is Mart�n I am 24 years old and
live in Argentina. <br>
And sorry for my very bad english.<br>
Thanks! <br><br>
<x-sigsep><p></x-sigsep>
<hr>
<div align="center"><font size=2 color="#333333"><b>Martin Bove </b>-<b>
<i>Webmaster</b></font><font size=2> </i>- <a
href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]</a> - <a
href="http://www.bordeline.com.ar/";
eudora="autourl">http://www.bordeline.com.ar</a><br>
</font>Bordeline Internet Solutions - Macromedia Associate Partner<br>
<font size=2>Tel: (54)-0341-4822847 Fax: (54)-0341-4818934<br>
</font></div>
</html>
--=====================_24231763==_.ALT--
------------------------------
Date: Thu, 10 Oct 2002 14:18:50 -0500
From: Steve Bryant <[EMAIL PROTECTED]>
Subject: Re: loop and query
As a general rule, it is a good idea to avoid looping over queries if you
can help it. If you want help combining the two queries into one, feel free
to send me both queries and your display code off-list and I would be glad
to help you combine them into one query.
At 03:59 PM 10/10/2002 -0300, you wrote:
>Hello to all!
>This it is my first message in this list, I am new using fusebox, so I
>request excuses to him if I make questions of novice.
>
>What I want to know is as this code can be adapted, to separate the logic
>of query. If it exists some way, or it would be necessary to do it of
>some other way?
>
>The code is this:
>
><CFLOOP query="Prioridad_list">
> <CFQUERY name="List_task" datasource="#request.site.mainDSN#">
> SELECT Tarea_id, User_id, Prioridad_id,
> Tarea_nombre, Tarea_descripcion,
> Tarea_fecha_alta, Tarea_fecha_fin, Tarea_act
> FROM Tareas
> WHERE
> (User_id = #session.user_id#) AND (Tarea_act ='1') AND
> (Prioridad_id = #Prioridad_list.Prioridad_id#)
> ORDER BY Tarea_fecha_alta DESC;
> </CFQUERY>
> </CFLOOP>
>
>In order to finish presenting to, my name is Mart�n I am 24 years old and
>live in Argentina.
>And sorry for my very bad english.
>Thanks!
------------------------------
Date: Thu, 10 Oct 2002 13:34:07 -0600
From: "Terry Hogan" <[EMAIL PROTECTED]>
Subject: Importing text files
Hi,
I need to build a module that will upload a tab delimited text file, then import the
records to the database.
I know I've seen this done, but can't find any samples.
TIA
Terry
(I know this is more of a CF-talk question, but I couldn't access the archives and my
email was rejected.)
------------------------------
Date: Thu, 10 Oct 2002 20:05:53 +0000
From: alex artigues <[EMAIL PROTECTED]>
Subject: RE: Importing text files
This will help you with the parsing once you
have the data in your hand. We'll call your data
"tabFile":
----------------------------------------------------------------
<CFSET columnDelim = " "> <!--- TAB BETWEEN THE QUOTES --->
<CFSET rowDelim = CHR(13) & CHR(10)>
<CFSET rowCount = ListLen(tabFile, rowDelim)>
<CFLOOP from="1" to="#rowCount#" index="counter">
<CFSET thisRow = ListGetAt(tabFile, counter, rowDelim)>
<CFSET item1 = ListGetAt(thisRow, 1, columnDelim)>
<CFSET item2 = ListGetAt(thisRow, 2, columnDelim)>
<!--- NOW RUN YOUR INSERT QUERY FOR THESE FIELDS --->
</CFLOOP>
--------------------------------------------------------------------
Terry Hogan wrote:
> Hi,
>
> I need to build a module that will upload a tab delimited text file,
> then import the records to the database.
>
> I know I've seen this done, but can't find any samples.
>
> TIA
>
> Terry
>
> (I know this is more of a CF-talk question, but I couldn't access the
> archives and my email was rejected.)
>
>
>
------------------------------
Date: Thu, 10 Oct 2002 21:40:49 +0100
From: Bert Dawson <[EMAIL PROTECTED]>
Subject: RE: Importing text files
you might try using the querysim tag (from www.halhelms.com), and do
something like:
<cfquerysim>
myQueryFromTextFile
col1,col2,col3
<cfinclude template="yourtextfile.txt">
</cfquerysim>
You'll have to check the syntax and might have to hack it about a bit to
accept tabs as the delimiter (i think it uses '|' but i haven't looked at it
for a while.)
All being well this should re-create the data from the text file as a query,
which you then loop though inserting into the dB.
Alternatively you could use querySim() UDF from www.cflib.org but you'll
have to get the contents of the file into a variable, (either a cfinclude
wrapped in a cfbodycontent, or using <cffile read> (yuk)):
<cfsavecontent variable="filedata">
<cfinclude template="yourtextfile.txt">
</cfsavecontent>
<cfset querySim('
myQueryFromTextFile
col1,col2,col3
#filedata#')>
...but while the UDF is far more elegant (check the author:), it does get
increasingly slower the larger the amount of data you pass it...
The other alternative is to do like alex suggests and loop through the
filecontents using crlf and tab (chr(9)) as the delimiters.
Horses for courses.
HTH
Bert
ps for general (i.e. non fusebox) questions like this i can highly recommend
the fusebox community list:
[EMAIL PROTECTED]
> -----Original Message-----
> From: alex artigues [mailto:[EMAIL PROTECTED]]
> Sent: 10 October 2002 21:06
> To: [EMAIL PROTECTED]
> Subject: RE: Importing text files
>
>
> This will help you with the parsing once you
> have the data in your hand. We'll call your data
> "tabFile":
> ----------------------------------------------------------------
> <CFSET columnDelim = " "> <!--- TAB BETWEEN THE QUOTES --->
> <CFSET rowDelim = CHR(13) & CHR(10)>
> <CFSET rowCount = ListLen(tabFile, rowDelim)>
>
> <CFLOOP from="1" to="#rowCount#" index="counter">
> <CFSET thisRow = ListGetAt(tabFile, counter, rowDelim)>
> <CFSET item1 = ListGetAt(thisRow, 1, columnDelim)>
> <CFSET item2 = ListGetAt(thisRow, 2, columnDelim)>
>
> <!--- NOW RUN YOUR INSERT QUERY FOR THESE FIELDS --->
> </CFLOOP>
> --------------------------------------------------------------------
>
>
>
> Terry Hogan wrote:
> > Hi,
> >
> > I need to build a module that will upload a tab delimited
> text file,
> > then import the records to the database.
> >
> > I know I've seen this done, but can't find any samples.
> >
> > TIA
> >
> > Terry
> >
> > (I know this is more of a CF-talk question, but I couldn't
> access the
> > archives and my email was rejected.)
> >
> >
> >
>
>
> __________________________________________/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: Thu, 10 Oct 2002 16:56:30 -0400
From: "Ajay" <[EMAIL PROTECTED]>
Subject: Using ThisTag.HasEndTag with CFMODULE
We want to call a custom validation tag using <cfmodule> instead of
calling it like <cf_mytagname>
However, the tag checks for ThisTag.HasEndTag, and returns false. Here
is the code we are attempting to run:
<cfmodule template="../cf_library/dataValidate.cfm" output="stErrors"
type="structure">
<cfmodule template="../cf_library/dataValidateItem.cfm"
type="required" value="#form.AdminLogin#" message="Admin Login Name is
Required" formfield="AdminLogin">
<cfmodule template="../cf_library/dataValidateItem.cfm"
type="required" value="#form.AdminPassword#" message="Password is
Required" formfield="AdminPassword">
</cfmodule template="../cf_library/dataValidate.cfm">
Is there any way around this except editing the custom tag to not check
the HasEndTag variable?
--
Ajay Sathuluri, TeraTech, Inc. - Tools for Programmers(tm)
12221 Parklawn Drive Ste 200, Rockville MD 20852 USA
Voice: 301-881-1440, 800-447-9120 Fax:301-881-3586
Web: http://www.teratech.com
Email: mailto:[EMAIL PROTECTED]
------------------------------
Date: Thu, 10 Oct 2002 20:57:49 +0000
From: Matthew C. Parks <[EMAIL PROTECTED]>
Subject: CLIENT variables in Layout Pages
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
------------------------------
Date: Thu, 10 Oct 2002 15:59:26 -0500
From: "David Huyck" <[EMAIL PROTECTED]>
Subject: Re: Using ThisTag.HasEndTag with CFMODULE
You can close a cfModule tag, and that will do the trick...
<cfmodule ...>
stuff ...
</cfModule>
HTH,
David Huyck
[EMAIL PROTECTED]
"Na vida se cai se leva rasteira.
Quem nunca caiu, n�o � capoeira..."
----- Original Message -----
From: "Ajay S" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 3:56 PM
Subject: Using ThisTag.HasEndTag with CFMODULE
| We want to call a custom validation tag using <cfmodule> instead of
| calling it like <cf_mytagname>
|
| However, the tag checks for ThisTag.HasEndTag, and returns false. Here
| is the code we are attempting to run:
|
| <cfmodule template="../cf_library/dataValidate.cfm" output="stErrors"
| type="structure">
| <cfmodule template="../cf_library/dataValidateItem.cfm"
| type="required" value="#form.AdminLogin#" message="Admin Login Name is
| Required" formfield="AdminLogin">
| <cfmodule template="../cf_library/dataValidateItem.cfm"
| type="required" value="#form.AdminPassword#" message="Password is
| Required" formfield="AdminPassword">
| </cfmodule template="../cf_library/dataValidate.cfm">
|
| Is there any way around this except editing the custom tag to not check
| the HasEndTag variable?
|
| --
| Ajay Sathuluri, TeraTech, Inc. - Tools for Programmers(tm)
| 12221 Parklawn Drive Ste 200, Rockville MD 20852 USA
| Voice: 301-881-1440, 800-447-9120 Fax:301-881-3586
| Web: http://www.teratech.com
| Email: mailto:[EMAIL PROTECTED]
|
|
| __________________________________________/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: Thu, 10 Oct 2002 17:06:17 -0400
From: "Ajay" <[EMAIL PROTECTED]>
Subject: Re: Using ThisTag.HasEndTag with CFMODULE
David,
I tried closing cfModule tag. That did not work
David Huyck wrote:
> You can close a cfModule tag, and that will do the trick...
>
> <cfmodule ...>
> stuff ...
> </cfModule>
>
> HTH,
> David Huyck
> [EMAIL PROTECTED]
>
> "Na vida se cai se leva rasteira.
> Quem nunca caiu, nco i capoeira..."
>
> ----- Original Message -----
> From: "Ajay S" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, October 10, 2002 3:56 PM
> Subject: Using ThisTag.HasEndTag with CFMODULE
>
> | We want to call a custom validation tag using <cfmodule> instead of
> | calling it like <cf_mytagname>
> |
> | However, the tag checks for ThisTag.HasEndTag, and returns false. Here
> | is the code we are attempting to run:
> |
> | <cfmodule template="../cf_library/dataValidate.cfm" output="stErrors"
> | type="structure">
> | <cfmodule template="../cf_library/dataValidateItem.cfm"
> | type="required" value="#form.AdminLogin#" message="Admin Login Name is
> | Required" formfield="AdminLogin">
> | <cfmodule template="../cf_library/dataValidateItem.cfm"
> | type="required" value="#form.AdminPassword#" message="Password is
> | Required" formfield="AdminPassword">
> | </cfmodule template="../cf_library/dataValidate.cfm">
> |
> | Is there any way around this except editing the custom tag to not check
> | the HasEndTag variable?
> |
> | --
> | Ajay Sathuluri, TeraTech, Inc. - Tools for Programmers(tm)
> | 12221 Parklawn Drive Ste 200, Rockville MD 20852 USA
> | Voice: 301-881-1440, 800-447-9120 Fax:301-881-3586
> | Web: http://www.teratech.com
> | Email: mailto:[EMAIL PROTECTED]
> |
> |
> | __________________________________________/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
>
--
Ajay Sathuluri, TeraTech, Inc. - Tools for Programmers(tm)
12221 Parklawn Drive Ste 200, Rockville MD 20852 USA
Voice: 301-881-1440, 800-447-9120 Fax:301-881-3586
Web: http://www.teratech.com
Email: mailto:[EMAIL PROTECTED]
------------------------------
Date: Thu, 10 Oct 2002 16:07:47 -0500
From: "David Huyck" <[EMAIL PROTECTED]>
Subject: Re: Using ThisTag.HasEndTag with CFMODULE
Try without indicating the template (</cfmodule
template="../cf_library/dataValidate.cfm"> should be simply </cfmodule>).
That will probably involve closing all your nested custom tags, and making
sure those only run when the tag is opened and not closed.
What is probably happening with the way you have it is that the (</cfmodule
template="../cf_library/dataValidate.cfm"> is actually only closing the
last-opened custom tag, and not the one you indicate with the template
attribute.
Make sense?
David Huyck
[EMAIL PROTECTED]
----- Original Message -----
From: "Ajay S" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 4:06 PM
Subject: Re: Using ThisTag.HasEndTag with CFMODULE
David,
I tried closing cfModule tag. That did not work
David Huyck wrote:
> You can close a cfModule tag, and that will do the trick...
>
> <cfmodule ...>
> stuff ...
> </cfModule>
>
> HTH,
> David Huyck
> [EMAIL PROTECTED]
>
> "Na vida se cai se leva rasteira.
> Quem nunca caiu, nco i capoeira..."
>
> ----- Original Message -----
> From: "Ajay S" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, October 10, 2002 3:56 PM
> Subject: Using ThisTag.HasEndTag with CFMODULE
>
> | We want to call a custom validation tag using <cfmodule> instead of
> | calling it like <cf_mytagname>
> |
> | However, the tag checks for ThisTag.HasEndTag, and returns false. Here
> | is the code we are attempting to run:
> |
> | <cfmodule template="../cf_library/dataValidate.cfm" output="stErrors"
> | type="structure">
> | <cfmodule template="../cf_library/dataValidateItem.cfm"
> | type="required" value="#form.AdminLogin#" message="Admin Login Name is
> | Required" formfield="AdminLogin">
> | <cfmodule template="../cf_library/dataValidateItem.cfm"
> | type="required" value="#form.AdminPassword#" message="Password is
> | Required" formfield="AdminPassword">
> | </cfmodule template="../cf_library/dataValidate.cfm">
> |
> | Is there any way around this except editing the custom tag to not check
> | the HasEndTag variable?
> |
> | --
> | Ajay Sathuluri, TeraTech, Inc. - Tools for Programmers(tm)
> | 12221 Parklawn Drive Ste 200, Rockville MD 20852 USA
> | Voice: 301-881-1440, 800-447-9120 Fax:301-881-3586
> | Web: http://www.teratech.com
> | Email: mailto:[EMAIL PROTECTED]
> |
> |
> | __________________________________________/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
>
--
Ajay Sathuluri, TeraTech, Inc. - Tools for Programmers(tm)
12221 Parklawn Drive Ste 200, Rockville MD 20852 USA
Voice: 301-881-1440, 800-447-9120 Fax:301-881-3586
Web: http://www.teratech.com
Email: mailto:[EMAIL PROTECTED]
__________________________________________/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: Thu, 10 Oct 2002 16:09:40 -0500
From: "Matt Jones" <[EMAIL PROTECTED]>
Subject: RE: Using ThisTag.HasEndTag with CFMODULE
You have a couple of choices
1.
<cfmodule template="../cf_library/dataValidate.cfm" output="stErrors"
type="structure">
<cfmodule template="../cf_library/dataValidateItem.cfm"
type="required" value="#form.AdminLogin#" message="Admin Login Name is
Required" formfield="AdminLogin" />
<cfmodule template="../cf_library/dataValidateItem.cfm"
type="required" value="#form.AdminPassword#" message="Password is
Required" formfield="AdminPassword" />
</cfmodule>
or
2.
<cfmodule template="../cf_library/dataValidate.cfm" output="stErrors"
type="structure">
<cfmodule template="../cf_library/dataValidateItem.cfm"
type="required" value="#form.AdminLogin#" message="Admin Login Name is
Required" formfield="AdminLogin">
</cfmodule>
<cfmodule template="../cf_library/dataValidateItem.cfm"
type="required" value="#form.AdminPassword#" message="Password is
Required" formfield="AdminPassword">
</cfmodule>
</cfmodule>
either should work just fine.
Hth
Matt
-----Original Message-----
From: Ajay S [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 3:57 PM
To: [EMAIL PROTECTED]
Subject: Using ThisTag.HasEndTag with CFMODULE
We want to call a custom validation tag using <cfmodule> instead of
calling it like <cf_mytagname>
However, the tag checks for ThisTag.HasEndTag, and returns false. Here
is the code we are attempting to run:
<cfmodule template="../cf_library/dataValidate.cfm" output="stErrors"
type="structure">
<cfmodule template="../cf_library/dataValidateItem.cfm"
type="required" value="#form.AdminLogin#" message="Admin Login Name is
Required" formfield="AdminLogin">
<cfmodule template="../cf_library/dataValidateItem.cfm"
type="required" value="#form.AdminPassword#" message="Password is
Required" formfield="AdminPassword">
</cfmodule template="../cf_library/dataValidate.cfm">
Is there any way around this except editing the custom tag to not check
the HasEndTag variable?
--
Ajay Sathuluri, TeraTech, Inc. - Tools for Programmers(tm)
12221 Parklawn Drive Ste 200, Rockville MD 20852 USA
Voice: 301-881-1440, 800-447-9120 Fax:301-881-3586
Web: http://www.teratech.com
Email: mailto:[EMAIL PROTECTED]
__________________________________________/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: Thu, 10 Oct 2002 17:08:33 -0400
From: "Douglas Smith" <[EMAIL PROTECTED]>
Subject: Re: Using ThisTag.HasEndTag with CFMODULE
We are doing that in the example, but it's still generating a "false" for
HasEndTag variable.
At 03:59 PM 10/10/02 -0500, David Huyck wrote:
>You can close a cfModule tag, and that will do the trick...
>
><cfmodule ...>
>stuff ...
></cfModule>
>
>HTH,
>David Huyck
>[EMAIL PROTECTED]
>
>"Na vida se cai se leva rasteira.
>Quem nunca caiu, nco i capoeira..."
>
>----- Original Message -----
>From: "Ajay S" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, October 10, 2002 3:56 PM
>Subject: Using ThisTag.HasEndTag with CFMODULE
>
>
>| We want to call a custom validation tag using <cfmodule> instead of
>| calling it like <cf_mytagname>
>|
>| However, the tag checks for ThisTag.HasEndTag, and returns false. Here
>| is the code we are attempting to run:
>|
>| <cfmodule template="../cf_library/dataValidate.cfm" output="stErrors"
>| type="structure">
>| <cfmodule template="../cf_library/dataValidateItem.cfm"
>| type="required" value="#form.AdminLogin#" message="Admin Login Name is
>| Required" formfield="AdminLogin">
>| <cfmodule template="../cf_library/dataValidateItem.cfm"
>| type="required" value="#form.AdminPassword#" message="Password is
>| Required" formfield="AdminPassword">
>| </cfmodule template="../cf_library/dataValidate.cfm">
>|
>| Is there any way around this except editing the custom tag to not check
>| the HasEndTag variable?
>|
>| --
>| Ajay Sathuluri, TeraTech, Inc. - Tools for Programmers(tm)
>| 12221 Parklawn Drive Ste 200, Rockville MD 20852 USA
>| Voice: 301-881-1440, 800-447-9120 Fax:301-881-3586
>| Web: http://www.teratech.com
>| Email: mailto:[EMAIL PROTECTED]
>|
>|
>| __________________________________________/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
>
------------------------------
Date: Thu, 10 Oct 2002 17:10:37 -0400
From: "Douglas Smith" <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Subject: Re: CLIENT variables in Layout Pages
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
>
------------------------------
Date: Thu, 10 Oct 2002 17:10:37 -0400
From: "Douglas Smith" <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Subject: Re: CLIENT variables in Layout Pages
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
>
------------------------------
Date: Fri, 11 Oct 2002 00:15:25 +0300 (EEST)
From: Jens Winberg <[EMAIL PROTECTED]>
Subject: PHP/Fusebox...MySQL applications???
Hello!
My name is Jens, I'm from Finland and I just started to get acquainted with
Fusebox two day's ago. I was wondering if there is any PHP/Fusebox application
available that I could look at, since I think this is the best way to learn
something new (looking at other people's code). Until now I have only found a
small tutorial and a "VERY" basic example of how to use Fusebox with PHP, but
what I would like is a more complex application (even greater if it used a
database like MySQL).
I really appreciate any help to get me started. So far I think Fusebox looks
like a great architecture but unfortunately there isn't that much ready code
to find on the internet, which would make it more popular to newbies.
Anyway, I hope somebody can help me.
Thanks!
Jens Winberg ([EMAIL PROTECTED])
------------------------------
Date: Thu, 10 Oct 2002 14:18:08 -0700
From: hamid <[EMAIL PROTECTED]>
Subject: Re: PHP/Fusebox...MySQL applications???
There are some example applications here:
http://www.fusebox.org/index.cfm?&fuseaction=phpframework.default
----- Original Message -----
From: "Jens Winberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 2:15 PM
Subject: PHP/Fusebox...MySQL applications???
Hello!
My name is Jens, I'm from Finland and I just started to get acquainted with
Fusebox two day's ago. I was wondering if there is any PHP/Fusebox
application
available that I could look at, since I think this is the best way to learn
something new (looking at other people's code). Until now I have only found
a
small tutorial and a "VERY" basic example of how to use Fusebox with PHP,
but
what I would like is a more complex application (even greater if it used a
database like MySQL).
I really appreciate any help to get me started. So far I think Fusebox looks
like a great architecture but unfortunately there isn't that much ready code
to find on the internet, which would make it more popular to newbies.
Anyway, I hope somebody can help me.
Thanks!
Jens Winberg ([EMAIL PROTECTED])
__________________________________________/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: Thu, 10 Oct 2002 17:34:53 -0400
From: Daniel Daugherty <[EMAIL PROTECTED]>
Subject: RE: Importing text files
Terry,
What database server are you using? Is the file in a predefined
format. How many users need to be able to do this at one time? How often
is this done and how many records do you expect per upload. What size is
the file being uploaded? I can give you a more detailed answer with the
answers from the above. General suggestions below.
If you are using SQL Server this is fairly simple there are many
ways you can do this with SQL server. Bulk insert from the file. BCP (bulk
copy program, most RDMS have one) to insert into the database from a file.
You can use a DTS package to do the import also. Lastly you can read the
file in via many different CF methods and use insert to place the data in.
I have a few tricks doing multiple record inserts with a insert statement.
But if you are dealing with more than 200 records I recommend a using bulk
insert,DTS or BCP if available in your Database.
Hope this helps
Daniel
-----Original Message-----
From: Terry Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 3:34 PM
To: [EMAIL PROTECTED]
Subject: Importing text files
Hi,
I need to build a module that will upload a tab delimited text file, then
import the records to the database.
I know I've seen this done, but can't find any samples.
TIA
Terry
(I know this is more of a CF-talk question, but I couldn't access the
archives and my email was rejected.)
__________________________________________/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: Thu, 10 Oct 2002 16:42:32 -0500
From: "David Huyck" <[EMAIL PROTECTED]>
Subject: Re: PHP/Fusebox...MySQL applications???
I am actualy not aware of any freely available "databased" example apps, but
that doesn't mean there aren't any. I will actually be presenting one for the
Fusebox Conference in Orlando this October 26 & 27 (plug! plug! plug! YOU
SHOULD GO IF YOU CAN-- IT'S AWESOME! plug! plug! plug!). After the conference
I plan to make it available, either as part of the conference materials, in an
online article, or on my own site-- whatever makes the most sense.
Sorry that doesn't help right now, but truth be told, I'm not done yet... If
there is anyone else out there with a sample PHP-Fusebox app that integrates a
database, please do share! :) Bueller? Bueller? Bueller?
David Huyck
[EMAIL PROTECTED]
----- Original Message -----
From: "Jens Winberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 4:15 PM
Subject: PHP/Fusebox...MySQL applications???
Hello!
My name is Jens, I'm from Finland and I just started to get acquainted with
Fusebox two day's ago. I was wondering if there is any PHP/Fusebox application
available that I could look at, since I think this is the best way to learn
something new (looking at other people's code). Until now I have only found a
small tutorial and a "VERY" basic example of how to use Fusebox with PHP, but
what I would like is a more complex application (even greater if it used a
database like MySQL).
I really appreciate any help to get me started. So far I think Fusebox looks
like a great architecture but unfortunately there isn't that much ready code
to find on the internet, which would make it more popular to newbies.
Anyway, I hope somebody can help me.
Thanks!
Jens Winberg ([EMAIL PROTECTED])
__________________________________________/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: Thu, 10 Oct 2002 15:02:50 -0700
From: hamid <[EMAIL PROTECTED]>
Subject: Global EXit FuseActions
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
------------------------------
Date: Thu, 10 Oct 2002 15:49:50 -0700
From: "Barney Boisvert" <[EMAIL PROTECTED]>
Subject: RE: Global EXit FuseActions
IMHO, if an XFA is used in a fuseaction, you should set it in that
fuseaction. If you're using an XFA in a layout, it should be set in
fbx_Layouts. If you're using an XFA in a lot of fuseactions within a
circuit, then you might want to look at how you're doing your layouts,
because you might be including stuff in your dsp_ fuses that could be in
your layout files.
barneyb
-----Original Message-----
From: hamid [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 3:03 PM
To: [EMAIL PROTECTED]
Subject: Global EXit FuseActions
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
---
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
------------------------------
Date: Fri, 11 Oct 2002 08:58:26 +1000
From: "Lee Borkman" <[EMAIL PROTECTED]>
Subject: Re: Global EXit FuseActions
Yes, Hamid. It's a fairly common practice.
I would usually put any code that applies to a particular circuit, but not to
its children, inside the fbx_switch and outside the cfswitch block. That is the
only place in your code that gets executed for every fuseaction within a
particular circuit, but does not get executed for child circuits. Common uses
would include setting global XFAs, or checking permissions.
Many people use fbx_settings to set global XFAs, but I find that this reduces
the value of fbx_switch as a comprehensive "map".
See ya,
LeeBB
----- Original Message -----
From: hamid <[EMAIL PROTECTED]>
> 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?
>
------------------------------
Date: Thu, 10 Oct 2002 20:55:40 -0600
From: "Terry Hogan" <[EMAIL PROTECTED]>
Subject: RE: Importing text files--follow Up
Thanks for the replies, but I'm still having some problems.
I'm using cffile to read the file and put in a variable "importfile". It's a tab
delimited file with 14 columns and the column names are in the first record.
I'm checking if the 1st field is numeric (it's a key field) and if so setting the list
positions to field names in preparation to input in database.
But I'm getting an error:
"In function ListGetAt(list, index [, delimiters]) the value of index, which is 9, is
not a valid index for the list given as a the first argument (this list has 8
elements). Valid indexes are in the range 1 through the number of elements in the list"
It doesn't seem to be reading the tab delimiter?
My code is below.
More info: I'm using MSAccess. Imported files will have 200 to 1000 records. Only
one user will be accessing at any time.
Code:
<cffile action="READ" file="C:\WebSite\htdocs\GrandData\CENTURY05-26-01.TXT"
variable="ImportFile">
<cfset colDelim = " ">
<cfset rowDelim = CHR(13)&CHR(10)>
<cfset lineNumber = ListLen(ImportFile,rowDelim)>
<CFLOOP from="1" to="#lineNumber#" index="counter">
<CFSET thisRow = ListGetAt(ImportFile, counter, rowDelim)>
<cfif IsNumeric(ListGetAt(thisRow, 1, colDelim))>
<CFSET PN = ListGetAt(thisRow, 1, colDelim)>
<cfset Title = ListGetAt(thisRow, 2, colDelim)>
<cfset First = ListGetAt(thisRow, 3, colDelim)>
<cfset Last = ListGetAt(thisRow, 4, colDelim)>
<cfset Org = ListGetAt(thisRow, 5, colDelim)>
<cfset Addr1 = ListGetAt(thisRow, 6, colDelim)>
<cfset Addr2 = ListGetAt(thisRow, 7, colDelim)>
<cfset City = ListGetAt(thisRow, 8, colDelim)>
<cfset State = ListGetAt(thisRow, 9, colDelim)>
<cfset Zip = ListGetAt(thisRow, 10, colDelim)>
<cfset email = ListGetAt(thisRow, 11, colDelim)>
<cfset Tele1 = ListGetAt(thisRow, 12, colDelim)>
<cfset Tele2 = ListGetAt(thisRow, 13, colDelim)>
Thanks again,
Terry
*********** REPLY SEPARATOR ***********
On 10/10/2002 at 8:05 PM alex artigues wrote:
>This will help you with the parsing once you
>have the data in your hand. We'll call your data
>"tabFile":
>----------------------------------------------------------------
><CFSET columnDelim = " "> <!--- TAB BETWEEN THE QUOTES --->
><CFSET rowDelim = CHR(13) & CHR(10)>
><CFSET rowCount = ListLen(tabFile, rowDelim)>
>
><CFLOOP from="1" to="#rowCount#" index="counter">
> <CFSET thisRow = ListGetAt(tabFile, counter, rowDelim)>
> <CFSET item1 = ListGetAt(thisRow, 1, columnDelim)>
> <CFSET item2 = ListGetAt(thisRow, 2, columnDelim)>
>
> <!--- NOW RUN YOUR INSERT QUERY FOR THESE FIELDS --->
></CFLOOP>
>--------------------------------------------------------------------
>
>
>
>Terry Hogan wrote:
>> Hi,
>>
>> I need to build a module that will upload a tab delimited text file,
>> then import the records to the database.
>>
>> I know I've seen this done, but can't find any samples.
>>
>> TIA
>>
>> Terry
>>
>> (I know this is more of a CF-talk question, but I couldn't access the
>> archives and my email was rejected.)
>>
>>
>>
>
>
>__________________________________________/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 13:25:15 +1000
From: "Lee Borkman" <[EMAIL PROTECTED]>
Subject: Re: Importing text files--follow Up
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.
leebb
----- Original Message -----
From: Terry Hogan <[EMAIL PROTECTED]>
Thanks for the replies, but I'm still having some problems.
I'm using cffile to read the file and put in a variable "importfile". It's a tab
delimited file with 14 columns and the column names are in the first record.
I'm checking if the 1st field is numeric (it's a key field) and if so setting
the list positions to field names in preparation to input in database.
But I'm getting an error:
"In function ListGetAt(list, index [, delimiters]) the value of index, which is
9, is not a valid index for the list given as a the first argument (this list
has 8 elements). Valid indexes are in the range 1 through the number of elements
in the list"
It doesn't seem to be reading the tab delimiter?
My code is below.
More info: I'm using MSAccess. Imported files will have 200 to 1000 records.
Only one user will be accessing at any time.
Code:
<cffile action="READ" file="C:\WebSite\htdocs\GrandData\CENTURY05-26-01.TXT"
variable="ImportFile">
<cfset colDelim = " ">
<cfset rowDelim = CHR(13)&CHR(10)>
<cfset lineNumber = ListLen(ImportFile,rowDelim)>
...
------------------------------
Date: Thu, 10 Oct 2002 22:33:04 -0600
From: "Terry Hogan" <[EMAIL PROTECTED]>
Subject: Re: Importing text files--follow Up
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.
>
>leebb
>
>----- Original Message -----
>From: Terry Hogan <[EMAIL PROTECTED]>
>
>
>Thanks for the replies, but I'm still having some problems.
>
>I'm using cffile to read the file and put in a variable "importfile". It's
>a tab
>delimited file with 14 columns and the column names are in the first
>record.
>
>I'm checking if the 1st field is numeric (it's a key field) and if so
>setting
>the list positions to field names in preparation to input in database.
>
>But I'm getting an error:
>"In function ListGetAt(list, index [, delimiters]) the value of index,
>which is
>9, is not a valid index for the list given as a the first argument (this
>list
>has 8 elements). Valid indexes are in the range 1 through the number of
>elements
>in the list"
>
>It doesn't seem to be reading the tab delimiter?
>
>My code is below.
>
>More info: I'm using MSAccess. Imported files will have 200 to 1000
>records.
>Only one user will be accessing at any time.
>
>Code:
><cffile action="READ"
>file="C:\WebSite\htdocs\GrandData\CENTURY05-26-01.TXT"
>variable="ImportFile">
>
><cfset colDelim = " ">
><cfset rowDelim = CHR(13)&CHR(10)>
><cfset lineNumber = ListLen(ImportFile,rowDelim)>
>
>...
>
>
>__________________________________________/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 14:37:44 +1000
From: "Lee Borkman" <[EMAIL PROTECTED]>
Subject: Re: Importing text files--follow Up
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.
------------------------------
Date: Fri, 11 Oct 2002 13:05:15 +0800
From: "Neville Bent" <[EMAIL PROTECTED]>
Subject: Re: Importing text files--follow Up
This is a MIME message. If you are reading this text, you may want to
consider changing to a mail reader or gateway that understands how to
properly handle MIME multipart messages.
------=_NextPartTM-000-615b9555-dccf-11d6-9544-00105a68c8ef
Content-Type: multipart/alternative;
boundary="=_065A90AF.D0B1D230"
--=_065A90AF.D0B1D230
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 8bit
Or if you're on cf5, try Patrick's 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
<A
href="http://www.fusebox.org/index.cfm?fuseaction=conference.main http://www.fusebox.org/index.cfm?fuseaction=conference.main
--=_065A90AF.D0B1D230
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=us-ascii">
<META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt Tahoma; MARGIN-LEFT: 2px">
<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--
</BODY></HTML>
------------------------------
__________________________________________/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 967
