At 01:48 PM 9/1/00 -0400, you wrote:
>Paul, why did you set the data in a temporary structure, then copy it to
>the application structure?
Other than that was the way I was taught to do it, I believe it's needed to
create a structure with "N-columns" (in my case, Class_ID, Class_Name,
Pages, and NewPages, or 4 columns) and "M-rows" (in my case over 7,000
rows), or what I think many must call a "Nested Structure"
>Did you intend to put a lock around the application structure?
Yes. I actually did put a LOCK there but I kept getting some error
message. I haven't had time to sort it out.
BTW, Dan Switzer has a super tutorial on Structures at:
http://www.oacfug.org/dsp_articles.cfm/dsp_Articles.cfm?view=Articles_35
(the page throws a JS error for me, clicking on "No" seemed to work)
best, paul
>At 01:26 PM 8/31/00 -0700, paul smith wrote:
> >Here's an example:
> >
> ><CFQUERY NAME="GetYPs" DATASOURCE="#DSN#" USERNAME="#user#"
> PASSWORD="#pass#">
> >SELECT Class_ID, Class_Name, Pages, NewPages
> >FROM YellowPages (nolock)
> ></CFQUERY>
> >
> ><CFSET STTEMP = STRUCTNEW()> <!--- temporary structure --->
> ><CFSET APPLICATION.YPS = STRUCTNEW()> <!--- final structure for Headings
> --->
> ><CFLOOP QUERY="GetYPs">
> ><CFSET STTEMP["Class_ID"] = "#Class_ID#">
> ><CFSET STTEMP["Class_Name"] = "#Class_Name#">
> ><CFSET STTEMP["Pages"] = "#Pages#">
> ><CFSET STTEMP["NewPages"] = "#NewPages#">
> ><CFSET APPLICATION.YPS[STTEMP["Class_ID"]] = STRUCTCOPY(STTEMP)>
> ><CFSET TMPVAR = STRUCTCLEAR(STTEMP)>
> ></CFLOOP>
> >
> >best, paul
> >
> >At 10:45 AM 8/31/00 -0400, you wrote:
> >> Is there a way to add multiple records into a structure or do
> I have
> >>to make an array of strucutres. Right now I made an aray of strucutures but
> >>I want to make sure that is the most logical way to be doing it.
> >
> >-------------------------------------------------------------------------
> -----
> >Archives: http://www.mail-archive.com/[email protected]/
> >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.
>
>
>---------------------------------------------------------------------------
>Peter Theobald, Chief Technology Officer
>LiquidStreaming http://www.liquidstreaming.com
>[EMAIL PROTECTED]
>Phone 1.212.545.1232 Fax 1.212.679.8032
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>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.
Paul Smith, Web/Database Droid
A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611
P: (510) 763-2358
C: (510) 205-6755
F: (510) 763-2370
E: [EMAIL PROTECTED]
W: http://www.support.net
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
